1. Home
  2. Validation rules
  3. R_67
Cross Record

R_67

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_67
Version 1
Status Active
Category Cross Record
Severity Error
Error message

The learner must not have more than one Learning Delivery Work Placement record with the same Work placement start date and Work placement employer identifier

Intent

This rule ensures that there is no overlapping work-placement records recorded for the learner

Guidance

Check there are no overlapping work-placement records in the ILR, the dates between the start and end date must not overlap with the same work-placement employment id

Description

There must not be more than one Learning Delivery Work Placement record with the same combination of Work placement start date and Work placement employer identifier

Detailed error condition
Detailed description

There must not be more than one Learning Delivery Work Placement record with the same combination of Work placement start date ( LearningDeliveryWorkPlacement.WorkPlaceStartDate ) and Work placement employer identifier ( LearningDeliveryWorkPlacement.WorkPlaceEmpd )

(error where There is more than one record for this learning aim with the same combination of LearningDeliveryWorkPlacement.WorkPlaceStartDate and LearningDeliveryWorkPlacement.WorkPlaceEmpd

Flow chart R67

Open flow chart in a new window

Flow chart details

Flowchart for 'R67' rule

1. Has a more than one work placement record been added to the ILR?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is there an overlap in Dates with the same work place employment record?

  • If 'No' then the rule is not triggered

  • If 'Yes' then the rule is triggered

Change summary

Version 1

The rule has been rolled over from the previous year

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDeliveryWorkPlacement.WorkPlaceStartDate

LearningDeliveryWorkPlacement.WorkPlaceEmpId

Need help understanding some of these terms?

View the validation rules glossary of terms