PL 2Phin Fake or Blank

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Finds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.
Related: PHIN field
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query PL_2Phin_Fake_or_Blank
Uses L Problem table: no
Status: implemented
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

"cannot open any more tables" in Access

See "cannot open any more tables" in Access

Can't limit this to RecordStatus completes/sent

This query is used for Generating PseudoPHINs. One requirement there is to make sure that no PHINs are currently < 100000000, even incompletes, since having one of those would mess up our incrementing for PseudoPHINs. So, this query needs to include incompletes, even if they won't usually need to be acted on.

Related articles

Related articles: