Scribd
Upload
12 views1 page

Location Data Validation Checklist

Uploaded by

abhijitp
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views1 page

Location Data Validation Checklist

Uploaded by

abhijitp
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Check Category

ValidationStatus
Rule (Pass/Fail)
Comments
MandatoryLocation Code should not be blank
MandatoryLocation Name and Country must be provided
Duplicates Check for duplicate Location Codes
Duplicates Check for inconsistent naming conventions (NY vs New York)
Address DaCountry/State codes must match ISO standards
Address DaPostal Code must be in valid format
Address DaAddress Line 1 should not exceed Oracle field length
Address DaCheck for invalid/special characters in address fields
Effective DEffective Dates should not overlap
Effective DNo future-dated locations unless required
Effective DInactive locations should be flagged
Mapping &Ensure Location hierarchy matches Oracle requirements
Mapping &Timezone/Geocode values must be valid and standardized
Data Quali Correct typographical errors in names/addresses
Data Quali Ensure locations are linked to active Business Units/Departments

You might also like