FINAID AWARD STATUS Table
Contains all the financial aid award and note statuses. For each award status (eg. ACTL, CANC, ESTI), there exists all the possible loan promissory note status codes (eg. RECM, SIGN) for promissory loan notes of Federal Direct Loans, Perkins Loans, Parent Loans, and Technology Loans; and also the status codes of outside scholarship checks (eg. wether the checks were received or signed for deposit).
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_IS_ACCEPTED |
Whether the status of the award indicates that the award is accepted by the student. Y=Yes, N=No. |
VARCHAR2 |
1 |
AWARD_IS_CANCELLED |
Whether the status of the award indicates that the offer of the award has been cancelled. Y=Yes, N=No. |
VARCHAR2 |
1 |
AWARD_IS_DECLINED |
Whether the status of the award indicates that the award offfered has been declined. Y=Yes, N=No |
VARCHAR2 |
1 |
AWARD_IS_OFFERED |
Whether the status of the award indicates that the award is offered to the student. Y=Yes, N=No. |
VARCHAR2 |
1 |
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 |
100 |
AWARD_STATUS_DESC |
Description of the status code of the financial aid award. Examples: "Actual" for ACTL; "Cancelled" for CANC; "Paid Directly to Student" for KEPT. |
VARCHAR2 |
30 |
AWARD_STATUS_KEY |
Key identifying an entry in the FINAID AWARD STATUS Table. This field should only be used for linking together the tables of FINAID AWARD STATUS and FINAID AWARD DETAIL, not for reporting. |
VARCHAR2 |
15 |
FED_LOAN_PERIOD |
XXX |
VARCHAR2 |
6 |
FED_LOAN_PERIOD_DESC |
XXX |
VARCHAR2 |
20 |
NOTE_IS_ACTIVE |
Whether the status of the promissory loan note or outside scholarship check indicates that the award is active. Y=Yes, N=No |
VARCHAR2 |
1 |
NOTE_IS_CANCELLED |
Whether the status of the promissory loan note or outside scholarship check indicates that the note/check has been cancelled. Y=Yes, N=No |
VARCHAR2 |
1 |
NOTE_IS_ON_HOLD |
Whether the status of the promissory loan note or outside scholarship check indicates that the award is on hold. |
VARCHAR2 |
1 |
NOTE_IS_SIGNED |
Whether the status of the promissory loan note or outside scholarship check indiates that the note/check is signed. Y=Yes, N=No |
VARCHAR2 |
1 |
NOTE_STATUS |
Status of the promissory loan note or outside scholarship check. Examples: RECM, RECV, CMKS, SIGN. |
VARCHAR2 |
4 |
NOTE_STATUS_DESC |
Description of the status code of the promissory loan note or outside scholarship check. Examples: "Recommended" for RECM, "Received Check, sign for Deposit" for RECV, "Comaker signed, not borrower" for CMKS, "Signed" for SIGN. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |