PL Chart 9 Digit: Difference between revisions

Revision as of 10:44, 16 September 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 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.mdb should trap this error, so we would need to find out if there is something collectors do differently to let this through.

@@ Line 9: / Line 9: @@
 {{Discuss | who = Pagasa | question = * [[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]]'''}}
+** 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.
+* Got this 9 digit chart error today. [[User:PTorres|PTorres]] 11:37, 2019 August 22 (CDT)
-[[User:PTorres|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.mdb should trap this error, so we would need to find out if there is something collectors do differently to let this through.}}
 == Related articles ==
 {{Related Articles}}