CCMDB Data Structure: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
For information on data fields, see [[Auto Data Dictionary]]. For information on data encoded in the [[Entity–attribute–value model of the L_Tmp_V2 table]], see [[Projects]]. | For information on data fields, see [[Auto Data Dictionary]]. For information on data encoded in the [[Entity–attribute–value model of the L_Tmp_V2 table]], see [[Projects]]. | ||
== | == Actual Data == | ||
All of these are 1-many, except for the link between [[L_Log table]] and [[L_PHI table]], which is 1-to-1. The only reason for the split in table is for de-identification in the [[ | All of these are 1-many, except for the link between [[L_Log table]] and [[L_PHI table]], which is 1-to-1. The only reason for the split in table is for de-identification in the [[Centralized_data.accdb]]/[[PHI.mdb]], this data is all stored in [[L_Log]] in [[CCMDB.mdb]]. Also see [[Entity Relationship Diagram for the Critical Care and Medicine Database]] for a visual representation. | ||
* [[ | * [[L_Log table]] links to the following on [[D_ID]] | ||
** [[L_PHI table]] | ** [[L_PHI table]] | ||
** [[L_ICD10 table]] | |||
** [[L_CCI_Picklist table]] | ** [[L_CCI_Picklist table]] | ||
** [[L_CCI_Component table]] | ** [[L_CCI_Component table]] | ||
** [[L_Labs_Flowsheet table]] | ** [[L_Labs_Flowsheet table]] | ||
** [[L_Pharm_Flowsheet table]] | ** [[L_Pharm_Flowsheet table]] | ||
** [[L_TISS Item table]] | ** [[L_TISS Item table]] (in different file) | ||
** [[L_TmpV2 table]] | ** [[L_TmpV2 table]] | ||
** [[L_Labs_DSM table]] (in different file) | ** [[L_Labs_DSM table]] (in different file) | ||
== | == Support/Dropdown Tables == | ||
=== [[L_Log table]] === | === [[L_Log table]] === | ||
Some fields in [[L Log table]] draw from support tables as follows: | Some fields in [[L Log table]] draw from support tables as follows: | ||
| Line 33: | Line 34: | ||
| [[Dispo field]] || dispo|| {{#show: Dispo field| ?DataElementSortIndex}} || [[S dispo table]] | | [[Dispo field]] || dispo|| {{#show: Dispo field| ?DataElementSortIndex}} || [[S dispo table]] | ||
|- | |- | ||
| [[RecordStatus field]] || RecordStatus || {{#show: RecordStatus field| ?DataElementSortIndex}} || [[ | | [[RecordStatus field]] || RecordStatus || {{#show: RecordStatus field| ?DataElementSortIndex}} || [[s_RecordStatus table]] | ||
|- | |- | ||
| [[ADL Bathing]] || ADL_Bathing || {{#show: ADL Bathing| ?DataElementSortIndex}} || [[S ADLOptions table]] | | [[ADL Bathing]] || ADL_Bathing || {{#show: ADL Bathing| ?DataElementSortIndex}} || [[S ADLOptions table]] | ||
| Line 47: | Line 48: | ||
| [[ADL Feeding]] || ADL_Feeding|| {{#show: ADL Feeding| ?DataElementSortIndex}} || [[S ADLOptions table]] | | [[ADL Feeding]] || ADL_Feeding|| {{#show: ADL Feeding| ?DataElementSortIndex}} || [[S ADLOptions table]] | ||
|- | |- | ||
| [[Admit Type for APACHE II]] || Ap_AdmitType|| {{#show: Admit Type for APACHE II| ?DataElementSortIndex}} || [[ | | [[Admit Type for APACHE II]] || Ap_AdmitType|| {{#show: Admit Type for APACHE II| ?DataElementSortIndex}} || [[S_AP_AdmitType table]] | ||
|- | |- | ||
| [[Chronic Health APACHE]] || Ap_Chronic|| {{#show: Chronic Health APACHE| ?DataElementSortIndex}} || [[S AP Chronic table]] | | [[Chronic Health APACHE]] || Ap_Chronic|| {{#show: Chronic Health APACHE| ?DataElementSortIndex}} || [[S AP Chronic table]] | ||
| Line 75: | Line 76: | ||
=== [[L_TmpV2 table]] === | === [[L_TmpV2 table]] === | ||
The [[L_TmpV2 table]] links on both of the following two fields together with the [[ | The [[L_TmpV2 table]] links on both of the following two fields together with the [[s_tmp table]] table: | ||
* L_TmpV2.project = s_Tmp.Study | * L_TmpV2.project = s_Tmp.Study | ||
* L_TmpV2.Item = S_tmp.Value | * L_TmpV2.Item = S_tmp.Value | ||
| Line 93: | Line 94: | ||
== Created/Derived Data == | == Created/Derived Data == | ||
* [[ | * [[Created_Variables_Common_2021 table]] | ||
* [[ | * [[Created_Variables_CC_2021 table]] | ||
== Related articles == | == Related articles == | ||