Generating PseudoPHINs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m u |
Ttenbergen (talk | contribs) |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
== Instructions == | == Instructions == | ||
* run query '' | * run query ''[[PL_2Phin Fake or Blank]]'' to find patients without a PHIN | ||
* check if any of the patients on the list has a PHIN < 100000000; if so, correct that PHIN before proceeding since this PHIN would interfere with generating new PseudoPHINs (new # would be that bad PHIN + 1) | |||
* for each patient on the list, | * for each patient on the list, | ||
** click the | ** click the [[Cat button]] to bring up possible matches for that patient if he/she has been encountered before | ||
** if one of these matches the patient | ** if one of these matches the patient | ||
*** copy (ctrl-c) the PHIN | *** copy (ctrl-c) the PHIN | ||
*** open the patient's record | *** open the patient's record | ||
*** paste (ctrl-v) the PHIN into the PHIN field | *** paste (ctrl-v) the PHIN into the PHIN field | ||
** if none matches the patient | ** if none matches the patient generate a new [[PseudoPHIN]]: | ||
*** open the patient | |||
*** | *** click the '''pseudo''' button to the left of the PHIN field label | ||
*** | *** the program will look up the highest previous PseudoPHIN and enter that + 1 into the PHIN field | ||
*** | |||
=== [["cannot open any more tables" in Access]] === | |||
See [["cannot open any more tables" in Access]] | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Data Processing]] | [[Category:Data Processing]] | ||
[[Category:PL queries]] | [[Category:PL queries]] | ||
Latest revision as of 12:13, 7 December 2022
This article describes how the Data Processor generates PseudoPHINs.
Instructions
- run query PL_2Phin Fake or Blank to find patients without a PHIN
- check if any of the patients on the list has a PHIN < 100000000; if so, correct that PHIN before proceeding since this PHIN would interfere with generating new PseudoPHINs (new # would be that bad PHIN + 1)
- for each patient on the list,
- click the Cat button to bring up possible matches for that patient if he/she has been encountered before
- if one of these matches the patient
- copy (ctrl-c) the PHIN
- open the patient's record
- paste (ctrl-v) the PHIN into the PHIN field
- if none matches the patient generate a new PseudoPHIN:
- open the patient
- click the pseudo button to the left of the PHIN field label
- the program will look up the highest previous PseudoPHIN and enter that + 1 into the PHIN field
"cannot open any more tables" in Access
See "cannot open any more tables" in Access