L TISS76 table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
''' | '''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|| | | 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 || | | Total || 100 || numeric (8) || Total TISS Score | ||
|} | |} | ||
| Line 29: | 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
- Start Date : Varies depending on the collection start date of the site ( 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)