Data Futures Return: Collaborative Provision Entity
For each Engagement entity in the extract, a single Collaborative Provision entity is created based on the defined COLPROVTYPEID if Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.
Entities are created using one of these steps. If an entity is created in a step, the subsequent steps are skipped.
An entity is created if COLPROVTYPEID is defined in the most recent HESA Instance record for the Engagement entity.
An entity is created if COLPROVTYPEID is defined for the most recent effective-dated Sub-Plan HESA Data record for the Engagement entity.
An entity is created if COLPROVTYPEID is defined for the most recent effective-dated Plan HESA Data record for the Engagement entity.
An entity is created if COLPROVTYPEID is defined for the most recent effective-dated Program HESA Data record of the Engagement entity.
If COLPROVTYPEID isn’t defined, entities aren’t created.
If the Engagement is subsequently flagged as dormant, the derived value is updated to null and the derivation step is set to zero.
Return: Data Futures
Entity: Collaborative Provision
Page Used:
|
Page |
Page Element |
|---|---|
|
Program HESA Data |
COLPROVTYPEID |
|
Plan HESA Data |
COLPROVTYPEID |
|
Sub-Plan HESA Data |
COLPROVTYPEID |
|
HESA Instance Data |
COLPROVTYPEID |
Field Derivation Rule: Derive for all entities.
Derivation Steps:
Derive from HESA Instance Data.
Derive from Sub-Plan HESA Data.
Derive from Plan HESA Data.
Derive from Program HESA Data.
Return: Data Futures
Entity: Collaborative Provision
Page Used:
|
Page |
Page Element |
|---|---|
|
HESA Instance Data |
PARTNERNUMHUS |
Field Derivation Rule: Include for all entities.
Derivation Steps:
Derive from HESA Instance Data.
Derive as null.
Return: Data Futures
Entity: Collaborative Provision
Page Used:
|
Page |
Page Element |
|---|---|
|
HESA Instance Data |
PARTNERSID |
Field Derivation Rule: Include for all entities.
Derivation Steps:
Derive from HESA Instance Data.
Derive as null.
Return: Data Futures
Entity: Collaborative Provision
Page Used:
|
Page |
Page Element |
|---|---|
|
HESA Instance Data |
PARTNERUKPRN |
Field Derivation Rule: Include for all entities.
Derivation Steps:
Derive from HESA Instance Data.
Derive as null.