HR EMPLOYEE AFFILIATION TYPE Table
Reference table defining employee affiliation types and related reporting indicators used to categorize and interpret employee affiliations in HR analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_EMP_AFFILIATION_TYPE |
Descriptive name of the employee affiliation type (e.g., primary appointment, secondary affiliation). |
VARCHAR2 |
29 |
HR_EMP_AFFILIATION_TYPE_CODE |
Short code representing the employee affiliation type in source HR systems. |
VARCHAR2 |
3 |
HR_EMP_AFFILIATION_TYPE_KEY |
Surrogate key uniquely identifying an employee affiliation type. |
VARCHAR2 |
10 |
IS_ADMIN_DEPT |
Indicator specifying whether this affiliation type is associated with an administrative department (Y/N). |
VARCHAR2 |
1 |
IS_CURRENT_AFFILIATION |
Indicator specifying whether this affiliation type represents a current/active affiliation (Y/N). |
VARCHAR2 |
1 |
IS_HEADCNT_DEPT |
Indicator specifying whether this affiliation type is counted toward departmental headcount (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |