Pat ID field: Difference between revisions

Revision as of 17:57, 29 November 2017

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

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.

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.

@@ Line 4: / Line 4: @@
 | CCMDB_tab = Top Row
 | element_description = The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See [[Serial number]].
-| in_table = L CCI table, L Como table, L Dxs table, L ICD10 table, L_Labs_Flowsheet table table, L Log table, L PCH table, 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_Flowsheet table table, L Log table, L PCH table, L PHI table, L_Pharm_Flowsheet table table table, L TISS Form table, L TISS Item table, L TmpV2 table
 | data_type = number
 | datafield_length = Long Integer
@@ Line 22: / Line 22: @@
 [[Category: L_TmpV2 table]]
 [[Category: L_Labs_Flowsheet table table]]
-[[Category: L_Pharm_Flowsheet]]
+[[Category: L_Pharm_Flowsheet table]]