L TISS Item table

From CCMDB Wiki
Revision as of 13:44, 2018 February 19 by Ttenbergen (talk | contribs) (Text replacement - "|*" to "| *")
Jump to navigation Jump to search

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
+--------------+----------+---------------------------------------