Data Warehouse

APPT_BEGIN_DATE

Start date for an employee's appointment to a specific MIT position.

DATE

8

APPT_END_DATE

End date for an employee's appointment to a specific MIT position or 12/31/2999 for indefinite end

DATE

8

APPT_TX_BEGIN_DATE

Effective date of a change to an appointment, i.e. salary increase, leave, change in effort, etc.

DATE

8

APPT_TX_END_DATE

This field does not have any business meaning, and will be hidden in the future

DATE

8

COST_COLLECTOR_KEY

Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

12

DISTRIBUTION_BEGIN_DATE

Beginning date of the salary distribution to a position/person/percent/and cost object.

DATE

8

DISTRIBUTION_END_DATE

Ending date of salary distribution to a position/person/percent/and cost object.

DATE

8

GL_ACCOUNT_KEY

Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

10

HOURS_WORKED

XXX

NUMBER

22

HR_APPT_SUBTYPE

This field contains the description of the appointment subtype, Examples: Academic Appointment (MNT1), Academic Appointment--MAP (MAP1), etc..

VARCHAR2

100

HR_APPT_SUBTYPE_CODE

Code to identify the appointment subtype: MNT1= Academic Appointment, MAP1 = Academic Appointment--MAP, etc..

VARCHAR2

4

HR_ORG_UNIT_FP_KEY

Similar to HR_ORG_UNIT_KEY but used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables to corresponding HR_ORG_UNIT_FP_KEY in Fact tables when retrieving data as it was in the selected past fiscal period rather than current data. Used ONLY for joining data, not for reporting.

VARCHAR2

14

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

14

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_VACATION_CREDIT

A flag (Y or N) to indicate whether the distribution is a vacation credit

VARCHAR2

1

LINK_FIELD

XXX

VARCHAR2

10

MASTER_COST_COLLECTOR_ID

This is the payroll clearing account, where payroll is posted. It is the offset for the distribution entry.

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

ORIGINAL_BASE_AMOUNT

Annual base salary, not including partial pay or temporary pay

NUMBER

11.2

ORIGINAL_EMPLOYMENT_PERCENT

Percent effort based on normal working hours. For Faculty and exempt staff, 100% represents full time effort. For Support staff, it is normal work hours divided by # of hours in work schedule rule

NUMBER

7.4

ORIGINAL_FTE_PERCENT_EFFORT

Percent effort based on normal working hours. For Faculty 100% represents full time effort. For Support and Service staff, 100% represents a 35, 37.5 or 40 hour work week.

NUMBER

7.4

ORIGINAL_HOURLY_RATE

Hourly rate of pay, not including partial pay or temporary pay, for hourly paid employees only. This is 0 for monthly paid employees.

NUMBER

7.2

ORIGINAL_PERIOD_AMOUNT

Monthly pay amount, not including partial pay or temporary pay, for monthly paid employees. This is 0 for hourly paid employees.

NUMBER

11.2

PAYROLL_DIST_AMOUNT

The amount distributed for the specified parameters (cost collector, time period, etc) for a position/person/percent/and cost object

NUMBER

22

PAYROLL_DIST_COMMENTS

Text created by the CDU (cost distribution utility) to indicate how the data got into the edacca table.. Ex: 'add for retro', or 'reversal'

VARCHAR2

40

PAYROLL_DIST_PERCENT

The percent of salary distributed for the specified parameters (cost collector, time period, etc)

NUMBER

5.2

PAYROLL_DIST_PERCENT_ACROSS_WT

The percent of salary distributed to each wage type for the specified parameters (cost collector, time period, etc)

NUMBER

22

PAYROLL_EDACCA_CERT_KEY

Key field used to join the Payroll Edacca Cert table to Payroll Edacca Detail. This field should only be used for joining data, NOT for reporting.

VARCHAR2

20

PAYROLL_FOR_PERIOD_KEY

Key field used to join the PAYROLL_FOR_PERIOD table to Payroll fact tables. Use for joining data, not for reporting.

VARCHAR2

8

PAYROLL_IN_PERIOD_KEY

Key field used to join the PAYROLL_IN_PERIOD table to Payroll fact tables. Use for joining data, not for reporting.

VARCHAR2

8

PAYROLL_PAYMENT_DATE

The date that appears on the check or direct deposit as the payment date.

DATE

8

PAYROLL_WAGE_TYPE_KEY

Key field used to join the PAYROLL_WAGE_TYPE table to Payroll fact tables. Use for joining data, not for reporting.

VARCHAR2

4

PAY_BASIS

Description of the timeframe for this appointment, eg. 09 months, 12 months, fall (9/1 to 1/15), temporary (< 12 months), etc.

VARCHAR2

50

PAY_BASIS_CODE

Code specifying the number of months or timeframe for this appointment, eg. 09 (for 9 months), 12 (for 12 months), fall (for 9/1 to 1/15), temp (for < 12 months), etc.

VARCHAR2

7

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

RECORD_COUNTER

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

NUMBER

1

REPORT_BASE_AMOUNT

Current annual base salary. If there is a temporary change in base amount, it will appear in this field; otherwise, the field will display the original base amount.

NUMBER

11.2

REPORT_EMPLOYMENT_PERCENT

Same as Original Employment Percent unless the person has a temporary change in effort, up or down, in which case this field will show the percent based on the temporary change.

NUMBER

7.4

REPORT_FTE_PERCENT_EFFORT

Current percent effort based on normal working hours. For Faculty, 100% represents full time effort. For Support and Service staff, 100% represents a 40 hour work week. If there is a temporary change FTE percent effort amount, it will appear in this field, otherwise the field wil display the original fte percent effort.

NUMBER

7.4

REPORT_HOURLY_RATE

Current hourly wage for hourly paid employees only. This is 0 for monthly paid employees. If there is a temporary change hourly amount, it will appear in this field, otherwise the field will display the original hourly rate.

NUMBER

11.2

REPORT_PERIOD_AMOUNT

Current monthly amount for monthly paid employees only. This is 0 for hourly paid employees. If there is a temporary change monthly amount, it will appear in this field, otherwise the field will display the original period amount.

NUMBER

11.2

REPORT_WORK_WEEK

Current normal weekly hours for hourly paid employees only. This is 0 for monthly paid employees. If there is a temporary change work week, it will appear in this field, otherwise the field will display the original work week.

NUMBER

4.2

SUSPENSE_STATUS

A flag, Y or N, indicating that the salary payment has been distributed to the department's suspense cost object by the payroll system, e.g., when a cost object has expired. This flag is NOT set if the salary was manually charged to the department's suspense cost object by the department administrator or the Payroll Service Center.

VARCHAR2

60

TIME_MONTH_KEY

Key used only for joining the TIME_MONTH table to other tables, NOT for reporting.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

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

DATE

8

WORK_SCHEDULE_HOURS

The person's normal work week, e.g., 35, 37.5, 40, or 42.5 hours

NUMBER

22