Repository Guide

Back Next

REP_TARG_TBL_COLS

This view provides the properties of columns defined for the target tables in a data warehouse or data mart.

The following table lists target table column properties for the REP_TARG_TBL_COLS view:

Column Name	Datatype	Description
SUBJECT_AREA*	VARCHAR2 (240)	Folder name.
TABLE_NAME*	VARCHAR2 (240)	Table this column belongs to.
TABLE_BUSNAME	VARCHAR2 (240)	Business name of the table.
COLUMN_NAME	VARCHAR2 (240)	Column name.
COLUMN_BUSNAME	VARCHAR2 (240)	Business name of this column.
COLUMN_NUMBER	INTEGER	Order number of the column.
COLUMN_ID*	INTEGER	Column ID (primary key).
VERSION_ID	INTEGER	Folder version ID.
VERSION_NAME*	VARCHAR2 (240)	Folder version name.
DESCRIPTION	VARCHAR2 (2000)	Column description.
COLUMN_KEYTYPE	VARCHAR2 (50)	Primary Key, Not a Key, Foreign Key, Primary and Foreign Key.
DATA_TYPE	VARCHAR2 (40)	Native database datatype.
DATA_TYPE_GROUP	CHAR (1)	Datatype group. C = Character D = Date N = Numeric
DATA_PRECISION	INTEGER	Decimal precision for numeric fields or field length for CHAR fields.
DATA_SCALE	INTEGER	Decimal scale for numeric columns.
NEXT_COLUMN_ID	INTEGER	Link to next column.
IS_NULLABLE	INTEGER	Whether NULLs are accepted.
SOURCE_COLUMN_ID	INTEGER	Link to source this column was created from.
TARGET_VERSION_NUMBER	NUMBER	Target version number.
*Indicates that the column is a key column.