| Data element |
Definition |
| Aidy_Id Indexed - no
Format - Varchar2 (10)
May be Null? Y | Legacy AID ID for fund from SAM. |
| Fed_Fund_Id Indexed - no
Format - Varchar2 (4)
May be Null? Y | This code specifies the federal fund if appropriate associated with the fund code. |
| Fund_Active_Ind Indexed - no
Format - Varchar2 (1)
May be Null? Y | Indicates if fund code is still active. |
| Fund_Activity_Date Indexed - yes
Format - Date
May be Null? Y | The date that information in this record was entered or last updated in source (Banner). |
| Fund_Code Indexed - yes
Format - Varchar2(6)
May be Null? N | This field is used to establish and maintain valid fund codes used by the institution. |
| Fund_Data_Origin Indexed - no
Format - Varchar2(4)
May be Null? Y | Source system that created or updated the data. |
| Fund_Detail_Code Indexed - yes
Format - Varchar2 (4)
May be Null? N | This code is used to link a Financial Aid Fund Code to an AR detail code for crediting funds to student accounts. |
| Fund_Detail_Desc Indexed - N
Format - Varchar(30)
May be Null? N | This field specifies a free-format description of the detail code. |
| Fund_Detail_Group_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | This field identifies the detail charge/payment category code referenced by Student Bill Mod. Reqd vals: APF - Admis Applicatn Chgs, FA - Fin Aid, FEE - Registr. Fees, HOU - Housing, TUI - Registr. Tuition, TRN - Transcript Fee. |
| Fund_Detail_Group_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | This field specifies the free-format detail category associated with the detail category code. |
| Fund_Detail_Type_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | This field indicates the whether the detail code is a charge or a payment. Valid values are: C - Charge, P - Payment. |
| Fund_Src_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | This field identifies the fund source code to be associated with the fund code. |
| Fund_Srce_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | This field idenfies the fund source description associated with the fund code. |
| Fund_Srce_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | This indicator is used to specify the ultimate source of the aid. Valid values are (F)ederal, (S)tate, (I)nstitution, (O)ther. |
| Fund_Title Indexed - no
Format - Varchar2(30)
May be Null? Y | The short description of the fund code. |
| Fund_Title_Long Indexed - no
Format - Varchar2(200)
May be Null? Y | The full description of the fund code. |
| Fund_Type_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | This code defines various types of funds. Examples include: federal grants, institutional loans, federal work, internal scholarships, etc. |
| Fund_Type_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | This field describes the type codes identified. |
| Fund_Type_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | This field indicates the aid type as associated with the fund type code. Valid values are (W)ork, (L)oan, (S)cholarship, (G)rant. This field is mandatory and does not default to any value. |
| Fund_Vr_Msg_No Indexed - no
Format - Number(6)
May be Null? Y | The Voice Response message number assigned to the recorded message that describes the fund code. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Last time data was refreshed in data warehouse. |
