L Log table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m clean-up
Line 2: Line 2:


== Difference between [[Centralized_data.mdb]] and [[CCMDB_data.mdb]] ==
== Difference between [[Centralized_data.mdb]] and [[CCMDB_data.mdb]] ==
In CCMBD.mdb, the L_Log table contains all the patient related data. In [[CFE]], the information that could identify the patient is stored in [[PHI.mdb]].[[L_PHI]] instead, but the other information is still stored in [[Centralized_data.mdb]].[[L_Log]]. (This should likely be moved somewhere on its own.)
In CCMBD.mdb, the L_Log table contains all the patient related data. In [[CFE]], the information that could identify the patient is stored in [[PHI.mdb]].[[L_PHI]] instead, but the other information is still stored in [[Centralized_data.mdb]].[[L_Log]]. (This documentation should likely be moved somewhere on its own.)


== Data Structure ==
== Data Structure ==
To see the data structure of this table, see most up-to-date ccmdb_data.mdb in [[Regional Server]]\data\Master [[CCMDB.mdb]].
More info about individual fields can be found via [[:Category: L_Log table]].
=== SMW table description ===
{{#ask: [[Category:L Log]]  
{{#ask: [[Category:L Log]]  
| ?FieldName
| ?FieldName

Revision as of 17:14, 6 February 2017

L_Log is the main table where the basic patient information is stored. In the relational structure of our data, L_Log is the parent table to the other L-tables.

Difference between Centralized_data.mdb and CCMDB_data.mdb

In CCMBD.mdb, the L_Log table contains all the patient related data. In CFE, the information that could identify the patient is stored in PHI.mdb.L_PHI instead, but the other information is still stored in Centralized_data.mdb.L_Log. (This documentation should likely be moved somewhere on its own.)

Data Structure

No pages for labs that meet the semantic mediawiki criteria