FINAID WORK EARNINGS DETAIL Table
Contains student's work earnings data from on campus jobs such as fellowships, teaching assistant, research assistant, undergraduate on campus work. Only the latest three financial aid years of data are included in this table.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Key identifying an entry in the Financial Aid Applicant Table. This field should only be used for linking tables together, not for reporting. The field is a concatenation of the fields of MIT ID and Aid Year |
VARCHAR2 |
13 |
ASSIGNED_TO_CWS |
XXX |
NUMBER |
9 |
AVERAGE_RATE |
XXX |
NUMBER |
6 |
BEGIN_DATE |
Date when the transaction starts become effective. |
DATE |
8 |
ELIG_CWSP |
Amount eligible for College Work Study Program |
NUMBER |
9 |
ELIG_FWS |
Amount eligible for Federal Work Study Program |
NUMBER |
9 |
ELIG_WORK |
XXX |
NUMBER |
9 |
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. |
DATE |
8 |
FINAID_WORK_STUDENT_KEY |
Use this field to join between the FINAID WORK STUDENT table to a financial aid fact table which contains the same-name field, eg. FINAID WORK EARNINGS DETAIL, FINAID PAYROLL DIST DETAIL. |
VARCHAR2 |
13 |
FINAID_YEAR_KEY |
Key identifying an entry in the FINAID YEAR Table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
4 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
TOTAL_AMOUNT |
The total dollar amount earned (for both regular and premium pay rates) in the pay period. |
NUMBER |
9 |
TOTAL_HOURS |
The total hours works (for both regular and premium pay rates) in the pay period. |
NUMBER |
7 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |