This entity would record the fields involved in a particular query. The user uses this Ad-Hoc Query during runtime after a successful login. In the ad-hoc query screen there are two types of query, standard and custom. This entity would store the field for the standard ad-hoc query. It would record the ad-hoc query, fields and condition set by the user for the query that they would use.

The name of the ad hoc query fields. It is the primary key for the AdHocQueryFields table.
Example: PayGroupId / DepartmentId / EmployeeId etc

The entity name for the ad hoc query field. It is the primary key for the AdHocQueryFields table.
Example: PayEmployee / Employee etc

Stores a query from the condition.

Stores a query to the condition.

Shows the start date of the query.
It is in the format: DD-MM-YYYY.

Shows the end date of the query.
It is in the format: DD-MM-YYYY.

Shows the start range of the query value.

Shows the end range of the query value.

Shows a query that is not the condition.