FAID PERIOD ENROLL DISBURSE Table
View exposing financial aid disbursement by enrollment period including period enrollment status, disbursement eligibility indicators, period-specific disbursement measures, and period definitions used for aid payment processing and cash flow management.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_STATUS |
Award status associated with the record. |
VARCHAR2 |
1 |
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
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 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
15 |
FUND_NAME |
Fund name associated with the record. |
VARCHAR2 |
10 |
FUND_TOKEN |
Fund token associated with the record. |
NUMBER |
|
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
30 |
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_NAME |
Poe name associated with the record. |
VARCHAR2 |
30 |
POE_TOKEN |
Poe token associated with the record. |
NUMBER |
|
SSN |
Ssn associated with the record. |
VARCHAR2 |
9 |
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 |
|
TOTAL_AWARD |
Total award associated with the record. |
NUMBER |
|
TOTAL_DISBURSED |
Total disbursed associated with the record. |
NUMBER |
|
TOTAL_POE_AWARD_AMOUNT |
Total poe award amount associated with the record. |
NUMBER |
|
TOTAL_POE_AWARD_DISBURSE_AMT |
Total poe award disburse amt associated with the record. |
NUMBER |
|
TRACKING_STATUS |
Tracking status associated with the record. |
VARCHAR2 |
2 |