...
- Procedures: vw_admissions_summary_build, vw_sps_enbrollmentenrollment_build, vw_sps_enrollment_enrollm,ent_trcltrcl_build, vw_mkt_unified_build
- Views: a1_admissions_summary, a1_sps_enrollment, a1_sps_enrollment_trcl
- Tables: sys_logging
Cadence: Runs each morning at 67:30am
Trigger: Executed through Crystal Reports scheduler (DEV)
...
The following tables are created when the procedure is successfully executed:
- Daily
- vw_admissions_summary
- All admissions related data in a consolidated table. Used in Power BI reports such as the ASR, and any others that require admissions statuses, such as admits, commits, etc.
- This table is a drop-in replacement for any procedure using the a1_admissions_summary view as a source
- vw_sps_enrollment
- All SPS students across terms based on courses in the TOOK table
- This table is a drop-in replacement for any procedure using the a1_sps_enrollment view as a source
- vw_sps_enrollment_trcl
- All SPS students across terms based on transactions in the TRCL table (regardless of TOOK attendance)
- This table is a drop-in replacement for any procedure using the a1_sps_enrollment_trcl view as a source
- vw_admissions_summary
- Weekly
- RPT_MKT_UNIFIED
- Static aggregation table of marketing related information from imported Slate tables (RPT_%)
- RPT_MKT_UNIFIED
The following table is updated when the procedure is successfully executed:
...