Pat ID field

From CCMDB Wiki
Revision as of 19:52, 8 February 2017 by Ttenbergen (talk | contribs) (not in DSM)
Jump to navigation Jump to search
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.