L Log table: Difference between revisions

(17 intermediate revisions by 2 users not shown)

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>

{{DISPLAYTITLE:L_Log table}}<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]] ==

== Difference between [[Centralized_data.accdb]] 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 table]] instead, but the other information is still stored in [[Centralized_data.accdb]].[[L_Log]].

== 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]].~~

{{#ask: [[InTable::L Log table]]

~~More info about individual fields can be found via~~ [[:~~Category~~: ~~L_Log~~ table]].

| ?FieldName

| ?FieldDataType

| ?FieldLength

| ?DataElementStartDate

| ?DataElementEndDate

| ?DataElementProgram

|DataElementSortIndex = order in table

|sort=DataElementSortIndex

|order=ascending

|format=broadtable

|default=No pages for L_Log that meet the semantic mediawiki criteria

|headers=show

|class=sortable wikitable smwtable

|limit=150

}}

[[Category: Data structure]]

== Related articles ==

[[Category: L_Log | *]]

[[Category:Data structure]]

[[Category:L_Log table| *]]

[[Category:L Table]]

@@ 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>
+{{DISPLAYTITLE:L_Log table}}<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]] ==
+== Difference between [[Centralized_data.accdb]] 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 table]] instead, but the other information is still stored in [[Centralized_data.accdb]].[[L_Log]].
 == 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]].
+{{#ask: [[InTable::L Log table]]
-More info about individual fields can be found via [[:Category: L_Log table]].
+| ?FieldName
+| ?FieldDataType
+| ?FieldLength
+| ?DataElementStartDate
+| ?DataElementEndDate
+| ?DataElementProgram
+|DataElementSortIndex = order in table
+|sort=DataElementSortIndex
+|order=ascending
+|format=broadtable
+|default=No pages for L_Log that meet the semantic mediawiki criteria
+|headers=show
+|class=sortable wikitable smwtable
+|limit=150
+}}
-[[Category: Data structure]]
+== Related articles ==
-[[Category: L_Log | *]]
+{{Related Articles}}
+[[Category:Data structure]]
+[[Category:L_Log table| *]]
+[[Category:L Table]]