PowerCenter
- PowerCenter 10.5.1
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
DEP_GROUP_ID*
| NUMBER
| Deployment group ID.
|
DEP_GROUP_NAME
| VARCHAR2 (240)
| Deployment group name.
|
DESCRIPTION
| VARCHAR2 (2000)
| Description of the group.
|
CREATED_BY
| VARCHAR2 (240)
| Name of user who created the deployment group.
|
OWNER_ID*
| NUMBER
| User ID.
|
GROUP_ID*
| NUMBER
| Group ID.
|
CREATION_TIME
| VARCHAR2 (30)
| Creation time.
|
LAST_SAVED
| VARCHAR2 (30)
| Last saved time.
|
GROUP_TYPE
| NUMBER
| Deployment group type. 0 = static; 1 = dynamic.
|
QUERY_ID*
| NUMBER
| Query ID associated with a dynamic group.
|
QUERY_NAME
| VARCHAR2 (240)
| Query name associated with a dynamic group.
|
QUERY_DESCRIPTION
| VARCHAR2 (2000)
| Query description.
|
QUERY_CREATED_BY
| VARCHAR2 (240)
| Name of user who created the query.
|
QUERY_OWNER_ID
| NUMBER
| Query user.
|
QUERY_GROUP_ID
| NUMBER
| Query group ID.
|
QUERY_CREATION_TIME
| VARCHAR2 (30)
| Query creation time.
|
QUERY_LAST_SAVED
| VARCHAR2 (30)
| Query last saved time.
|
QUERY_TYPE
| NUMBER
| Query type. 1 = public; 2 = personal.
|
*Indicates that the column is a key column.
|