L Log table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m cat |
Ttenbergen (talk | contribs) m →Data Structure: m |
||
| Line 7: | Line 7: | ||
To see the data structure of this table, see most up-to-date ccmdb_data.mdb in [[Regional Server]]\data\Master [[CCMDB.mdb]]. | 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]]. | More info about individual fields can be found via [[:Category: L_Log table]]. | ||
=== SMW table description === | |||
* D_ID - unique record ID | |||
{{#ask: [[Category:L Log]] | |||
| ?FieldName | |||
| ?FieldDataType | |||
| ?DataElementSortIndex = order in table | |||
|sort=DataElementSortIndex | |||
|order=ascending | |||
|format=broadtable | |||
|default=No pages for labs that meet the semantic mediawiki criteria | |||
|headers=show | |||
|class=sortable wikitable smwtable | |||
}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: L_Log | *]] | [[Category: L_Log | *]] | ||
Revision as of 10:28, 4 January 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 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.
SMW table description
- D_ID - unique record ID
No pages for labs that meet the semantic mediawiki criteria