ESANDI Table
View exposing labor distribution allocation records including personnel, appointment, cost collector, general ledger account, distribution percent, 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 |
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 |
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 |
|
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 |