Student Record Return: Mobility Entity

For each Instance entity, the Create Extract process can create unlimited number of Mobility entities.

The process creates the mobility extract records (SSR_HE_MB_EXT, SSR_HE_MB_EX_FL) only if you have selected the Include Student entities check box on the Create Extract Data page.

If the Retain Data from Previous Run check box is selected on the Create Extract Data page, the process:

• Deletes any existing extract records for the return with status of INACTIVE.

• Updates any existing extract records for the return with status of ACTIVE and sets status of these records to INACTIVE.

If Retain Data from Previous Run is not selected, the process deletes existing extract records of any status for the return.

For each Instance (with a HUSID and NUMHUS) in the Instance Extract table for this run of the return (that is, with status of ACTIVE), if Instance.LOCSDY = T, U, or Z and Instance.REDUCEDI = 00 or 01:

• The process creates Mobility entities based on the records defined for the most recent effective dated HESA Instance Data record where the effective date is not after the reporting period end date (that is, not in future).

• The process selects only records that cover some or all of this reporting period based on the Mobility Start and End, where either:

  The Start Date or the End Date falls within the reporting period

  Or the Start Date is before the reporting period start date and the End Date is after the reporting period end date.

• The process selects only non-UK records whose location code is not XF, XG, XH, XI, XK, XL, JE, GG or IM.

• If either the Start Date or the End Date is outside of the reporting period (that is, overlapping) the process includes the record only if one of these conditions is met:

  • The duration in this reporting period is 25 days or more (that is, 4 weeks or more)

  • The duration in this reporting period is less than 25 days and more than half of the total number of days are in this reporting period: That is, this is the major part of the duration, the minor part is in the next or previous period and will be added to this. If the major part is in the next or previous reporting period and the duration of this minor part is less than 24 days then the process does not include the record because those days will be added to the major part.

  • The duration in this reporting period is less than 25 days and exactly half of the days are in this reporting period and the start date is in this reporting period. That is, for an exact split between periods where both parts are less than 25 days, the record is included in the first period only and all the days reported there.

For each Instance (with a HUSID and NUMHUS) in the Instance Extract table for this run of the return (that is, with status of ACTIVE), if Instance.LOCSDY is not equal to T or U and Instance.REDUCEDI is not equal to 00 or 01, then process does not create the Mobility entity and skips to the next Instance.