Pat ID field: Difference between revisions

(6 intermediate revisions by the same user not shown)

Line 3:

| CCMDB_label = Serial

| CCMDB_tab = Top Row

~~| CCMDB_tab = Lab~~

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

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

| 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

Line 13:

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 [[CCMDB.~~mdb~~]], where it is the primary identifier.

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

* Used by [[Centralized_data.~~mdb~~]], where it is only kept in [[L_Log table]] for reference.

* Used by [[Centralized_data.accdb]], where it is only kept in [[L_Log table]] for reference.

== Related Articles ==

@@ Line 3: / Line 3: @@
 | CCMDB_label = Serial
 | CCMDB_tab = Top Row
-| CCMDB_tab = Lab
+| element_description = The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]].
-| element_description = The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See [[Serial number]].
 | 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
@@ Line 13: / 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 [[CCMDB.mdb]], where it is the primary identifier.
+* Used by [[CCMDB.accdb]], where it is the primary identifier.
-* Used by [[Centralized_data.mdb]], where it is only kept in [[L_Log table]] for reference.
+* Used by [[Centralized_data.accdb]], where it is only kept in [[L_Log table]] for reference.
 == Related Articles ==
 {{Related Articles}}