The FA_BORROW_PRIOR_TO_PENN Table


			<< go back

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

Data element	Definition	Object name in Business Objects universe (if different from data element name)
Aid_Id Indexed - yes Format - Char May be Null? Y
Aid_Year Indexed - yes Format - Varchar2(6) May be Null? Y
Load_Date Indexed - no Format - Date May be Null? Y	The latest date this student's record was refreshed in the warehouse from the Student Aid Management system (SAM). Does not indicate a specific column in a table has changed; the entire student's record gets refreshed whenever there is any change in SAM
Offer_Amount Indexed - no Format - Number May be Null? Y
Paid_Amount Indexed - no Format - Number May be Null? Y
Program_Name Indexed - no Format - Char May be Null? Y
Sid Indexed - yes Format - Char May be Null? Y	Social Security Number which is key from the SAM source

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