主数据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系统
路径:主数据管理—主数据控制台—数据发布—联网下发