Data Futures Return: Course Initiative Entity
For each Course extract record, an entity is created for each initiative defined at sub-plan, plan, or program level. In each case, the latest record where the effective date falls on or before the reporting period end date is considered. Records where Valid To is before the start of the reporting period are not considered.
Course Initiative extract records are created if you selected the Include Course Entities parameter check box.
For each Course entity in the extract for the return with an active status:
If the Course.COURSEID is derived from a Sub-Plan, an entity is created for each eligible record:
If at least one Initiative is defined for the Sub-plan with Valid To either blank, or a date on or after the Reporting Period start date. The derivation step for INITIATIVEIDCI is set to 1.
If at least one Initiative is defined for the parent Plan with Valid To either blank, or a date on or after the Reporting Period start date. The derivation step for INITIATIVEIDCI is set to 2.
If the parent Plan is associated with an Academic Program (ACAD_PROG in ACAD_PLAN_TBL), and at least one Initiative is defined for the parent Program with Valid To either blank, or a date on or after the Reporting Period start date. The derivation step for INITIATIVEIDCI is set to 3.
If the Course.COURSEID is derived from a Plan, an entity is created for each eligible record:
If at least one Initiative is defined for the Plan with Valid To either blank, or a date on or after the Reporting Period start date. The derivation step for INITIATIVEIDCI is set to 2.
If the Plan is associated with an Academic Program (ACAD_PROG in ACAD_PLAN_TBL), and at least one Initiative is defined for the parent Program with Valid To either blank, or a date on or after the Reporting Period start date. The derivation step for INITIATIVEIDCI is set to 3.
If no eligible records are found at any level, no entities are created.
Return: Data Futures
Entity: Course Initiative
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data — Initiatives |
Initiative |
|
Plan HESA Data — Initiatives |
Initiative |
|
Sub-Plan HESA Data — Initiatives |
Initiative |
Field Derivation Rule: Include for all entities
Derivation Steps:
-
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
-
Derive from the Plan HESA Data page.
-
Derive from the Program HESA Data page.
Return: Data Futures
Entity: Course Initiative
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data — Initiatives |
Valid From |
|
Plan HESA Data — Initiatives |
Valid From |
|
Sub-Plan HESA Data — Initiatives |
Valid From |
Field Derivation Rule: Include for all entities
Derivation Steps:
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page converted to YYYY-MM-DD format.
Derive from the Plan HESA Data page converted to YYYY-MM-DD format.
Derive from the Program HESA Data page converted to YYYY-MM-DD format.
Return: Data Futures
Entity: Course Initiative
Pages Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data — Initiatives |
Valid To |
|
Program HESA Data — Initiatives |
Valid To |
|
Program HESA Data — Initiatives |
Valid To |
Field Derivation Rule: Include for all entities
Derivation Steps:
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page converted to YYYY-MM-DD format.
Derive from the Plan HESA Data page converted to YYYY-MM-DD format.
Derive from the Program HESA Data page converted to YYYY-MM-DD format.
Derive as null.