HR APPT LETTER DETAIL Table
This table contains all of the letters sent to Employees by HR. One letter is sent for every appointment transaction that occurs. This table includes salary information for all employees and its use is restricted to HR_Superusers.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
APPOINTMENT_AMOUNT |
The total dollar amount paid for the duration of an appointment. Generally used for non-tenure academic appointments. |
NUMBER |
15.2 |
APPT_LETTER_BEGIN_DATE |
Beginning date of the appointment for the letter to be issued. |
DATE |
8 |
APPT_LETTER_END_DATE |
Ending date of the appointment for the letter to be issued. |
DATE |
8 |
COLLECTION_POINT |
Code identifying a location within an organzational unit where time reports are collected and submitted for service, support staff, and undergraduate students. |
VARCHAR2 |
3 |
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_PERSONNEL_ACTION_TYPE_KEY |
This field is used to join HR_PERSONNEL_ACTION_DETAIL table with HR_PERSONNEL_ACTION_TYPE table. |
VARCHAR2 |
4 |
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_ACTION_CORRECTION |
XXX |
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 |
LETTER |
Type of letter to be created. |
VARCHAR2 |
100 |
LETTER_CODE |
Code to determine the type of letter to be generated. |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
SPONSOR |
XXX |
VARCHAR2 |
100 |
SPONSOR_CODE |
Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
6 |
STIPEND_PAID_BY |
XXX |
VARCHAR2 |
1 |
VACATION_DAYS_DUE |
Number of vacation days to be paid. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |