HR OBJECT RELATIONSHIP PFML Table
Subset of HR_OBJECT_RELATIONSHIP containing relationship codes: (1) Z02 (2) ZLI (3) ZC1 (4) ZC2. Also includes MIT_ID and FULL_NAME and RELATIONSHIP_ACTIVE_FLG. Stores personnel-focused HR object relationships, enriched with individual identifiers and activity flags for reporting and analysis. Each row represents a relationship between HR objects associated with a specific individual.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDL_DATA |
Supplemental or auxiliary data associated with the relationship. |
VARCHAR2 |
32 |
FULL_NAME |
Full name of the individual associated with the relationship. |
VARCHAR2 |
100 |
HR_OBJECT_CODE |
Identifier of the primary HR object participating in the relationship. |
VARCHAR2 |
8 |
HR_OBJECT_RELATIONSHIP |
Descriptive name of the relationship between the HR objects. |
VARCHAR2 |
25 |
HR_OBJECT_RELATIONSHIP_CODE |
Code identifying the type of relationship between the primary and related HR objects. |
VARCHAR2 |
4 |
HR_OBJECT_RELATION_END_DATE |
Effective end date of the relationship between the HR objects. |
DATE |
|
HR_OBJECT_RELATION_START_DATE |
Effective start date of the relationship between the HR objects. |
DATE |
|
HR_OBJECT_TYPE |
Descriptive name of the primary HR object type. |
VARCHAR2 |
25 |
HR_OBJECT_TYPE_CODE |
Code identifying the type of the primary HR object. |
VARCHAR2 |
2 |
HR_OBJECT_WITH_TYPE |
Composite identifier representing the primary HR object and its object type. |
VARCHAR2 |
10 |
HR_RELATED_OBJECT_CODE |
Identifier of the related HR object participating in the relationship. |
VARCHAR2 |
45 |
HR_RELATED_OBJECT_TYPE |
Descriptive name of the related HR object type. |
VARCHAR2 |
25 |
HR_RELATED_OBJECT_TYPE_CODE |
Code identifying the type of the related HR object. |
VARCHAR2 |
2 |
HR_RELATED_OBJECT_WITH_TYPE |
Composite identifier representing the related HR object and its object type. |
VARCHAR2 |
47 |
LAST_UPDATE_DATE |
Date the relationship record was last updated in the source system. |
DATE |
|
LAST_UPDATE_USER |
Identifier of the user or process that last updated the relationship record. |
VARCHAR2 |
12 |
MIT_ID |
MIT identifier for the individual associated with the HR object relationship. |
VARCHAR2 |
9 |
OBJECT_PLANNING_STATUS_CODE |
Code indicating the planning or lifecycle status of the relationship. |
VARCHAR2 |
1 |
RELATIONSHIP_ACTIVE_FLG |
Flag indicating whether the HR object relationship is currently active. |
CHAR |
|
SORT_FIELD |
Sort sequence used to order multiple relationships of the same type. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WEIGHT_PERCENT |
Percentage weight assigned to the relationship. |
NUMBER |
5,2 |