FINAID WORK EARNINGS DETAIL Table
View exposing student work earnings detail associated with financial aid work-study programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
ASSIGNED_TO_CWS |
Assigned to cws associated with the record. |
NUMBER |
18,2 |
AVERAGE_RATE |
Average rate associated with the record. |
NUMBER |
34 |
BEGIN_DATE |
Date associated with begin. |
DATE |
|
ELIG_CWSP |
Elig cwsp associated with the record. |
NUMBER |
18,2 |
ELIG_FWS |
Elig fws associated with the record. |
NUMBER |
18,2 |
ELIG_WORK |
Elig work associated with the record. |
NUMBER |
18,2 |
END_DATE |
Date associated with end. |
DATE |
|
FINAID_WORK_STUDENT_KEY |
Surrogate key identifying the finaid work student. |
VARCHAR2 |
13 |
FINAID_YEAR_KEY |
Surrogate key identifying the finaid year. |
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 |
Record counter associated with the record. |
NUMBER |
|
TOTAL_AMOUNT |
Total amount associated with the record. |
NUMBER |
19,2 |
TOTAL_HOURS |
Total hours associated with the record. |
NUMBER |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |