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]

TABLE: IGS.IGS_EN_DCNT_REASONCD_ALL

Object Details

Object Name:	IGS_EN_DCNT_REASONCD_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_EN_DCNT_REASONCD_ALL
Subobject Name:
Status:	VALID

IGS_EN_DCNT_REASONCD_ALL describes the available list of reasons as to why a student's program attempt is to be discontinued. For example, Non payment of fees, Voluntary withdrawal, No tax file number specified.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_DCNT_REASONCD_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISCONTINUATION_REASON_CD

Columns

Name	Datatype	Length	Mandatory	Comments
DISCONTINUATION_REASON_CD	VARCHAR2	(10)	Yes	Identifies the reason for the discontinuation of the student program attempt.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes the reason for the discontinuation of the student program attempt.
DFLT_IND	VARCHAR2	(1)	Yes	Indicator that 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 program attempt discontinuations.
S_DISCONTINUATION_REASON_TYPE	VARCHAR2	(30)		Identifies the system-defined reason type for the discontinuation of the student program attempt. For example 'TRANSFER' is used where a student program attempt is discontinued by the program transfer process.
SYS_DFLT_IND	VARCHAR2	(1)	Yes	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.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the discontinuation reason is open or closed. Setting the checkbox to 'closed' prevents use of the discontinuation reason in new or modified student course attempt discontinuation records.
COMMENTS	VARCHAR2	(2000)		Text-based facility for entering additional information or details about the discontinuation reason code.
DCNT_PROGRAM_IND	VARCHAR2	(1)		Indicator that identifies the corresponding discontinuation reason code applicable to a program. A discontinuation reason is applicable to a program if this is selected.
DCNT_UNIT_IND	VARCHAR2	(1)		Indicator that identifies the corresponding discontinuation reason code applicable to a unit in general. A discontinuation reason is applicable to a unit if this is selected.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT DISCONTINUATION_REASON_CD
,      DESCRIPTION
,      DFLT_IND
,      S_DISCONTINUATION_REASON_TYPE
,      SYS_DFLT_IND
,      CLOSED_IND
,      COMMENTS
,      DCNT_PROGRAM_IND
,      DCNT_UNIT_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_EN_DCNT_REASONCD_ALL;

Dependencies

[top of page]

IGS.IGS_EN_DCNT_REASONCD_ALL does not reference any database object

IGS.IGS_EN_DCNT_REASONCD_ALL is referenced by following:

APPS: IGS_EN_DCNT_REASONCD_ALL