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. |