产品版本: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)) left OUTER JOIN T_ORG_ADMINHIS t2 on ((T0.FADMINORGID = T2.FHISTORYRELATEID and (T2.FEFFDT <= and=>= T0.FEFFDT)) left OUTER JOIN T_ORG_POSITIONHIS t3 on ((T0.FPOSITIONID = T3.FHISTORYRELATEID and (T3.FEFFDT <= and=>= T0.FEFFDT)) where ((((T0.FASSIGNTYPE = 1 and T1.FHISTORYRELATEID = '上面语句返回的fid') and T0.FISINNER = 1) and (T0.FEFFDT <= ts= and=>= {ts '2016-06-28'})) 其中的日期,请改为当前日期,返回的记录是否存在两条或多条,把反馈结果导出到excel表里,提单反馈。

4、检查人员所在的行政组织及岗位的变更历史信息中日期有没有重复或交叉,如有请提单进行反馈。