L TISS Item table: Difference between revisions

Revision as of 14:47, 17 November 2021

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.

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

@@ Line 2: / Line 2: @@
 == 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 ==
- | Field        | Type     | Meaning
+{{Related Articles}}
- +--------------+----------+---------------------------------------
- | 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]]