
文档地址:$/051.HR产品部(2014)/10.EASHR个性化私包登记/00EAS与s-HR集成/s-HR与EAS集成部署包对应说明.xlsx
集成文档见附件
shr同步EAS:t_bas_param where FNUMBER ='IntegratedPattern'
s-HR端相关表
T_HR_ModifyDataEASRec 同步日志表
EAS端相关表
t_shr_idmapping 映射表
T_HR_SHRInteModifyRec 同步对象属性变化记录表
T_HR_SyncDataStatus 变化信息记录表
T_HR_SHRSyncConfigur shr与eas字段对应信息表
T_HR_SHRRespExcep s-HR osf 异常Response信息记录表
T_HR_OrgMapping 组织id映射
T_HR_SHROrg
注意:
两个服务应用之间只支持一对数据库同步,不能多数据中心对多数据中心,因为EAS环境下配置文件只记录了一个s-HR的地址没有指定数据库,EAS用user账号token登陆s-HR会指向单点登陆配置的数据库,同时EAS配置文件shrIntegradeEasConfig.properties只有一个不支持多中心
补录某段时间内的监听数据
```language
INSERT INTO T_HR_ModifyDataEASRec (FID,FOBJECTIDID,FTYPE,FMETHOD,FOPTTIME,FSYNEASSTATE ) SELECT newbosid('68BAE360'), FID ,'orgUnit' ,'update' ,FLASTUPDATETIME,0 FROM t_org_admin where FLASTUPDATETIME > {ts'2022-08-05'} and FID not in ( SELECT FOBJECTIDID FROM T_HR_ModifyDataEASRec where FTYPE = 'orgUnit' and FSYNEASSTATE = 0); -- 补组织监听数据
INSERT INTO T_HR_ModifyDataEASRec (FID,FOBJECTIDID,FTYPE,FMETHOD,FOPTTIME,FSYNEASSTATE ) SELECT newbosid('68BAE360'), FID ,'position' ,'update' ,FLASTUPDATETIME,0 FROM t_org_position where FLASTUPDATETIME > {ts'2022-08-05'} and FID not in ( SELECT FOBJECTIDID FROM T_HR_ModifyDataEASRec where FTYPE = 'position' and FSYNEASSTATE = 0); -- 补职位监听数据
INSERT INTO T_HR_ModifyDataEASRec (FID,FOBJECTIDID,FTYPE,FMETHOD,FOPTTIME,FSYNEASSTATE ) SELECT newbosid('68BAE360'), FID ,'person' ,'update' ,FLASTUPDATETIME,0 FROM t_bd_person where FLASTUPDATETIME > {ts'2022-08-05'} and FID not in ( SELECT FOBJECTIDID FROM T_HR_ModifyDataEASRec where FTYPE = 'person' and FSYNEASSTATE = 0); -- 补员工基础数据变化监听数据
INSERT INTO T_HR_ModifyDataEASRec (FID,FOBJECTIDID,FTYPE,FMETHOD,FOPTTIME,FSYNEASSTATE ) SELECT newbosid('68BAE360'), FPERSONID ,'person' ,'update' ,FLASTUPDATETIME,0 FROM T_HR_EmpOrgRelation where FLASTUPDATETIME > {ts'2022-08-05'} and FPERSONID not in ( SELECT FOBJECTIDID FROM T_HR_ModifyDataEASRec where FTYPE = 'person' and FSYNEASSTATE = 0); -- 补员工变动记录变化监听数据
```
常见问题
1>检查shrIntegradeEasConfig.properties配置正确;
2>前一步无误后还是同步失败,那就要检查 com.kingdee.eas.hr.base.app.synch.LtpaTokenManag