Data element |
Definition |
Aidy_Code Indexed - yes Format - Varchar2 (4) May be Null? N | The aid year associated with the award schedule. |
Citz_Desc Indexed - no Format - Varchar2 (20 Char) May be Null? Y | Description of student status such as US Citizen, Eligible Non-Citizen, etc from Financial Aid documentation such as CSS profile, FAFSA, etc. |
Citz_Ind Indexed - no Format - Varchar2 (2 Char) May be Null? Y | Indicates if the student is a US Citizen or other status based on Financial aid doumentation such as CSS profile, FAFSA, etc. |
Fa_Active_Duty Indexed - no Format - Varchar2 (75 Char) May be Null? Y | Code indicating if student is active duty based on Financial Aid documentation (ie FAFSA, Profile, etc). |
Fa_Addr Indexed - no Format - Varchar2 (75) May be Null? Y | Address based on Financial Aid information. |
Fa_Bio_Pk Indexed - yes Format - Varchar2(19) May be Null? Y | Internal warehouse primary key: based on PIDM, AIDY_CODE |
Fa_Birthday Indexed - no Format - Date May be Null? Y | Birthday based on Financial Aid information |
Fa_City Indexed - no Format - Varchar2(50) May be Null? Y | City based on Fincancial Aid information. |
Fa_Fac_Staff_Desc Indexed - no Format - Varchar2(30) May be Null? Y | Description of code indicating if student is tied to a faculty or staff position (including dependents). |
Fa_First_Name Indexed - no Format - Varchar2(60) May be Null? Y | First name as listed on financial aid documents such as CSS profile, FAFSA, etc. |
Fa_Last_Name Indexed - no Format - Varchar2(60) May be Null? Y | Last name as listed on finacial aid documents such as CSS profile, FAFSA, etc. |
Fa_Mi Indexed - no Varchar2 (60) May be Null? Y | Middle initial or middle name as listed on financial aid documents such as CSS profile, FAFSA, etc. |
Fa_State Indexed - no Format - Varchar2 (2) May be Null? Y | State code based on financial aid information. |
Fa_Vet_Ind Indexed - no Format - Varchar2 (2 Char) May be Null? Y | Code indicating if a student is a vet based on Financial Aid documentation (ie FAFSA, Profile, etc). |
FA_Zip Indexed - no Format - Varchar2 (30) May be Null? Y | Zip code based on Financial Aid information. |
Father_DOB Indexed - yes Format - Date May be Null? N | Birthday of parent 1 or father. |
Father_Edu_Desc Indexed - no Format - Varchar2 (20) May be Null? Y | Description of education level of father or parent 1. |
Father_Edu_Lvl Indexed - no Format - Varchar2 (2) May be Null? Y | Code that indicates education level of father or parent 1. |
Mother_Dob Indexed - no Format - Date May be Null? Y | Birthday or parent2 or mother. |
Mother_Edu_Desc Indexed - no Format - Varchar2 (20) May be Null? Y | Description of education level of mother or parent 2. |
Mother_Edu_Levl Indexed - no Format - Varchar2 (2) May be Null? Y | Code that indicates education level of mother or parent 2. |
Mtrl_Status Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates if student is married based on Financial Aid information. |
Numb_In_Coll Indexed - no Format - Number May be Null? Y | Number of family members in college based on student household. |
Numb_In_Fam Indexed - no Format - Number May be Null? Y | Number of family members in college based on student household. |
Pa_Mtrl_Status Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates if the paretns of the students are married. |
Pa_Numb_In_Coll Indexed - no Format - Number May be Null? Y | Number of family members in college based on student household. |
Pa_Numb_In_Fam Indexed - no Format - Number May be Null? Y | Number of family members based on parent household. |
Penn_Id Indexed - no Format - Varchar2 (15) May be Null? Y | Student ID for the university. |
Pidm Indexed - yes Format - Number (8) May be Null? N | Internal system generated student identification number. |
Refresh_Date Indexed - no Format - Date May be Null? Y | Last time data was refreshed in the data warehouse. |
Sibl_1_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recoreded college level for sibling based on Financial Aid documents (ie FAFSA, CSS Profile). |
Sibl_2_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recoreded college level for sibling 2 based on Financial Aid documents (ie FAFSA, CSS Profile). |
Sibl_3_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recoreded college level for sibling 3 based on Financial Aid documents (ie FAFSA, CSS Profile). |
Sibl_4_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recorded college level for sibling 4 based on Financial Aid documents (ie FAFSA, CSS Profile). |
Sibl_5_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recorded college level for sibling 5 based on Financial Aid documents (ie FAFSA, CSS Profile). |
Sibl_6_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recorded college level for sibling 6 based on Financial Aid documents (ie FAFSA, CSS Profile). |
Sibl_7_Coll_Levl Indexed - no Format - Varchar2 (20) May be Null? Y | Indicates recorded college level for sibling 7 based on Financial Aid documents (ie FAFSA, CSS Profile). |
Stat_Code_Res Indexed - no Format - Varchar2 (3) May be Null? Y | Listed state of residence based on financial aid documents such as CSS profile, FAFSA, etc. |
Yr_At_Penn Indexed - no Format - Varchar2 (2) May be Null? Y | Indicates the number of years a student has been at Penn based on CSS profile, FAFSA, or other Financial Aid documentation. |
Fa_Yr_In_Coll Indexed - no Format - Varchar2 (2) May be Null? Y | Indicates the number of years a student has been in college based on CSS profile, FAFSA, or other Financial Aid documentation. |