PL Chart 9 Digit: Difference between revisions

Latest revision as of 22:13, 22 July 2025

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:	No
Status:	implemented
Implementation Date:	not entered
Backlogged:	No

@@ Line 5: / Line 5: @@
 |DIC_coding=query ''PL Chart 9 Digit''
 |DIC_status=implemented
+|DIC_LProblem=No
 |DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
 }}
+== Related articles ==
-{{Discuss | who = Pagasa | question = * [[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. [[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.accdb 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}}