PL 2Phin Fake or Blank
| 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 |
"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: |