Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA BIO Table . Pennant Financial Aid Home . Data Warehouse Home

FA_BIO Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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.

FA BIO Table . Pennant Financial Aid Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania