PowerCenter
- PowerCenter 10.5
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
PARENT_SUBJECT_AREA
| VARCHAR2 (240)
| Parent folder name.
|
PARENT_SUBJECT_ID*
| NUMBER
| Parent folder ID.
|
PARENT_SOURCE_NAME
| VARCHAR2 (240)
| Parent source name.
|
PARENT_SOURCE_BUSINESS_NAME
| VARCHAR2 (240)
| Business name of the parent source.
|
PARENT_SOURCE_ID*
| NUMBER
| Parent source ID.
|
PARENT_SOURCE_DESCRIPTION
| VARCHAR2 (2000)
| Description of the parent source.
|
PARENT_SOURCE_VERSION_NUMBER*
| NUMBER
| Version number of the parent source.
|
PARENT_SOURCE_VERSION_STATUS
| NUMBER
| Status of the parent source version.
|
PARENT_SOURCE_UTC_CHECKIN
| NUMBER
| UTC time when the parent source was checked in.
|
PARENT_SOURCE_UTC_LAST_SAVED
| NUMBER
| UTC time when the parent source was last saved.
|
PARENT_SOURCE_LAST_SAVED
| VARCHAR2 (30)
| Time when the parent source was last saved.
|
PARENT_SOURCE_TYPE
| NUMBER
| Source type such as relational database or flat file.
|
PARENT_SOURCE_DATABASE_NAME
| VARCHAR2 (240)
| Database name of the parent source.
|
PARENT_SOURCE_DATABASE_TYPE
| VARCHAR2 (50)
| Database type of the parent source.
|
SUBJECT_AREA
| VARCHAR2 (240)
| Folder name.
|
SUBJECT_ID*
| NUMBER
| Folder ID.
|
SOURCE_NAME
| VARCHAR2 (240)
| Source name.
|
SOURCE_ID*
| NUMBER
| Source ID.
|
SOURCE_DESCRIPTION
| VARCHAR2 (2000)
| Source description.
|
SOURCE_VERSION_NUMBER*
| NUMBER
| Source version number.
|
SOURCE_VERSION_STATUS
| NUMBER
| Specifies whether the source version is active or has been deleted.
|
SOURCE_UTC_CHECKIN
| NUMBER
| UTC time when the source was last checked in.
|
SOURCT_UTC_LAST_SAVED
| NUMBER
| UTC time when the source was last saved.
|
SOURCE_LAST_SAVED
| VARCHAR2 (30)
| Time when the source was last saved.
|
SOURCE_DATABASE_NAME
| VARCHAR2 (240)
| Name of the database for the source.
|
SOURCE_FIELD_NAME
| VARCHAR2 (240)
| Source field name.
|
SOURCE_FIELD_BUSINESS_NAME
| VARCHAR2 (240)
| Business name of the source field.
|
SOURCE_FIELD_ID*
| NUMBER
| ID of the source field (primary key).
|
SOURCE_FIELD_DESCRIPTION
| VARCHAR2 (2000)
| Description of the source field.
|
SOURCE_FIELD_NUMBER
| NUMBER
| Source field number.
|
SOURCE_FIELD_NEXT_FIELD_ID*
| NUMBER
| ID of the field that follows the current field.
|
SOURCE_FIELD_LEVEL
| NUMBER
| Field level number for non-relational sources.
|
SOURCE_FIELD_PICTURE_TEXT
| VARCHAR2 (240)
| Picture text that a COBOL source uses. Null for relational sources.
|
SOURCE_FIELD_OCCURS_TIME
| NUMBER
| Number of time that the field (or record) occurs in the source.
|
SOURCE_FIELD_REDEFINES_FIELD
| VARCHAR2 (240)
| Identifies the field/record that this field/record redefines.
|
SOURCE_FIELD_DISPLAY_OFFSET
| NUMBER
| Offset of this field within the source.
|
SOURCE_FIELD_DISPLAY_LENGTH
| NUMBER
| Display field length.
|
SOURCE_FIELD_PHYSICAL_OFFSET
| NUMBER
| Offset of this field within this FD.
|
SOURCE_FIELD_PHYSICAL_LENGTH
| NUMBER
| Physical field length.
|
SOURCE_FIELD_CHILD_FIELD_ID*
| NUMBER
| The next child, if any, for a non-relational COBOL source.
|
SOURCE_FIELD_KEY_TYPE
| VARCHAR2 (50)
| Specifies whether the source field key is a primary key or a foreign key.
|
SOURCE_FIELD_DATATYPE
| VARCHAR2 (40)
| Field datatype.
|
SOURCE_FIELD_PRECISION
| NUMBER
| Length or precision for the field.
|
SOURCE_FIELD_SCALE
| NUMBER
| Scale for the field.
|
SOURCE_FIELD_PIC_USAGE_NAME
| NUMBER
| Source field picture usage name.
|
SOURCE_FIELD_NULLTYPE
| NUMBER
| Specifies whether nulls are allowed.
0= nulls allowed; 1 = nulls not allowed.
|
REPOSITORY_NAME
| VARCHAR2 (240)
| Repository name.
|
IS_SHORTCUT
| NUMBER
| Specifies whether the source is a shortcut.
1 = shortcut; 0 = not a shortcut.
|
IS_GLOBAL_SHORTCUT
| NUMBER
| Specifies whether the source is a global shortcut.
1 = shortcut; 0 = not a shortcut.
|
*Indicates that the column is a key column.
|