L TISS Item table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m
 
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 ==
* '''TISS_ITEM_ID''' - autonumber(long int) - unique identifier
 
* '''D_ID''' - text(18) - [[D_ID]] in [[L_Log table]]
+--------------+----------+---------------------------------------  
* '''ITEM_DATE''' - date - the date of the ITSS item that was filled in
| Field        | Type    | Meaning                               
* '''ITSS_ITSM''' - byte - the line number on the [[File:TISS28 Form.pdf]] of the TISS item
+--------------+----------+---------------------------------------  
| 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
+--------------+----------+---------------------------------------