FINAID GRANT Table
View exposing financial aid grant reference data including grant identifiers and program attributes used in aid packaging.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTMENT_AMOUNT |
Adjustment amount associated with the record. |
NUMBER |
11,2 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
AMOUNT_TO_SPEND |
Amount to spend associated with the record. |
NUMBER |
12,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
ESTABLISHED_DATE |
Date associated with established. |
DATE |
|
FINAID_GRANT_KEY |
Surrogate key identifying the finaid grant. |
VARCHAR2 |
10 |
FUNDS_AMOUNT_AVAILABLE |
Funds amount available associated with the record. |
NUMBER |
11,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
IS_EXPENDABLE |
Indicator identifying whether expendable (Y/N). |
VARCHAR2 |
1 |
IS_RENEWABLE |
Indicator identifying whether renewable (Y/N). |
VARCHAR2 |
1 |
IS_REPORTING |
Indicator identifying whether reporting (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
MAX_AMOUNT_TO_AWARD |
Max amount to award associated with the record. |
NUMBER |
11,2 |
MIN_AMOUNT_TO_AWARD |
Min amount to award associated with the record. |
NUMBER |
11,2 |
NUMBER_OF_ASSIGNMENTS |
Number of assignments associated with the record. |
NUMBER |
4 |
NUMBER_OF_CHARGES |
Number of charges associated with the record. |
NUMBER |
4 |
REMAINING_AMOUNT_TO_ASSIGN |
Remaining amount to assign associated with the record. |
NUMBER |
19,2 |
REMAINING_AMOUNT_TO_CHARGE |
Remaining amount to charge associated with the record. |
NUMBER |
19,2 |
RESTRICT_CODE |
Code identifying restrict. |
VARCHAR2 |
30 |
SELECTION_PRIORITY |
Selection priority associated with the record. |
NUMBER |
3 |
SFS_STEWARD_IND |
Sfs steward ind associated with the record. |
VARCHAR2 |
1 |
SUBFUND_CODE |
Code identifying subfund. |
VARCHAR2 |
6 |
SUBFUND_TITLE |
Subfund title associated with the record. |
VARCHAR2 |
30 |
TOTAL_ASSIGNED_AMOUNT |
Total assigned amount associated with the record. |
NUMBER |
18,2 |
TOTAL_CHARGED_AMOUNT |
Total charged amount associated with the record. |
NUMBER |
18,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |