D ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m catfix
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
 
(20 intermediate revisions by 2 users not shown)
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.
|Rank=N/A
| in_table =  
|in_table=L_CCI_Picklist table, L_CCI_Component table, L_Como table, L_Dxs table, L_ICD10 table, L_Labs_DSM table, L_Labs_Flowsheet table , L_Log table, L_PCH table, L_PHI table , L_Pharm_Flowsheet table, L_TISS_Form table, L_TISS_Item table, L_TmpV2 table, L_TISS76 table
| data_type = string
|data_type=string
| datafield_length = 18
|datafield_length=18
| program_collecting = Med and CC
|program_collecting=Med and CC
| created_raw = Raw
|created_raw=Raw
| data_element_sort_index = 1
|data_element_sort_index=1
|element_description=The unique identifier/index of records in the Critical Care and Medicine Database.
}}
}}
D_ID is used in [[CFE]]/[[Centralized_data.mdb]]. In [[CCMDB.accdb]] / [[CCMDB_data.mdb]], [[Pat_ID]] is the equivalent. [[D_ID]] is the combination of the [[Service/Location]] and the [[Pat_ID]].


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]].
== Changing D_IDs ==
[[Changing D_IDs]]


== Tables ==
== Related Articles ==
Used by [[Centralized_data.mdb]].
{{Related Articles}}
* [[InTable::L_PHI]]
* [[InTable::L_Log]]
* [[InTable::L_Dxs]]
* [[InTable::L_Como]]
* [[InTable::L_TmpV2]]
* [[InTable::L_Labs_Flowsheet]]
* [[InTable::L_Labs_DSM]]
* [[InTable::L_Pharm_Flowsheet]]
 
[[Category: L_Log]]
[[Category: L_PHI]]
[[Category: L_Dxs]]
[[Category: L_Como]]
[[Category: L_TmpV2 table]]
[[Category: L_Labs_Flowsheet]]
[[Category: L_Pharm_Flowsheet]]

Latest revision as of 10:45, 2019 September 22

Data Element (edit)
Field Name: D_ID
CCMDB Label: not stated
CCMDB tab: not stated
Table: L_CCI_Picklist table, L_CCI_Component table, L_Como table, L_Dxs table, L_ICD10 table, L_Labs_DSM table, L_Labs_Flowsheet table, L_Log table, L_PCH table, L_PHI table, L_Pharm_Flowsheet table, L_TISS_Form table, L_TISS_Item table, L_TmpV2 table, L_TISS76 table
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.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


D_ID is used in CFE/Centralized_data.mdb. In CCMDB.accdb / CCMDB_data.mdb, Pat_ID is the equivalent. D_ID is the combination of the Service/Location and the Pat_ID.

Changing D_IDs

Changing D_IDs

Related Articles

Related articles: