L TISS Form table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:L_TISS_Form table}}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. | The data in the table is kept only for trouble shooting purposes to be able to find the image of a form. | ||
| Line 10: | Line 10: | ||
| TISS_FORM_ID | longint | unique identifier | | | TISS_FORM_ID | longint | unique identifier | | ||
| PATIENT_ID | longint | [[D_ID]] in [[L_Log table]] | | | PATIENT_ID | longint | [[D_ID]] in [[L_Log table]] | | ||
| BATCH_NO | | BATCH_NO | text(10) | batch number in text | | ||
| BATCH_R_DATE | datetime | ??? | | | BATCH_R_DATE | datetime | ??? | | ||
| OUTPUT_FILENAME | text(255)| file name of scanned form image | | | OUTPUT_FILENAME | text(255)| file name of scanned form image | | ||
| FIRST_DATE | datetime | date - first date on form? | | | FIRST_DATE | datetime | date - first date on form? | | ||
| ITEM_DATE_GRP | text(14) | ??? | | | ITEM_DATE_GRP | text(14) | ??? | | ||
| import_date | date | date imported | | |||
+-----------------+----------+---------------------------------------+ | +-----------------+----------+---------------------------------------+ | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:TISS28_data.mdb]] | [[Category:TISS28_data.mdb]] | ||
[[Category:L Table]] | |||
[[Category:L TISS Form table| *]] | |||
Latest revision as of 14:09, 17 May 2023
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
+-----------------+----------+---------------------------------------+ | Field | Type | Meaning | +-----------------+----------+---------------------------------------+ | TISS_FORM_ID | longint | unique identifier | | PATIENT_ID | longint | D_ID in L_Log table | | BATCH_NO | text(10) | batch number in text | | BATCH_R_DATE | datetime | ??? | | OUTPUT_FILENAME | text(255)| file name of scanned form image | | FIRST_DATE | datetime | date - first date on form? | | ITEM_DATE_GRP | text(14) | ??? | | import_date | date | date imported | +-----------------+----------+---------------------------------------+