1. Home
  2. Validation rules
  3. OrigLearnStartDate_05
Learning delivery

OrigLearnStartDate_05

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name OrigLearnStartDate_05
Version 1
Status Deleted
Category Learning delivery
Severity N/A
Error message

The Learning aim reference is not valid in the LARS database for this Funding model on this Original learning start date

Intent

This rule ensures that the learning aim recorded with the original learning start date is valid in LARS

Guidance

Check the LARS database to ensure that the learning aim you have recorded is valid for apprenticeship funding on the original learning start date, if this aim is not available for that funding model then it must not be used.

Description

If the Original learning start date is returned and the aim is a component aim and the learning aim is part of a funded apprenticeship framework programme, then the Original learning start date must be between the validity start date and end date in the LARS database for this learning aim.

Detailed error condition
Detailed description

If the Original learning start date is returned (LearningDelivery.OrigLearnStartDate is known), and the aim is a component aim (LearningDelivery.AimType = 3) and the learning aim is part of a funded apprenticeship framework programme (DD07 = Y), then the Original learning start date must be between the validity start date and end date in the LARS database for this learning aim

(error where there is no record where LearningDelivery.OrigLearnStartDate is between LARS_StartDate and LARS_EndDate in the LARS_Validity table where (LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = APPRENTICESHIPS)

Exclusions

This rule is not triggered by apprenticeship standards (ProgType = 25)

Flow chart OrigLearnStartDate_05

Open flow chart in a new window

Flow chart details

Flowchart for ' OrigLearnStartDate_05 ' rule

1. Is the Learner enrolled on an Apprenticeship Framework?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has the Original learning start date been recorded?

  • If "No" rule is not triggered

  • If "Yes" then:

3. Is the validity of the component aim between the valid start and end date in LARS?

  • If "Yes" the the rule is not triggered

  • If "No" then the rule is triggered

Change summary

Version 1

This rule has been deleted

Status summary

Current SLD severity

N/A

Current FIS severity

N/A

Is this rule in FIS?

Yes

Field values

LearningDelivery.LearnAimRef

LearningDelivery.AimType

LearningDelivery.OrigLearnStartDate

LearningDelivery.FundModel

Need help understanding some of these terms?

View the validation rules glossary of terms