L TISS76 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
No edit summary
mNo edit summary
 
(8 intermediate revisions by 3 users not shown)
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 ==
== Structure ==
Line 10: Line 10:
| D_ID || 2 || string(18) || [[D_ID]]
| 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
|}
|}


Line 24: Line 30:


[[Category: Data structure]]
[[Category: Data structure]]
[[Category: L TISS76 table| *]]

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.

Structure

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

Collection date for ICU only

  • End Date : Dec 31, 2012

See also