BENEFITS TUITION ASSISTANCE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNTING_DOC_NUMBER |
XXX |
VARCHAR2 |
10 |
APPLICATION_FEE |
XXX |
NUMBER |
13,2 |
BENEFIT_RECEIPT_TYPE |
XXX |
VARCHAR2 |
4 |
BEN_AGREE_TO_CANCEL |
XXX |
VARCHAR2 |
1 |
BEN_AREA |
XXX |
VARCHAR2 |
2 |
BEN_CLAIM_CANCELLED |
XXX |
VARCHAR2 |
1 |
BEN_CLAIM_ON_HOLD |
XXX |
VARCHAR2 |
1 |
BEN_CLAIM_SUBMISSION_DATE |
XXX |
VARCHAR2 |
8 |
BEN_DT_COST_INCUR |
XXX |
VARCHAR2 |
8 |
BEN_FLEX_SPEND_ACCOUNT_CLAIM |
XXX |
NUMBER |
13,2 |
BEN_PLAN |
XXX |
VARCHAR2 |
4 |
BEN_PLAN_TYPE |
XXX |
VARCHAR2 |
4 |
BEN_PROV_NAME |
XXX |
VARCHAR2 |
30 |
BEN_RECEIPT_NUMBER |
XXX |
VARCHAR2 |
20 |
BEN_RECEIPT_TYPE |
XXX |
VARCHAR2 |
4 |
BILLING_DEFERRED_FLAG |
XXX |
VARCHAR2 |
1 |
CHECK_PAYABLE_TO |
XXX |
VARCHAR2 |
1 |
COURSE_CODE |
XXX |
VARCHAR2 |
600 |
COURSE_COST_GROSS |
XXX |
NUMBER |
13,2 |
COURSE_COST_NET |
XXX |
NUMBER |
13,2 |
COURSE_COST_POSTED_THRU_JV |
XXX |
NUMBER |
13,2 |
COURSE_FOR_GRADE_FLAG |
XXX |
VARCHAR2 |
1 |
COURSE_GRADE |
XXX |
VARCHAR2 |
3 |
COURSE_LEVEL |
The level (Graduate or Undergraduate) of the course of major/degree program in which a student is enrolled. |
VARCHAR2 |
1 |
COURSE_NUMBER |
Course number or first part of the Subject ID (such as 6, 15, 18, 21W). |
VARCHAR2 |
20 |
COURSE_SESSION |
XXX |
VARCHAR2 |
2 |
CREDIT_FLAG |
XXX |
VARCHAR2 |
1 |
CS_APPROVED_FLAG |
XXX |
VARCHAR2 |
9 |
CURRENCY_KEY |
Key used to join to the LIBRARY_CURRENCY table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
5 |
DATE_DOC_PARKED |
XXX |
VARCHAR2 |
8 |
DATE_OF_LAST_CHANGE |
XXX |
VARCHAR2 |
8 |
END_DATE |
Specific to HR_POSITION_DETAIL: For filled positions, End Date equals Appointment End Date. For open-ended appointments, this date is usually 12/31/2999. For Closed Positions, the End Date is the delimit date on the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the latest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the end of the term. For STIP, this is set to the latest date for this account in the term in the stipend distribution section in the RPAGAAID form in MITSIS. UNMATCHED payroll has this set to the latest date in the unmatched Payroll records. In all other tables, END DATE is the thru date of the transaction. |
VARCHAR2 |
8 |
LAYOFF_RELATION_CHECKBOX |
XXX |
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 |
XXX |
VARCHAR2 |
1 |
NAME_OF_SCHOOL |
XXX |
VARCHAR2 |
60 |
ONLINE_COURSE_FLAG |
XXX |
VARCHAR2 |
1 |
PAYMENT_DATE |
XXX |
VARCHAR2 |
8 |
PAYMENT_NUMBER |
XXX |
VARCHAR2 |
13 |
PERSONNEL_NUMBER |
XXX |
VARCHAR2 |
8 |
PLAN_YEAR |
XXX |
VARCHAR2 |
4 |
PREPAYMENT_REQUEST |
XXX |
VARCHAR2 |
1 |
PROGRAM_TYPE |
XXX |
VARCHAR2 |
1 |
REFERENCE_DOC_NUMBER |
XXX |
VARCHAR2 |
16 |
SCHOOL_ABBREV |
XXX |
VARCHAR2 |
10 |
SCHOOL_CODE |
The school code for Schools at MIT, eg.: E (School of Engineering), S (Science) H (Humanities, Arts, and Social Sciences), M (Management) |
VARCHAR2 |
5 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
60 |
SEQNR |
XXX |
VARCHAR2 |
3 |
START_DATE |
The first day of the fiscal period. Specific to HR_POSITION_DETAIL: If the Position is filled, this value equals the appointment begin date of the person filling that position. If the position is unfilled, this value is either the date the last person vacated the position. For new positions that have never been filled, this date is the start date assigned to the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the earliest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the beginning of the term. For STIP, this is set to the earliest date for this account in the term in the stipend distribution section in the RPAGAAID form. UNMATCHED payroll has this set to the earliest date in the unmatched Payroll records. |
VARCHAR2 |
8 |
SUBTYPE |
XXX |
VARCHAR2 |
4 |
SUPPLEMENTAL_FEE |
XXX |
NUMBER |
13,2 |
TAXABILITY_FLAG |
XXX |
VARCHAR2 |
1 |
TA_APPROVED_FLAG |
XXX |
VARCHAR2 |
9 |
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
12 |
USER_UPDATE |
XXX |
VARCHAR2 |
12 |