PL 2Phin Fake or Blank: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "{{DT" to "{{TT") |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 7: | Line 7: | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
}} | }} | ||
. | |||
=== 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 [[PseudoPHIN]]s. So, this query needs to include incompletes, even if they won't ''usually'' need to be acted on. | |||
== Related articles == | == Related articles == | ||
Revision as of 15:35, 2021 July 15
| 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: | not entered |
| Status: | ready to implement |
| Implementation Date: | not entered |
| Backlogged: | true |
.
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: |