Return to Navigation

KIS Return: CourseLocation Entity

The Create Extract process creates up to three CourseLocation entities for each KISCourse record where KISCourse.KISTYPE = 1 or 2 and KISTYPE.DISTANCE = 0, where the Location ID fields are defined for the subplan, plan or program. If Location ID values are not defined, the process does not create the entities.

Return: KIS

Entity: CourseLocation

Pages Used:

Page

Page Element

Program HESA Data (KIS Course Data group box)

LOCID, LOCID2, LOCID3

Plan HESA Data (KIS Course Data group box)

LOCID, LOCID2, LOCID3

Sub-Plan HESA (KIS Course Data group box)

LOCID, LOCID2, LOCID3

Derivation Steps: Include for all CourseLocation entities.

  1. If KISCourse entity is based on a subplan, derive from the Sub-Plan HESA page.

  2. Derive from the Plan HESA Data page.

  3. Derive from the Program HESA Data page.

  4. Use default that is defined for LOCID.

Return: KIS

Entity: CourseLocation

Pages Used:

Page

Page Element

Plan HESA Data (KIS Course Data group box)

UCASCOURSEID, UCASCOURSEID2, UCASCOURSEID3

Sub-Plan HESA (KIS Course Data group box)

UCASCOURSEID, UCASCOURSEID2, UCASCOURSEID3

UCAS Course (Set Up SACR, Product Related, Recruiting and Admissions, UCAS, Mappings, UCAS Course)

UCAS Course Code

Derivation Steps: Include for all CourseLocation entities.

Derivation Steps:

  1. If LOCID is derived in Step 1 (that is, subplan) from LOCID, derive UCASCOURSEID value from the Sub-Plan HESA page.

  2. If LOCID is derived in Step 1 (that is, subplan) from LOCID, map the combination of subplan and plan to a UCAS course code via the UCAS mappings on the UCAS Course page. Refer to the following notes on UCAS Course mappings.

  3. If LOCID is derived in Step 1 (that is, subplan) from LOCID2, derive UCASCOURSEID2 value from the Sub-Plan HESA page.

  4. If LOCID is derived in Step 1 (that is, subplan) from LOCID3, derive UCASCOURSEID3 value from the Sub-Plan HESA page.

  5. If LOCID is derived in Step 1 (that is, subplan) from LOCID, LOCID2 or LOCID3, do not derive a value and leave the field blank.

  6. If LOCID is derived in Step 2 (that is, plan) from LOCID, derive UCASCOURSEID value from the Plan HESA Data page.

  7. If LOCID is derived in Step 2 (that is, plan) from LOCID, map the plan to a UCAS course code via the UCAS mappings on the UCAS Course page. Refer to the following notes on UCAS Course mappings.

  8. If LOCID is derived in Step 2 (that is, plan) from LOCID2, derive UCASCOURSEID2 value from the Plan HESA Data page.

  9. If LOCID is derived in Step 2 (that is, plan) from LOCID3, derive UCASCOURSEID3 value from the Plan HESA Data page.

  10. If LOCID is derived in Step 2 (that is, plan) from LOCID, LOCID2 or LOCID3, do not derive a value and leave the field blank.

  11. If LOCID is derived in Step 3 (that is program) or Step 4 (that is default), do not derive a value and leave the field blank.

Notes on UCAS Course mappings

The UCAS course code (SAD_UC_COURSE) is selected from the most recent record (by entry year and entry month) in SAD_UC_COURSE where the subplan (for step 2) or the plan (for step 7) is defined for the UCAS Course. The mappings are only done for entities derived from LOCID and not for entities derived for LOCID2 or LOCID3.

Step 2 - For subplans, records are selected from SAD_UC_COURSE where the academic institution matches the institution of the KIS return, the academic subplan matches the KISCOURSEID and the active flag is ‘Y’. If multiple records are found the record with the highest entry year (SAD_UC_ENTRYYEAR) is selected. If multiple records for the same Entry Year are found, the record with the highest Entry Month is selected. If multiple records for the same Entry Year and Entry Month are found (that is, more than one UCAS Course Code is found), NULL ERROR is derived.

Step 7 - For plans, records are selected from SAD_UC_COURSE where the academic institution matches the institution of the KIS return, the academic plan matches the KISCOURSEID, the subplan is blank and the Active flag is ‘Y’. If multiple records are found the record with the highest entry year (SAD_UC_ENTRYYEAR) is selected. If multiple records for the same Entry Year are found, the record with the highest Entry Month is selected. If multiple records for the same Entry Year and Entry Month are found (that is, more than one UCAS Course Code is found), NULL ERROR is derived.