PL Chart 9 Digit: Difference between revisions

Revision as of 10:52, 2019 November 28

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.accdb. 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 Got this 9 digit chart error today. PTorres 11:37, 2019 August 22 (CDT) Sorry, just saw this; was it a true error, and if so, what was the Chart number that was causing it? Probably too late to figure out for this particular instance, but if it happens again, that info would be helpful. I just confirmed again that CCMDB.accdb should trap this error, so we would need to find out if there is something collectors do differently to let this through.

@@ Line 14: / Line 14: @@
 == Related articles ==
+** Still getting 9 digit chart number current admission.
+** HSC and GRA
+[[User:PTorres|PTorres]] 09:52, 2019 November 28 (CST)
 {{Related Articles}}