L TISS Item table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m cat
No edit summary
Line 17: Line 17:
[[Category:TISS28_data.mdb]]
[[Category:TISS28_data.mdb]]
[[Category:L Table]]
[[Category:L Table]]
[[Category:L TISS Item table|*]]

Revision as of 17:28, 29 November 2017

The L TISS Item table in TISS28 Data.mdb contains the data collected on File:TISS28 Form.pdf as per the TISS28 Collection Guide. It is populated by the data processor during TISS28 Form Scanning. For each bubble that is filled in on a TISS form, a record is inserted into this table indicating the date the entry was made and the corresponding TISS item.

Data Structure

+--------------+----------+--------------------------------------- 
| Field        | Type     | Meaning                                
+--------------+----------+--------------------------------------- 
| TISS_ITEM_ID | longint  | AutoNumber  
| D_ID         | longint  | D_ID in L_Log table              
| ITEM_DATE    | datetime | the date of the ITSS item that was filled in           
| TISS_ITEM    | byte     | the line number on the File:TISS28 Form.pdf of the TISS item
+--------------+----------+---------------------------------------