L TISS Item table

From CCMDB Wiki
Revision as of 09:29, 18 April 2017 by Ttenbergen (talk | contribs) (m)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.

Data Structure

  • TISS_ITEM_ID - autonumber(long int) - unique identifier
  • D_ID - text(18) - D_ID in L_Log table
  • ITEM_DATE - date - the date of the ITSS item that was filled in
  • ITSS_ITSM - byte - the line number on the File:TISS28 Form.pdf of the TISS item