QUERIES

Table Description: Query Tracking

Detailed notes for this table are included below.

2.0 Data Dictionary

Table Constraints: QUERY_ID

ITM_NAME	DSCR	ITM_TYPE
QUERY_ID	Query ID	UUID
QUERY_DSCR	Query Description	TEXT
QUERY_STATUS	Query Status	TEXT
TARGET_REC_ID	Record ID in the target query is associated with	UUID
MOD_NAME	Name of the target query is associated with	TEXT
PATNO	Participant ID query is associated with	NUMBER
EVENT_ID	Visit ID query is associated with	TEXT
CNO	Site Number query is associated with	NUMBER

Details

This is a purely operational table designed to track queries on specific records in target tables being sent from the Blackfynn EDC to LONI. While queries are not being generated in the EDC itself, this table will serve to track queries that post-EDC transformations would obscure but which we still want to track.

The QUERY_STATUS column is related to the QUERY column that appears in all other targets on which queries could be made, but the QUERY column is a simple boolean indicating whether there is an open query or not.