PowerCenter
- PowerCenter 10.5.7
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
PARENT_SUBJECT_AREA
| VARCHAR2 (240)
| Parent folder name.
|
PARENT_SUBJECT_ID*
| NUMBER
| Folder ID.
|
PARENT_TARGET_NAME
| VARCHAR2 (240)
| Target name.
|
PARENT_TARGET_BUSINESS_NAME
| VARCHAR2 (240)
| Business name for the target.
|
PARENT_TARGET_ID*
| NUMBER
| Target ID (primary key).
|
PARENT_TARGET_DESCRIPTION
| VARCHAR2 (2000)
| Target description.
|
PARENT_TARGET_VERSION_NUMBER*
| NUMBER
| Target version number.
|
PARENT_TARGET_VERSION_STATUS
| NUMBER
| Status of the parent target version.
|
PARENT_TARGET_UTC_CHECKIN
| NUMBER
| UTC time (Coordinated Universal Time) when the parent target was checked in.
|
PARENT_TARGET_UTC_LAST_SAVED
| NUMBER
| UTC time when the target was last saved.
|
PARENT_TARGET_LAST_SAVED
| VARCHAR2 (30)
| Time when the target was last saved.
|
PARENT_TARGET_FIRST_FIELD_ID*
| VARCHAR2
| Link to first field of this table.
|
PARENT_TARGET_CONSTRAINT
| VARCHAR2 (2000)
| User-specified constraint string used when the DDL is generated.
|
PARENT_TARGET_CREATE_OPTIONS
| VARCHAR2 (2000)
| Options for use when generating DDL.
|
PARENT_TARGET_FIRST_INDEX_ID*
| NUMBER
| Link to first field of this table.
|
PARENT_TARGET_FILE_ID
| NUMBER
| ID for the parent target file.
|
PARENT_TARGET_DATABASE_TYPE
| VARCHAR2 (50)
| Database type for the parent target.
|
SUBJECT_AREA
| VARCHAR2 (240)
| Folder name.
|
SUBJECT_ID*
| NUMBER
| Folder ID.
|
TARGET_NAME
| VARCHAR2 (240)
| Target name.
|
TARGET_ID*
| NUMBER
| Target ID.
|
TARGET_DESCRIPTION
| VARCHAR2 (2000)
| Target description.
|
TARGET_VERSION_NUMBER*
| NUMBER
| Target version number.
|
TARGET_VERSION_STATUS
| NUMBER
| Status of the target version.
|
TARGET_UTC_CHECKIN
| NUMBER
| UTC time (Coordinated Universal Time) when the target was last checked in.
|
TARGET_UTC_LAST_SAVED
| NUMBER
| UTC time when the target was last saved.
|
TARGET_LAST_SAVED
| VARCHAR2 (30)
| Time when the target was last saved.
|
REPOSITORY_NAME
| VARCHAR2 (240)
| Repository name.
|
IS_SHORTCUT
| NUMBER
| Specifies whether the target is a shortcut.
1 = shortcut; 0 = not a shortcut.
|
IS_GLOBAL_SHORTCUT
| NUMBER
| Specifies whether the target is a global shortcut.
1 = shortcut; 0 = not a shortcut.
|
*Indicates that the column is a key column.
|