KIS Return: KISCourse Entity
The Create Extract process creates records in the Course Extract Data record (SSR_HE_CRS_EXT) in a similar way to the Course entity in the student return, except that academic plans and academic subplans are included based on whether KIS Type has been defined rather than whether Report to HESA has been selected. For each academic plan or subplan the effective dated record relevant to the start date of the reporting period is considered.
When selecting records, the Null Errors Only, Validation Errors Only, Academic Plan and Academic Sub-Plan parameters of the Create Extract process are considered.
The KISCOURSEID is derived as part of the initial entity selection and stored in the Course Extract Data record (in SSR_HE_COURSEID). The value is derived as the subplan or plan code. The remaining fields are derived and stored in the Course Fields Extract record (SSR_HE_CRS_EX_FL).
Dependent fields are derived first including KISTYPE and UCASCOURSEID that are required for the derivation of a number of other fields.
The most recent effective dated records on or before the reporting period end date are considered for programs, plans or subplans. The exception to this is KISTYPE that is derived from the effective dated record relevant to the start of the reporting period to be consistent with the logic for including plans and subplans in the KISCourse entity.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Links group box) |
Assessment Methods URL |
|
Plan HESA Data (KIS Course Links group box) |
Assessment Methods URL |
|
Sub-Plan HESA (KIS Course Links group box) |
Assessment Methods URL |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 3, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Links group box) |
Course Page URL |
|
Plan HESA Data (KIS Course Links group box) |
Course Page URL |
|
Sub-Plan HESA (KIS Course Links group box) |
Course Page URL |
Field Derivation Rule: Include for all KISCourse 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.
If KISTYPE = 1 or 2, derive as NULL ERROR.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
DISTANCE |
|
Plan HESA Data (KIS Course Data group box) |
DISTANCE |
|
Sub-Plan HESA (KIS Course Data group box) |
DISTANCE |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Links group box) |
Employment Details URL |
|
Plan HESA Data (KIS Course Links group box) |
Employment Details URL |
|
Sub-Plan HESA (KIS Course Links group box) |
Employment Details URL |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 3, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
ENGFEE |
|
Plan HESA Data (KIS Course Data group box) |
ENGFEE |
|
Sub-Plan HESA (KIS Course Data group box) |
ENGFEE |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1 or 2
KISCourse.FEETBC = 1
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
FEETBC |
|
Plan HESA Data (KIS Course Data group box) |
FEETBC |
|
Sub-Plan HESA (KIS Course Data group box) |
FEETBC |
Field Derivation Rule: Derive a value if KISCourse.KISTYPE = 1 or 2. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
FOUNDATION |
|
Plan HESA Data (KIS Course Data group box) |
FOUNDATION |
|
Sub-Plan HESA (KIS Course Data group box) |
FOUNDATION |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
HONOURS |
|
Plan HESA Data (KIS Course Data group box) |
HONOURS |
|
Sub-Plan HESA (KIS Course Data group box) |
HONOURS |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
For JACSA, JACSB and JACSC, records are selected from Course Subjects defined at Subplan, Plan or Program level (maximum 3 records) in the same way as for the CourseSubject entity in the Student return. Records are ordered with the highest percentage first and then used in order for JACSA, JACSB and then JACSC.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (Course Subjects group box) |
Subject |
|
Plan HESA Data (Course Subjects group box) |
Subject |
|
Sub-Plan HESA (Course Subjects group box) |
Subject |
|
Plan HESA Data (ILR Aims group box) |
ILR Year |
|
Sub-Plan HESA (ILR Aims group box) |
ILR Year |
|
Plan HESA Data (HESA Course group box) |
HESA Year |
|
Sub-Plan HESA (ILR Aims group box) |
HESA Year |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1
HESA Year is not defined for subplan or plan (that is, HESACourse does not exist)
ILR Year is not defined for subplan or plan (that is, ILRAims does not exist)
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
If KISCourse entity is based on a subplan, derive as Subject value from the Sub-Plan HESA page.
Derive as Subject value from the Plan HESA Data page.
Derive as Subject value from the Program HESA Data page.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (Course Subjects group box) |
Subject |
|
Plan HESA Data (Course Subjects group box) |
Subject |
|
Sub-Plan HESA (Course Subjects group box) |
Subject |
Field Derivation Rule: If KISCourse.JACSA is not blank or is NULL ERROR, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
If JACSA is derived from a subplan (Step 1), derive as Subject value from the Sub-Plan HESA page.
If JACSA is derived from a plan (Step 2), derive as Subject value from the Plan HESA Data page.
If JACSA is derived from a program (Step 3), derive as Subject value from the Program HESA Data page.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
JACSL2 |
|
Plan HESA Data (KIS Course Data group box) |
JACSL2 |
|
Sub-Plan HESA (KIS Course Data group box) |
JACSL2 |
Field Derivation Rule: If KISCourse.KISTYPE = 3, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
KISAIM |
|
Plan HESA Data (KIS Course Data group box) |
KISAIM |
|
Sub-Plan HESA (KIS Course Data group box) |
KISAIM |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
KISMODE |
|
Plan HESA Data (KIS Course Data group box) |
KISMODE |
|
Sub-Plan HESA (KIS Course Data group box) |
KISMODE |
Field Derivation Rule: Include for all KISCourse entities.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Plan HESA Data |
KIS Type |
|
Sub-Plan HESA |
KIS Type |
Field Derivation Rule: Include for all KISCourse 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.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data |
COURSEAIM |
|
Plan HESA Data |
COURSEAIM |
|
Sub-Plan HESA |
COURSEAIM |
Field Derivation Rule: If KISCourse.KISTYPE = 3, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
If KISCourse entity is based on a subplan and COURSEAIM value from the Sub-Plan HESA page is H00, H11, H16, H18, H22, H23, H24, M22 or M26, derive as F.
If KISCourse entity is based on a subplan and COURSEAIM value from the Sub-Plan HESA page begins with H, I, J or C, derive as U.
If COURSEAIM value from the Plan HESA Data page is H00, H11, H16, H18, H22, H23, H24, M22, M26, derive as F.
If COURSEAIM value from the Plan HESA Data page begins H, I, J or C, derive as U.
If COURSEAIM value from the Program HESA Data page is H00, H11, H16, H18, H22, H23, H24, M22, M26, derive as F.
If COURSEAIM value from the Program HESA Data page begins H, I, J or C, derive as U.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
LOCCHNGE |
|
Plan HESA Data (KIS Course Data group box) |
LOCCHNGE |
|
Sub-Plan HESA (KIS Course Data group box) |
LOCCHNGE |
Field Derivation Rule: Derive a value only if the following conditions are met
KISCourse.KISTYPE = 1 or 2
KISCourse.DISTANCE = 0
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Links group box) |
Learning/Teaching Methods URL |
|
Plan HESA Data (KIS Course Links group box) |
Learning/Teaching Methods URL |
|
Sub-Plan HESA (KIS Course Links group box) |
Learning/Teaching Methods URL |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 3, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
MEANSSUP |
|
Plan HESA Data (KIS Course Data group box) |
MEANSSUP |
|
Sub-Plan HESA (KIS Course Data group box) |
MEANSSUP |
Field Derivation Rule: Derive a value if KISCourse.KISTYPE = 1 or 2. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
NHS |
|
Plan HESA Data (KIS Course Data group box) |
NHS |
|
Sub-Plan HESA (KIS Course Data group box) |
NHS |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1 or 2
HESACourse does not exist
ILRAims does not exist
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
NIFEE |
|
Plan HESA Data (KIS Course Data group box) |
NIFEE |
|
Sub-Plan HESA (KIS Course Data group box) |
NIFEE |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1 or 2
KISCourse.FEETBC = 1
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
NONCREDITASSESS |
|
Plan HESA Data (KIS Course Data group box) |
NONCREDITASSESS |
|
Sub-Plan HESA (KIS Course Data group box) |
NONCREDITASSESS |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
NUMSTAGE |
|
Plan HESA Data (KIS Course Data group box) |
NUMSTAGE |
|
Sub-Plan HESA (KIS Course Data group box) |
NUMSTAGE |
Field Derivation Rule: If KISCourse.KISTYPE = 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
OTHSUP |
|
Plan HESA Data (KIS Course Data group box) |
OTHSUP |
|
Sub-Plan HESA (KIS Course Data group box) |
OTHSUP |
Field Derivation Rule: Derive a value if KISCourse.KISTYPE = 1 or 2. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
RELATEDKIS |
|
Plan HESA Data (KIS Course Data group box) |
RELATEDKIS |
|
Sub-Plan HESA (KIS Course Data group box) |
RELATEDKIS |
Field Derivation Rule: If KISCourse.KISTYPE = 2, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
RELATEDKIS2, RELATEDKIS3 |
|
Plan HESA Data (KIS Course Data group box) |
RELATEDKIS2, RELATEDKIS3 |
|
Sub-Plan HESA (KIS Course Data group box) |
RELATEDKIS2, RELATEDKIS3 |
Field Derivation Rule: If KISCourse.RELATEDKIS is not blank or is NULL ERROR, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
If RELATEDKIS is derived from Step 2, derive from the Sub-Plan HESA page.
If RELATEDKIS is derived from Step 3, derive from the Plan HESA Data page.
If RELATEDKIS is derived from Step 4, derive from the Program HESA Data page.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
SANDWICH |
|
Plan HESA Data (KIS Course Data group box) |
SANDWICH |
|
Sub-Plan HESA (KIS Course Data group box) |
SANDWICH |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
SCOTFEE |
|
Plan HESA Data (KIS Course Data group box) |
SCOTFEE |
|
Sub-Plan HESA (KIS Course Data group box) |
SCOTFEE |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1 or 2
KISCourse.FEETBC = 1
Do not derive a value and leave the field blank, if the conditions are not met.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Links group box) |
SUPPORTURL |
|
Plan HESA Data (KIS Course Links group box) |
SUPPORTURL |
|
Sub-Plan HESA (KIS Course Links group box) |
SUPPORTURL |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
TEACHUKPRN |
|
Plan HESA Data (KIS Course Data group box) |
TEACHUKPRN |
|
Sub-Plan HESA (KIS Course Data group box) |
TEACHUKPRN |
Field Derivation Rule: Derive a value if the following conditions are met:
HESACourse does not exist
ILRAims does not exist
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Do not derive a value and leave the field blank.
Note: Three fields are provided for TEACHUKPRN in Campus Solutions rather than the maximum 50 allowed by HESA.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
TEACHUKPRN2, TEACHUKPRN3 |
|
Plan HESA Data (KIS Course Data group box) |
TEACHUKPRN2, TEACHUKPRN3 |
|
Sub-Plan HESA (KIS Course Data group box) |
TEACHUKPRN2, TEACHUKPRN3 |
Field Derivation Rule: If KISCourse.TEACHUKPRN is not blank, derive a value. Otherwise, do not derive a value and leave the field blank.
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.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Plan HESA Data |
KIS Title Course Title |
|
Academic Plan Table |
Description (maximum 30 characters) |
|
Sub-Plan HESA |
KIS Title Course Title |
|
Academic Sub-Plan Table |
Description (maximum 30 characters) |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
If KISCourse entity is based on a subplan, derive as KIS Title from the Sub-Plan HESA page.
If KISCourse entity is based on a subplan, derive as Course Title from the Sub-Plan HESA page.
If KISCourse entity is based on a subplan, derive as combination of plan and subplan descriptions separated by a space.
Derive as KIS Title from the Plan HESA Data page.
Derive as Course Title from the Plan HESA Data page.
Derive as plan description.
Note: Because the TITLEK is derived as part of the initial creation of the KIS Course entity, the derivation steps are not captured in the Course Extract Field record and so TITLEK is not displayed on the Course Extract Data page.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data |
TTCID |
|
Plan HESA Data |
TTCID |
|
Sub-Plan HESA |
TTCID |
|
Plan HESA Data (ILR Aims group box) |
ILR Year |
|
Sub-Plan HESA (ILR Aims group box) |
ILR Year |
|
Plan HESA Data (HESA Course group box) |
HESA Year |
|
Sub-Plan HESA (ILR Aims group box) |
HESA Year |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1
HESA Year is not defined for subplan or plan (that is, HESACourse does not exist)
ILR Year is not defined for subplan or plan (that is, ILRAims does not exist)
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Note: This field is derived as per Course.TTCID in the Student return.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Plan HESA Data (KIS Course Data group box) |
UCASPROGID |
|
Sub-Plan HESA (KIS Course Data group box) |
UCASPROGID |
Field Derivation Rule: Derive a value if KISCourse.KISTYPE = 1 or 2. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
If KISCourse entity is based on a subplan, derive from the Sub-Plan HESA page.
Derive from the Plan HESA Data page.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
UKPRNAPPLY |
|
Plan HESA Data (KIS Course Data group box) |
UKPRNAPPLY |
|
Sub-Plan HESA (KIS Course Data group box) |
UKPRNAPPLY |
Field Derivation Rule: Include for all KISCourse 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.
Do not derive a value and leave the field blank.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
VARFEE |
|
Plan HESA Data (KIS Course Data group box) |
VARFEE |
|
Sub-Plan HESA (KIS Course Data group box) |
VARFEE |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1 or 2
KISCourse.FEETBC = 1
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
WAFEE |
|
Plan HESA Data (KIS Course Data group box) |
WAFEE |
|
Sub-Plan HESA (KIS Course Data group box) |
WAFEE |
Field Derivation Rule: Derive a value if the following conditions are met:
KISCourse.KISTYPE = 1 or 2
KISCourse.FEETBC = 1
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
WAIVER |
|
Plan HESA Data (KIS Course Data group box) |
WAIVER |
|
Sub-Plan HESA (KIS Course Data group box) |
WAIVER |
Field Derivation Rule: Derive a value if KISCourse.KISTYPE = 1 or 2. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.
Return: KIS
Entity: KISCourse
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data (KIS Course Data group box) |
YEARABROAD |
|
Plan HESA Data (KIS Course Data group box) |
YEARABROAD |
|
Sub-Plan HESA (KIS Course Data group box) |
YEARABROAD |
Field Derivation Rule: If KISCourse.KISTYPE = 1 or 2, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
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.
Use default.
Derive as NULL ERROR.