CCMDB Data Structure: Difference between revisions

(5 intermediate revisions by the same user not shown)

Line 3:

== 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 [[~~Centralized data~~.~~mdb~~]]/[[PHI.mdb]], this data is all stored in [[L_Log]] in [[CCMDB.mdb]].

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_Log table]] links to the following on [[D_ID]]

** [[L_PHI table]]

** [[L_ICD10 table]]

** [[L_CCI_Picklist table]]

** [[L_CCI_Component table]]

Line 33:

Line 34:

| [[Dispo field]] || dispo|| {{#show: Dispo field| ?DataElementSortIndex}} || [[S dispo table]]

|-

| [[RecordStatus field]] || RecordStatus || {{#show: RecordStatus field| ?DataElementSortIndex}} || [[~~S RecordStatus~~]]

| [[RecordStatus field]] || RecordStatus || {{#show: RecordStatus field| ?DataElementSortIndex}} || [[s_RecordStatus table]]

|-

| [[ADL Bathing]] || ADL_Bathing || {{#show: ADL Bathing| ?DataElementSortIndex}} || [[S ADLOptions table]]

Line 75:

Line 76:

=== [[L_TmpV2 table]] ===

The [[L_TmpV2 table]] links on both of the following two fields together with the [[~~S Tmp~~]] table:

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.Item = S_tmp.Value

@@ Line 3: / Line 3: @@
 == 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 [[Centralized data.mdb]]/[[PHI.mdb]], this data is all stored in [[L_Log]] in [[CCMDB.mdb]].
+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_Log table]] links to the following on [[D_ID]]
 ** [[L_PHI table]]
+** [[L_ICD10 table]]
 ** [[L_CCI_Picklist table]]
 ** [[L_CCI_Component table]]
@@ Line 33: / Line 34: @@
 | [[Dispo field]] || dispo|| {{#show: Dispo field| ?DataElementSortIndex}} || [[S dispo table]]
 |-
-| [[RecordStatus field]] || RecordStatus || {{#show: RecordStatus field| ?DataElementSortIndex}} || [[S RecordStatus]]
+| [[RecordStatus field]] || RecordStatus || {{#show: RecordStatus field| ?DataElementSortIndex}} || [[s_RecordStatus table]]
 |-
 | [[ADL Bathing]] || ADL_Bathing || {{#show: ADL Bathing| ?DataElementSortIndex}} || [[S ADLOptions table]]
@@ Line 75: / Line 76: @@
 === [[L_TmpV2 table]] ===
-The [[L_TmpV2 table]] links on both of the following two fields together with the [[S Tmp]] table:
+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.Item = S_tmp.Value