| Data element |
Definition |
| Aidy_Code Indexed - yes
Format - Varchar2 (4)
May be Null? N | Financial aid year associated with financial aid applicant. |
| All_Req_Comp_Date Indexed - no
Format - Date
May be Null? Y | The date all tracking requirements were satisfied for the applicant. |
| Appl_Decision Indexed - no
Format - Varchar2 (30)
May be Null? Y | Application to the university decision description. |
| Appl_Decision_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | TApplication to the university decision code. |
| Appl_Rcv_Date Indexed - no
Format - Date
May be Null? N | The date on which the applicant's financial aid application was received, processed or created, depending on the institutional option. |
| Awrd_Ltr_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether an award letter should be generated for the applicant. |
| Classification Indexed - no
Format - Varchar2 (15)
May be Null? Y | Class level classifcation for student at U Penn. |
| Committee_Review Indexed - Y
Format - Varchar2(1)
May be Null? Y | Indicates if the student's committee review process was satisfied. |
| Fa_Group_By_Aidy_Pk Indexed - Y
Format - Varchar(30)
May be Null? N | Internal warehouse primary key: based on PIDM, AIDY_CODE |
| Fa_Ind Indexed - no
Format - Varchar2(20)
May be Null? Y | FA Indicator. |
| Fafsa_Submitted Indexed - no
Format - Varchar2(30)
May be Null? Y | Indicator if the student or applicant submitted the FAFSA for the aid year. |
| Fall_Enrollment Indexed - no
Format - Varchar2(2)
May be Null? Y | Indicates student fall enrollment within aid year. |
| Ffa_Ind Indexed - no
Format - Varchar2(20)
May be Null? Y | Indicates FFA eligibility. |
| Im_Review_Satisfied Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates if the IM Review process was satisfied for the student. |
| Mayor Indexed - no
Format - Varchar2(20)
May be Null? Y | Mayor indicator. |
| Packaging_Grp_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | The packaging group code assigned to the applicant. |
| Packaging_Grp_Desc Indexed - no
Format - Varchar2(200)
May be Null? Y | The packaging group description assigned to the applicant. |
| Pckg_Comp_Date Indexed - no
Format - Date
May be Null? Y | The date the financial aid package was completed for the applicant. |
| Pckg_Req_Comp_Date Indexed - no
Format - Date
May be Null? Y | The date all tracking requirements which are required for packaging were satisfied for the applicant. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Student or applicant Penn ID number. |
| Period_Assign_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | The aid period assigned to the applicant. |
| Period_Assign_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | The aid period description assigned to the applicant. |
| Pfas_Submitted Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicator if the student submitted the PFAS for the aid year. |
| PIDM Indexed - no
Format - Number(8)
May be Null? Y | Internal number for individual within Banner. |
| Pre_Ffa Indexed - no
Format - Varchar2(20)
May be Null? Y | Indicates Pre-FFA eligibility. |
| Pre_Read_Athlete Indexed - no
Format - Varchar2(20)
May be Null? Y | Pre-read athlete indicator. |
| QB_IND Indexed - no
Format - Varchar2(20)
May be Null? Y | QuestBridge indicator. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Last time data was refreshed in data warehouse. |
| Spring_Enrollment Indexed - no
Format - Varchar2(20)
May be Null? Y | Indicates student spring enrollment within aid year. |
| Stdn_Ind Indexed - no
Format - Varchar2(6)
May be Null? Y | Indicates if the record shown is from the student or application record. |
| Stu_Adm_Dc_Admt_Ind Indexed - no
Format - Varchar2(2)
May be Null? Y | Admit indicator for student. |
| Stu_Adm_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Student admit code. |
| Stu_Admt_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student admit description. |
| Stu_Appl_Dc_Date Indexed - no
Format - Date
May be Null? Y | Application decision date. |
| Stu_Camp_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Student campus code. |
| Stu_Camp_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student campus code. |
| Stu_Coll_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Student college code. |
| Stu_Coll_Code_2 Indexed - no
Format - Varchar2(2)
May be Null? Y | Student college code 2. |
| Stu_Degc_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Student degree code. |
| Stu_Degc_Code_2 Indexed - no
Format - Varchar2(6)
May be Null? Y | Student degree code 2. |
| Stu_Leav_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Student leave of absence code. |
| Stu_Leav_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student leave of absence description. |
| Stu_Levl_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Student level code. |
| Stu_Majr_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Student major code. |
| Stu_Majr_Code_2 Indexed - no
Format - Varchar2(4)
May be Null? Y | Student major code 2. |
| Stu_Majr_Code_Conc Indexed - no
Format - Varchar2(4)
May be Null? Y | Student major code concentration. |
| Stu_Majr_Code_Conc_2 Indexed - no
Format - Varchar2(4)
May be Null? Y | Student major code concentration 2. |
| Stu_Med_Timeout Indexed - no
Format - Varchar2(2)
May be Null? Y | Student medical study time out indicator. |
| Stu_Program Indexed - no
Format - Varchar2(12)
May be Null? Y | Student Program Code. |
| Stu_Program_Desc Indexed - no
Format - Varchar2(12)
May be Null? Y | Student Program Description |
| Stu_Rate_Code Indexed - no
Format - Varchar2(5)
May be Null? Y | Student rate code. |
| Stu_Rate_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student rate description. |
| Stu_Resd_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Student resdiency code. |
| Stu_Resd_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student residency description. |
| Stu_Status_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Student status code to indicate if the student is considered active, inactive, graduated, on leave, etc. |
| Stu_Status_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student status description. |
| Stu_Styp_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Student Type Code. |
| Stu_Styp_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Student Type Description. |
| Stu_Term_Code_Admit Indexed - no
Format - Varchar2(6)
May be Null? Y | Student admit term code. |
| Stu_Tuit_Reduction Indexed - no
Format - Varchar2(6)
May be Null? Y | Student tuition reduction indicator. |
| Tracking_Grp_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | The tracking group assigned to the applicant. |
| Tracking_Grp_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | The tracking group description assigned to the applicant. |
| Verification_Complete Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates if the verification process was complete. |
