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

360

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

48

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

240

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

36

COMPENSATE_FREQUENCY

Text for pay basis; annually, hourly, etc. Examples: Annually (6), Hourly (8), or null.

VARCHAR2

240

COMPENSATE_FREQUENCY_CODE

Code for pay basis; 6 = Annually, 8= Hourly, or null.

VARCHAR2

36

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

168

EEO_CATEGORY

XXX

VARCHAR2

360

EEO_CATEGORY_CODE

XXX

VARCHAR2

36

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

ESTIMATED_BUDGET_TYPE

XXX

VARCHAR2

300

ESTIMATED_BUDGET_TYPE_CODE

XXX

VARCHAR2

36

GL_ACCOUNT_ID

Identifies the GL Account.

VARCHAR2

72

GL_ACCOUNT_NAME

The text name associated with the GL_ACCOUNT_ID. For example: Telephone-Data Facilities, Materials and Services, and outside purchases.

VARCHAR2

600

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

120

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_ADDITION_TO_HEADCOUNT

XXX

VARCHAR2

36

IS_APPROVED

XXX

VARCHAR2

12

IS_EXEMPT

Is this an exempt position? Y or N.

VARCHAR2

12

IS_SHIFT_ELIGIBLE

Is this a shift type of position, Y or N

VARCHAR2

12

IS_VACANT

Is this a vacant position? Y or N.

VARCHAR2

12

JOB_DESCRIPTION_FLAG

XXX

VARCHAR2

12

JOB_FAMILY

XXX

VARCHAR2

480

JOB_FAMILY_CODE

XXX

VARCHAR2

36

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

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

144

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

1200

OCCUPATION_GROUP_CODE

MIT uses these codes, provided by the US Census Bureau, to group occupations for purposes of Affirmative Action planning

VARCHAR2

48

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

360

PAYROLL_RANK_CODE

XXX

VARCHAR2

36

PAY_GRADE

XXX

VARCHAR2

240

PAY_GRADE_AREA

XXX

VARCHAR2

240

PAY_GRADE_AREA_CODE

XXX

VARCHAR2

36

PAY_GRADE_CODE

XXX

VARCHAR2

96

PAY_GRADE_TYPE

XXX

VARCHAR2

240

PAY_GRADE_TYPE_CODE

XXX

VARCHAR2

36

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_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,2

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

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

10

REFERENCE_SALARY

Midpoint for salary range.

NUMBER

11,2

TENURE_STATUS

Tenure track (faculty only)

VARCHAR2

240

TENURE_STATUS_CODE

NT=Not tenured, TT=Tenure track

VARCHAR2

36

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_CLUSTER

XXX

VARCHAR2

360

WAREHOUSE_CLUSTER_CODE

XXX

VARCHAR2

60

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE