Pat ID field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "| element_description" to "| CCMDB_tab = Lab | element_description" |
Ttenbergen (talk | contribs) m Text replacement - "| element_description" to "| CCMDB_tab = Pharm | element_description" |
||
| Line 4: | Line 4: | ||
| CCMDB_tab = Top Row | | CCMDB_tab = Top Row | ||
| CCMDB_tab = Lab | | CCMDB_tab = Lab | ||
| CCMDB_tab = Pharm | |||
| 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-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 | | 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 | ||
Revision as of 00:23, 3 January 2019
| Data Element (edit) | |
| Field Name: | Pat_ID |
| CCMDB Label: | Serial |
| CCMDB tab: | Pharm |
| 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 |
| 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.
Tables
- 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.