ESANDI RETRO Table
View exposing retroactive labor distribution allocation records including personnel, appointment, cost collector, general ledger account, retro amount, and related costing attributes used for financial allocation reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT_TO_BE_DISTRIBUTED |
Amount to be distributed associated with the record. |
NUMBER |
34 |
AMOUNT_TO_BE_PAID |
Amount to be paid associated with the record. |
NUMBER |
34 |
APPT_SUBTYPE |
Appt subtype associated with the record. |
VARCHAR2 |
100 |
APPT_SUBTYPE_CODE |
Code identifying appt subtype. |
VARCHAR2 |
4 |
BASIS |
Basis associated with the record. |
VARCHAR2 |
50 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
Cost collector name associated with the record. |
VARCHAR2 |
100 |
CURRENT_MONTH_PAY |
Current month pay associated with the record. |
NUMBER |
34 |
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
75 |
DISTRIBUTION_BEGIN_DATE |
Date associated with distribution begin. |
DATE |
|
DISTRIBUTION_END_DATE |
Date associated with distribution end. |
DATE |
|
DISTRIBUTION_PERCENT |
Distribution percent associated with the record. |
NUMBER |
5,2 |
DIST_CURRENT_MONTH_AMOUNT |
Dist current month amount associated with the record. |
NUMBER |
34 |
DIST_FYTD_AMOUNT |
Dist fytd amount associated with the record. |
NUMBER |
34 |
DIST_RETRO_AMOUNT |
Dist retro amount associated with the record. |
NUMBER |
15,2 |
EDACCA_DISTRIBUTION_BEGIN_DATE |
Date associated with edacca distribution begin. |
DATE |
|
EDACCA_DISTRIBUTION_END_DATE |
Date associated with edacca distribution end. |
DATE |
|
FOR_PERIOD |
For period associated with the record. |
VARCHAR2 |
12 |
FOR_PERIOD_DATE_LONG |
For period date long associated with the record. |
VARCHAR2 |
41 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
150 |
FYTD_PAY |
Fytd pay associated with the record. |
NUMBER |
34 |
GL_ACCOUNT_ID |
Business identifier for the gl account. |
VARCHAR2 |
6 |
GL_ACCOUNT_NAME |
Gl account name associated with the record. |
VARCHAR2 |
50 |
IN_PERIOD |
In period associated with the record. |
VARCHAR2 |
12 |
IN_PERIOD_DATE_LONG |
In period date long associated with the record. |
VARCHAR2 |
41 |
IS_VACATION_CREDIT |
Indicator identifying whether vacation credit (Y/N). |
VARCHAR2 |
1 |
JOB_TITLE |
Job title associated with the record. |
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 |
Payment schedule associated with the record. |
VARCHAR2 |
40 |
PERCENT_EFFORT |
Percent effort associated with the record. |
NUMBER |
34 |
PERSONNEL_SUBAREA |
Personnel subarea associated with the record. |
VARCHAR2 |
40 |
PREVIOUS_MONTH |
Previous month associated with the record. |
DATE |
|
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
RATE |
Rate associated with the record. |
NUMBER |
34 |
REPORT_DATE |
Date associated with report. |
VARCHAR2 |
90 |
SUPPLEMENT_TYPE |
Supplement type associated with the record. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |