Learning delivery

DelLocPostCode_03

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	DelLocPostCode_03
Version	1
Status	Active
Category	Learning delivery
Severity	Warning
Error message	The Delivery location postcode is not valid
Intent	This rule ensures that the delivery location postcode is a valid postcode on the lookup table
Guidance	Check the delivery location postcode is valid on the ONS postcode checker and is recorded in the correct format
Description	The Delivery location postcode should be either a valid postcode on the list of complete UK postcodes table or ZZ99 9ZZ

Detailed error condition

Detailed description	The Delivery location postcode ( LearningDelivery.DelLocPostCode ) should be either a valid postcode on the list of complete UK postcodes table (Postcodes.PostcodeValidity) or ZZ99 9ZZ (error where LearningDelivery.DelLocPostCode <> valid lookup on Postcodes.PostcodeValidity or <> ZZ99 9ZZ)
Exclusions	This rule is not triggered by OLASS funded aims ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 034)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'DelLocPostCode_03' rule 1. Is the learner recorded as OLASS? If 'Yes' then the rule is not triggered If 'No' then: 2. Has the Delivery location postcode been returned? If 'No' then the rule is not triggered If 'Yes' then: 3. Is the postcode valid or ZZ99 9ZZ? If 'Yes' then the rule is not triggered If 'No' then the rule is triggered

Change summary

Version 1	The rule has been rolled over from the previous year

Status summary

Current SLD severity	Warning
Current FIS severity	N/A
Is this rule in FIS?	No
Field values	LearningDelivery.DelLocPostCode LearningDeliveryFAM.LearnDelFAMType LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms