L TISS76 table: Difference between revisions

Latest revision as of 12:26, 9 May 2023

L_TISS76 table in Legacy TMS Data.mdb contains TISS76-Points information for the first 10 days of stay in ICU. It is linked to L_Log table by D_ID.

To see the most up-to-date data structure of this table, see the master files.

name	position	type	description
D_ID	2	string(18)	D_ID
Date	3	date	Date
T1	4	integer	TISS 1 point score as per TISS76-Points
...	...	...	...
T 96	99	integer	TISS 96 point score as per TISS76-Points
Total	100	numeric (8)	Total TISS Score

Start Date : Varies depending on the collection start date of the site ( Data Collection start dates -click here)

@@ Line 1: / Line 1: @@
-'''L TISS76''' is table that contains [[TISS76-Legacy]] information. It is linked to [[L_Log table]] by [[D_ID]].
+'''L_TISS76''' table in [[Legacy TMS Data.mdb]] contains [[TISS76-Points]] information for the first 10 days of stay in ICU. It is linked to [[L_Log table]] by [[D_ID]].
 == Structure ==
@@ Line 10: / Line 10: @@
 | D_ID || 2 || string(18) || [[D_ID]]
 |-
-| ... || ... || ... || ...
+| Date || 3 || date || Date
 |-
-| ... || ... || ... || ...
+| T1   || 4 || integer || TISS 1 point score as per [[TISS76-Points]]
+|-
+| ...  || ... || ... || ...
+|-
+| T 96 || 99 || integer || TISS 96 point score as per [[TISS76-Points]]
+|-
+| Total || 100 || numeric (8) || Total TISS Score
 |}
+== Collection date for  ICU only ==
+*Start Date : Varies depending on the collection start date of the site ( [[Site and Location table |  Data Collection start dates -click here]])
+*End Date : Dec 31, 2012
+== See also ==
+* [[:Category:TISS]]
+* [[L TISS Item table]] - current data structure (as opposed to this legacy data)
 [[Category: Data structure]]
+[[Category: L TISS76 table| *]]