Pat ID field: Difference between revisions
Jump to navigation
Jump to search
m (Text replacement - "L_Labs_Flowsheet" to "L_Labs_Flowsheet table") |
Ttenbergen (talk | contribs) mNo edit summary |
||
(13 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
| CCMDB_label = Serial | | CCMDB_label = Serial | ||
| CCMDB_tab = Top Row | | CCMDB_tab = Top Row | ||
| element_description = The Pat_ID field contains a unique-per- | | element_description = The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]]. | ||
| in_table = | | 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 | | data_type = number | ||
| datafield_length = Long Integer | | datafield_length = Long Integer | ||
Line 12: | Line 12: | ||
}} | }} | ||
Pat_ID is used in [[CCMDB. | Pat_ID is used in [[CCMDB.accdb]]. In [[CFE]] / [[Centralized_data.mdb]], [[D_ID]] is the equivalent. [[D_ID]] is the combination of the [[Service/Location]] and the [[Pat_ID]]. | ||
== Tables == | == Tables == | ||
* Used by [[CCMDB. | * 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.mdb]], where it is only kept in [[L_Log table]] for reference. | ||
== Related Articles == | |||
{{Related Articles}} | |||
Latest revision as of 09:37, 2020 July 24
Data Element (edit) | |
Field Name: | Pat_ID |
CCMDB Label: | Serial |
CCMDB tab: | Top Row |
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 |
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-laptop identifying number for patient ward admissions. See Serial number.
Pat_ID is used in CCMDB.accdb. 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.accdb, where it is the primary identifier.
- Used by Centralized_data.mdb, where it is only kept in L_Log table for reference.