Person ID field: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m L_Log too |
||
| Line 2: | Line 2: | ||
|field_name=Person_ID | |field_name=Person_ID | ||
|CCMDB_label=N/A | |CCMDB_label=N/A | ||
|in_table=L Person table | |in_table=L Log table, L Person table | ||
|data_type=number | |data_type=number | ||
|datafield_length=long integer | |datafield_length=long integer | ||
Revision as of 12:23, 18 September 2017
| 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 |
| Data Dependencies(Reports/Indicators/Data Elements): | |
Unique id per patient that combines the D_IDs across admissions/encounters.
A random number generated by Access when a new line is added.
It would be permanently stored and therefore remain the same for new encounters of that patient in L_Log/L_PHI, but if an L_Person record were ever deleted and recreated it would NOT receive the same ID next time around.
The Person_ID field in Centralized_data.mdb's L_Person table contains a unique id per patient that combines the D_IDs across admissions.
Template:Discussion The L_Person table, it doesn't have a D_ID. It seems to be populated, though: the last_update column's dates are recent. I think we may have abandoned this process in mid-build. Do we need to discuss? Ttenbergen 12:10, 2017 September 18 (CDT)
Related articles
| Related articles: |
|