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. MX Views Reference
  17. PowerCenter Reports Reference

Repository Guide

Repository Guide

REP_TASK_INST

REP_TASK_INST

This view displays all task instances within workflows and worklets.
The following table lists task instance information in the REP_TASK_INST view:
Column Name
Datatype
Description
WORKFLOW_ID*
NUMBER
Workflow ID (primary key).
INSTANCE_ID*
NUMBER
Instance ID (primary key).
TASK_ID*
NUMBER
Task ID.
TASK_TYPE
NUMBER
Task type.
TASK_TYPE_NAME
VARCHAR2 (240)
Name of the object.
INSTANCE_NAME
VARCHAR2 (240)
Name of the instance.
IS_ENABLED
NUMBER
Specifies whether the task instance is enabled.
DESCRIPTION
VARCHAR2 (2000)
Description of the task.
IS_VALID
NUMBER
Specifies whether the task is valid. 0 = invalid;
1 = valid.
VERSION_NUMBER*
NUMBER
Workflow version number.
SERVER_ID*
NUMBER
Server ID associated with the workflow.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!