Penn Computing

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

FA_GROUP_BY_AIDY 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

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.

Fa_Group_by_Aidy_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