Pat ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
m m
Line 12: Line 12:
}}
}}


Pat_ID is used in [[CCMDB.mdb]]. In [[CFE]] / [[Centralized_data.mdb]], [[D_ID]] is the equivalent. [[D_ID]] is the combination of the [[SErvice/Location]] and the [[Pat_ID]].
Pat_ID is used in [[CCMDB.mdb]]. In [[CFE]] / [[Centralized_data.mdb]], [[D_ID]] is the equivalent. [[D_ID]] is the combination of the [[Service/Location]] and the [[Pat_ID]].
 
== Tables ==
Used by [[Centralized_data.mdb]].
* [[InTable::L_Log]]
* [[InTable::L_Dxs]]
* [[InTable::L_Como]]
* [[InTable::L_TmpV2]]
* [[InTable::L_Labs_Flowsheet]]
* [[InTable::L_Labs_Flowsheet_DSM]]
* [[InTable::L_Pharm_Flowsheet]]
 
[[Category: L_Log]]
[[Category: L_Dxs]]
[[Category: L_Como]]
[[Category: L_TmpV2 table]]
[[Category: L_Labs_Flowsheet]]
[[Category: L_Labs_Flowsheet_DSM]]
[[Category: L_Pharm_Flowsheet]]

Revision as of 18:15, 6 February 2017

Data Element (edit)
Field Name: Pat_ID
CCMDB Label: Serial
CCMDB tab: Top Row
Table: L_Log
Data type: number
Length: Long Integer
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 1
Data Dependencies(Reports/Indicators/Data Elements): No results

The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See Serial number.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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

Tables

Used by Centralized_data.mdb.