薪酬核算向导第三步薪酬核算人员重复
【关键字】:薪酬核算、第三步、核算、重复、人员
【适用版本】:通用
【解决方案】:
1、请先检查使用系统默认的查询方案是否有该问题;
2、如果没有,则使用排查法排查自定义的查询方案选择的字段是否有重复 ;
3、使用SQL语句查询是否有重复 :
1)、select fid from t_bd_person where fnumber ='重复的人员编码'
2)、SELECT "T0"."FID" "ID", "T0"."FPERSONID" "T1.ID",
"T1"."FNAME_L2" "T1.NAME", "T1"."FNAME_L1" "T1.NAME_L1",
"T1"."FNAME_L2" "T1.NAME_L2", "T1"."FNAME_L3" "T1.NAME_L3",
"T0"."FADMINORGID" "T2.ID", "T2"."FNAME_L2" "T2.NAME",
"T2"."FNAME_L1" "T2.NAME_L1", "T2"."FNAME_L2" "T2.NAME_L2",
"T2"."FNAME_L3" "T2.NAME_L3", "T0"."FPOSITIONID" "T3.ID",
"T3"."FNAME_L2" "T3.NAME", "T3"."FNAME_L1" "T3.NAME_L1",
"T3"."FNAME_L2" "T3.NAME_L2", "T3"."FNAME_L3" "T3.NAME_L3"
from "T_HR_EMPORGRELATION" "t0"
left OUTER JOIN "T_BD_PERSONHIS" "t1"
on (("T0"."FPERSONID" = "T1"."FHISTORYRELATEID"
and ("T1"."FEFFDT" <= "T0"."FEFFDT"))
and ("T1"."FLEFFDT" >= "T0"."FEFFDT"))
left OUTER JOIN "T_ORG_ADMINHIS" "t2"
on (("T0"."FADMINORGID" = "T2"."FHISTORYRELATEID"
and ("T2"."FEFFDT" <= "T0"."FEFFDT"))
and ("T2"."FLEFFDT" >= "T0"."FEFFDT"))
left OUTER JOIN "T_ORG_POSITIONHIS" "t3"
on (("T0"."FPOSITIONID" = "T3"."FHISTORYRELATEID"
and ("T3"."FEFFDT" <= "T0"."FEFFDT"))
and ("T3"."FLEFFDT" >= "T0"."FEFFDT"))
where (((("T0"."FASSIGNTYPE" = 1
and "T1"."FHISTORYRELATEID" = '上面语句返回的fid')
and "T0"."FISINNER" = 1)
and ("T0"."FEFFDT" <= {ts '2016-06-28'}))
and ("T0"."FLEFFDT" >= {ts '2016-06-28'}))
其中的日期,请改为当前日期,返回的记录是否存在两条或多条,把反馈结果导出到excel表里,提单反馈。
4、检查人员所在的行政组织及岗位的变更历史信息中日期有没有重复或交叉,如有请提单进行反馈。
文章评论