Specifying procedure parameters

This page allows you to create/modify the parameters associated with the population procedure. The parameter name and parameter type can be assigned to a population procedure for entering user-specific values later.

Select the “Specify Procedure Parameters” link in the “Define View” page.

The “Specify Procedure Parameters” page appears.

The system displays the following fields:

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 either “Public” or “Private”.
Procedure Name	The name of the population procedure defined for the view.

Enter the following:

Help On Parameter Value - SP Name

The name of the stored procedure (Alphanumeric, 255). This procedure will be used for providing help in “Dynamic Filters” page.

Enter the following fields in the “Procedure Parameters” multiline:

Parameter Display Name	The parameter name to be displayed in the ”Inquiries” activity (Alphanumeric, 255).
Parameter Name	The parameter name of the population procedure (Alphanumeric, 255). This is used to receive user-specific inputs for the procedure.
Parameter Type	Use the drop-down list box to select the data type of the parameter. The system lists the options “Character”, “Integer”, “Numeric”, “Date-Time”, “Date” and “Time”. One of the parameter types must be assigned to the parameter name.
Mandatory	Use the drop-down list box to specify whether the parameter is mandatory or not. The system lists the options “Yes” and “No”.

Check the box in the “Select” column of the multiline to mark the record for deletion.
Click the Delete icon in the tool bar above the multiline to delete the selected record.
Click the “Save” pushbutton to save the details of the parameters associated with the procedure.