Scribd
Upload
6 views1 page

Department 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
6 views1 page

Department 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

Check Category

ValidationStatus
Rule (Pass/Fail)
Comments
MandatoryDepartment ID/Code must not be blank
MandatoryDepartment Name and Business Unit must be provided
Duplicates Check for duplicate Department Codes
Duplicates Check for inconsistent naming conventions (HR vs Human Resources)
Effective DEffective Dates should not overlap
Effective DNo future-dated departments unless required
Effective DInactive departments should be flagged
Hierarchy Ensure Department hierarchy is properly mapped (parent-child)
Hierarchy Department should be linked to valid Business Unit / Cost Center
Mapping Department code length should not exceed Oracle limits
Mapping Ensure mapping of Departments to Business Unit/Legal Entity is valid
Data Quali Correct typographical errors in department names
Data Quali Check for orphan departments not linked to any parent
Data Quali Ensure inactive or obsolete departments are not migrated unnecessarily

You might also like