Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_BORROR_PRIOR_TO_PENN Table - Data Element Index   Tables and Data Elements   FinAid Home   Data Warehouse Home

BORROW_PRIOR_TO_PENN Table

(dwsfa.fa_borrow_prior_to_penn)

Explanation
Contains information about student borrowing activitiy at colleges or universities prior to coming to Penn.

Common Usage examples

  • Find borrowing history for students who apply for financial aid at Penn.

Primary Key Indexed Data Elements Related Tables
SID, AID_YEAR, AID_ID
     
 
FA_BIO

Cautions
  • Although SID is part of the record key, it is a protected field, and cannot be seen or used in Data Warehouse reports. Tables in the Business Objects universe are joined on Penn_ID.
  • The Aid Year in this table cannot be used to join to any other Year columns in other tables, because it is not a standard date format.

Source

  • Data are extracted nightly from the Student Aid Management system (SAM) on the administrative mainframe.
FA_BORROR_PRIOR_TO_PENN Table - Data Element Index   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