Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR POSITION Table


Master data table containing position information, such as position title, position area/subarea and employee group/subgroup, for the current fiscal period.


Field Name

Description

Data Type

Length

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

HR_JOB_KEY

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

VARCHAR2

10

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_SHIFT_ELIGIBLE

Is this a shift type of position, Y or N

VARCHAR2

1

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

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

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

TIME_GROUP

XXX

VARCHAR2

65

TIME_GROUP_CODE

XXX

VARCHAR2

10

UROP_LIMIT

XXX

NUMBER

22

WAREHOUSE_LOAD_DATE

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

DATE

8