薪酬核算向导第三步薪酬核算人员重复。

产品版本:V8.2、V8.5

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 <= and=>= T0.FEFFDT))