HR APPOINTMENT DETAIL Table
This table contains the detail information for all employee appointments (such as: shift eligibility, pay basis, and . This table contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003.The salary for confidential employees is set to $0.01.
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_WAGE_TYPE |
XXX |
VARCHAR2 |
25 |
APPT_WAGE_TYPE_CODE |
XXX |
VARCHAR2 |
4 |
APPT_WORK_BEGIN_DATE |
XXX |
DATE |
7 |
APPT_WORK_END_DATE |
XXX |
DATE |
7 |
FTE_ORIGINAL_BASE_AMOUNT |
XXX |
NUMBER |
22 |
FTE_REPORT_BASE_AMOUNT |
XXX |
NUMBER |
22 |
FTE_TEMP_CHANGE_BASE_AMOUNT |
XXX |
NUMBER |
22 |
HR_APPT_KEY |
XXX |
NUMBER |
22 |
HR_APPT_TYPE_KEY |
XXX |
VARCHAR2 |
20 |
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 |
IS_MOST_RECENT_APPT |
XXX |
VARCHAR2 |
1 |
IS_SHIFT_ELIGIBLE |
Is this a shift type of position, Y or N |
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 |
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 |
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 |
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 |
TEMP_CHANGE_BASE_AMOUNT |
Temporary annual base salary, used for partial pay or when temporary pay applies |
NUMBER |
11.2 |
TEMP_CHANGE_EMPLOYMENT_PERCENT |
XXX |
NUMBER |
7.4 |
TEMP_CHANGE_FTE_PERCENT_EFFORT |
Temporary 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 |
TEMP_CHANGE_HOURLY_RATE |
Temporary hourly rate for hourly paid employees. This is 0 for monthly paid employees. |
NUMBER |
7.2 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WORKING_WEEK |
Normal weekly hours |
VARCHAR2 |
100 |
WORKING_WEEK_CODE |
Code for normal weekly hours |
VARCHAR2 |
2 |
WORK_SCHEDULE_RULE |
Code specifying the number of normal hours for the job, e.g., 35_WW |
VARCHAR2 |
8 |
WORK_SCHEDULE_RULE_DESCRIPTION |
XXX |
VARCHAR2 |
40 |
YRS_IN_POSITION |
XXX |
NUMBER |
22 |