ST_CURRENT_CONTACT_FLAT_MV column definitions . Pennant Student Records Home . Data Warehouse Home

ST_CURRENT_CONTACT_FLAT_MV

(dwngss_ps.st_current_contact_flat_mv)

Explanation

Current contact information for a student returned in the format of one row per student. This information includes current address, permanent address, permanent phone, mobile/cell phone, penn email and preferred email.

Source

The warehouse ST_CURRENT_CONTACT_FLAT_MV is a materialized view that is refreshed daily. It derives information from the warehouse tables DWNGSS_PS.ST_EMAIL, DWNGSS_PS.ST_ADDRESS, and DWNGSS_PS.ST_PHONE. The logic for the MV determines which address is active and current and returns the information for one row per student.

Common Uses

• This MV was designed mainly to be used to allow for easier reporting when looking to include current contact information on the student. The one row per record without having to add any conditions to the results allows for utilizing an outer join to the table and not losing any records from your query or duplicating any of your records.

Cautions and notes

• The results of the MV are calculated for current and active address information. If you are looking at past students or trying to do some type of historical analysis, you may be better using the original tables to control active status, date ranges, and other fields that may bring back the data that you need.

ST_CURRENT_CONTACT_FLAT_MV column definitions . Pennant Student Records Home . Data Warehouse Home