PowerCenter
- PowerCenter 10.5.6
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
COLUMN_NAME
| VARCHAR2 (240)
| Field name.
|
COLUMN_BUSNAME
| VARCHAR2 (240)
| Business name of the field.
|
COLUMN_ID*
| INTEGER
| Field ID (primary key).
|
SUBJECT_AREA*
| VARCHAR2 (240)
| Folder name.
|
TABLE_ID
| INTEGER
| Source table ID.
|
TABLE_NAME
| VARCHAR2 (240)
| Table name.
|
TABLE_BUSNAME
| VARCHAR2 (240)
| Business name of the table.
|
COLUMN_NUMBER
| INTEGER
| Order number of the column.
|
COLUMN_DESCRIPTION
| VARCHAR2 (2000)
| Description of the column.
|
KEY_TYPE
| VARCHAR2 (50)
| Key type for this column.
|
SOURCE_TYPE
| VARCHAR2 (40)
| Data type for this column.
|
DATA_PRECISION
| INTEGER
| Decimal precision for numeric fields or field length for CHAR fields.
|
DATA_SCALE
| INTEGER
| Decimal scale for numeric fields.
|
NEXT_COLUMN_ID
| INTEGER
| Link to next field in source table.
|
VERSION_ID
| INTEGER
| Folder version ID.
|
VERSION_NAME
| VARCHAR2 (240)
| Folder version name.
|
SOURCE_VERSION_NUMBER
| NUMBER
| Source version number.
|
*Indicates that the column is a key column.
|