Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR POSITION FULL Table


Master data table containing position information, such as position title, position area/subarea and employee group/subgroup, for the current fiscal period. 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_KEY

This field should be used to join HR_POSITION and HR_POSITION_LIMITED tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

10

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_BEGIN_DATE

The date when the position becomes active. Most positions that were converted in the fall 2003 have this date set to 01/01/1900.

DATE

8

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_END_DATE

The date when the position stops being active. The positions that have not been closed, will have 12/31/2999 in this field.

DATE

8

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

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