Cube_Stage
Introduction
Cube_Stage holds information about stage results for students. It should be used where analysis of stages is required. Stage information is also held on Cube_Assessment and Cube_Module for use in board reporting.
Shared Dimensions
Dimensions in the cube based upon Shared Dimensions are as below. Details of these columns are in the Shared Dimensions section.
| Shared Dimension Name | Name in Cube | Notes |
|---|---|---|
| Member | Stage Member | |
| Fee Profile | Stage Fee Profile | |
| Course | Stage Course | The course the student was on during the stage. Note: The current course for a student can be found on Cube_Module. |
| Stage | Stage |
Cube-Specific Dimensions
Stage Other
This contains various columns from the underlying fact table useful for context.
| Column Names | Meaning |
|---|---|
| Confirmed Progression Code | |
| Stage Academic Year Src | Used to show academic year for the stage. |
| Stage Credits | Number of credits obtained during the stage. |
Measures
The measures used are retrieved from the underlying fact table Fact_Stage_Over_Time. These include
| Cube Measures Group | Cube Field | Derivation | Description |
|---|---|---|---|
| Fact Stage | Fact Stage Count | Number of records. | |
| Stage Average Confirmed Mark Count | Number of stage_average_confirmed_marks populated | ||
| Avg_Stage_Confirmed_Mark | stage_average_confirmed_mark/ Stage Average Confirmed Mark Count |