Person ID field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 11: | Line 11: | ||
}} | }} | ||
See [[Generate Person IDs]] and [[Correcting Person IDs]] for how Person_IDs are generated and maintained. A new line is generated in [[L_Person table]], and the Person_ID is | See [[Generate Person IDs]] and [[Correcting Person IDs]] for how Person_IDs are generated and maintained. A new line is generated in [[L_Person table]], and the Person_ID is assigned to [[Centralized data.mdb]].[[L_Log table]].Person_ID . | ||
For the most part, Person_ID is permanently stored and therefore remains the same for new encounters of that patient in [[L_Log table]]/[[L_Person table]]. | For the most part, Person_ID is permanently stored and therefore remains the same for new encounters of that patient in [[L_Log table]]/[[L_Person table]]. |
Revision as of 14:42, 2018 November 7
Data Element (edit) | |
Field Name: | Person_ID |
CCMDB Label: | N/A |
CCMDB tab: | not stated |
Table: | L Log table, L Person table |
Data type: | number |
Length: | long integer |
Program: | Med and CC |
Created/Raw: | Created |
Start Date: | 1988-07-11 |
End Date: | 2300-01-01 |
Sort Index: | 1 |
Unique random number id per patient that combines the D_IDs across admissions/encounters.
See Generate Person IDs and Correcting Person IDs for how Person_IDs are generated and maintained. A new line is generated in L_Person table, and the Person_ID is assigned to Centralized data.mdb.L_Log table.Person_ID .
For the most part, Person_ID is permanently stored and therefore remains the same for new encounters of that patient in L_Log table/L_Person table.
If an L_Person record were ever deleted and recreated it would NEVER receive the same Person_ID next time around. See Generate Person IDs and Correcting Person IDs for how Person_IDs are generated and updated for more info on scenarios that might cause a Patient_ID to change.
Related articles
Related articles: |
|