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

...

Table Creation

Technical Details

Build procedure: vw_table_build

...

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

Overview

This is a centralized procedure 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:

...