D ID field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m m |
||
Line 2: | Line 2: | ||
| field_name = D_ID | | field_name = D_ID | ||
| element_description = The unique identifier/index of records in the Critical Care and Medicine Database. | | element_description = The unique identifier/index of records in the Critical Care and Medicine Database. | ||
| in_table = | | in_table = L_Log, L_Dxs, L_Como | ||
| data_type = string | | data_type = string | ||
| datafield_length = 18 | | datafield_length = 18 |
Revision as of 21:26, 2017 September 16
Data Element (edit) | |
Field Name: | D_ID |
CCMDB Label: | not stated |
CCMDB tab: | not stated |
Table: | L_Log, L_Dxs, L_Como |
Data type: | string |
Length: | 18 |
Program: | Med and CC |
Created/Raw: | Raw |
Start Date: | 1988-07-11 |
End Date: | 2300-01-01 |
Sort Index: | 1 |
The unique identifier/index of records in the Critical Care and Medicine Database.
D_ID is used in CFE/Centralized_data.mdb. In CCMDB.mdb / CCMDB_data.mdb, Pat_ID is the equivalent. D_ID is the combination of the Service/Location and the Pat_ID.
Tables
Used by Centralized_data.mdb.