Web Content Display Web Content Display

This holds details of the stage, indicating how far a student is through their course.  This is static data based upon level info on the LEV form in SITS.

Column Name Data Type Description Derivation
stage_sk integer This uniquely identifies the stage record. The value increments each time a record is entered into the table.
stage_code varchar The code on SITS for the stage CAM_LEV.LEV_CODE
stage_name varchar The description of the stage. CAM_LEV.LEV_NAME
entry_stage_category varchar

As name

 

Applicable stages split into '0+1' & '2+'
stage_order integer Numeric order of stages. Number equivalent to stage code from 1-7.