HR POSITION DETAIL HISTORY Table
This table contains information about position budgets and statuses, from 2004 to present. For filled positions, it specifies who holds them and for what periods of time. For unfilled positions, it specifies their sub-status.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_PLANNING_TYPE |
This field indicates the source for the Position Budget field. For a filled position, the value is Actual Salary (same as base annual salary) For unfilled positions: where the Estimated Salary has been maintained, the value is Estimated Sal (same as estimated base annual salary); where the Estimated Salary has not been maintained in SAP, the value is N/A. |
VARCHAR2 |
14 |
END_DATE |
Specific to HR_POSITION_DETAIL: For filled positions, End Date equals Appointment End Date. For open-ended appointments, this date is usually 12/31/2999. For Closed Positions, the End Date is the delimit date on the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the latest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the end of the term. For STIP, this is set to the latest date for this account in the term in the stipend distribution section in the RPAGAAID form in MITSIS. UNMATCHED payroll has this set to the latest date in the unmatched Payroll records. In all other tables, END DATE is the thru date of the transaction. |
DATE |
8 |
EXPECTED_FILL_DATE |
This field is used only for unfilled positions. It is an estimate of the anticipated hire date supplied by the DLC administrator on the RFP form. |
DATE |
8 |
HR_JOB_FP_KEY |
XXX |
VARCHAR2 |
14 |
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_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_STATUS_KEY |
This field should be used to join HR_POSITION_DETAIL or HR_POSITION_LIMITED_DETAIL tables and the HR_POSITION_STATUS table for the various statuses of a position |
VARCHAR2 |
11 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
POSITION_BUDGET |
If the Position is filled, this value equals the Base Annual Salary of the person for that appointment. If the position is unfilled, this value equals the Estimated Base Annual Salary provided on the RFP and stored as part of the vacancy information for the position. |
NUMBER |
13.3 |
POSITION_FTE_PERCENT |
If the Position is filled, this value equals the percent time for that appointment. If the position is unfilled, this value equals the Planned FTE provided on the RFP and stored as part of the vacancy information for the position. NOTE: By definition, full time equivalent is based on a 40-hour work week for hourly paid employees. (e.g. 35/40 = 87.5% FTE) |
NUMBER |
7.4 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
START_DATE |
The first day of the fiscal period. Specific to HR_POSITION_DETAIL: If the Position is filled, this value equals the appointment begin date of the person filling that position. If the position is unfilled, this value is either the date the last person vacated the position. For new positions that have never been filled, this date is the start date assigned to the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the earliest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the beginning of the term. For STIP, this is set to the earliest date for this account in the term in the stipend distribution section in the RPAGAAID form. UNMATCHED payroll has this set to the earliest date in the unmatched Payroll records. |
DATE |
8 |
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 |
WEBHIRE_REQ_NUMBER |
Indicates the WebHire (applicant tracking system) Job Requisition number for vacant/posted positions. |
VARCHAR2 |
12 |
WORK_WEEK_HOURS |
Applies only to hourly paid positions. If the Position is filled, this value equals the planned number of hours for that appointment. If the position is unfilled, this value equals the Planned WorkHours provided on the RFP and stored as part of the vacancy information for the position. |
NUMBER |
5.2 |