Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference

Repository Guide

Repository Guide

REP_WFLOW_VAR

REP_WFLOW_VAR

This view displays a list of all variables declared within a workflow or worklet.
The following table lists variable information in the REP_WFLOW_VAR view:
Column Name
Datatype
Description
SUBJECT_ID*
NUMBER
Folder ID.
WORKFLOW_ID*
NUMBER
Workflow ID (primary key).
VARIABLE_ID*
NUMBER
Unique ID for a variable within a workflow (primary key).
VARIABLE_NAME
VARCHAR2 (240)
Name of the variable.
VARIABLE_TYPE
NUMBER
Variable type. 0 = built in; 1 = user-defined.
VARIABLE_DESCRIPTION
VARCHAR2 (2000)
Comments on the variable.
VARIABLE_DATATYPE
NUMBER
Datatype of a workflow variable.
3 = decimal
4 = integer
5 = small integer
7 = real
8 = double
11 = date/time
12 = string
VARIABLE_DEFAULT_VALUE
VARCHAR2 (2000)
Default value of a variable.
LAST_SAVED
VARCHAR2 (30)
Date and time that this task was last saved.
TASK_INST_ID*
NUMBER
ID of the instance where the variable is defined.
TASK_INST_NAME
VARCHAR2 (240)
Name of the task instance.
BIT_OPTIONS
NUMBER
Specifies whether the workflow variable is null or persistent. 1 = workflow variable is persistent;
2 = workflow variable is NULL.
VERSION_NUMBER*
NUMBER
Workflow version number.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!