Cross Record

R_142

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	R_142
Version	1
Status	Active
Category	Cross Record
Severity	Error
Error message	The Total Negotiated Price Record must not be on or after the learning start date of an open programme aim where the learner has previously withdrawn.
Intent	This rule ensures that the total negotiated price has been returned correctly
Guidance	Ensure that the total negotiated price on the withdrawn programme aim is not before the start of the open programme, it is important to check that the correct TNP records are correct and allocated to the correct programme ensuring dates match
Description	For open apprenticeship standard programmes started on or after 1 August 2022 where the learner has previously withdrawn or temporarily withdrawn due to an agreed break in learning the apprenticeship financial record date for a total negotiated price record on that withdrawn programme aim must not be on or after the learning start date of an open programme aim.

Detailed error condition
Detailed description	For open apprenticeship standard programmes started on or after 1 August 2022 where the learner has previously withdrawn ( LearningDelivery.CompStatus =3) or temporarily withdrawn due to an agreed break in learning ( LearningDelivery.CompStatus = 6) the apprenticeship financial record date for a total negotiated price record on that withdrawn programme aim must not be on or after the learning start date of an open programme aim. Where there is an open apprenticeship standard programme aim LearningDelivery.LearnStartDate >= 2022-08-01 and LearningDelivery.AimType = 1 and LearningDelivery.ProgType = 25 And LearningDelivery.LearnActEndDate is not returned and there is a closed apprenticeship standard programme aim AimType = 1 And LearningDelivery.ProgType = 25 and LearningDelivery.CompStatus = 3 or 6 and AppFinRecord.AFinType = TNP and AppFinRecord.AFinDate on the closed programme aim is >= the LearningDelivery.LearnStartDate of the open programme aim
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'R142' rule 1. Has an apprentice returned from a break in learning or restarted after a withdrawal? If 'No' then the rule is not triggered If 'Yes' then: 2. Has a TNP record been added to the withdrawn programme? If 'No' then the rule is not triggered If 'Yes' then: 3. Does the TNP date on the withdrawn programme aim overlap with the start date of the new programme? If 'No' then the rule is not triggered If 'Yes' then 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	LearningDelivery.AimType LearningDelivery.ProgType LearningDelivery.CompStatus LearningDelivery.AchDate LearningDelivery.LearnAimRef LearningDelivery.LearnActEndDate

Need help understanding some of these terms?

View the validation rules glossary of terms