Pat ID field: Difference between revisions

(19 intermediate revisions by 2 users not shown)

Line 3:

| CCMDB_label = Serial

| CCMDB_tab = Top Row

| element_description = The Pat_ID field contains a unique-per-~~location~~ identifying number ~~per~~ patient ward ~~admission~~. See [[Serial number]].

| element_description = The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]].

| in_table = ~~L_Log~~

| in_table = L_CCI_Picklist table, L_CCI_Component 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 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.accdb]]. In [[CFE]] / [[Centralized_data.accdb]], [[D_ID]] is the equivalent. [[D_ID]] is the combination of the [[Service/Location]] and the [[Pat_ID]].

== Tables ==

Used by [[~~Centralized_data~~.~~mdb~~]].

* Used by [[CCMDB.accdb]], where it is the primary identifier.

* [[~~InTable::L_Log]]~~

* Used by [[Centralized_data.accdb]], 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]]~~

== Related Articles ==

~~[[Category: L_Dxs]]~~

~~[[Category: L_Como]]~~

~~[[Category: L_TmpV2 table]]~~

~~[[Category: L_Labs_Flowsheet]]~~

~~[[Category: L_Pharm_Flowsheet]]~~

@@ Line 3: / Line 3: @@
 | CCMDB_label = Serial
 | CCMDB_tab = Top Row
-| element_description = The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See [[Serial number]].
+| element_description = The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]].
-| in_table = L_Log
+| in_table = L_CCI_Picklist table, L_CCI_Component 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 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.accdb]]. In [[CFE]] / [[Centralized_data.accdb]], [[D_ID]] is the equivalent. [[D_ID]] is the combination of the [[Service/Location]] and the [[Pat_ID]].
 == Tables ==
-Used by [[Centralized_data.mdb]].
+* Used by [[CCMDB.accdb]], where it is the primary identifier.
-* [[InTable::L_Log]]
+* Used by [[Centralized_data.accdb]], 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]]
+== Related Articles ==
-[[Category: L_Dxs]]
+{{Related Articles}}
-[[Category: L_Como]]
-[[Category: L_TmpV2 table]]
-[[Category: L_Labs_Flowsheet]]
-[[Category: L_Pharm_Flowsheet]]