Learning delivery

CompStatus_01

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	CompStatus_01
Version	1
Status	Active
Category	Learning delivery
Severity	Error
Error message	The Completion status is not a valid code
Intent	To ensure that, where a Completion status is returned, it is a valid code
Guidance	Ensure that, where a Completion status is returned, it is a valid lookup in the ILR CompStatus table
Description	The Completion status must be a valid lookup on ILR_CompStatus

Detailed error condition

Detailed description	The Completion status must be a valid lookup ( LearningDelivery.CompStatus is a valid lookup on ILR_CompStatus) (error where LearningDelivery.CompStatus <> valid lookup on ILR_CompStatus)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'CompStatus_01' rule 1. Is an aim Completion status returned? If 'No' then the rule is not triggered If 'Yes' then: 2. Is the Completion status a valid lookup in the ILR CompStatus table? If 'No' then the rule is triggered If 'Yes' then the rule is not 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.CompStatus

Need help understanding some of these terms?

View the validation rules glossary of terms