L_TISS_Item table
		
		
		
		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
| column | field | type | description | 
|---|---|---|---|
| 1 | TISS_ITEM_ID | longint | AutoNumber | 
| 2 | D_ID | text(18) | D ID field | 
| 3 | ITEM_DATE | datetime | the date of the ITSS item that was filled in | 
| 4 | TISS_ITEM | byte | the line number on the File:TISS28 Form.pdf of the TISS item |