Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL HRLY STU SAL DETAIL Table


This fact table contains salary/appointment information for hourly paid students.


Field Name

Description

Data Type

Length

APPT_SUBTYPE

Descriptive text about the appointment, e.g., academic or non-academic, regular or short-term, exempt or non-exempt, etc.

VARCHAR2

100

APPT_SUBTYPE_CODE

4-character alphanumeric code for the appointment subtype, e.g., RGE1 - non-academic regular or STE1 - non-academic short-term exempt.

VARCHAR2

4

ASSIGNMENT

Assignment number (e.g., 1st, 2nd, 4th) indicating which hourly student position the salary is for.

VARCHAR2

2

ASSIGNMENT_CODE

Four digit code (e.g., 0001, 0004) indicating which hourly student position the salary is for

VARCHAR2

16

HOURLY_PAY_AMOUNT

Hourly pay amount (pay rate) of an hourly paid employee

NUMBER

9.2

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

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PAY_BEGIN_DATE

The beginning date (Monday) of a work/paid week.

DATE

8

PAY_END_DATE

The ending date (Sunday) of a work/paid week.

DATE

8

PERSONNEL_KEY

Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

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

DATE

8