PL 2Phin Fake or Blank: Difference between revisions

mNo edit summary
m Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No"
 
(2 intermediate revisions by 2 users not shown)
Line 5: Line 5:
|DIC_coding=query ''PL_2Phin_Fake_or_Blank''
|DIC_coding=query ''PL_2Phin_Fake_or_Blank''
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=No
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_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 ===
=== 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.  
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.