HR POSITION HISTORY Table
Master data table containing position information, such as position title, position area/subarea and employee group/subgroup.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
240 |
EMPLOYEE_GROUP_CODE |
Code identifying an employee grouping: E for Exempt, N for Non-Exempt, X for External. |
VARCHAR2 |
12 |
EMPLOYEE_SUBGROUP |
Further classifies employee into classified, monthly, or weekly paid. |
VARCHAR2 |
240 |
EMPLOYEE_SUBGROUP_CODE |
Further classifies employee group into classified, monthly, or weekly paid, EM for exempt monthly. |
VARCHAR2 |
24 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
360 |
HR_POSITION_FP_KEY |
Similar to HR_POSITION_KEY but used to join HR_POSITION to corresponding HR_POSITION_FP_KEY in Fact tables when retrieving data as it was in selected past fiscal period rather than current data. Used ONLY for joining data, not for reporting. |
VARCHAR2 |
168 |
IS_SHIFT_ELIGIBLE |
Is this a shift type of position, Y or N |
VARCHAR2 |
12 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
600 |
MIT_JOB_CODE |
Indicates the job code used by Human Resources. For admin and support staff jobs, the codes include the level of the job (e.g. HR-QG034, HR-04FN01). |
VARCHAR2 |
144 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
360 |
PERSONNEL_AREA_CODE |
4 character code to identify employee groups; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
48 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
240 |
PERSONNEL_SUBAREA_CODE |
4 character code to further identify the personnel area, e.g., CFAC for faculty. |
VARCHAR2 |
48 |
POSITION_DESCRIPTION_FLAG |
This field contains a "Y" if the position has a full description in SAP. Otherwise it contains an "N". |
VARCHAR2 |
12 |
POSITION_ID |
This is an 8-digit unique number generated by SAP and is specific to each position. |
VARCHAR2 |
96 |
POSITION_SORT |
For some departments, this field is used for sorting positions in positiion management reports. For all other departments, this field is blank. |
VARCHAR2 |
144 |
POSITION_TITLE |
Specific Position Title tied to the Position ID. This may be more specifc than the official job title. |
VARCHAR2 |
540 |
POSITION_TITLE_LONG |
The 50-character long position title. |
VARCHAR2 |
600 |
TIME_GROUP |
XXX |
VARCHAR2 |
780 |
TIME_GROUP_CODE |
XXX |
VARCHAR2 |
120 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
72 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |