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 or U 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.
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.
Return: Student Record
Entity: Mobility
Page Used:
|
Page |
Page Element |
|---|---|
|
Mobility (Records and Enrollment, Career and Program Information, HESA Instance Details, Mobility) |
Start Date and End Date |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
If the Start and End Date both fall within the reporting period (that is, not overlapping), derive as the total number of days converted to weeks. Days are converted to weeks by dividing by 7 and rounding to the nearest week; 4 days is rounded up; 3 days is rounded down.
For overlapping records the total number of days is calculated as:
Number of days that fall in this reporting period. That is, days from the Start Date or reporting period start (whichever is later) until the End Date or reporting period end (whichever is earlier).
If the Start Date is before the reporting period and the number of days in the preceding period is between 1 and 24 inclusive, those days are added to the total.
If the End Date is after the reporting period and the total number of days in the following period is between 1 and 24 inclusive, those days are added to the total.
Derive as total number of days converted to weeks
Return: Student Record
Entity: Mobility
Page Used:
|
Page |
Page Element |
|---|---|
|
Mobility (Records and Enrollment, Career and Program Information, HESA Instance Details, Mobility) |
Location |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
1. Derive from the Mobility page.
Return: Student Record
Entity: Mobility
Page Used:
|
Page |
Page Element |
|---|---|
|
Mobility (Records and Enrollment, Career and Program Information, HESA Instance Details, Mobility) |
Scheme |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
1. Derive from the Mobility page.
Return: Student Record
Entity: Mobility
Page Used:
|
Page |
Page Element |
|---|---|
|
Mobility (Records and Enrollment, Career and Program Information, HESA Instance Details, Mobility) |
Type 1 |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
1. Derive from the Mobility page.
Return: Student Record
Entity: Mobility
Page Used:
|
Page |
Page Element |
|---|---|
|
Mobility (Records and Enrollment, Career and Program Information, HESA Instance Details, Mobility) |
Type 2and Type 3 |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
Derive from the Mobility page.
Do not derive a value and leave the field blank.