D ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m cat
m m
Line 1: Line 1:
<onlyinclude>The [[D_ID field]] is the unique identifier/index of records in the Critical Care and Medicine Database. </onlyinclude>
{{Data_element
| field_name = D_ID
| element_description = The unique identifier/index of records in the Critical Care and Medicine Database.
| in_table =
| data_type = string
| datafield_length = 18
| program_collecting = Med and CC
| created_raw = Raw
| data_element_sort_index = 1
}}


== Location ==
In [[CCMDB.mdb]] / [[CCMDB_data.mdb]], [[Pat_ID]] is the equivalent.
* table [[L_Log]] in [[CCMDB.mdb]] and [[Centralized_data.mdb]]
* table [[1Main]] in [[MCHP Export.mdb]]


[[Category: L_Log table]]
== Tables ==
[[Category: 1Main table]]
Used by [[Centralized_data.mdb]].
* [[InTable::L_PHI]]
* [[InTable::L_Log]]
* [[InTable::L_Diag]]
* [[InTable::L_Como]]
* [[InTable::L_TmpV2]]
* [[InTable::L_Labs_Flowsheet]]
* [[InTable::L_Pharm_Flowsheet]]
* [[InTable::L_Labs_DSM]]
 
 
 
[[Category: L_Log]]

Revision as of 17:01, 2017 February 6

Data Element (edit)
Field Name: D_ID
CCMDB Label: not stated
CCMDB tab: not stated
Table: N/A
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


In CCMDB.mdb / CCMDB_data.mdb, Pat_ID is the equivalent.

Tables

Used by Centralized_data.mdb.