L TISS Item table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m |
Ttenbergen (talk | contribs) m m |
||
Line 1: | Line 1: | ||
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]]. | 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]]. For each bubble that is filled in on a TISS form, a record is inserted into this table indicating the date the entry was made and the corresponding TISS item. | ||
== Data Structure == | == Data Structure == | ||
+--------------+----------+--------------------------------------- | |||
| Field | Type | Meaning | |||
+--------------+----------+--------------------------------------- | |||
| TISS_ITEM_ID | longint | AutoNumber | |||
| D_ID | longint | [[D_ID]] in [[L_Log table]] | |||
| ITEM_DATE | datetime | the date of the ITSS item that was filled in | |||
| TISS_ITEM | byte | the line number on the [[File:TISS28 Form.pdf]] of the TISS item | |||
+--------------+----------+--------------------------------------- | |||
[[Category:TISS28]] | [[Category:TISS28]] | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:TISS28_data.mdb]] | [[Category:TISS28_data.mdb]] |
Revision as of 12:33, 18 April 2017
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. For each bubble that is filled in on a TISS form, a record is inserted into this table indicating the date the entry was made and the corresponding TISS item.
Data Structure
+--------------+----------+--------------------------------------- | Field | Type | Meaning +--------------+----------+--------------------------------------- | TISS_ITEM_ID | longint | AutoNumber | D_ID | longint | D_ID in L_Log table | ITEM_DATE | datetime | the date of the ITSS item that was filled in | TISS_ITEM | byte | the line number on the File:TISS28 Form.pdf of the TISS item +--------------+----------+---------------------------------------