Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_BORROW_PRIOR_TO_PENN Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

BORROW_PRIOR_TO_PENN Table - Data Element Index

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

FA_BORROW_PRIOR_TO_PENN Table   Tables and Data Elements   FinAid 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