| 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. |
