Repository Guide

Back Next

REP_SRC_FILE_FLDS and REP_SEG_FLDS

These views provide access to the fields in a non-relational source. Each field is contained in the scanned tables listed in the REP_SEG_FLDS view.

The following table lists source field information in the REP_SRC_FILE_FLDS and REP_SEG_FLDS views:

Column Name	Datatype	Description
FIELD_ID	INTEGER	Field ID (primary key)
SUBJECT_AREA	VARCHAR2 (240)	Folder name.
FILE_ID	INTEGER	Source ID (primary key).
FIELD_NAME	VARCHAR2 (240)	Field name.
FIELD_LEVEL	NUMBER	Field level (for example, 01 and 02).
FIELD_NUMBER	NUMBER	Order number of the field.
FIELD_DESCRIPTION	VARCHAR2 (2000)	Comments for this field.
PICTURE_TEXT	VARCHAR2 (240)	PIC clause.
OCCURS	NUMBER	Number of OCCURS.
REDEFINES_FIELD	VARCHAR2 (240)	Redefines this field.
KEY_TYPE	NUMBER	Key type. 1 = primary key; 0 = not a key.
DISPLAY_OFFSET	NUMBER	Offset using display length.
DISPLAY_LENGTH	NUMBER	Display length.
PHYSICAL_OFFSET	NUMBER	Physical offset.
PHYSICAL_LENGTH	NUMBER	Physical length.
USAGE_TYPE	VARCHAR2 (240)	COMP type (binary compressed fields).
DATA_PRECISION	NUMBER	Decimal precision for numeric fields or field length for CHAR fields.
DATA_SCALE	NUMBER	Decimal scale for numeric fields.
CHILD_ID	NUMBER	Link to child field if this is a group item.
SIBLING_ID	NUMBER	Link to next field at this level.
VERSION_ID	NUMBER	Link to next field at this level.
SRC_VERSION_NUMBER	NUMBER	Version number of the source.