Files > CPRS QUERY DEFINITION

name

CPRS QUERY DEFINITION

number

102.21

location

^ORD(102.21,

description

The CPRS query tool provides a mechanism by which clinical users may search for items typically managed by CPRS. These are very limited types of queries. A wizard helps the user construct the criteria used in the query. This file contains definitions of queries used to build reports of CPRS items (orders, consults, documents). Each query definition contains a list of constraints. These constraints are used by the query routines to return a subset of CPRS items. This file also contains definitions of report criteria. These criteria are selected and modified by the user when building custom reports. A report criterion contains a list of constraints that apply to the particular criterion. A critieron behaves much like a "mini-report". The other part of a query definition stored in this file is the list of fields to be displayed after the query is run. The query produces a columnar report with the selected display field in each column.

Fields

#	Name	Location	Type	Details	Index	Description
.01	name(+)	0;1	FREE TEXT		B	This is the name of the report or criterion. Personally created reports are stored as RPTUduz user-created-name. This assures uniqueness of personal custom reports.
2	display text	0;2	FREE TEXT			This is the text that is displayed in the list box when selecting a criterion or a report.
3	disable	0;3	FREE TEXT			This is the text that is desplayed when the definition is disabled.
4	type(+)	0;4	SET OF CODES	C:constraint R:report S:search item B:baseline		This specifies whether the record is a report or a criterion.
5	owner	0;5	POINTER	200		This contains the owner of a custom report.
6	parent	0;6	POINTER	102.21		This identifies the entry that is the parent criterion. Criteria may appear in a hierarchy.
7	tag	0;7	NUMERIC		T	This contains an integer that matches the Tag property of the Windows control that references this criterion.
10	query text	1;0	MULTIPLE	102.211		This multiple allows a sequence of captions to be defined that comprise the default text of a query description.
20	format	2;0	MULTIPLE	102.212		This multiple contains formatting information for the columns of the report.