【问题】: (FAQ)人力资源初始化时，提示人员信息不完整！
版本: 6.0
模块: 系统配置
【答复】:
该情况应该是当前登录HR组织下，有人员的信息不完整,人员信息要求： 该员工的编码，名称，员工状态不能为空，身份证和护照号码不能同时为空 请使用以下SQL进行排查哪些人员信息不完整，然后进行补充资料。其中： --获取当前登录的HR组织fid select fid from t_org_hro where fnumber = '当前登录HR组织的编码' SELECT "PERSON".FNumber AS 人员编码, "PERSON".FName_l2 AS 人员名称, "PERSON".FIDCardNO AS 身份证号码, "PERSON".FPassportNO AS 护照号码, "EMPLOYEETYPE".fname_l2 AS 人员的状态 FROM T_BD_Person AS "PERSON" INNER JOIN T_ORG_CtrlUnit AS "CU" ON "PERSON".FControlUnitID = "CU".FID LEFT OUTER JOIN T_HR_BDEmployeeType AS "EMPLOYEETYPE" ON "PERSON".FEmployeeTypeID = "EMPLOYEETYPE".FID INNER JOIN T_ORG_HRO HRO ON HRO.FID =PERSON.FHRORGUNITID WHERE PERSON.FHRORGUNITID = '当前登录HR组织的ID' and (EmployeeType.Fid IS NULL OR (fidCardNO IS NULL AND fpassportNO IS NULL))

该情况应该是当前登录HR组织下，有人员的信息不完整,人员信息要求： 该员工的编码，名称，员工状态不能为空，身份证和护照号码不能同时为空 请使用以下SQL进行排查哪些人员信息不完整，然后进行补充资料。其中： --获取当前登录的HR组织fid select fid from t_org_hro where fnumber = '当前登录HR组织的编码' SELECT "PERSON".FNumber AS 人员编码, "PERSON".FName_l2 AS 人员名称, "PERSON".FIDCardNO AS 身份证号码, "PERSON".FPassportNO AS 护照号码, "EMPLOYEETYPE".fname_l2 AS 人员的状态 FROM T_BD_Person AS "PERSON" INNER JOIN T_ORG_CtrlUnit AS "CU" ON "PERSON".FControlUnitID = "CU".FID LEFT OUTER JOIN T_HR_BDEmployeeType AS "EMPLOYEETYPE" ON "PERSON".FEmployeeTypeID = "EMPLOYEETYPE".FID INNER JOIN T_ORG_HRO HRO ON HRO.FID =PERSON.FHRORGUNITID WHERE PERSON.FHRORGUNITID = '当前登录HR组织的ID' and (EmployeeType.Fid IS NULL OR (fidCardNO IS NULL AND fpassportNO IS NULL))