HR ORG UNIT PEOPLE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HRO_FIRST_NAME |
XXX |
VARCHAR2 |
40 |
HRO_FULL_NAME |
XXX |
VARCHAR2 |
100 |
HRO_KRBNAME |
XXX |
VARCHAR2 |
30 |
HRO_LAST_NAME |
XXX |
VARCHAR2 |
40 |
HRO_MIDDLE_NAME |
XXX |
VARCHAR2 |
40 |
HRO_MIT_ID |
XXX |
VARCHAR2 |
9 |
HRO_OFFICE_ADDRESS |
XXX |
VARCHAR2 |
40 |
HRO_OFFICE_ADDR_SITE |
XXX |
VARCHAR2 |
2 |
HRO_OFFICE_BUILDING |
XXX |
VARCHAR2 |
15 |
HRO_OFFICE_PHONE |
XXX |
VARCHAR2 |
15 |
HRO_OFFICE_ROOM |
XXX |
VARCHAR2 |
15 |
HRO_PERSONNEL_KEY |
XXX |
VARCHAR2 |
8 |
HR_ORG_UNIT_KEY |
This field should be used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |