主数据MDM下发eHR系统操作整理v1.0 - 图文

主数据MDM下发eHR系统操作整理

?

1、定时任务管理

?

路径：系统公共—公共服务—调度服务—任务组管理?

??

2、数据下发设置 条件设置

路径：主数据管理—主数据控制台—管理范围设置

??

2.1 行政组织 过滤sql

三级：

(orgcode in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='3 )) 四级：

(orgcode in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='4' )) 五级：

? ? ? ? ? ?

(orgcode in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='5' )) 六级：

(orgcode in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='6' )) 七级：

(orgcode in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='7' ))

? ? ? ? ? ?

(orgcode in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='7' )) ? ? ? ? ? ?

?

2.2 行政部门 过滤sql

?

三级

(orgcode in (select orgcode from MDMOrgInfo where OrgUnitNM in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='3' )and orgtype='1')) 四级

(orgcode in (select orgcode from MDMOrgInfo where OrgUnitNM in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='4' )

and orgtype='1')) 五级

(orgcode in (select orgcode from MDMOrgInfo where OrgUnitNM in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='5' )and orgtype='1')) 六级

(orgcode in (select orgcode from MDMOrgInfo where OrgUnitNM in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='6' )and orgtype='1')) 七级

(orgcode in (select orgcode from MDMOrgInfo where OrgUnitNM in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='7' )and orgtype='1'))

(orgcode in (select orgcode from MDMOrgInfo where OrgUnitNM in (select ORGCODE from MDMOrgInfo where orgtype='0'and ishistory='0'and js='7' )and orgtype='1'))

人力4个部门编码

‘00003241

2.2.1行政部门直接用编码过滤下发?

(orgcode in ('00003241','00000264','00003222','00003242'))

??

2.3 人员字典

2.3.1 人员字典修改前，?

人员字典过滤发送： 修改前

(userpredef_2 like '%F%' and

substring(userpredef_2,instr(userpredef_2,'F',1,1),3)<>'F00' and mdmzgzd_zgbh<>'00000001' and mdmzgzd_gwmc is not null and userpredef_4 is not null)

2.3.2 人员字典按组织下发?

修改后，仅发送铜川启德环卫工程有限公司（00002182）(userpredef_2 like '%F%' and

substring(userpredef_2,instr(userpredef_2,'F',1,1),3)<>'F00' and mdmzgzd_zgbh<>'00000001' and mdmzgzd_gwmc is not null and userpredef_4 is not null and MDMZGZD_HRDWNM ='00002182')

??

2.3.3 人员按部门下发

MDMZGZD_HRBMNM

(userpredef_2 like '%F%' and

substring(userpredef_2,instr(userpredef_2,'F',1,1),3)<>'F00' and mdmzgzd_zgbh<>'00000001' and mdmzgzd_gwmc is not null and userpredef_4 is not null and MDMZGZD_HRBMNM ='00003242')

??

2.3.4 人员按编码下发?

(MDMZGZD_ZGBH in

('00000192','00000238','00003500','00636318','00637623','00843341','00890361','00864341'))

?

?

3、数据下发OA系统

?

路径：主数据管理—主数据控制台—数据发布—联网下发

?

4、eHR中间表数据抓取

?

?

end

???

?