Overview

All of the processes documented here are self-contained within the CEREPORTS and impact data that is stored locally on the database server. This can include processes that create lookup tables, or clean and process data in some way, and is triggered by an automated execution either on the server or externally.

Process List

Local Table Creation

Technical Details

Procedure: vw_table_build

Dependencies: vw_admissions_summary_build, vw_sps_enbrollment_build, vw_sps_enrollm,ent_trcl_build

Cadence: Runs each morning at 6:30am

Trigger: Executed through Crystal Reports scheduler (DEV)

Location: Crystal / All Folders / SPS - School of Professional Studies / Feeds

Overview

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.