HR ROLES QUALIFIER Table
HR Roles qualifier
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
8 |
ROLES_QUALIFIER_CODE |
XXX |
VARCHAR2 |
15 |
ROLES_QUALIFIER_KEY |
XXX |
NUMBER |
12 |
ROLES_QUALIFIER_NAME |
XXX |
VARCHAR2 |
50 |
ROLES_QUALIFIER_TYPE |
XXX |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |