FINAID TERM Table
Contains information about financial aid terms
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
AID_YEAR_DESC |
Description of the financial aid year. |
VARCHAR2 |
30 |
AID_YEAR_END_DATE |
The end date of the financial aid year. |
DATE |
8 |
AID_YEAR_START_DATE |
The begin date of the financial aid year. |
DATE |
8 |
FINAID_TERM_KEY |
Key identifying an entry in the FINAID TERM Table. This field should only be used for linking together the tables of FINAID TERM and FINAID AWARD DETAIL, not for reporting. |
VARCHAR2 |
6 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
TERM_CODE_DESC |
Description of the academic term. |
VARCHAR2 |
30 |
TERM_END_DATE |
The end date of the academic term. |
DATE |
8 |
TERM_START_DATE |
The begin date of the academic term. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |