eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_EN_ELGB_OVR_STEP_V

Object Details

Object Name:	IGS_EN_ELGB_OVR_STEP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_ELGB_OVR_STEP_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Describes the Enrollment Category Eligibility Validation Override step Details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Rowid.
ELGB_OVR_STEP_ID	NUMBER	(15)	Yes	Unique Identifier for the Eligibility Override step.
ELGB_OVERRIDE_ID	NUMBER	(15)	Yes	Unique Identifier for the Eligibility Override information.
UNIT_CD	VARCHAR2	(0)		Unit Code for which the override applied
VERSION_NUMBER	NUMBER			Unit Version Number for which the override ap -Obsoleteplied
TITLE	VARCHAR2	(0)		Title -Obsolete
UOO_ID	NUMBER			Unique Identifier of Organization. -Obsolete
US_UNIT_CD	VARCHAR2	(0)		Unique identifier of the unit being offered.
US_VERSION_NUMBER	NUMBER			Version number of the unit. Students are normally enrolled in the current version. Prior versions are end-dated. -Obsolete
US_TITLE	VARCHAR2	(0)		Title of the unit. -Obsolete
US_CAL_TYPE	VARCHAR2	(0)		Name of a type calendar used within the institution. For example, ACAD-YR, SEM-1, LOAD-1. -Obsolete
US_CI_SEQUENCE_NUMBER	NUMBER			Unique identifier of the calendar instance
US_CI_START_DATE	DATE			Start date of calendar instance. -Obsolete
US_CI_END_DATE	DATE			End date of calendar instance. -Obsolete
US_ALTERNATE_CODE	VARCHAR2	(0)		Alternate short reference code for identifying a calendar instance. Alternate codes are mandatory for academic, admission progression, and teaching calendars. The code is used to facilitate mass keying of enrolments, unit and course offerings and is displayed in relevant forms and reports. -Obsolete
US_LOCATION_CD	VARCHAR2	(0)		Institution-defined location code, typically of a campus, at that a unit offering option is offered. -Obsolete
US_UNIT_CLASS	VARCHAR2	(0)		Institution-defined code that identifies a unit class. -Obsolete
US_CALL_NUMBER	NUMBER			Unique identifier needed to support Interactive Voice Response registration. -Obsolete
STEP_OVERRIDE_TYPE	VARCHAR2	(80)	Yes	The Eligibility step type override.
STEP_OVR_TYPE_MEANING	VARCHAR2	(80)	Yes	The over type meaning.
STEP_GROUP_TYPE	VARCHAR2	(10)		The type of step group.
STEP_OVERRIDE_DT	DATE		Yes	The date on which the override is applied.
STEP_OVERRIDE_LIMIT	NUMBER	(5)		The override credit point limit if applicable.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ELGB_OVR_STEP_ID
,      ELGB_OVERRIDE_ID
,      UNIT_CD
,      VERSION_NUMBER
,      TITLE
,      UOO_ID
,      US_UNIT_CD
,      US_VERSION_NUMBER
,      US_TITLE
,      US_CAL_TYPE
,      US_CI_SEQUENCE_NUMBER
,      US_CI_START_DATE
,      US_CI_END_DATE
,      US_ALTERNATE_CODE
,      US_LOCATION_CD
,      US_UNIT_CLASS
,      US_CALL_NUMBER
,      STEP_OVERRIDE_TYPE
,      STEP_OVR_TYPE_MEANING
,      STEP_GROUP_TYPE
,      STEP_OVERRIDE_DT
,      STEP_OVERRIDE_LIMIT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_ELGB_OVR_STEP_V;

Dependencies

[top of page]

APPS.IGS_EN_ELGB_OVR_STEP_V references the following:

APPS: IGS_EN_ELGB_OVR_STEP; IGS_LOOKUPS_VIEW

APPS.IGS_EN_ELGB_OVR_STEP_V is not referenced by any database object