HR EMPLOYEE AFFILIATION DETAIL Table
Stores detailed employee affiliation records, including organizational assignment, position context, and employment percentage over a defined time period. Used for HR reporting and workforce analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFILIATION_BEGIN_DATE |
Start date of the employee affiliation period. |
DATE |
|
AFFILIATION_END_DATE |
End date of the employee affiliation period, if applicable. |
DATE |
|
HR_EMP_AFFILIATION_TYPE_KEY |
Foreign key identifying the type of employee affiliation (e.g., primary, secondary, courtesy). |
VARCHAR2 |
10 |
HR_ORG_UNIT_KEY |
Foreign key identifying the HR organizational unit associated with the affiliation. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Foreign key identifying the position associated with the employee affiliation. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the individual. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_KEY |
Surrogate key uniquely identifying the employee in HR source systems. |
VARCHAR2 |
8 |
RECORD_COUNTER |
System-generated counter used to distinguish multiple records for the same employee and affiliation. |
NUMBER |
|
REPORT_EMPLOYMENT_PERCENT |
Percentage of employment effort associated with this affiliation for reporting purposes. |
NUMBER |
17,8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |