Pat ID field: Difference between revisions
Jump to navigation
Jump to search
m (Text replacement - "L_Labs_Flowsheet" to "L_Labs_Flowsheet table") |
m (Text replacement - "L_Labs_Flowsheet" to "L_Labs_Flowsheet table") |
||
Line 21: | Line 21: | ||
[[Category: L_Dxs table]] | [[Category: L_Dxs table]] | ||
[[Category: L_TmpV2 table]] | [[Category: L_TmpV2 table]] | ||
[[Category: L_Labs_Flowsheet table]] | [[Category: L_Labs_Flowsheet table table]] | ||
[[Category: L_Pharm_Flowsheet]] | [[Category: L_Pharm_Flowsheet]] |
Revision as of 17:54, 2017 November 29
Data Element (edit) | |
Field Name: | Pat_ID |
CCMDB Label: | Serial |
CCMDB tab: | Top Row |
Table: | L CCI table, L Como table, L Dxs table, L ICD10 table, L Labs Flowsheet table, L Log table, L PCH table, L PHI table, L Pharm Flowsheet table, L TISS Form table, L TISS Item table, L TmpV2 table |
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 |
The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See Serial number.
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 CCMDB.mdb, where it is the primary identifier.
- Used by Centralized_data.mdb, where it is only kept in L_Log table for reference.