Penn Computing

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

AWARD Table

Oracle schema and table name: dwsfa.fa_award_term
Business Objects class: Award (AWD)


Explanation
Contains one record for each award "program" a student is offered in his or her award package, by program identifier, and aid year (year is further delineated into term and term session.)

Common Usage examples

  • Find students whose aid package includes WorkStudy this semester.
  • Summarize awards that include Perkins loans for the past five years.

Primary Key Indexed Data Elements Related Tables

     SID, SRS_Term, Term_Session, Aid_ID
Aid_ID, COA_CNAC, COA_CREF, COA_FUND, 
COA_OBJECT, COA_ORG, COA_PROGRAM,
PENN_ID, Paid_Status, SAM_School_Code,
SAM_Term, Source, SRS_DIvision_Code, SRS_School_Code, SRS_Term, Term_Session
APPLICATION

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.

Source

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