Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA VALUE SNAP column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Value Snap table

(dwngss_pf.fa_value_snap)

Explanation

This table captures specific values from existing warehouse tables. The Financial Aid office decides which fields they are interested in tracking. This table keeps track of those values and records if there was a change from a previous value for that student and the value.

Source

The data listed here is from the warehouse. The process to check for any changes is based on any changes to the data.

Common Uses

  • Track if a change was made for a specific value.

 

Primary Key Indexed Data Elements Related Tables
AIDY_CODE
PERIOD
PENN_ID
TABLE_NAME
FIELD_NAME

Cautions and notes

  • While this table can be used as an audit, keep in mind that this table is only used for specific values and cannot be relied on as an audit of all warehouse data.
FA VALUE SNAP column definitions . Pennant Financial Aid 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