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.
||Indexed Data Elements
- 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.
- Data are extracted nightly from the Student Aid Management system (SAM) on the administrative mainframe.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania