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

R_43

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The learner must not have more than one Learner Employment status record with the same Date employment status applies

Intent

This rule ensures that the learner is not recorded with more than one employment status on the same date.

Guidance

Check the date recorded on the employment status records and ensure they are not on the same date, one must be dated after the other to pass validation.

Description

A learner must not have more than one Learner Employment Status record with the same Date employment status applies.

Detailed error condition
Detailed description

A learner must not have more than one Learner Employment Status record with the same Date employment status applies.

(error where there is more than one record for the learner with the same LearnerEmploymentStatus.DateEmpStatApp )

Flow chart R43

Open flow chart in a new window

Flow chart details

Flowchart for 'R43' rule

1. Has more than one employment status record been returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is there duplicate date applies across the returned records?

  • 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

LearnerEmploymentStatus.DateEmpStatApp

Need help understanding some of these terms?

View the validation rules glossary of terms