Tmp TISS Export table

From CCMDB Wiki
Jump to navigation Jump to search

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    |            |
+-----------------+----------+----------+-----+---------+------------+