HR JOB HISTORY Table
Master data table containing a list of jobs, job titles, pay grade, salary ranges and other job related data.
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 |
DEFINED_BENEFIT_PLAN_CATEGORY |
XXX |
VARCHAR2 |
50 |
DEFINED_BENEFIT_PLAN_CAT_CODE |
XXX |
VARCHAR2 |
2 |
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 |
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 |
HIRING_RANGE_BEGIN_DATE |
XXX |
DATE |
7 |
HIRING_RANGE_END_DATE |
XXX |
DATE |
7 |
HOURLY_HIRING_MAX |
XXX |
NUMBER |
22 |
HOURLY_HIRING_MIN |
XXX |
NUMBER |
22 |
HR_JOB_FP_KEY |
XXX |
VARCHAR2 |
14 |
IPEDS_CATEGORY |
XXX |
VARCHAR2 |
80 |
IPEDS_CATEGORY_CODE |
XXX |
VARCHAR2 |
3 |
IS_9MOD_FOR_LIFE_INS |
XXX |
VARCHAR2 |
1 |
IS_EXEMPT |
Is this an exempt position? Y or N. |
VARCHAR2 |
1 |
JOB_DESCRIPTION_FLAG |
XXX |
VARCHAR2 |
1 |
JOB_FAMILY |
XXX |
VARCHAR2 |
30 |
JOB_FAMILY_CODE |
XXX |
VARCHAR2 |
3 |
JOB_ID |
The SAP 8-digit object id assigned to the job. |
VARCHAR2 |
8 |
JOB_LEVEL |
XXX |
VARCHAR2 |
10 |
JOB_LEVEL_CODE |
XXX |
VARCHAR2 |
3 |
JOB_SUBFAMILY |
XXX |
VARCHAR2 |
50 |
JOB_SUBFAMILY_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 |
JOB_TITLE_UPPERCASE |
Same as job title, BUT IN UPPERCASE. |
VARCHAR2 |
40 |
JOB_TITLE_WO_SRS |
XXX |
VARCHAR2 |
40 |
JOB_TRACK |
XXX |
VARCHAR2 |
22 |
JOB_TRACK_CODE |
XXX |
VARCHAR2 |
3 |
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 |
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_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
VACATION_ELIGIBILITY |
XXX |
VARCHAR2 |
50 |
VACATION_ELIGIBILITY_CODE |
XXX |
VARCHAR2 |
2 |
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 |
YEARLY_HIRING_MAX |
XXX |
NUMBER |
22 |
YEARLY_HIRING_MIN |
XXX |
NUMBER |
22 |