|
发表于 2022-1-26 21:22:03
|
显示全部楼层
--NC操作路径:动态建模平台-->基础数据-->人员信息-->人员
select org_orgs.name 所属业务单元,
bd_psndoc.code 人员编码,
bd_psnjob.pk_psnjob,
bd_psnjob.psncode,
bd_psndoc.name 姓名,
bd_psnidtype.name 证件类型,
bd_psndoc.id 证件号,
bd_psnjob.pk_dept, org_dept.code 部门编码,
org_dept.name 所在部门,
bd_psnjob.indutydate 任职开始日期,
bd_psnjob.enddutydate 任职结束日期,
sm_user_c.user_name 创建人,
bd_psndoc.creationtime 创建时间,
sm_user_m.user_name 最后修改人,
bd_psndoc.modifiedtime 最后修改时间
from bd_psndoc bd_psndoc
left join bd_psnjob bd_psnjob
on bd_psnjob.pk_psndoc = bd_psndoc.pk_psndoc
left join org_dept org_dept
on org_dept.pk_dept = bd_psnjob.pk_dept
left join bd_psnidtype bd_psnidtype
on bd_psndoc.idtype = bd_psnidtype.pk_identitype
left join org_orgs org_orgs
on org_orgs.pk_org = bd_psndoc.pk_org
inner join sm_user sm_user_c
on bd_psndoc.creator = sm_user_c.cuserid
left join sm_user sm_user_m
on bd_psndoc.modifier = sm_user_m.cuserid
where nvl(bd_psndoc.dr, 0) = 0 |
|