HR ORG UNIT PEOPLE Table
View exposing relationships between people and HR organizational units including person identifiers, organizational assignments, and related attributes used for organizational reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HRO_FIRST_NAME |
Column HRO_FIRST_NAME. |
VARCHAR2 |
40 |
HRO_FULL_NAME |
Column HRO_FULL_NAME. |
VARCHAR2 |
100 |
HRO_KRBNAME |
Column HRO_KRBNAME. |
VARCHAR2 |
30 |
HRO_LAST_NAME |
Column HRO_LAST_NAME. |
VARCHAR2 |
40 |
HRO_MIDDLE_NAME |
Column HRO_MIDDLE_NAME. |
VARCHAR2 |
40 |
HRO_MIT_ID |
Column HRO_MIT_ID. |
VARCHAR2 |
9 |
HRO_OFFICE_ADDRESS |
Column HRO_OFFICE_ADDRESS. |
VARCHAR2 |
40 |
HRO_OFFICE_ADDR_SITE |
Column HRO_OFFICE_ADDR_SITE. |
VARCHAR2 |
2 |
HRO_OFFICE_BUILDING |
Column HRO_OFFICE_BUILDING. |
VARCHAR2 |
15 |
HRO_OFFICE_PHONE |
Column HRO_OFFICE_PHONE. |
VARCHAR2 |
15 |
HRO_OFFICE_ROOM |
Column HRO_OFFICE_ROOM. |
VARCHAR2 |
15 |
HRO_PERSONNEL_KEY |
Column HRO_PERSONNEL_KEY. |
VARCHAR2 |
8 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |