PowerCenter
- PowerCenter 10.5.7
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
SUBJECT_AREA*
| VARCHAR2 (240)
| Folder name.
|
WORKFLOW_NAME*
| VARCHAR2 (240)
| Workflow name.
|
SCHEDULER_NAME*
| VARCHAR2 (240)
| Scheduler associated with the workflow.
|
START_TIME
| TIMESTAMP
| Start time configured for the scheduler.
|
END_TIME
| TIMESTAMP
| End time configured for the scheduler.
|
IS_RUN_ON_LIMIT
| NUMBER
| Object ID used for cyclic redundancy check (CRC).
|
RUN_OPTIONS
| INTEGER
| The workflow schedule type. Records the following values for each schedule type:
1 = Run on demand.
2 = Run once.
4 = Run every DELTA_VALUE seconds.
8 = Customized repeat.
16 = Run on Integration Service initialization.
18 = Run on Integration Service initialization and run once.
20 = Run on Integration Service initialization and every DELTA_VALUE seconds.
24 = Run on Integration Service initialization and customized repeat.
32 = Run continuously.
|
END_OPTIONS
| INTEGER
| The stop condition option for the workflow schedule type. Records the following values for each stop condition option:
0 = End on a date.
1 = End after the number of runs stored in RUN_COUNT.
2 = Run forever.
|
DELTA_VALUE
| NUMBER
| Number of seconds the Integration Service waits between successive workflow runs.
|
RUN_COUNT
| INTEGER
| Number of times the Integration Service runs the workflow before stopping the workflow.
|
SCHEDULER_ID*
| NUMBER
| Scheduler ID.
|
SCHEDULER_IS_REUSABLE
| NUMBER
| Specifies if scheduler is reusable.
|
SCHEDULER_COMMENTS
| VARCHAR2 (2000)
| Scheduler description.
|
SCHEDULER_VERSION_NUMBER*
| NUMBER
| Version number of the scheduler.
|
WORKFLOW_VERSION_NUMBER*
| NUMBER
| Workflow version number.
|
WORKFLOW_ID*
| NUMBER
| Workflow ID.
|
WORKFLOW_IS_VALID
| NUMBER
| Specifies whether the workflow is valid or not.
1 = valid; 0 = invalid.
|
WORFLOW_IS_SERVICE
| NUMBER
| Specifies whether the workflow is a service.
1 = service; 0 = not a service.
|
WORKFLOW_IS_RUNNABLE_SERVICE
| NUMBER
| Specifies whether the workflow is a runnable service.
1 = runnable service; 0 = not a runnable service.
|
WORKFLOW_LAST_SAVED
| VARCHAR2 (30)
| Date and time when the workflow was last saved.
|
WORKFLOW_COMMENTS
| VARCHAR2 (2000)
| Description of the workflow.
|
SUBJECT_ID*
| NUMBER
| Folder ID.
|
SERVER_NAME
| VARCHAR2 (240)
| Name of the Integration Service registered with the repository.
|
SERVER_ID
| NUMBER
| Integration Service ID.
|
WORKFLOW_IS_IMPACTED
| NUMBER
| Specifies whether the workflow is impacted by a change to dependent objects that may require the workflow to be revalidated.
0 = not impacted; 1 = impacted.
|
*Indicates that the column is a key column.
|