Generate Person IDs

"Generate Person IDs" is the step during Centralized data Vetting Process by which unique Person IDs are generated in L Person table and associated with the ward-admission records in centralized_data.mdb. It also refers to the button "Generate Person IDs" in CFE.

Related to Encounter processing and L Person table.

Instructions

At the right point in Centralized data Vetting Process (and only then):

1. click the 'generate person IDs'
2. screen prompt 'done generating...', click OK
3. email the Statistician that all data is completed, corrected and vetted.

Proceed as instructed in Centralized data Vetting Process.

Correcting Person_IDs

see Correcting Person IDs

Consistency of Person_ID over time

See Person ID field#Consistency of Person_ID over time

Algorithm summary

collapsed so it doesn't look like steps the Data processor needs to do.

see encounter_processing module Sub Encounter_processor() for most current implementation clean out inconsistent data delete Person_IDs in L_Log where the Person_ID corresponds to more than one PHIN delete Person_IDs in L_Log for which no L_Person table entry exists delete records in L_Person table that have no counterpart in L_Log for each L_Log entry for which Person_ID is blank and recordstatus is not "incomplete" if a record matching PHIN doesn't exist in L_Person table generate record in L_Person table (set death to discharge date if deceased) update L_Log.Person_ID to that new record's Person_ID set L_Person table .last_updated to now if a record matching PHIN does exist in L_Person table add Person_ID to L_Log table update last_updated and death in L_Person table

We don't have process to populate L_Hospitalization worked out yet.

• SMW

• Cargo

• Categories