FW_ACCOUNT: refreshed nightly from ACCOUNT table from Financial data warehouse on Enterprise1
Faculty Activity Report
Multi-Dimensional Warehouse (MDW) Tables/Views
ASU_EMP_JOB_PROFILE_VW: contains Job snapshots taken after each Pay End Dt. The view is a snapshot per pay period, of all active jobs and jobs terminated during the pay period.
ASU_EMP_JOB_PROFILE_CURR_VW: view providing just the most recent snapshot of Job data from ASU_EMP_JOB_PROFILE_VW
Changes to EPM Business Rules and Logic
PS_ASU_HR158_VW: modified logic behind the view, to significantly improve performance. The view may now return different results in some cases, due to improvements and changes in source tables and derivation logic. There is discussion of retiring PS_ASU_HR158_VW; recommend use of ASU_EMP_JOB_PROFILE_VW or ASU_EMP_JOB_CURR_VW