DEFINE PARAMETERS#

The Define Parameters (IMPM) is used to maintain the supplied parameters for the reports within the system. The definition data for the Define Parameters screen is stored in the P2K_AM_FUNCTIONS and P2K_AM_PARAMETERS tables.

Description

This field provides a short description of the parameter.

Table

This field identifies the table associated with the parameter.

Seq #

This field defines the sequential order of the parameters.

Parameter Name

This field identifies the parameter by name.

Prompt

This field displays how the parameter will be identified in the columns on forms in the system.

Prompt (FRE)

If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the parameter. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)

Reference

This field allows you to provide reference information for the parameter.

Item Name

CLEANUP

Data Type

This field defines the data type of parameter, for example, numeric, alphanumeric, etc.

Format tab #

Parameter Length

The length of the parameter value is defined in this field.

Hint Text

This field provides a hint as to the parameter's usage within the report.

Mandatory

If this toggle is checked, the parameter is mandatory and must be completed.

Singular

If this toggle is checked, only one value may be selected for the parameter

Filter

If this toggle is checked, the parameter is used to further qualify the list of records that will be processed.

Default Value

If there is a default value for the parameter, it will defined in this field.

Clause tab #

Validation Clause

This field displays the clause that is added to the “Report List Query” in IMLQ to refine the report list.

LOV Query

This field displays the sql query used to define the List Of Values (LOV).