View Display Name

The name of the view, as it appears in the “Inquiries” activity.

View Type

The type of the view, which could be “Adhoc”, “Audit” or “Report”.

View Access

The access type of the view, which could be “Public” or “Private”.

Select Distinct Values

Check this box to remove duplicate records in the view output.

Table Name

The name of the table, for which columns have to be specified (Alphanumeric, 255).

Help facility available.

Column Name

The column name, required for the view. The column names appear based on the selection of the table (Alphanumeric, 255).

Column Alias

The name of the column, as it would appear in the view output (Alphanumeric, 255). By default, the system displays a part of the column name.

Column Data Type

Use the drop-down list box to select the data type of the column. The system lists the standard data types such as “Character”, “Integer”, “Numeric”, “Date-Time”, “Date” and “Time”.

Decimal Length

The number of decimal digits to be displayed in the view output (Integer).

Standard Function

Use the drop-down list box if you want to perform an arithmetic function on the column. The system lists “Sum”, “Count”, “Maximum”, “Minimum” and “Average” as standard functions.

“Sum” and “Average” can be performed only on columns with numeric values. All the other functions can be performed on columns with any value. This would create a computed column.

Visible

Use the drop-down list box to set the visibility of the column. Select “Yes” if the column must be shown. Select “No” if the column must be hidden.

Display Length

The number of characters that will be displayed in the view output (Integer). This value will decide the width of column in the view output.

Display Sequence

The order in which the columns would be displayed in the view (Integer). This holds good only if the “Visible” field is “Yes”.

The number should be a running sequence number.  For example, if there are four columns to be sequenced, the numbers used should be 1, 2, 3, 4 and not 2, 4, 5, 8. 

If no value is specified, the system will generate a running number. If a value is specified in this field, it must be specified for all the multiline rows and the value must be continuous starting from 1.

Sort Order

Use the drop-down list box to select the sorting order. You can select either “Ascending” or “Descending” order.

Sort Sequence

The sequence in which the sorting should be prioritized on columns (Integer). The sort sequence should be a running sequential number. For example, if there are four columns to be sequenced, the numbers used should be 1, 2, 3, 4 and not 2, 4, 5, 8.

If no value is specified, the system generates a running number. If a value is specified in this field, it must be specified for all the multiline rows and the value must be continuous starting from 1.