HR EMPLOYEE AFFILIATION TYPE Table
Data identifying the type of research affiliation (high,medium,low)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_EMP_AFFILIATION_TYPE |
XXX |
VARCHAR2 |
50 |
HR_EMP_AFFILIATION_TYPE_CODE |
XXX |
VARCHAR2 |
4 |
HR_EMP_AFFILIATION_TYPE_KEY |
XXX |
VARCHAR2 |
50 |
IS_ADMIN_DEPT |
XXX |
VARCHAR2 |
1 |
IS_CURRENT_AFFILIATION |
Indicates whether or not this affiliation is current:Y or N. |
VARCHAR2 |
1 |
IS_HEADCNT_DEPT |
Is this the headcount department? Y or N. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |