S AllLabs: Difference between revisions

Line 2:

*NOTE: S_Labs is a rogue file. For more information, click here...[[S_Labs]].

==~~S_AllLabs Table~~==

==Lab Items Collected==

* ~~ICU Database~~

Different itesm are collected at HSC compared to all other sites. The S_AllLabs list has different ''views'' for these locations. To view only the items collected at your site, set the view as per below.

*HSC - ''Collect at HSC''

*All other sites (STB, VIC, GRA, OAK, CON)- ''Collect at others''

If we update the contents of the S_Drugs table a new one will be loaded onto your PDA at [[sync]] time. When this happens you will have to set your view again.

==Contents of S_AllLabs Table==

{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>

|- style="font-size:11pt"

Line 11:

Line 16:

| width="59" align="center" valign="bottom" | manual HSCCollect

| width="59" align="center" valign="bottom" | manual-ALL Other SitesCollect

| width="59" align="center" valign="bottom" | Legacy Data Info

|-

Line 164:

Line 170:

|-

|style="font-size:11pt" height="14" valign="bottom" | 132

|style="font-size:11pt" valign="bottom" | VDRL

|style="font-size:11pt" valign="bottom" | [http://en.wikipedia.org/wiki/VDRL VDRL]

|style="font-size:11pt" align="center" valign="bottom" | YES

|style="font-weight:bold" align="center" valign="bottom" | NO

Line 272:

Line 278:

|- style="font-size:11pt"

| height="14" valign="bottom" | 136

| valign="bottom" | Pentaspan

| valign="bottom" | [http://en.wikipedia.org/wiki/Pentaspan Pentaspan]

| align="center" valign="bottom" | YES

Line 290:

Line 296:

|- style="font-size:11pt"

| height="14" valign="bottom" | 142

| valign="bottom" | Voluven

| valign="bottom" | [http://en.wikipedia.org/wiki/Voluven Voluven]

| align="center" valign="bottom" | YES

| align="center" valign="bottom" | started 25 Jul 2008

|}

== ~~New item~~==

== Data Structure ==

*~~Lab item 142''' Voluven'''~~ - ~~added July 25~~.08

* Labcode - integer number we use to identify the lab in the database, i.e what is actually stored in [[L_Labs]]

* LabName - text string with the "friendly name" that will be displayed on the PDA and in Access

* HSCCollect - a boolean (i.e. yes/no) variable stating if this lab should be collected at HSC

* OtherCollect - a boolean (i.e. yes/no) variable stating if this lab should be collected at locations other than HSC

HSCCollect and OtherCollect are used to generate the location specific listings/views.

== Bug Note ==

Line 305:

Line 316:

== to do before de-stubbing ==

* explain data structure

* Is there Legacy Data Info beyond when Voluven was added? Are there old labs we no longer collect?--[[User:Ttenbergen|Ttenbergen]] 09:58, 12 August 2008 (CDT)

* From the wikipedia article sounds like Pentaspan and Voluven are interventions rather than labs. If so, we need an explanation why they are tracked under Labs rather than Pharm. --[[User:Ttenbergen|Ttenbergen]] 09:58, 12 August 2008 (CDT)

[[Category: Data structure]]

[[Category: Legacy Data]]

@@ Line 2: / Line 2: @@
 *NOTE: S_Labs is a rogue file. For more information, click here...[[S_Labs]].
-==S_AllLabs Table==
+==Lab Items Collected==
-* ICU Database
+Different itesm are collected at HSC compared to all other sites. The S_AllLabs list has different ''views'' for these locations. To view only the items collected at your site, set the view as per below.
+*HSC - ''Collect at HSC''
+*All other sites (STB, VIC, GRA, OAK, CON)- ''Collect at others''
+If we update the contents of the S_Drugs table a new one will be loaded onto your PDA at [[sync]] time. When this happens you will have to set your view again.
+==Contents of S_AllLabs Table==
 {| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
 |- style="font-size:11pt"
@@ Line 11: / Line 16: @@
 | width="59" align="center" valign="bottom" | manual HSCCollect
 | width="59" align="center" valign="bottom" | manual-ALL Other SitesCollect
+| width="59" align="center" valign="bottom" | Legacy Data Info
 |-
@@ Line 164: / Line 170: @@
 |-
 |style="font-size:11pt" height="14"  valign="bottom" | 132
-|style="font-size:11pt"  valign="bottom" | VDRL
+|style="font-size:11pt"  valign="bottom" | [http://en.wikipedia.org/wiki/VDRL VDRL]
 |style="font-size:11pt" align="center" valign="bottom" | YES
 |style="font-weight:bold" align="center" valign="bottom" | NO
@@ Line 272: / Line 278: @@
 |- style="font-size:11pt"
 | height="14"  valign="bottom" | 136
-|  valign="bottom" | Pentaspan
+|  valign="bottom" | [http://en.wikipedia.org/wiki/Pentaspan Pentaspan]
 | align="center" valign="bottom" | YES
 | align="center" valign="bottom" | YES
@@ Line 290: / Line 296: @@
 |- style="font-size:11pt"
 | height="14"  valign="bottom" | 142
-|  valign="bottom" | Voluven
+|  valign="bottom" | [http://en.wikipedia.org/wiki/Voluven Voluven]
 | align="center" valign="bottom" | YES
 | align="center" valign="bottom" | YES
+| align="center" valign="bottom" | started 25 Jul 2008
 |}
-== New item==
+== Data Structure ==
-*Lab item 142''' Voluven''' - added July 25.08
+* Labcode - integer number we use to identify the lab in the database, i.e what is actually stored in [[L_Labs]]
+* LabName - text string with the "friendly name" that will be displayed on the PDA and in Access
+* HSCCollect - a boolean (i.e. yes/no) variable stating if this lab should be collected at HSC
+* OtherCollect - a boolean (i.e. yes/no) variable stating if this lab should be collected at locations other than HSC
+HSCCollect and OtherCollect are used to generate the location specific listings/views.
 == Bug Note ==
@@ Line 305: / Line 316: @@
 == to do before de-stubbing ==
-* explain data structure
+* Is there Legacy Data Info beyond when Voluven was added? Are there old labs we no longer collect?--[[User:Ttenbergen|Ttenbergen]] 09:58, 12 August 2008 (CDT)
+* From the wikipedia article sounds like Pentaspan and Voluven are interventions rather than labs. If so, we need an explanation why they are tracked under Labs rather than Pharm. --[[User:Ttenbergen|Ttenbergen]] 09:58, 12 August 2008 (CDT)
 {{stub}}
 [[Category: Data structure]]
+[[Category: Legacy Data]]