L Log table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 9: Line 9:
| ?FieldDataType
| ?FieldDataType
| ?FieldLength
| ?FieldLength
| ?DataElementStartDate
| ?DataElementEndDate
| ?DataElementProgram
|DataElementSortIndex = order in table
|DataElementSortIndex = order in table
|sort=DataElementSortIndex
|sort=DataElementSortIndex

Revision as of 11:40, 7 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