PAYROLL SALARY DETAIL Table
This table contains appointment/salary information for employees (exempts and non-exempts), graduate students, and hourly paid students.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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_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 |
FOREIGN_FELLOWSHIP_FLAG |
XXX |
VARCHAR2 |
1 |
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_EXEMPT_EMPLOYEE |
Flag Y/N is the employee exempt; in Payroll_Salary_Detail, status is as of time of transaction; in Payroll_Person, status is as of the time the query is run |
VARCHAR2 |
1 |
IS_HOURLY_PAID_STUDENT |
A flag, Y or N, indicating whether the person is an hourly paid student; in Payroll_Salary_Detail, status is as of time of transaction; in Payroll_Person, status is as of the time the query is run. |
VARCHAR2 |
1 |
IS_STUDENT_APPOINTMENT |
Flag Y/N indicates whether the employee has a student appointment; in Payroll_Salary_Detail, status is as of time of transaction; in Payroll_Person, status is as of the time the query is run |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
8 |
LAST_UPDATE_USER |
Last person that changed this record. |
VARCHAR2 |
12 |
LINK_FIELD |
XXX |
VARCHAR2 |
10 |
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_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_PERCENT_TIME |
The same as Original Employment Percent except for Support Staff. In DLCs where full time effort for Support Staff is: 40 hours, Original Percent time will be 100%; 35 hours, 87.5%; 37.5 hours, 93.75%. |
NUMBER |
22 |
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 |
ORIGINAL_WORK_WEEK |
Normal weekly hours for hourly paid employees only. This is 0 for monthly paid employees. |
NUMBER |
4.2 |
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 |
PAY_BASIS_NUMBER_OF_MONTHS |
The actual mumber of months for a particular appointment. Examples: 12 months = 12.0, 9 months = 9.0, fall = 5.0, temporary = 12.0, etc. |
NUMBER |
2 |
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 |
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_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_PERCENT_TIME |
the same as Original Percent Time 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 |
22 |
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 |
SUPPLEMENT_TYPE |
Supplements are payments outside the appointment base amount. Ex: rewards & recognition |
VARCHAR2 |
2 |
SUPPLEMENT_TYPE_CODE |
2 character alphanumeric code of supplement_type: EX: A1, CA, D9 |
VARCHAR2 |
1 |
TEMP_CHANGE_BASE_AMOUNT |
Temporary annual base salary, used for partial pay or when temporary pay applies |
NUMBER |
11.2 |
TEMP_CHANGE_HOURLY_RATE |
Temporary hourly rate for hourly paid employees. This is 0 for monthly paid employees. |
NUMBER |
7.2 |
TEMP_CHANGE_PERCENT_TIME |
The amount of the temporary change in percent time, up or down. This temporary number is reflected in Report Percent Time. |
NUMBER |
22 |
TEMP_CHANGE_PERIOD_AMOUNT |
Temporary monthly pay amount for monthly paid employees. This is 0 for hourly paid employees. |
NUMBER |
11.2 |
TEMP_CHANGE_REASON |
Description of the temporary action reason, e.g., leave of absence, extended sick leave |
VARCHAR2 |
100 |
TEMP_CHANGE_REASON_CODE |
Code for temporary action reason, e.g., LOA, ESL |
VARCHAR2 |
2 |
TEMP_CHANGE_WORK_WEEK |
Temporary normal weekly hours for hourly paid employees only. This is 0 for monthly paid employees. |
NUMBER |
4.2 |
TEMP_EMPLOYMENT_PERCENT |
The amount of the temporary change in employemnt percent, up or down. This temporary number is reflected in Report Employment Percent. |
NUMBER |
22 |
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 |