FA USER DEFINED BY AIDY Table . Pennant Financial Aid Home . Data Warehouse Home

Pk_Fa_User_Defined_Aidy Usdfa_Aidy_Code Usdfa_Pidm Usdfa_Penn_Id Usdfa_Refresh_Date Usdfa_Value_1 Usdfa_Value_2 Usdfa_Value_16

Data element	Definition
Pk_Fa_User_Defined_Aidy Indexed - yes Format - Varchar2(15) May be Null? N	Primary key for table. Unique by PIDM and Aid Year.
Usdfa_Aidy_Code Indexed - no Format - Varchar2 (4) May be Null? Y	Aid year code for individual student record within table.
Usdfa_Pidm Indexed - no Format - Number (8) May be Null? Y	Internal Banner identification number for student.
Usdfa_Penn_Id Indexed - no Format - Varchar2 (9) May be Null? Y	Student's Penn ID or university ID.
Usdfa_Refresh_Date Indexed - no Format - Date May be Null? Y	Last date the record was updated in the data warehouse.
Usdfa_Value_1 Indexed - no Format - Varchar2(20) May be Null? Y	Year at Penn.
Usdfa_Value_2 Indexed - no Format - Varchar2(20) May be Null? Y	IM Case Complexity.
Usdfa_Value_16 Indexed - no Format - Varchar2(20) May be Null? Y	User Assignment. FA staff assigned to student.

FA USER DEFINED BY AIDY Table . Pennant Financial Aid Home . Data Warehouse Home