Entity TmplQuery

Description of Entity TmplQuery

This entity is used to create data filters. These data filters are named queries. They are defined using conditions that are rules that outline the date required. As a general rule, the more conditions the smaller the result set is.


List of all Dependencies of the Entity TmplQuery

Name

Code

Class Name

Relation_130163

Relation_130163

Reference

Relation_126748

Relation_126748

Reference

Relation_126747

Relation_126747

Reference


List of Attributes of the Entity TmplQuery

Name

Code

Template Query ID

TmplQueryID

Query Description

QueryDesc

DistinctOption

DistinctOption

TableString

TableString


Entity Attribute Template Query ID of the Entity TmplQuery

Card of Attribute Template Query ID of the Entity TmplQuery

Name

Template Query ID

Code

TmplQueryID

Data Type

char(20)

Mandatory

Yes


Description of Attribute Template Query ID of the Entity TmplQuery

Shows the identity of the template query. This is the primary key for the TmplQuery table.
Example: PersonalQuery / EmployeeQuery etc


Entity Attribute Query Description of the Entity TmplQuery

Card of Attribute Query Description of the Entity TmplQuery

Name

Query Description

Code

QueryDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Query Description of the Entity TmplQuery

Stores a description about the query.
Example: Basic Personal Details / Personal Employment Details etc


Entity Attribute DistinctOption of the Entity TmplQuery

Card of Attribute DistinctOption of the Entity TmplQuery

Name

DistinctOption

Code

DistinctOption

Data Type

smallint

Mandatory

No


Description of Attribute DistinctOption of the Entity TmplQuery

Shows if it is a distinct option, in a form of a checkbox.


Entity Attribute TableString of the Entity TmplQuery

Card of Attribute TableString of the Entity TmplQuery

Name

TableString

Code

TableString

Data Type

char(255)

Mandatory

No


Description of Attribute TableString of the Entity TmplQuery

The table list contains the string of how the tables are joined for this query.