L Log table: Difference between revisions

(16 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]].~~

~~=== SMW table description ===~~

* D_ID - unique record ID

{{#ask: [[~~Category~~:L Log]]

| ?FieldName

| ?FieldDataType

| ?DataElementSortIndex = order in table

| ?FieldLength

| ?DataElementStartDate

| ?DataElementEndDate

| ?DataElementProgram

|DataElementSortIndex = order in table

|sort=DataElementSortIndex

|order=ascending

|format=broadtable

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

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

|headers=show

|class=sortable wikitable smwtable

|limit=150

}}

== Related articles ==

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: L_Log | *]]

[[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]].
-=== SMW table description ===
-*	D_ID - unique record ID
-{{#ask: [[Category:L Log]]
 | ?FieldName
 | ?FieldDataType
-| ?DataElementSortIndex = order in table
+| ?FieldLength
+| ?DataElementStartDate
+| ?DataElementEndDate
+| ?DataElementProgram
+|DataElementSortIndex = order in table
 |sort=DataElementSortIndex
 |order=ascending
 |format=broadtable
-|default=No pages for labs that meet the semantic mediawiki criteria
+|default=No pages for L_Log that meet the semantic mediawiki criteria
 |headers=show
 |class=sortable wikitable smwtable
+|limit=150
 }}
+== Related articles ==
+{{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: L_Log | *]]
+[[Category:L_Log table| *]]
+[[Category:L Table]]