D ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
m m
Line 2: Line 2:
| field_name = D_ID
| field_name = D_ID
| element_description = The unique identifier/index of records in the Critical Care and Medicine Database.
| element_description = The unique identifier/index of records in the Critical Care and Medicine Database.
| in_table =  
| in_table = L_Log, L_Dxs, L_Como
| data_type = string
| data_type = string
| datafield_length = 18
| datafield_length = 18

Revision as of 21:26, 2017 September 16

Data Element (edit)
Field Name: D_ID
CCMDB Label: not stated
CCMDB tab: not stated
Table: L_Log, L_Dxs, L_Como
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.

Tables

Used by Centralized_data.mdb.