Pat ID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "| element_description" to "| CCMDB_tab = Lab | element_description")
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 01:23, 2019 January 3

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

The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See Serial number.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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

Related Articles

Related articles: