03 March 2025

CDR Changes for 4.42

The following changes have been made to the CDR module for 4.42:

  • Fields have been added or updated in Central to allow for the 2023-24 return.

    New Fields

    • EMA Id

    • Client Id

    • Participant Id

    • Social Inclusion Course

    • Learner Support Funding

    Fields that are now dropdown menus

    • Has Disability

    • No GCSEs A*-C

    • No GCSEs D-G

    • EssentialSkillsNumeracyGrade

    • EssentialSkillsLiteracyGrade

    • GCSEMathGrade

    • GCSEEnglishGrade

    Fields moved from Learner Details to Enrolments

    • Long Term Destination has been moved from Learner Details to Enrolments

    • Long Term Employment has been moved from Learner Details to Enrolments

  • Fields have been added or updated in the CDR output to allow for the 2023-24 return.

    New Fields

    • IND_SI

    • IND_STU

    • IND_ES

    • IND_PSSA

    • AGE_BAND_NISRA

    • Learner Support Funding

    • EMA Id

    • Client Id

    • Participant Id

    • Social Inclusion Course

    Updated to CDR Output fields

    • DEPENDANTS

    • HAS_DISABILITY

    • PROG_PATHWAY

    • SESS_TITLE

    • FEE_WAIVER

    • JULY_AGE

    • GCSEMathGrade

    • GCSEEnglishGrade

    • EssentialSkillsNumeracyGrade

    • EssentialSkillsLiteracyGrade

    • GCSE_A_C

    • GCSE_D_G

    • MODE_OF_DELIVERY

  • There is change in the way Fee Waivers are processed. If not recorded at 'Q' the output is now recorded as ‘Y’ level.

Changes for Service Pack 1

  • Qualification Numbers for learners are now visible on the Learner Manager Enrolments screen.

  • All dates for funding years will now use a standard format

    ex. 1st September 2023 would be 01-Sep-2023

  • Created a nightly scheduled workflow to update UNIT_INSTANCE_OCCURRENCES.YEAR_OF_UNIT in ebs for those UIOs that span more than 1 academic year so that the derived FINAL_YR value is calculated correctly.

New Validation Rules added

  • Validation Rule 183 is 'TOTAL_S_HRS are 0'

    Logic is:

    TOTAL_S_HRS = 0

    Type is W

  • Validation Rule 271 is 'Ukrainian migrant but scheme is invalid'

    Logic is:

    immigration_status = 'B' AND vprs NOT in valid list (0,A,B,C)

    Type is EC

  • Validation Rule 272 is 'Afghan migrant but scheme is invalid'

    Logic is:

    immigration_status = 'C' AND vprs NOT in valid list (0,D,E)

    Type is EC

  • Validation Rule 273 is 'Syrian refugee but VPRS flag is invalid'

    Logic is:

    immigration_status = 'R' AND county_of_birth = 757 Syria AND vprs NOT in valid list (0,1)

    Type is EC

  • Validation Rule 274 is 'Refugee but VPRS/migrant scheme is invalid'

    Logic is:

    immigration_status = 'R' AND county_of_birth <> 757 AND vprs in (0,1,A,B,C,D,E)

    Type is EC

  • Validation Rule 275 is 'Asylum seeker but VPRS/migrant scheme is invalid'

    Logic is:

    immigration_status in (A) AND vprs in (0,1,A,B,C,D,E)

  • Validation Rule 276 is 'Neither an asylum seeker, migrant, nor a refugee but vprs/migrant scheme is invalid'

    Logic is:

    immigration_status in (N) AND vprs in (0,1,A,B,C,D,E)

    Type is EC

  • Validation Rule 277 is 'VPRS/migrant scheme but immigration status is null'

    Logic is:

    vprs in (0,1,A,B,C,D,E) AND immigration_status is null

    Type is EC

  • Validation Rule 339 is 'Course title contains "ESOL" and subject code not in Q374, Q375'

    Logic is:

    Course title contains "ESOL" and subject code not in Q374, Q375

    Type is W

  • Validation Rule 340 is 'Nationality/Country of Birth is invalid'

    Logic is:

    Country of birth not one of the active DD values and is not null

    Type is W

  • Validation Rule 341 is 'Nationality/Country of Birth is missing'

    Logic is:

    Country of birth is null

    Type is W

  • Validation Rule 342 is 'HECOS Code is missing'

    Logic is:

    LVL >= 4 and HECOS is null

    Type is EC

Validation Rule Changes

  • Rule 6 - Description changed to ‘Student Forename contains invalid characters’.

  • Rule 19- Removed ‘0’ and ‘06’ from valid list.

  • Rule 21- Removed ‘0’ from valid list.

  • Rule 23- Removed 00 and 09 from valid list.

  • Rule 81 - Added 73, 74, 75, 76, 77 to valid list.

  • Rule 84 - Added 73, 74, 75, 76, 77 to valid list

  • Rule 106 - Added ‘20’ (Level 2 Traineeship) to valid list and removed '1','2','3','4','5','6','7','8','9'.

  • Rule 138 - Changed from W to EC

  • Rule 174- Added 10, 11, 12, 13, 14to valid list and removed ‘1’.

  • Rule 310 - Added '20' to valid list.

  • Rule 318 - Removed '001' from valid list and added '806' and '808'.

  • Rule 319- Amend rule criteria to check value ‘01’ rather than ‘1’.

  • Rule 321 - Removed '99' from valid list.

  • Rule 329- Added '05' Apprenticeship to valid list.

  • Rule 330- Description updated to 'Programme Pathway Date null for Traineeship enrolments with Referral (04) or Apprenticeship (05)' and Added ‘05’ to valid list and removed '03'.

  • Rule 331- Amended rule criteria to give precedence to Student Type 97 over Course Type 97 and include STUDENT_MOA ‘01’.

  • Rule 332 - Validation set to inactive by default.

  • Rule 333 - Validation set to inactive by default.

  • Rule 334 - Amend rule criteria to match double digit codes in DD.

  • Rule 336- Removed ‘06', '07' & '98' from valid list and added '97'.