主数据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