FAID AWARD DETAIL Table
View exposing detailed financial-aid award records by applicant, award year, term, and fund including award status, scheduled disbursement, and actual disbursement amounts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMT_SCHDISBT |
Amt schdisbt associated with the record. |
NUMBER |
|
AWARDAMT |
Awardamt associated with the record. |
NUMBER |
|
AWARD_STATUS |
Award status associated with the record. |
VARCHAR2 |
1 |
AWARD_TRANS_TOKEN |
Award trans token associated with the record. |
NUMBER |
|
COD_DISBURSEMENT_DATE |
Date associated with cod disbursement. |
DATE |
|
DISBPAID_AWD |
Disbpaid awd associated with the record. |
NUMBER |
|
DISB_SCHEDULE_DATE |
Date associated with disb schedule. |
DATE |
|
DL_SCH_DISB_GRO |
Dl sch disb gro associated with the record. |
NUMBER |
8,2 |
DL_SCH_DISB_NET |
Dl sch disb net associated with the record. |
NUMBER |
8,2 |
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
FAID_ENROLLMENT_KEY |
Surrogate key identifying the faid enrollment. |
VARCHAR2 |
23 |
FAID_FUND_KEY |
Surrogate key identifying the faid fund. |
VARCHAR2 |
30 |
FAID_TERM |
Faid term associated with the record. |
VARCHAR2 |
13 |
FAID_YEAR |
Faid year associated with the record. |
NUMBER |
|
FAID_YEAR_DESC |
Description of faid year. |
VARCHAR2 |
23 |
FUND_AY_TOKEN |
Fund ay token associated with the record. |
NUMBER |
|
FUND_NAME |
Fund name associated with the record. |
VARCHAR2 |
20 |
MITSIS_TERM_CODE |
Code identifying mitsis term. |
VARCHAR2 |
42 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
POE_TOKEN |
Poe token associated with the record. |
NUMBER |
|
STUDENT_TOKEN |
Student token associated with the record. |
NUMBER |
|
STU_AWARD_TOKEN |
Stu award token associated with the record. |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
Stu award year token associated with the record. |
NUMBER |
|
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
Warehouse update timestamp associated with the warehouse record. |
DATE |