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.
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|
|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.|
This contains various columns from the underlying fact table useful for context.
|Confirmed Progression Code|
|Stage Academic Year Src||Used to show academic year for the stage.|
|Stage Credits||Number of credits obtained during the stage.|
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|