KIS Return: CourseStage Entity
The Create Extract process creates up to seven CourseStage entities in the Course Stage Extract Data record (SSR_HE_CST_EXT) for each KISCourse entity where the derived KISTYPE = 1 or 3. If no CourseStage records are defined for the academic plan or subplan then no entities are created.
The fields are derived and stored in the CourseStage Fields Extract record (SSR_HE_CSTEX_FL).
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Assessment Method |
Plan HESA Data (Course Stage group box) |
Assessment Method |
Sub-Plan HESA (Course Stage group box) |
Assessment Method |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan), derive from the same CourseStage record.
If STAGE is derived from Step 2 (plan), derive from the same CourseStage record.
If STAGE is derived from Step 3 (program), derive from the same CourseStage record.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Coursework |
Program HESA Data (Stage Modules group box) |
Coursework |
Plan HESA Data (Course Stage group box) |
Coursework |
Plan HESA Data (Stage Modules group box) |
Coursework |
Sub-Plan HESA (Course Stage group box) |
Coursework |
Sub-Plan HESA (Stage Modules group box) |
Coursework |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from subplan, and at least one Stage Module record is defined for the subplan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 2 (plan) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from plan and at least one Module record is defined for the plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 3 (program) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from program and at least one Module record is defined for the program stage, derive as the average value for each of the modules weighted by FTE.
Note: For steps 2, 4 and 6 after all three assessment fields (COURSEWORK, PRACTICAL and WRITTEN) have been derived, if the total of all three fields does not equal 100 or zero the derived value of the field with the largest value is adjusted to ensure that the total equals 100. The largest value is adjusted to ensure that a zero value is not adjusted to -1.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Independent Study |
Program HESA Data (Stage Modules group box) |
Independent Study |
Plan HESA Data (Course Stage group box) |
Independent Study |
Plan HESA Data (Stage Modules group box) |
Independent Study |
Sub-Plan HESA (Course Stage group box) |
Independent Study |
Sub-Plan HESA (Stage Modules group box) |
Independent Study |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from subplan and at least one Stage Module record is defined for the sub-plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 2 (plan) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from plan and at least one Module record is defined for the plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 3 (program) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from program and at least one Module record is defined for the program stage, derive as the average value for each of the modules weighted by FTE.
Note: For steps 2, 4 and 6 after all three Learning Method fields (SCHEDULED, INDEPENDENT and PLACEMENT) have been derived, if the total of all three fields does not equal 100 or zero the derived value of the field with the largest value is adjusted to ensure that the total equals 100. The largest value is adjusted to ensure that a zero value is not adjusted to -1.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Learning/Teaching Method |
Plan HESA Data (Course Stage group box) |
Learning/Teaching Method |
Sub-Plan HESA (Course Stage group box) |
Learning/Teaching Method |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan), derive from the same CourseStage record.
If STAGE is derived from Step 2 (plan), derive from the same CourseStage record.
If STAGE is derived from Step 3 (program), derive from the same CourseStage record.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Placement Study |
Program HESA Data (Stage Modules group box) |
Placement Study |
Plan HESA Data (Course Stage group box) |
Placement Study |
Plan HESA Data (Stage Modules group box) |
Placement Study |
Sub-Plan HESA (Course Stage group box) |
Placement Study |
Sub-Plan HESA (Stage Modules group box) |
Placement Study |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from subplan and at least one Stage Module record is defined for the subplan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 2 (plan) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from plan and at least one Module record is defined for the plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 3 (program) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from program and at least one Module record is defined for the program stage, derive as the average value for each of the modules weighted by FTE.
Note: For steps 2, 4 and 6 after all three Learning Method fields (SCHEDULED, INDEPENDENT and PLACEMENT) have been derived, if the total of all three fields does not equal 100 or zero the derived value of the field with the largest value is adjusted to ensure that the total equals 100. The largest value is adjusted to ensure that a zero value is not adjusted to -1.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Practical Exam |
Program HESA Data (Stage Modules group box) |
Practical Exam |
Plan HESA Data (Course Stage group box) |
Practical Exam |
Plan HESA Data (Stage Modules group box) |
Practical Exam |
Sub-Plan HESA (Course Stage group box) |
Practical Exam |
Sub-Plan HESA (Stage Modules group box) |
Practical Exam |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from subplan, and at least one Stage Module record is defined for the subplan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 2 (plan) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from plan and at least one Module record is defined for the plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 3 (program) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from program and at least one Module record is defined for the program stage, derive as the average value for each of the modules weighted by FTE.
Note: For steps 2, 4 and 6 after all three assessment fields (COURSEWORK, PRACTICAL and WRITTEN) have been derived, if the total of all three fields does not equal 100 or zero the derived value of the field with the largest value is adjusted to ensure that the total equals 100. The largest value is adjusted to ensure that a zero value is not adjusted to -1.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Scheduled Study |
Program HESA Data (Stage Modules group box) |
Scheduled Study |
Plan HESA Data (Course Stage group box) |
Scheduled Study |
Plan HESA Data (Stage Modules group box) |
Scheduled Study |
Sub-Plan HESA (Course Stage group box) |
Scheduled Study |
Sub-Plan HESA (Stage Modules group box) |
Scheduled Study |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from subplan and at least one Stage Module record is defined for the subplan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 2 (plan) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from plan and at least one Module record is defined for the plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 3 (program) and either (a) the total of the three Learning Method fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from program and at least one Module record is defined for the program stage, derive as the average value for each of the modules weighted by FTE.
Note: For steps 2, 4 and 6 after all three Learning Method fields (SCHEDULED, INDEPENDENT and PLACEMENT) have been derived, if the total of all three fields does not equal 100 or zero the derived value of the field with the largest value is adjusted to ensure that the total equals 100. The largest value is adjusted to ensure that a zero value is not adjusted to -1.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Stage |
Plan HESA Data (Course Stage group box) |
Stage |
Sub-Plan HESA (Course Stage group box) |
Stage |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If KISCourse entity is based on a subplan, derive from the Sub-Plan HESA page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Return: KIS
Entity: CourseStage
Pages Used:
Page |
Page Element |
---|---|
Program HESA Data (Course Stage group box) |
Written Exam |
Program HESA Data (Stage Modules group box) |
Written Exam |
Plan HESA Data (Course Stage group box) |
Written Exam |
Plan HESA Data (Stage Modules group box) |
Written Exam |
Sub-Plan HESA (Course Stage group box) |
Written Exam |
Sub-Plan HESA (Stage Modules group box) |
Written Exam |
Field Derivation Rule: Include for all CourseStage entities.
Derivation Steps:
If STAGE is derived from Step 1 (subplan) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from subplan, and at least one Stage Module record is defined for the subplan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 2 (plan) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from plan and at least one Module record is defined for the plan stage, derive as the average value for each of the modules weighted by FTE.
If STAGE is derived from Step 3 (program) and either (a) the total of the three Assessment fields is 100 or (b) no Stage Modules are defined, derive from the same CourseStage record.
If STAGE is derived from program and at least one Module record is defined for the program stage, derive as the average value for each of the modules weighted by FTE.
Note: For steps 2, 4 and 6 after all three assessment fields (COURSEWORK, PRACTICAL and WRITTEN) have been derived, if the total of all three fields does not equal 100 or zero the derived value of the field with the largest value is adjusted to ensure that the total equals 100. The largest value is adjusted to ensure that a zero value is not adjusted to -1.