D ID field: Difference between revisions

Revision as of 22:30, 2017 September 16

Data Element (edit)
Field Name:	D_ID
CCMDB Label:	not stated
CCMDB tab:	not stated
Table:	L CCI table, L Como table, L Dxs table, L ICD10 table, L Labs DSM table, L Labs Flowsheet table, L Log table, L PCH, L PHI table, L Person, L Pharm Flowsheet table, L TISS Form table, L TISS Item table, L TmpV2 table
Data type:	not entered
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.

@@ Line 1: / Line 1: @@
-{{Data_element
+{{Data element
-| field_name = D_ID
+|field_name=D_ID
-| element_description = The unique identifier/index of records in the Critical Care and Medicine Database.
+|in_table=L CCI table, L Como table, L Dxs table, L ICD10 table, L Labs DSM table, L Labs Flowsheet table, L Log table, L PCH, L PHI table, L Person, L Pharm Flowsheet table, L TISS Form table, L TISS Item table, L TmpV2 table
-| in_table = L_Log, L_Dxs, L_Como
+|datafield_length=18
-| data_type = string
+|program_collecting=Med and CC
-| datafield_length = 18
+|created_raw=Raw
-| program_collecting = Med and CC
+|data_element_sort_index=1
-| created_raw = Raw
+|element_description=The unique identifier/index of records in the Critical Care and Medicine Database.
-| data_element_sort_index = 1
 }}
 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]].