FINAID TERM Table
View exposing financial aid term reference data used in aid packaging and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
AID_YEAR_DESC |
Description of aid year. |
VARCHAR2 |
30 |
AID_YEAR_END_DATE |
Date associated with aid year end. |
DATE |
|
AID_YEAR_START_DATE |
Date associated with aid year start. |
DATE |
|
FINAID_TERM_KEY |
Surrogate key identifying the finaid term. |
VARCHAR2 |
6 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
TERM_CODE_DESC |
Description of term code. |
VARCHAR2 |
30 |
TERM_END_DATE |
Date associated with term end. |
DATE |
|
TERM_START_DATE |
Date associated with term start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |