(FAQ)社保结账和审核人数不一致
结账界面除了审核界面的人数外，还包含了已经从这个组织异动到别的组织，但是在异动人员列表里勾选了“当月在原组织缴纳社保”的选项的人。 通过如下语句可以查询这些人的情况。 select person.fnumber as 员工编号,person.fname_l2 as 员工姓名,old.fnumber as 异动前组织编码,old.fdisplayname_l2 as 异动前组织名称,newadmin.fnumber as 异动后组织编码,newadmin.fdisplayname_l2 as 异动后组织名称,fb.feffectdate as 异动日期,fb.ftraninolddep as 是否在原组织缴纳社保 from T_HR_fluctuationperson fb left outer join T_BD_Person person on person.fid=fb.fpersonid left outer join T_ORG_ADMIN newadmin on newadmin.fid=fb.fnewadminorgid left outer join T_ORG_ADMIN old on old.fid=fb.foldadminorgid