HRMS 相关的表主要有:PER_ALL_ASSIGNMENTS_F员工信息分配表PER_ALL_PEOPLE_员工基本信息表PER_PEOPLE_V_O员工最新基本信息PER_ASSIGNMENTS_V_O员工最新分配信息......
因此取员工类型的时候不能以per_all_people_f的person_type_id为准，而应该
PER_PERSON_TYPE_USAGES_F里存储了每个员工的类型，通过person_id和per_all_people_f进行关联，通过person_type_id和PER_PERSON_TYPES_V进行关联。简而言之：三个表的关系如下：per_all_people_f.person_id = PER_PERSON_TYPE_USAGES_F.person_id and
PER_PERSON_TYPE_USAGES_F.person_type_id = PER_PERSON_TYPES_V.person_type_id
3/3 首页 上一页 1 2 3 |
