L_TISS_Item table

From CCMDB Wiki
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

Related articles

Related articles: