Penn Computing

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

AIDID_RULES Table

(dwsfa.fa_aidid_rules)

Explanation
The Aid ID Rules table sets the rules for which Aid IDs to be included in the aggregate buckets in the Application and Cumulative Aid tables.  The Begin and End Aid ID fields set the range of Aid IDs to include for a given bucket (rule_header).  Paid or Offered sets whether to use the Offer or Paid amounts in the calculation. 

Common Usage examples

  • While unlikely to be used in common queries, this table is provided for the end user to review the Aid ID groupings used in the aggregation processes.

Primary Key Indexed Data Elements Related Tables
UNIQUE_ID
     
 
 

Cautions
  • This table is primarily used for the load of data and is present only for reference purposes.  Given the complex rules applied during the load, it would be very difficult to try linking this table to the raw data in the tables.

Source

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