FAID FUND MANAGEMENT Table
View exposing financial-aid fund-management detail by fund and year including fund type and source, minimum and maximum amounts, balances, awarded and paid amounts, need-based indicators, and loan or grant classifications.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATIVE_LOAN |
Alternative loan associated with the record. |
VARCHAR2 |
1 |
ANTICIPATED |
Anticipated associated with the record. |
VARCHAR2 |
1 |
FAID_FUND_CODE |
Code identifying faid fund. |
VARCHAR2 |
10 |
FAID_FUND_KEY |
Surrogate key identifying the faid fund. |
VARCHAR2 |
20 |
FAID_FUND_SOURCE |
Faid fund source associated with the record. |
VARCHAR2 |
4 |
FAID_FUND_TITLE |
Faid fund title associated with the record. |
VARCHAR2 |
40 |
FAID_FUND_TYPE |
Faid fund type associated with the record. |
VARCHAR2 |
5 |
FAID_YEAR |
Faid year associated with the record. |
NUMBER |
|
FAID_YEAR_DESC |
Description of faid year. |
VARCHAR2 |
23 |
FUND_AMOUNT_ACCEPTED |
Fund amount accepted associated with the record. |
NUMBER |
|
FUND_AMOUNT_AWARDED |
Fund amount awarded associated with the record. |
NUMBER |
|
FUND_AMOUNT_PAID |
Fund amount paid associated with the record. |
NUMBER |
|
FUND_AVAILABLE_DOLLARS |
Fund available dollars associated with the record. |
NUMBER |
|
FUND_BALANCE |
Fund balance associated with the record. |
NUMBER |
|
FUND_GRANT_SUBTYPE |
Fund grant subtype associated with the record. |
VARCHAR2 |
4 |
FUND_MAXIMUM |
Fund maximum associated with the record. |
NUMBER |
|
FUND_MINIMUM |
Fund minimum associated with the record. |
NUMBER |
|
FUND_NUMBER_ACCEPTED |
Fund number accepted associated with the record. |
NUMBER |
|
FUND_NUMBER_AWARDED |
Fund number awarded associated with the record. |
NUMBER |
|
FUND_NUMBER_PAID |
Fund number paid associated with the record. |
NUMBER |
|
FUND_TOKEN |
Fund token associated with the record. |
NUMBER |
|
INCLUDE_IN_NEED_BASED |
Include in need based associated with the record. |
VARCHAR2 |
1 |
IS_FEDERAL_DIRECT_LOAN |
Indicator identifying whether federal direct loan (Y/N). |
VARCHAR2 |
1 |
IS_PARENT_LOAN |
Indicator identifying whether parent loan (Y/N). |
VARCHAR2 |
1 |
IS_REDUCING_NEED |
Indicator identifying whether reducing need (Y/N). |
VARCHAR2 |
1 |
IS_REPLACING_TFC |
Indicator identifying whether replacing tfc (Y/N). |
VARCHAR2 |
1 |
LOAN_TYPE |
Loan type associated with the record. |
VARCHAR2 |
1 |
NET_PROCEEDS_PERCENT |
Net proceeds percent associated with the record. |
NUMBER |
|
NON_PARS_FLAG |
Non pars flag associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
Warehouse update timestamp associated with the warehouse record. |
DATE |