D ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "L Pharm Flowsheet" to "L_Pharm_Flowsheet table"
m Text replacement - "L_Pharm_Flowsheet" to "L_Pharm_Flowsheet table"
Line 2: Line 2:
|field_name=D_ID
|field_name=D_ID
|Rank=N/A
|Rank=N/A
|in_table=L CCI table, L Como table, L Dxs table, L ICD10 table, L Labs DSM table, L_Labs_Flowsheet table table, L Log table, L PCH, L PHI table, L_Pharm_Flowsheet table table, L TISS Form table, L TISS Item table, L TmpV2 table
|in_table=L CCI table, L Como table, L Dxs table, L ICD10 table, L Labs DSM table, L_Labs_Flowsheet table table, L Log table, L PCH, L PHI table, L_Pharm_Flowsheet table table table, L TISS Form table, L TISS Item table, L TmpV2 table
|data_type=string
|data_type=string
|datafield_length=18
|datafield_length=18
Line 24: Line 24:
[[Category: L_TmpV2 table]]
[[Category: L_TmpV2 table]]
[[Category: L_Labs_Flowsheet table table]]
[[Category: L_Labs_Flowsheet table table]]
[[Category: L_Pharm_Flowsheet]]
[[Category: L_Pharm_Flowsheet table]]

Revision as of 16:57, 2017 November 29

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 table, L Log table, L PCH, L PHI table, L_Pharm_Flowsheet table table table, L TISS Form table, L TISS Item table, L TmpV2 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.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

Related Articles

Related articles: