HR POSITION FULL HISTORY Table
Master data table containing position information, such as position title, position area/subarea and employee group/subgroup. It also includes position's salary information
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
AAP_CATEGORY |
This is the text description of the AAP_CATEGORY_CODE which is an employment category defined by MIT. It is a further breakdown of the EEO_Category. Examples: Administrative Professional Level (41), Data Processing Professional (4D), Financial Planning Professional (4F), and Physicians (4P). |
VARCHAR2 |
30 |
AAP_CATEGORY_CODE |
This is an employment category defined by MIT. It is a further breakdown of the EEO_Category_Code. Examples: 41 = Administrative Professional Level, 4D = Data Processing Professional, 4F = Financial Planning Professional and 4P = Physicians. |
VARCHAR2 |
4 |
BENEFITS_ELIGIBILITY |
Text for BENEFITS_ELIGIBILITY_CODE. One of the factors for determining an employee?s benefits eligibility is the percent of effort an employee is working. Employee?s working 50% or more satisfy that eligibility factor. At the Institute, employees can have multiple positions, which may or may not add up to over 50% effort. These positions need to be analyzed to determine the total percent of effort the employee is working. Example: Example: Ineligible (1), Partial (2), All (4), or N/A (N/A). |
VARCHAR2 |
30 |
BENEFITS_ELIGIBILITY_CODE |
Code indicating if an employee is eligible for MIT benefits. One of the factors for determining an employee?s benefits eligibility is the percent of effort an employee is working. Employee?s working 50% or more satisfy that eligibility factor. At the Institute, employees can have multiple positions, which may or may not add up to over 50% effort. These positions need to be analyzed to determine the total percent of effort the employee is working. Example: 1 = Ineligible, 2 = Partial, 4 = All, or N/A = N/A. |
VARCHAR2 |
3 |
COMPENSATE_FREQUENCY |
Text for pay basis; annually, hourly, etc. Examples: Annually (6), Hourly (8), or null. |
VARCHAR2 |
20 |
COMPENSATE_FREQUENCY_CODE |
Code for pay basis; 6 = Annually, 8= Hourly, or null. |
VARCHAR2 |
3 |
COST_PLANNING_TYPE |
This field indicates the source for the Position Budget field. For a filled position, the value is Actual Salary (same as base annual salary) For unfilled positions: where the Estimated Salary has been maintained, the value is Estimated Sal (same as estimated base annual salary); where the Estimated Salary has not been maintained in SAP, the value is N/A. |
VARCHAR2 |
14 |
EEO_CATEGORY |
XXX |
VARCHAR2 |
30 |
EEO_CATEGORY_CODE |
XXX |
VARCHAR2 |
3 |
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
30 |
EMPLOYEE_GROUP_CODE |
Code identifying an employee grouping: E for Exempt, N for Non-Exempt, X for External. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Further classifies employee into classified, monthly, or weekly paid. |
VARCHAR2 |
30 |
EMPLOYEE_SUBGROUP_CODE |
Further classifies employee group into classified, monthly, or weekly paid, EM for exempt monthly. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
30 |
ESTIMATED_BUDGET_TYPE |
XXX |
VARCHAR2 |
25 |
ESTIMATED_BUDGET_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
GL_ACCOUNT_ID |
Identifies the GL Account. |
VARCHAR2 |
6 |
GL_ACCOUNT_NAME |
The text name associated with the GL_ACCOUNT_ID. For example: Telephone-Data Facilities, Materials and Services, and outside purchases. |
VARCHAR2 |
20 |
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 |
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 |
14 |
IS_ADDITION_TO_HEADCOUNT |
XXX |
VARCHAR2 |
3 |
IS_APPROVED |
XXX |
VARCHAR2 |
3 |
IS_EXEMPT |
Is this an exempt position? Y or N. |
VARCHAR2 |
1 |
IS_SHIFT_ELIGIBLE |
Is this a shift type of position, Y or N |
VARCHAR2 |
1 |
IS_VACANT |
Is this a vacant position? Y or N. |
VARCHAR2 |
1 |
JOB_DESCRIPTION_FLAG |
XXX |
VARCHAR2 |
1 |
JOB_FAMILY |
XXX |
VARCHAR2 |
30 |
JOB_FAMILY_CODE |
XXX |
VARCHAR2 |
3 |
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 |
50 |
MAXIMUM_SALARY |
Maximum salary for pa level; hourly will be in terms of hourly rate. |
NUMBER |
11.2 |
MINIMUM_SALARY |
Minimum salary for pay level: hourly will be in terms of hourly rate, and zero for others. |
NUMBER |
11.2 |
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 |
12 |
OCCUPATION_GROUP |
Text for Occupation Group Code. MIT uses these codes, provided by the US Census Bureau, to group occupations for purposes of Affirmative Action planning |
VARCHAR2 |
20 |
OCCUPATION_GROUP_CODE |
MIT uses these codes, provided by the US Census Bureau, to group occupations for purposes of Affirmative Action planning |
VARCHAR2 |
3 |
PAYROLL_RANK |
Rank of instructors. Eg.: Professor, Teaching Assistant, Lecturer, Assistant Professor, Associate Professor with tenure, Research Assistant, Grad Student Fellow, Associate Professor w/o tenure, Instructor, senior Lecturer, Technical Instructor, etc. |
VARCHAR2 |
30 |
PAYROLL_RANK_CODE |
XXX |
VARCHAR2 |
3 |
PAY_GRADE |
XXX |
VARCHAR2 |
20 |
PAY_GRADE_AREA |
XXX |
VARCHAR2 |
20 |
PAY_GRADE_AREA_CODE |
XXX |
VARCHAR2 |
3 |
PAY_GRADE_CODE |
XXX |
VARCHAR2 |
8 |
PAY_GRADE_TYPE |
XXX |
VARCHAR2 |
20 |
PAY_GRADE_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
30 |
PERSONNEL_AREA_CODE |
4 character code to identify employee groups; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
4 |
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 |
30 |
PERSONNEL_SUBAREA_CODE |
4 character code to further identify the personnel area, e.g., CFAC for faculty. |
VARCHAR2 |
4 |
POSITION_BUDGET |
If the Position is filled, this value equals the Base Annual Salary of the person for that appointment. If the position is unfilled, this value equals the Estimated Base Annual Salary provided on the RFP and stored as part of the vacancy information for the position. |
NUMBER |
13.3 |
POSITION_DESCRIPTION_FLAG |
This field contains a "Y" if the position has a full description in SAP. Otherwise it contains an "N". |
VARCHAR2 |
1 |
POSITION_ID |
This is an 8-digit unique number generated by SAP and is specific to each position. |
VARCHAR2 |
8 |
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 |
12 |
POSITION_TITLE |
Specific Position Title tied to the Position ID. This may be more specifc than the official job title. |
VARCHAR2 |
50 |
POSITION_TITLE_LONG |
The 50-character long position title. |
VARCHAR2 |
50 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
REFERENCE_SALARY |
Midpoint for salary range. |
NUMBER |
11.2 |
TENURE_STATUS |
Tenure track (faculty only) |
VARCHAR2 |
20 |
TENURE_STATUS_CODE |
NT=Not tenured, TT=Tenure track |
VARCHAR2 |
3 |
TIME_GROUP |
XXX |
VARCHAR2 |
65 |
TIME_GROUP_CODE |
XXX |
VARCHAR2 |
10 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_CLUSTER |
XXX |
VARCHAR2 |
30 |
WAREHOUSE_CLUSTER_CODE |
XXX |
VARCHAR2 |
5 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |