Repository Guide

Back Next

REP_LOAD_SESSIONS

This view provides information about sessions in the repository.

The following table lists session information in the REP_LOAD_SESSIONS view:

Column Name	Datatype	Description
SUBJECT_AREA*	VARCHAR2 (240)	Folder name.
SESSION_NAME	VARCHAR2 (240)	Name of the session.
LAST_SAVED	VARCHAR2 (240)	Time the session was last saved.
SESSION_ID*	NUMBER	Session ID.
MAPPING_NAME*	VARCHAR2 (240)	Name of the mapping this session uses.
VERSION_ID	NUMBER	Folder version ID.
VERSION_NAME	VARCHAR2 (240)	Folder version name.
IS_ACTIVE	NUMBER	Specifies whether the session is active.
STARTTIME	VARCHAR2 (240)	Session start time.
SESS_INTERVAL	NUMBER	Session interval.
REPEAT_COUNT	NUMBER	Repeat count.
SESSION_LOG_FILE	VARCHAR2 (240)	Session log file name.
BAD_FILE_LOCATION	VARCHAR2 (240)	Location of the reject file.
TARGET_ID	NUMBER	Target ID.
SOURCE_ID	NUMBER	Source ID.
SESSION_VERSION_NUMBER	NUMBER	Version number of the session.
MAPPING_VERSION_NUMBER	NUMBER	Version number of the mapping.
SUBJECT_ID*	NUMBER	Folder ID.
IS_VALID	NUMBER	Specifies whether the session is valid or not. 0 = invalid; 1 = valid.
IS_REUSABLE	NUMBER	Specifies whether the session is reusable or not. 0 = not reusable; 1= reusable.
COMMENTS	VARCHAR2 (2000)	Description of the session.
MAPPING_ID	NUMBER	Sequence ID for the mapping associated with the session.
IS_IMPACTED	NUMBER	Specifies whether the session is impacted by a change to dependent objects that may require the session to be revalidated. 0 = not impacted; 1 = impacted.
*Indicates that the column is a key column.