Centralized data front end.accdb Change Request: Difference between revisions

No edit summary
Line 21: Line 21:
3. If she can’t find a match, she assigns the next pseudo PHIN number in her booklet to that patient.   
3. If she can’t find a match, she assigns the next pseudo PHIN number in her booklet to that patient.   


Propose we integrate this with the "PHIN Blank" check we are working out as part of [[Query for centralized‎]]. If blank PHIN is found, check if the name/dob/chart match elsewhere. If so, use that PHIN. If not, find highest previous Pseudo-PHIN and assign x+1.  
Propose we integrate this with the "PHIN Blank" check we are working out as part of [[Centralized_data Vetting Process‎]]. If blank PHIN is found, check if the name/dob/chart match elsewhere. If so, use that PHIN. If not, find highest previous Pseudo-PHIN and assign x+1.  
This would mean that "blank PHIN" should be the first check applied so that all others don't trigger for this. Also, since the assignment of a new PHIN is a known and frequent process, this would likely benefit from automation. Any thoughts? Ttenbergen 12:45, 2014 January 13 (CST) {{discussion}}
This would mean that "blank PHIN" should be the first check applied so that all others don't trigger for this. Also, since the assignment of a new PHIN is a known and frequent process, this would likely benefit from automation. Any thoughts? Ttenbergen 12:45, 2014 January 13 (CST) {{discussion}}