EPM Release Notes - August 23, 2011

New or Changed Tables and Views
Operational Warehouse Staging (OWS) Tables/Views

• Campus Solutions
• ASU_STDNT_PROFILE_MAJ_CURRENT*
• PS_ASU_SR205_CKLST
• PS_ASU_SR205_PROFL
• PS_ASU_SR205_STAT
• PS_ASU_SR205_THSIS
• PS_ASU_SR205_THS_R

*ASU_STDNT_PROFILE_MAJ_CURRENT is the new Current Student Profile table that includes student major-related data such as program, plan, subplan and campus. It includes data for all records that are active as of the current date (the day you run your query), even if the student is not yet term activated - for example, first-time freshmen who have not yet made an orientation reservation. This new table simplifies the data, reduces errors, promotes consistency, and reduces the complexities of the tables so users can easily create their own queries.

Three student Data Warehouse tables were renamed to make them easier to find in the My Reports table catalog:

New Name: ASU_STDNT_PROFILE_MAJ_CURRENT
Old Name: PS_ASU_SPRF_CURR

New Name: ASU_STDNT_PROFILE_MAJ_TERM
Old Name: PS_ASU_SR0189_SPRF

New Name: ASU_STDNT_PROFILE_TERM
Old Name: PS_ASU_SR0189_SBYT

This change will not cause existing queries to break. However, when building new queries, you need to look for the new names.

Changes to EPM Business Rules and Logic
n/a