FAID APPLICANT AWARD SNAPSHOT Table
View exposing snapshot financial-aid award detail by applicant, award year, and snapshot event including budget category, fund attributes, award and disbursement amounts, award status, and snapshot key.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMT |
Actual amt associated with the record. |
NUMBER |
|
ADJUSTEDTOTAL |
Adjustedtotal associated with the record. |
NUMBER |
|
AMT_SCHDISBT |
Amt schdisbt associated with the record. |
NUMBER |
|
ATRANPOE |
Atranpoe associated with the record. |
NUMBER |
|
AWARD_STATUS |
Award status associated with the record. |
VARCHAR2 |
1 |
AWARD_YEAR_TOKEN |
Award year token associated with the record. |
NUMBER |
|
BASEAMOUNT |
Baseamount associated with the record. |
NUMBER |
|
BUDGET_CATEGORY_DESCRIPTION |
Description of budget category. |
VARCHAR2 |
20 |
DISBPAID_AWD |
Disbpaid awd associated with the record. |
NUMBER |
|
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 |
30 |
FUND_NAME |
Fund name associated with the record. |
VARCHAR2 |
20 |
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_AWARD_AMOUNT |
Poe award amount associated with the record. |
NUMBER |
|
POE_FUND_NAME |
Poe fund name associated with the record. |
VARCHAR2 |
10 |
SNAPSHOT_EVENT |
Snapshot event associated with the record. |
VARCHAR2 |
30 |
SNAPSHOT_KEY |
Surrogate key identifying the snapshot. |
BLOB |
|
STUDENT_TOKEN |
Student 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 |