D ID field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m it isn't actually in L_Person table |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
|field_name=D_ID | |field_name=D_ID | ||
|Rank=N/A | |Rank=N/A | ||
|in_table= | |in_table=L_CCI_Picklist table, L_CCI_Component table, L_Como table, L_Dxs table, L_ICD10 table, L_Labs_DSM 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, L_TISS76 table | ||
|data_type=string | |data_type=string | ||
|datafield_length=18 | |datafield_length=18 | ||
| Line 10: | Line 10: | ||
|element_description=The unique identifier/index of records in the Critical Care and Medicine Database. | |element_description=The unique identifier/index of records in the Critical Care and Medicine Database. | ||
}} | }} | ||
D_ID is used in [[CFE]]/[[Centralized_data.mdb]]. In [[CCMDB. | D_ID is used in [[CFE]]/[[Centralized_data.mdb]]. In [[CCMDB.accdb]] / [[CCMDB_data.mdb]], [[Pat_ID]] is the equivalent. [[D_ID]] is the combination of the [[Service/Location]] and the [[Pat_ID]]. | ||
== Changing D_IDs == | == Changing D_IDs == | ||
| Line 17: | Line 17: | ||
== Related Articles == | == Related Articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
Latest revision as of 10:45, 2019 September 22
| Data Element (edit) | |
| Field Name: | D_ID |
| CCMDB Label: | not stated |
| CCMDB tab: | not stated |
| Table: | L_CCI_Picklist table, L_CCI_Component table, L_Como table, L_Dxs table, L_ICD10 table, L_Labs_DSM 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, L_TISS76 table |
| Data type: | string |
| Length: | 18 |
| Program: | Med and CC |
| Created/Raw: | Raw |
| Start Date: | 1988-07-11 |
| End Date: | 2300-01-01 |
| Sort Index: | 1 |
The unique identifier/index of records in the Critical Care and Medicine Database.
D_ID is used in CFE/Centralized_data.mdb. In CCMDB.accdb / CCMDB_data.mdb, Pat_ID is the equivalent. D_ID is the combination of the Service/Location and the Pat_ID.