L Log table: Difference between revisions

(21 intermediate revisions by 2 users not shown)

Line 1:

'''L_Log''' is the main table where the basic patient information is stored. ~~An entry~~ is ~~needed in L_Log in order~~ to ~~makes sense of entries in~~ the other [[L-tables]].

{{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>

~~As of~~ [[~~CCMDB~~.~~mdb_Change_Log_2012#ver_2012-10-19|ver_2012-10-19~~]] the data ~~for y/n drugs for~~ [[~~pharmacy collection~~]] is ~~also~~ stored in ~~L_Log~~. ~~Each patient will have a yes or no for each of them~~, ~~so from a relational data perspective it made sense to put them there~~.

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

| ?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:Data structure]]

[[Category:L_Log table| *]]

[[Category:L Table]]

@@ Line 1: / Line 1: @@
-'''L_Log''' is the main table where the basic patient information is stored. An entry is needed in L_Log in order to makes sense of entries in the other [[L-tables]].
+{{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>
-As of [[CCMDB.mdb_Change_Log_2012#ver_2012-10-19|ver_2012-10-19]] the data for y/n drugs for [[pharmacy collection]] is also stored in L_Log. Each patient will have a yes or no for each of them, so from a relational data perspective it made sense to put them there.
+== 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 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]]
+| ?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 ==
+{{Related Articles}}
+[[Category:Data structure]]
+[[Category:L_Log table| *]]
+[[Category:L Table]]