HR OBJECT RELATIONSHIP PFML Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDL_DATA |
XXX |
VARCHAR2 |
32 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
HR_OBJECT_CODE |
XXX |
VARCHAR2 |
8 |
HR_OBJECT_RELATIONSHIP |
XXX |
VARCHAR2 |
25 |
HR_OBJECT_RELATIONSHIP_CODE |
XXX |
VARCHAR2 |
4 |
HR_OBJECT_RELATION_END_DATE |
XXX |
DATE |
|
HR_OBJECT_RELATION_START_DATE |
XXX |
DATE |
|
HR_OBJECT_TYPE |
XXX |
VARCHAR2 |
25 |
HR_OBJECT_TYPE_CODE |
XXX |
VARCHAR2 |
2 |
HR_OBJECT_WITH_TYPE |
XXX |
VARCHAR2 |
10 |
HR_RELATED_OBJECT_CODE |
XXX |
VARCHAR2 |
45 |
HR_RELATED_OBJECT_TYPE |
XXX |
VARCHAR2 |
25 |
HR_RELATED_OBJECT_TYPE_CODE |
XXX |
VARCHAR2 |
2 |
HR_RELATED_OBJECT_WITH_TYPE |
XXX |
VARCHAR2 |
47 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
|
LAST_UPDATE_USER |
Last person that changed this record. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OBJECT_PLANNING_STATUS_CODE |
XXX |
VARCHAR2 |
1 |
RELATIONSHIP_ACTIVE_FLG |
XXX |
CHAR |
|
SORT_FIELD |
XXX |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WEIGHT_PERCENT |
XXX |
NUMBER |
5,2 |