本文已参与「新人创作礼」活动，一起开启掘金创作之路。 Oracle HCM 选择UE和GROUP的一些方法
1 . UE: PER_EXT_PAY_EMPLOYEES_UE Threading Database Item: Extract Employee Assignment ID Threading Action Type = “Object Actions”.
--for non-payroll interfaces especially if we need to think about ‘Cancel Work Relationship’
使用 PER_EXT_SEC_PERSON_UE Threading DBI : Extract Person ID For every data record used, primary key combination MUST be extracted for the UE – so for PER_EXT_PAY_EMPLOYEES_UE, it is “Extract Employee Assignment ID” and “Extract Employee Assignment Effective Start Date”
编辑
NI NUMBER —— Person Primary National Identifier Number
Person Title —— Person Title
Gender —— Person Gender
Date of Birth —— Person Date of Birth
Address1 —— Person Home Address Line1
Address2 —— Person Home Address Line2
Address3 —— Person Home Address Line3
Address4 —— Person Home Town or City
County —— Person Home Region2
Post Code —— Person Home Postal Code
Assignment Start Date —— Extract Employee Assignment Effective Start Date
Assignment Category —— Assignment Employment Category - Lookup Meaning
Assignment Hours —— Assignment Normal Hours
FTE Hours Role —— Assignment Standard Working Hours
Assignment Status Type —— Assignment Status Type User Status
Latest Start Date —— Extract Employee Relationship Date Start
Annual Salary —— Assignment Salary Annual Amount
Leave Date —— Extract Employee Relationship Termination Date
FTE Hours Role —— Assignment Standard Working Hours
-
Suggest to use ‘PER_EXT_SEC_PERSON_UE’ as the root record (Threading database item is ‘Extract Person ID’) for non-payroll interfaces especially if we need to think about ‘Cancel Work Relationship’
-
PER_EXT_ORGANIZATION_TREE_UE 的Payroll Relationship ID 和 PER_EXT_PAY_EMPLOYEES_UE 的 Extract Employee Payroll Relationship ID 相连 用来取Division Legal Entity Sub Division Business Unit
Organization Name Extract —— Organization Tree Organization Name
Organization Depth —— Extract Organization Tree Depth
-
PER_EXT_SEC_ASSIGNMENT_UE 的Extract Assignment Person ID 和 PER_EXT_SEC_PERSON_UE 的 Extract Person ID 相连 用来取 LOCATION ID/DESCRIPTION EMPLOYMENT TYPE JOB DESCRIPTION 这些字段
-
要取BALANCE的数据 先通过 PAYROLL_ASSIGNED_EMPLOYEE_UE 的PAYROLL_ASSIGNED_EMPLOYEE_PERSON_ID 和 PER_EXT_PAY_EMPLOYEES_UE 的Extract Employee Person ID 相连
再通过 PAYROLL_INTERFACE_DE_UE 的 Payroll Interface Deduction Person Id 和 PAYROLL_ASSIGNED_EMPLOYEE_UE 的 PAYROLL_ASSIGNED_EMPLOYEE_PERSON_ID 相连
才能取到CONTRIBUTION 的字段
Period Name —— Pay Earning Period Name
6. ELEMENT ENTRIES 的 Payroll Relationship ID 和 PAYROLL_ASSIGNED_EMPLOYEE_UE 的 Extract Employee Payroll Relationship ID 相连
EE Value —— Element Entry Value
-
COST_TCG_COST_ALLOCATION_FLEXFIELD_UE 主要用来取一些 COST CODE COST CENTER 这些特殊的字段
-
PER_TRM_WORKTERM_DETAILS_UE 用于取关于人的页面上Work Relationship 的数据
-
PER_ASG_ASSIGNMENT_DETAILS_UE
HourlySalaried/ AssignmentCategory Extract Employee Assignment Employment Category RegularTemporary Assignment Permanent Temporary Indicator
LegalEmployerName Assignment Attribute1 OR Work Term Organization Name
