PowerCenter
- PowerCenter 10.5.1
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
PARENT_SUBJECT_AREA
| VARCHAR2 (240)
| Folder name.
|
PARENT_SUBJECT_ID*
| NUMBER
| Folder ID.
|
PARENT_TARGET_NAME
| VARCHAR2 (240)
| Name of parent target.
|
PARENT_TARGET_BUSINESS_NAME
| VARCHAR2 (2000)
| Business name of the parent target.
|
PARENT_TARGET_ID*
| NUMBER
| Parent target ID.
|
PARENT_TARGET_DESCRIPTION
| VARCHAR2 (2000)
| Description of parent target.
|
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 last checked in.
|
PARENT_TARGET_UTC_LAST_SAVED
| NUMBER
| UTC time when the parent target was last saved.
|
PARENT_TARGET_LAST_SAVED
| VARCHAR2 (30)
| Time when the parent target was last modified.
|
PARENT_TARGET_FILE_ID*
| NUMBER
| ID of parent target file.
|
PARENT_TARGET_DATABASE_TYPE
| VARCHAR2 (50)
| Database type of 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 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 target was last saved.
|
TARGET_FIELD_NAME
| VARCHAR2 (240)
| Target field name.
|
TARGET_FIELD_BUSINESS_NAME
| VARCHAR2 (240)
| Business name of target field.
|
TARGET_FIELD_ID*
| NUMBER
| Target field ID.
|
TARGET_FIELD_DESCRIPTION
| VARCHAR2 (2000)
| Description of target field.
|
TARGET_FIELD_NUMBER
| VARCHAR2 (240)
| Target field number.
|
TARGET_FIELD_NEXT_FIELD_ID*
| NUMBER
| ID of the next field in target.
|
TARGET_FIELD_PICTURE_TEXT
| VARCHAR2 (240)
| Picture text that COBOL sources use.
|
TARGET_FIELD_IS_NULLABLE
| NUMBER
| Specifies whether target field is null.
0 = Null; 1 = Not Null.
|
TARGET_FIELD_SOURCE_FIELD_ID*
| NUMBER
| Link to source from which this field was created.
|
TARGET_FIELD_KEY_TYPE
| NUMBER
| Key type of target field.
|
TARGET_FIELD_DATATYPE
| VARCHAR2 (240)
| Datatype of target field.
|
TARGET_FIELD_DATATYPE_GROUP
| CHAR (1)
| Datatype group codes.
B = Binary and Bit
C = Character, String, Text, and Byte
D = Date
N = Numeric and Money
|
TARGET_FIELD_PRECISION
| NUMBER
| Precision for target field.
|
TARGET_FIELD_SCALE
| NUMBER
| Scale for target field.
|
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.
|