Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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