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