EAS_Table

SHR人力

员工表 T_BD_PERSON

fbirthday 出生日期

femployeetypeid 员工状态

员工状态 T_HR_BDEMPLOYEETYPE

T_BD_PERSON.femployeetypeid = T_HR_BDEMPLOYEETYPE.fid

femployeemodleid 在职在岗

在岗情况 T_BD_EmployeeModle

T_HR_BDEMPLOYEETYPE.femployeemodleid = T_BD_EmployeeModle.fid

fnumber 在册在岗（01）在册不在岗（02）

职位岗 T_ORG_POSITION

fadminorgunitid 行政组织

cfgwflid 岗位分类

岗位分类 ct_mp_gwfl

fname_l2 管理类-高层管理岗管理类-中层管理岗

fnumber ( 0101 0102 )

职员任职 T_ORG_POSITIONMEMBER （人员和岗位的连接表）

fpersonid 人员

fpositionid 职位

行政组织 T_ORG_BaseUnit （过滤）(Admin)

fdisplayname_l2 组织全名称 fname_l2 简称

职称 T_HR_PERSONTECHPOST

fpersonid 人员 T_HR_PERSONTECHPOST.fpersonid = T_BD_PERSON .fid

cflevelid 级别

fconferdate 职称授予日期

级别表 T_HR_BDTechPostLevel

fname_l2 副高级 T_HR_BDTechPostLevel.fid = T_HR_PERSONTECHPOST.cflevelid

fnumber

(01正高级 02副高级（即高级），03中级，04,05,99其余为初级及以下)

职业信息表 T_HR_PersonPosition

fpersonid 人员

fenterdate 入职日期

学历学位 T_HR_PERSONDEGREE

FPERSONID 人员ID T_BD_PERSON.fid = T_HR_PERSONDEGREE.FPERSONID

fgraduatedate 毕业时间

学历 T_BD_HRDiploma T_HR_PERSONDEGREE.fdiploma = T_BD_HRDiploma.fid

fname_l2 大学本科

fnumber 博士 07 博士后 08

硕士毕业 Z1a 硕士研究生毕业 Z14 硕士研究生结业 Z15 研究生 06

大学本科 05

表连接：

T_ORG_POSITION .cfgwflid = ct_mp_gwfl.fid

T_ORG_POSITION.fadminorgunitid = T_ORG_BaseUnit.fid

T_BD_PERSON.fid = T_ORG_POSITIONMEMBER.fpersonid (员工和职位关联)

T_ORG_POSITIONMEMBER.fpositionid = T_ORG_POSITION .fid

组织（T_ORG_BaseUnit）：xt0AAAAAC3/M567U -- 天津百利机械装备集团有限公司

工作流OA

工作流任务表 T_WFR_Assign fbizobjid

处理过的（审批）任务表 T_WFR_AssignDetail fbizobjid

收文单 CT_ODM_BLJTSW (发文工作流)

流程信息表 T_bas_documentInfo fsourcepk

以上后面的字段均是单据(收文单)id关联

（动态单据）

流程模板 t_bas_template 关联字段 formid

动态单据数据库表 t_bas_formentity

动态单据表字段对应表 t_bas_formfield 记录了动态单据字段和所对应实体表字段的对应。

动态框架单据附件 T_BAS_BillAttachment bosType:40E7BFAC Attachment

成品demo

会议室

SELECT fname_l2 FROM T_MRM_MeetingRoom

百利装备下属部门

select fname_l2 from T_ORG_BaseUnit where FPARENTID = 'xt0AAAAAC3/M567U' --天津百利机械装备下属部门

OA领导（左王乔赵... 顺序）

 1 select
 2 PERSON.fname_l2 as pname,
 3 POSITION.fname_l2 as pwork,
 4 POSITION.findex as pindex,
 5 BaseUnit.fname_l2,
 6 BaseUnit.fid,
 7 BaseUnit.fnumber as fnumber
 8 from  T_BD_PERSON as PERSON
 9     left join T_ORG_POSITIONMEMBER as POSITIONMEMBER on PERSON.fid = POSITIONMEMBER.fpersonid 
10     left join T_ORG_POSITION as POSITION on POSITION.fid = POSITIONMEMBER.fpositionid
11     left join T_ORG_BaseUnit as BaseUnit on BaseUnit.fid = POSITION.fadminorgunitid 
12 where POSITIONMEMBER.fisprimary = '1' and BaseUnit.fid = 'xt0AAAAAC3/M567U'
13 and PERSON.fname_l2 not in ('温辉','吴树元') 
14 union
15 select
16 PERSON.fname_l2 as pname,
17 POSITION.fname_l2 as pwork,
18 POSITION.findex as pindex,
19 BaseUnit.fname_l2,
20 BaseUnit.fid,
21 BaseUnit.fnumber as fnumber
22 from  T_BD_PERSON as PERSON
23     left join T_ORG_POSITIONMEMBER as POSITIONMEMBER on PERSON.fid = POSITIONMEMBER.fpersonid 
24     left join T_ORG_POSITION as POSITION on POSITION.fid = POSITIONMEMBER.fpositionid
25     left join T_ORG_BaseUnit as BaseUnit on BaseUnit.fid = POSITION.fadminorgunitid 
26 where POSITIONMEMBER.fisprimary = '1' 
27 and PERSON.fname_l2 in ('杨川','宋春林')
28 order by fnumber,pindex

View Code

部室以及领导名称

select
PERSON.fid as fid,
PERSON.fname_l2 as pname,
BaseUnit.fname_l2 as buname
from  T_BD_PERSON as PERSON
    left join T_ORG_POSITIONMEMBER as POSITIONMEMBER on PERSON.fid = POSITIONMEMBER.fpersonid 
    left join T_ORG_POSITION as POSITION on POSITION.fid = POSITIONMEMBER.fpositionid
    left join T_ORG_BaseUnit as BaseUnit on BaseUnit.fid = POSITION.fadminorgunitid 
where POSITIONMEMBER.fisprimary = '1'  
and POSITION.FISRESPPOSITION =1 --是否部门负责人
and BaseUnit.FPARENTID = 'xt0AAAAAC3/M567U'
order by POSITION.findex