Defining Inquiry Columns

Access the Define Inquiry Columns form.

Column Heading 1

Enter up to 10 characters to describe the first line of the column heading that appears on the Job Status Inquiry form. The system automatically centers this line for the column.

Column Heading 2

Enter up to 10 characters to describe the second line of the column heading that appears on the Job Status Inquiry form. The system automatically centers this line for the column.

Formula

Enter a predefined formula number or an equation using multiple formula numbers from the list of formulas that the system displays to calculate the value for column. The math symbols that you can use in the equation are:

+ Addition.

– Subtraction.

* Multiplication.

/ Division.

() Left and right parenthesis for nesting equations.

Multiplier

Enter the factor by which the amounts or units in a column are multiplied. The system multiplies the result of the calculation in the Formula field by the multiplier factor before it displays the result on the Job Status Inquiry form.

For example, if you want to scale large numbers to thousands, enter .001. If you want percentages to appear as whole numbers, enter 100.

Data Item

Enter the data item from the Data Dictionary that describes the information about the column, which includes the related glossary description, display code, decimals, and item properties that the system uses. Changes to the column definition must be maintained using the Data Dictionary applications.