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_DCNT_REASONCD_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)
DISCONTINUATION_REASON_CD	VARCHAR2	(10)	A code that identifies the reason for the discontinuation of the student course attempt.
DESCRIPTION	VARCHAR2	(60)	Describes the reason for the discontinuation of the student course attempt.
DFLT_IND	VARCHAR2	(1)	An indicator which specifies whether the discontinuation reason code is the default reason. Setting the indicator will make the reason code appear as the default reason for all student course attempt discontinuations.
CLOSED_IND	VARCHAR2	(1)	An indicator which specifies whether the discontinuation reason is open or closed. Setting the checkbox to 'closed' ticked preventsuse of the discontinuation reason in new or modified student course attempt discontinuation records.
S_DISCONTINUATION_REASON_TYPE	VARCHAR2	(30)	Identifies the system-defined reason type for the discontinuation of the student course attempt. For example 'TRANSFER' is used where a student course attempt is discontinued by the course transfer process.
MEANING	VARCHAR2	(80)
DSP_CLOSED_IND	VARCHAR2	(1)	This is a flag for determining if the Lookup Type is closed
SYS_DFLT_IND	VARCHAR2	(1)	Indicates the institution-defined discontinuation reason code that will be used by system functionality to automatically set the reason code from a system-defined discontinuation reason type mapping.Only one discontinuation reason code can be defined as a systemdefault for a system discontinuation reason type.
COMMENTS	VARCHAR2	(2000)	A text-based facility for recording additional information ordetails about the discontinuation reason code.
DCNT_PROGRAM_IND	VARCHAR2	(1)	An indicator which identifies the corresponding discontinuation reason code applicable to a course. A discontinuation reason is applicable to a course if this is selected checked .
DCNT_UNIT_IND	VARCHAR2	(1)	An indicator which identifies the corresponding discontinuation reason code applicable to a unit in general. A discontinuation reason is applicable to a unit if this is selected checked.
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
LAST_UPDATE_DATE	DATE		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
,      DISCONTINUATION_REASON_CD
,      DESCRIPTION
,      DFLT_IND
,      CLOSED_IND
,      S_DISCONTINUATION_REASON_TYPE
,      MEANING
,      DSP_CLOSED_IND
,      SYS_DFLT_IND
,      COMMENTS
,      DCNT_PROGRAM_IND
,      DCNT_UNIT_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_DCNT_REASONCD_V;

Dependencies

[top of page]

APPS.IGS_EN_DCNT_REASONCD_V references the following:

APPS: IGS_EN_DCNT_REASONCD; IGS_LOOKUPS_VIEW

APPS.IGS_EN_DCNT_REASONCD_V is referenced by following:

APPS: IGS_EN_VAL_DR - show dependent code; IGS_FI_PRC_DISC_SUA - show dependent code; IGS_FI_PRC_DISC_SUA - show dependent code