L TISS Form table

From CCMDB Wiki
Revision as of 09:28, 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 Form 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.

The data in the table is kept only for trouble shooting purposes to be able to find the image of a form.

Data Structure

  • TISS_FORM_ID - autonumber(long int) - unique identifier
  • D_ID - text(18) - D_ID in L_Log table
  • BATCH_NO - long int - batch number
  • BATCH_NO_TEXT - text (10) - batch number in text
  • BATCH_R_DATE - date - ???
  • OUTPUT_FILENAME - file name of form image
  • FIRST_DATE - date - first date on form?
  • ITEM_DATE_GRP - text(14) - ???
Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_TISS_Form_table&oldid=54778"