L Log table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m m |
||
| Line 1: | Line 1: | ||
<onlyinclude>'''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]].</onlyinclude> | <onlyinclude>'''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]].</onlyinclude> | ||
== 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.) | |||
== Data Structure == | == Data Structure == | ||
Revision as of 09:27, 14 September 2016
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 should likely be moved somewhere on its own.)
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.