...
Local Table Creation
Technical Details
ProcedureBuild procedure: vw_table_build
Dependencies:
- Procedures: vw_admissions_summary_build, vw_sps_enbrollment_build, vw_sps_enrollm,ent_trcl_build
- Views: a1_admissions_summary, a1_sps_enrollment, a1_sps_enrollment_trcl
- Tables: sys_logging
Cadence: Runs each morning at 6:30am
...
Location: Crystal / All Folders / SPS - School of Professional Studies / Feeds
Overview
A This is a centralized procedure has been developed to create local tables based on views of data that are used regularly as the basis for SPS reporting and queries. These tables are then indexed to improve performance across the reporting landscape.
Outputs
The following tables are created when the procedure is successfully executed:
- 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
The following table is updated when the procedure is successfully executed:
- sys_logging
- Results of each execution are stored in the the sys_logging table for troubleshooting and validation of each build