FAID AWARD DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMT_SCHDISBT |
XXX |
NUMBER |
|
AWARDAMT |
XXX |
NUMBER |
|
AWARD_STATUS |
Status of the award. For RESEARCH AWARDS, indicates whether the award is Active, Pending, Closed, Terminated, or Inactive. For GRADUATE AWARDS (RA/TA), the possible values are: active, inactive, terminated, closed, hold, or pending. For FINANCIAL AID AWARDS, possible values include: ACTL, APPR, CANC, DECL, ESTI, KEPT, etc. |
VARCHAR2 |
1 |
AWARD_TRANS_TOKEN |
XXX |
NUMBER |
|
COD_DISBURSEMENT_DATE |
XXX |
DATE |
|
DISBPAID_AWD |
XXX |
NUMBER |
|
DISB_SCHEDULE_DATE |
The date in which a certain amount of the award is scheduled to be disbursed to the student's bursary account. |
DATE |
|
DL_SCH_DISB_GRO |
XXX |
NUMBER |
8,2 |
DL_SCH_DISB_NET |
XXX |
NUMBER |
8,2 |
FAID_APPLICANT_KEY |
XXX |
VARCHAR2 |
21 |
FAID_ENROLLMENT_KEY |
XXX |
VARCHAR2 |
23 |
FAID_FUND_KEY |
XXX |
VARCHAR2 |
30 |
FAID_TERM |
XXX |
VARCHAR2 |
13 |
FAID_YEAR |
XXX |
NUMBER |
|
FAID_YEAR_DESC |
XXX |
VARCHAR2 |
23 |
FUND_AY_TOKEN |
XXX |
NUMBER |
|
FUND_NAME |
* In the FINANCIAL tables: this represents the name of the fund/source of revenue (Example: Publications). * In STUDENT FINANCIAL AID: this is the descriptive title of a financial aid fund/award. Exampes: "Federal Perkins Loan" for PERKNL. |
VARCHAR2 |
20 |
MITSIS_TERM_CODE |
XXX |
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 |
XXX |
NUMBER |
|
STUDENT_TOKEN |
XXX |
NUMBER |
|
STU_AWARD_TOKEN |
XXX |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
XXX |
NUMBER |
|
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
XXX |
DATE |