BENEFITS TUITION ASSISTANCE Table
View exposing tuition assistance claim and payment detail including employee identifiers, benefit-plan attributes, school information, course attributes, reimbursement amounts, and approval indicators used for benefits reporting and administration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNTING_DOC_NUMBER |
Accounting doc number as provided by the source. |
VARCHAR2 |
10 |
APPLICATION_FEE |
Application fee as provided by the source. |
NUMBER |
13,2 |
BENEFIT_RECEIPT_TYPE |
Benefit receipt type as provided by the source. |
VARCHAR2 |
4 |
BEN_AGREE_TO_CANCEL |
Ben agree to cancel as provided by the source. |
VARCHAR2 |
1 |
BEN_AREA |
Ben area as provided by the source. |
VARCHAR2 |
2 |
BEN_CLAIM_CANCELLED |
Ben claim cancelled as provided by the source. |
VARCHAR2 |
1 |
BEN_CLAIM_ON_HOLD |
Ben claim on hold as provided by the source. |
VARCHAR2 |
1 |
BEN_CLAIM_SUBMISSION_DATE |
Date associated with ben claim submission. |
VARCHAR2 |
8 |
BEN_DT_COST_INCUR |
Ben dt cost incur as provided by the source. |
VARCHAR2 |
8 |
BEN_FLEX_SPEND_ACCOUNT_CLAIM |
Ben flex spend account claim as provided by the source. |
NUMBER |
13,2 |
BEN_PLAN |
Ben plan as provided by the source. |
VARCHAR2 |
4 |
BEN_PLAN_TYPE |
Ben plan type as provided by the source. |
VARCHAR2 |
4 |
BEN_PROV_NAME |
Ben prov name as provided by the source. |
VARCHAR2 |
30 |
BEN_RECEIPT_NUMBER |
Ben receipt number as provided by the source. |
VARCHAR2 |
20 |
BEN_RECEIPT_TYPE |
Ben receipt type as provided by the source. |
VARCHAR2 |
4 |
BILLING_DEFERRED_FLAG |
Billing deferred flag as provided by the source. |
VARCHAR2 |
1 |
CHECK_PAYABLE_TO |
Check payable to as provided by the source. |
VARCHAR2 |
1 |
COURSE_CODE |
Code identifying course. |
VARCHAR2 |
600 |
COURSE_COST_GROSS |
Course cost gross as provided by the source. |
NUMBER |
13,2 |
COURSE_COST_NET |
Course cost net as provided by the source. |
NUMBER |
13,2 |
COURSE_COST_POSTED_THRU_JV |
Course cost posted thru jv as provided by the source. |
NUMBER |
13,2 |
COURSE_FOR_GRADE_FLAG |
Course for grade flag as provided by the source. |
VARCHAR2 |
1 |
COURSE_GRADE |
Course grade as provided by the source. |
VARCHAR2 |
3 |
COURSE_LEVEL |
Course level as provided by the source. |
VARCHAR2 |
1 |
COURSE_NUMBER |
Course number as provided by the source. |
VARCHAR2 |
20 |
COURSE_SESSION |
Course session as provided by the source. |
VARCHAR2 |
2 |
CREDIT_FLAG |
Credit flag as provided by the source. |
VARCHAR2 |
1 |
CS_APPROVED_FLAG |
Cs approved flag as provided by the source. |
VARCHAR2 |
9 |
CURRENCY_KEY |
Surrogate key identifying the currency. |
VARCHAR2 |
5 |
DATE_DOC_PARKED |
Date doc parked as provided by the source. |
VARCHAR2 |
8 |
DATE_OF_LAST_CHANGE |
Date of last change as provided by the source. |
VARCHAR2 |
8 |
END_DATE |
Date associated with end. |
VARCHAR2 |
8 |
LAYOFF_RELATION_CHECKBOX |
Layoff relation checkbox as provided by the source. |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MIT_SPECIAL_FLAG |
Mit special flag as provided by the source. |
VARCHAR2 |
1 |
NAME_OF_SCHOOL |
Name of school as provided by the source. |
VARCHAR2 |
60 |
ONLINE_COURSE_FLAG |
Online course flag as provided by the source. |
VARCHAR2 |
1 |
PAYMENT_DATE |
Date associated with payment. |
VARCHAR2 |
8 |
PAYMENT_NUMBER |
Payment number as provided by the source. |
VARCHAR2 |
13 |
PERSONNEL_NUMBER |
Personnel number as provided by the source. |
VARCHAR2 |
8 |
PLAN_YEAR |
Plan year as provided by the source. |
VARCHAR2 |
4 |
PREPAYMENT_REQUEST |
Prepayment request as provided by the source. |
VARCHAR2 |
1 |
PROGRAM_TYPE |
Program type as provided by the source. |
VARCHAR2 |
1 |
REFERENCE_DOC_NUMBER |
Reference doc number as provided by the source. |
VARCHAR2 |
16 |
SCHOOL_ABBREV |
School abbrev as provided by the source. |
VARCHAR2 |
10 |
SCHOOL_CODE |
Code identifying school. |
VARCHAR2 |
5 |
SCHOOL_NAME |
School name as provided by the source. |
VARCHAR2 |
60 |
SEQNR |
Seqnr as provided by the source. |
VARCHAR2 |
3 |
START_DATE |
Date associated with start. |
VARCHAR2 |
8 |
SUBTYPE |
Subtype as provided by the source. |
VARCHAR2 |
4 |
SUPPLEMENTAL_FEE |
Supplemental fee as provided by the source. |
NUMBER |
13,2 |
TAXABILITY_FLAG |
Taxability flag as provided by the source. |
VARCHAR2 |
1 |
TA_APPROVED_FLAG |
Ta approved flag as provided by the source. |
VARCHAR2 |
9 |
USER_NAME |
User name as provided by the source. |
VARCHAR2 |
12 |
USER_UPDATE |
User update as provided by the source. |
VARCHAR2 |
12 |