PL Chart 9 Digit: Difference between revisions

Revision as of 08:34, 7 February 2019

Data Integrity Checks
Summary:	Finds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart number
Related:	Chart number
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query PL Chart 9 Digit
Uses L Problem table:	not entered
Status:	implemented
Implementation Date:	not entered
Backlogged:	true

	Function Validate Chart should capture all of these in CCMDB.mdb. Emailed Pagasa to find out if she ever actually finds any in here. If she does we need to fix Function Validate Chart, if she doesn't she could stop running this check. I did end up checking Function Validate Chart 2018-11-24 to confirm that the check >8 digits is being run. If there are others problems that slip through please log them as DT at Function Validate Chart

@@ Line 15: / Line 15: @@
 [[Category:Registry checks]]
+[[Category:PL queries]]
+[[Category:Data Processing]]