rs_script_call_parameters

on-site-related topic

The following table lists the columns for the rs_script_call_parameters view. The equivalent jcs_script_call_parameters view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.

Column Datatype Description
OWNER VARCHAR2 The owner of the script
SCRIPT_NAME VARCHAR2 The name of the script
SCRIPT_ID NUMBER The ID of the script
STEP_NAME VARCHAR2 The name of the Step this call parameter belongs to
STEP_ID NUMBER The ID (sequence number) of the Step this call parameter belongs to
CALL_ID NUMBER The ID (sequence number) of the call this parameter belongs to
PARAMETER_ID VARCHAR2 OBSOLETE
PARAMETER_NAME VARCHAR2 The name of the called parameter
R_SCRIPT_ID NUMBER The ID of the called script
R_PARAMETER_ID NUMBER The ID of the called parameter
TYPE VARCHAR2 The type of definition for this parameter
EXPRESSION VARCHAR2 The actual expression when the type is EXPRESSION
CHAINED_STEP_ID NUMBER The referred Stepid when the type is CHAINVAL
CHAINED_STEP_NAME VARCHAR2 The referred name of the Step when the type is CHAINVAL
CHAINED_CALL_ID NUMBER The referred call (sequence number) when the type is CHAINVAL
CHAINED_SCRIPT_ID NUMBER The referred script ID when the type is CHAINVAL
CHAINED_PARAMETER_ID NUMBER The referred parameter ID when the type is CHAINVAL
CHAINED_PARAMETER_NAME VARCHAR2 The referred parameter name when the type is CHAINVAL
CHAIN_PARAMETER_ID NUMBER The referred parameter for Chain parameter references (by ID)
GROUPNAME VARCHAR2 The GUI name of the parameter group
VISUAL_ATTRIBUTES VARCHAR2 Attributes that can be used by the GUI to store representational data

Note: PARAMETER_ID: In version 7 this column was already deprecated and always empty. It still is.

Note: EXPRESSION: Expressions are now in REL instead of PL/SQL

Note: VISUAL_ATTRIBUTES: Version 9 does not have visual attributes anymore, therefore this column is always empty