- Operational Warehouse Staging (OWS) Tables/Views
- Human Resources
- FW_ACCOUNT: refreshed nightly from ACCOUNT table from Financial data warehouse on Enterprise1
- Faculty Activity Report
- FAR_COMMUNITYSERVICES
- FAR_HONORS
- FAR_BOOKREVIEWS
- FAR_MONETARYAWARDPURPOSES
- FAR_MONETARYAWARDS
- FAR_NONREFEREEDARTICLES
- FAR_PROFESSIONALSERVICES
- FAR_REFEREEDARTICLES
- FAR_SHORTSTORIES
- FAR_UNIVERSITYSERVICES
- FAR_EVALUATIONS
- Multi-Dimensional Warehouse (MDW) Tables/Views
- Human Resources
- 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
No comments:
Post a Comment