Pat ID field: Difference between revisions

Revision as of 17:45, 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, 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.

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_Log
+| in_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
 | datafield_length = Long Integer
@@ Line 15: / Line 15: @@
 == Tables ==
-Used by [[Centralized_data.mdb]].
+* Used by [[CCMDB.mdb]], where it is the primary identifier.
-* [[InTable::L_Log]]
+* Used by [[Centralized_data.mdb]], where it is only kept in [[L_Log table]] for reference.
-* [[InTable::L_Dxs]]
-* [[InTable::L_Como]]
-* [[InTable::L_TmpV2]]
-* [[InTable::L_Labs_Flowsheet]]
-* [[InTable::L_Pharm_Flowsheet]]
-[[Category: L_Log]]
 [[Category: L_Dxs]]
-[[Category: L_Como]]
 [[Category: L_TmpV2 table]]
 [[Category: L_Labs_Flowsheet]]
 [[Category: L_Pharm_Flowsheet]]