| Data element |
Definition |
| Accept_Amt Indexed - no
Format - Number (22)
May be Null? Y | The accepted dollar amount of the award. |
| Accept_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was accepted. |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | The aid year associated with the award schedule. |
| Authorized_Amt Indexed - no
Format - Number (22)
May be Null? Y | The authorized dollar amount of the award. |
| Authorized_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was authorized. |
| Awd_Accept_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | This field defines if the particular award status code defines the award as Accepted. |
| Awd_Cancel_Ind Indexed - yes
Format - Varchar2 (4)
May be Null? Y | This indicator specifies whether the award status indicates that the award has been cancelled. |
| Awd_Decline_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | This indicator specifies whether the award status indicates that the award has been declined. |
| Awd_Offer_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | This indicator specifies whether the award status code indicates that the award has been offered. |
| Awd_Status_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | The code associated with the current status of the award. |
| Awd_Status_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award status was effective. |
| Awd_Status_Desc Indexed - no
Format - Varchar2 (120)
May be Null? Y | The description associated with the current status of the award. |
| Cancel_Amt Indexed - no
Format - Number (22)
May be Null? Y | The cancelled dollar amount of the award. |
| Cancel_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was cancelled. |
| Decline_Amt Indexed - no
Format - Number (22)
May be Null? Y | The declined dollar amount of the award. |
| Decline_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was declined. |
| Fa_Award_Aidy_Pk Indexed - yes
Format - Varchar2 (80)
May be Null? N | internal warehouse primary key: based on PIDM, AIDY_CODE, FUND_CODE |
| Fed_Fund_Id Indexed - no
Format - Varchar2 (16)
May be Null? Y | This code specifies the federal fund if appropriate associated with the fund code. |
| Fund_A_Bc_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_A_Budget_Code Indexed - no
Format - Varchar2 (240)
May be Null? Y | This field identifies the actual account number from the finance system associated with this detail code. |
| Fund_A_Cnac_Code Indexed - no
Format - Varchar2 (12)
May be Null? Y | |
| Fund_A_Cref_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_A_Fund_Code Indexed - no
Format - Varchar2 (24)
May be Null? Y | |
| Fund_A_Object_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_A_Org_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_A_Program_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_B_Bc_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_B_Budget_Code Indexed - no
Format - Varchar2 (240)
May be Null? Y | This field identifies the actual account number from the finance system associated with this detail code. |
| Fund_B_Cnac_Code Indexed - no
Format - Varchar2 (12)
May be Null? Y | |
| Fund_B_Cref_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_B_Fund_Code Indexed - no
Format - Varchar2 (24)
May be Null? Y | |
| Fund_B_Object_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_B_Org_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_B_Program_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | |
| Fund_Code Indexed - yes
Format - Varchar2 (24)
May be Null? Y | This field is used to establish and maintain valid fund codes used by the institution. |
| Fund_Detail_Code Indexed - no
Format - Varchar2 (16)
May be Null? Y | 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 - no
Format - Varchar2 (120)
May be Null? Y | This field specifies a free-format description of the detail code. |
| Fund_Detail_Group Indexed - no
Format - Varchar2 (120)
May be Null? Y | This field specifies the free-format detail category associated with the detail category code. |
| Fund_Detail_Group_Code Indexed - no
Format - Varchar2 (12)
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_Type Indexed - no
Format - Varchar2 (4)
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_Srce_Code Indexed - no
Format - Varchar2 (16)
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 (120)
May be Null? Y | This field idenfies the fund source description associated with the fund code. |
| Fund_Srce_Type Indexed - no
Format - Varchar2 (4)
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 (120)
May be Null? Y | The short description of the fund code. |
| Fund_Title_Long Indexed - no
Format - Varchar2 (800)
May be Null? Y | The full description of the fund code. |
| Fund_Type_Code Indexed - no
Format - Varchar2 (16)
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 (120)
May be Null? Y | This field describes the type codes identified. |
| Fund_Type_Ind Indexed - no
Format - Varchar2 (4)
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. |
| Legacy_Aid_Id Indexed - no
Format - Varchar2 (40)
May be Null? Y | |
| Memo_Amt Indexed - no
Format - Number (22)
May be Null? Y | The memo dollar amount of the award. |
| Memo_Date Indexed - no
Format - Date (7)
May be Null? Y | The date of the memo for the award. |
| Offer_Amt Indexed - no
Format - Number (22)
May be Null? Y | The offered dollar amount of the award. |
| Offer_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was offered. |
| Orgin_Offer_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was originally offered. |
| Orig_Offer_Amount Indexed - no
Format - Number (22)
May be Null? Y | The original offered dollar amount of the award. |
| Paid_Amt Indexed - no
Format - Number (22)
May be Null? Y | The paid dollar amount of the award. |
| Paid_Date Indexed - no
Format - Date (7)
May be Null? Y | The date the award was paid. |
| Penn_Id Indexed - no
Format - Varchar2 (36)
May be Null? Y | Assigned Penn ID to individual. |
| Pidm Indexed - yes
Format - Number (22)
May be Null? Y | The internal system generated student identification number. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | Last time data was refreshed in data warehouse. |
| Vet_Fund_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
