Data Warehouse

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

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