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 |