D ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 14: Line 14:
== Tables ==
== Tables ==
Used by [[Centralized_data.mdb]].
Used by [[Centralized_data.mdb]].
* [[InTable::L_PHI]]
* [[InTable::L_Log]]
* [[InTable::L_Dxs]]
* [[InTable::L_ICD10]]
* [[InTable::L_CCI]]
* [[InTable::L_Como]]
* [[InTable::L_TmpV2]]
* [[InTable::L_Labs_Flowsheet]]
* [[InTable::L_Labs_DSM]]
* [[InTable::L_Pharm_Flowsheet]]


[[Category: L_Log]]
[[Category: L_Log]]

Revision as of 22:31, 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: text"text" is not in the list (number, integer, long, boolean, string, memo, date, not entered) of allowed values for the "FieldDataType" property.
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.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.