Person ID field: Difference between revisions
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) mNo edit summary |
||
| 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 | |||
|data_type=number | |||
|datafield_length=long integer | |||
|program_collecting=Med and CC | |||
|created_raw=Created | |||
|data_element_sort_index=1 | |data_element_sort_index=1 | ||
|element_description=Unique id per patient that combines the [[D_ID]]s across admissions/encounters. | |element_description=Unique id per patient that combines the [[D_ID]]s across admissions/encounters. | ||
}} | }} | ||
A random number generated by Access when a new line is added. | A random number generated by Access when a new line is added. | ||
Revision as of 12:09, 18 September 2017
| Data Element (edit) | |
| Field Name: | Person_ID |
| CCMDB Label: | N/A |
| CCMDB tab: | not stated |
| 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: |
|