L TISS Item table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:L_TISS_Item table}}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 == | ||
{| class="wikitable sortable" | |||
|- | |||
!| column | |||
!| field | |||
!| type | |||
!| description | |||
|- | |||
||1 || '''TISS_ITEM_ID ''' || longint || AutoNumber | |||
|- | |||
||2 || '''D_ID''' || text(18) || [[D ID field]] | |||
|- | |||
||3 || '''ITEM_DATE''' || datetime || the date of the ITSS item that was filled in | |||
|- | |||
||4 || '''TISS_ITEM ''' || byte || the line number on the [[File:TISS28 Form.pdf]] of the TISS item | |||
|} | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:TISS28_data.mdb]] | [[Category:TISS28_data.mdb]] | ||
[[Category:L Table]] | |||
[[Category:L TISS Item table| *]] | |||
Latest revision as of 14:09, 17 May 2023
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
| column | field | type | description |
|---|---|---|---|
| 1 | TISS_ITEM_ID | longint | AutoNumber |
| 2 | D_ID | text(18) | D ID field |
| 3 | ITEM_DATE | datetime | the date of the ITSS item that was filled in |
| 4 | TISS_ITEM | byte | the line number on the File:TISS28 Form.pdf of the TISS item |