Tmp TISS Export table
The Tmp_TISS_Export table in TISS28 Data.mdb contains the data exported by Teleform from File:TISS28 Form.pdf by the data processor during TISS28 Form Scanning.
It is a temporary table and the data is overwritten during each scan/import cycle.
A mirror of the CSV file that is generated by Teleform after a batch has been committed. After a batch has been scanned, processed, and committed, a CSV file is created by Teleform containing the raw data from the batch. To facilitate post-processing within TISS28.accdb, the CSV data is imported into this table.
Data Structure
Field descriptions:
- FORM_ID - unique sequence number of the form (preprinted at the bottom center of the form)
- SERIAL - patient serial number that is unique to site and unit
- PAGE - page number of the form (only used as an aid to manual collating of completed forms)
- SITE - site where data was collected, e.g., HSC, VIC, GRA, STB, CON, or OAK
- UNIT - unit at site where data was collected
- FIRST_DATE - first date that data was collected in MM/DD/YYYY format
- ITEM_DATE_GRP - collection dates grouped as a string beginning at DD of FIRST_DATE
- Tn_GRP - TISS item bubble values (0 or 1) grouped as a string, delimited by "-"
- BATCH_NO - uniquely identified the batch
- BATCH_R_DATE - batch receive date
- PG_LINK - page link (to connect page 1 to page 2 - used during processing only)
- OUTPUT_FILENAME - file name of scanned TISS form image (as a PDF)
+-----------------+----------+----------+-----+---------+------------+ | Field | Type | Required | Key | Default | Extra | +-----------------+----------+----------+-----+---------+------------+ | D_ID | text(18) | | | FORM_ID | longint | Yes | Pri | 0 | Autonumber | | SERIAL | longint | Yes | | 0 | | | PAGE | longint | Yes | | 0 | Not used | | SITE | text(3) | Yes | | Null | | | UNIT | text(4) | Yes | | Null | | | FIRST_DATE | datetime | Yes | | Null | | | ITEM_DATE_GRP | text(14) | Yes | | Null | | | T1_GRP | text(13) | Yes | | Null | | | T2_GRP | text(13) | Yes | | Null | | | ... | | | | | | | T49_GRP | text(13) | Yes | | Null | | | BATCH_NO | longint | Yes | | 0 | Not used | | BATCH_R_DATE | datetime | Yes | | Null | Not used | | PG_LINK | longint | Yes | | 0 | Not used | | OUTPUT_FILENAME | text(255)| Yes | | Null | | +-----------------+----------+----------+-----+---------+------------+