| Data element |
Definition |
| Accept_Amt Indexed - yes
Format - Number (11)
May be Null? N | The accepted dollar amount of the award. |
| Accept_Date Indexed - no
Format - Date
May be Null? Y | The date the award was accepted. |
| Aidy_Code Indexed - no
Format - Varchar2 (4 Char)
May be Null? N | The aid year associated with the award schedule. |
| Authorization_Amt Indexed - no
Format - Date
May be Null? Y | The authorized dollar amount of the award. |
| Awd_Accept_Ind Indexed - no
Format - Date
May be Null? Y | This field defines if the particular award status code defines the award as Accepted. |
| Awd_Decline_Ind Indexed - yes
Format - Varchar2(19)
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(5)
May be Null? Y | Calculated legacy SAM term for a given period and aid year. |
| Awd_Status_Code Indexed - no
Format - Varchar2(5)
May be Null? Y | The code associated with the current status of the award. |
| Awd_Status_Date Indexed - no
Format - Varchar2(1)
May be Null? Y | The date the award status was effective. |
| Awd_Status_Desc Indexed - no
Format - Varchar2(1)
May be Null? Y | IThe description associated with the current status of the award. |
| Cancel_Amt Indexed - no
Format - Number
May be Null? Y | The cancelled dollar amount of the award. |
| Cancel_Date Indexed - no
Date
May be Null? Y | The date the award was cancelled. |
| Decline_Amt Indexed - no
Format - Number
May be Null? Y | The declined dollar amount of the award. |
| Decline_Date Indexed - no
Format - Date
May be Null? Y | Indicates if the term code is used for satisfactory academic progress data for the period. |
| Period_Start_Date Indexed - no
Format - Date
May be Null? Y | The date the award was declined. |
| FA_Award_Period_Pk Indexed - yes
Format - Varchar (20)
May be Null? N | Internal warehouse primary key: based on PIDM, AIDY_CODE, FUND_CODE |
| Fed_Fund_ID Indexed - no
Format - Varchar2 (4)
May be Null? Y | This code specifies the federal fund if appropriat associated with the fund code. |
| Fund_A_BC_Code Indexed - no
Format - Varchar2 (1)
May be Null? Y | |
| Fund_A_Budget_Code Indexed - no
Format - Varchar2 (60)
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 (3)
May be Null? Y | |
| Fund_A_Cref_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_A_Fund_Code Indexed - no
Format - Varchar2 (6)
May be Null? Y | |
| Fund_A_Object_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_A_Org_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_A_Program_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_B_BC_Code Indexed - no
Format - Varchar2 (1)
May be Null? Y | |
| Fund_B_Budget_Code Indexed - no
Format - Varchar2 (60)
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 (3)
May be Null? Y | |
| Fund_B_Cref_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_B_Fund_Code Indexed - no
Format - Varchar2 (6)
May be Null? Y | |
| Fund_B_Object_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_B_Org_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_B_Program_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | |
| Fund_Code Indexed - no
Format - Varchar2 (6)
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 (4)
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_Srce_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 identifies the fund source description associated with the fund code. |
| Fund_Srce_Type Indexed - no
Format - Varchar2 (30)
May be Null? Y | This field identifies the fund source description associated with the fund code. |
| 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_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 (1)
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. |
| Legacy_Aid_Id Indexed - no
Format - Varchar2 (10)
May be Null? Y | Legacy Aid Id from SAM. |
| Memo_Amt Indexed - no
Format - Number (11,2)
May be Null? Y | The memo dollar amount of the award. |
| Memo_Date Indexed - no
Format - Date
May be Null? Y | The date of the memo for the award. |
| Offer_Amt Indexed - no
Format - Number (11,2)
May be Null? Y | The offered dollar amount of the award. |
| Offer_Date Indexed - no
Format - Date
May be Null? Y | The date the award was offered. |
| Origin_Offer_Date Indexed - no
Format - Date
May be Null? Y | The date the award was originally offered. |
| Orig_Offer_Amt Indexed - no
Format - Number (11, 2)
May be Null? Y | The original offer dollar amount for the award |
| Paid_Amt Indexed - no
Format - Number (11, 2)
May be Null? Y | The paid dollar amount for the award |
| Paid_Date Indexed - no
Format - Date
May be Null? Y | The paid dollar date for the award |
| Penn_Id Indexed - no
Format - Varchar2 (9)
May be Null? Y | Assigned Penn ID to individual. |
| Period Indexed - no
Format - Varchar2 (15)
May be Null? Y | The period code associated with the award schedule within the aid year |
| Pidm Indexed - no
Format - Number (8)
May be Null? Y | The internal system generated student identification number. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Last time data was refreshed in data warehouse. |
