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
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

REP_ALL_TASKS

REP_ALL_TASKS

This view provides a list of all reusable and non-reusable tasks that can be used by a workflow or a worklet.
The following table lists reusable and non-reusable task information in the REP_ALL_TASKS view:
Column Name
Datatype
Description
SUBJECT_AREA
VARCHAR2 (240)
Folder name.
SUBJECT_ID*
NUMBER
Folder ID.
TASK_NAME
VARCHAR2 (240)
Task name.
TASK_ID*
NUMBER
Task ID.
IS_VALID
NUMBER
Specifies whether a workflow, worklet, or session is valid. 1 = valid; 0 = invalid.
LAST_SAVED
VARCHAR2 (30)
Time when task was last saved.
DESCRIPTION
VARCHAR2 (2000)
Description of the task.
VERSION_NUMBER*
NUMBER
Version number of the task.
IS_ENABLED
NUMBER
Specifies whether the task is enabled or not.
1 = enabled; 0 = disabled.
UTC_CHECKIN
NUMBER
UTC checkin time.
UTC_LAST_SAVED
VARCHAR2 (30)
UTC time when task was last saved.
IS_REUSABLE
NUMBER
Specifies whether the task is reusable or not. Values are: 1 = reusable; 0 = not reusable.
TASK_TYPE
NUMBER
Task type.
TASK_TYPE_NAME
VARCHAR2 (240)
Task type name.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!