ESANDI RETRO Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT_TO_BE_DISTRIBUTED |
XXX |
NUMBER |
34 |
AMOUNT_TO_BE_PAID |
XXX |
NUMBER |
34 |
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 |
BASIS |
XXX |
VARCHAR2 |
50 |
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
The name of the Cost Collector. |
VARCHAR2 |
100 |
CURRENT_MONTH_PAY |
XXX |
NUMBER |
34 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
75 |
DISTRIBUTION_BEGIN_DATE |
Beginning date of the salary distribution to a position/person/percent/and cost object. |
DATE |
|
DISTRIBUTION_END_DATE |
Ending date of salary distribution to a position/person/percent/and cost object. |
DATE |
|
DISTRIBUTION_PERCENT |
XXX |
NUMBER |
5,2 |
DIST_CURRENT_MONTH_AMOUNT |
XXX |
NUMBER |
34 |
DIST_FYTD_AMOUNT |
XXX |
NUMBER |
34 |
DIST_RETRO_AMOUNT |
XXX |
NUMBER |
15,2 |
EDACCA_DISTRIBUTION_BEGIN_DATE |
XXX |
DATE |
|
EDACCA_DISTRIBUTION_END_DATE |
XXX |
DATE |
|
FOR_PERIOD |
XXX |
VARCHAR2 |
12 |
FOR_PERIOD_DATE_LONG |
XXX |
VARCHAR2 |
41 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
150 |
FYTD_PAY |
XXX |
NUMBER |
34 |
GL_ACCOUNT_ID |
Identifies the GL Account. |
VARCHAR2 |
6 |
GL_ACCOUNT_NAME |
The text name associated with the GL_ACCOUNT_ID. For example: Telephone-Data Facilities, Materials and Services, and outside purchases. |
VARCHAR2 |
50 |
IN_PERIOD |
XXX |
VARCHAR2 |
12 |
IN_PERIOD_DATE_LONG |
XXX |
VARCHAR2 |
41 |
IS_VACATION_CREDIT |
A flag (Y or N) to indicate whether the distribution is a vacation credit |
VARCHAR2 |
1 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
300 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAYMENT_SCHEDULE |
XXX |
VARCHAR2 |
40 |
PERCENT_EFFORT |
Percentage of work effort. Examples: For faculty, academic and administrative staff, 100% represents full time effort. For Support and Service staff, 100% represents a 35, 37.5, or 40 hour work week. |
NUMBER |
34 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
40 |
PREVIOUS_MONTH |
XXX |
DATE |
|
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_NAME |
The text name of the profit center. |
VARCHAR2 |
40 |
RATE |
XXX |
NUMBER |
34 |
REPORT_DATE |
XXX |
VARCHAR2 |
90 |
SUPPLEMENT_TYPE |
Supplements are payments outside the appointment base amount. Ex: rewards & recognition |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |