Results for “discontinuation_reason_cd”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_EN_DCNT_REASONCD_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family, historically delivered as part of the Oracle Student System / Enterprise Enrollment module. In ETRM metadata for releases 12.1.1 and 12.2.2 the object is classified under IGS – Student System (Obsolete), and the metadata explicitly states that it is not implemented in the current database. Its single documented purpose is to consolidate the reasons that may be selected when a student discontinues a course or a unit.
The view exposes discontinuation reason codes together with their descriptive attributes, default indicators, closed indicators, program-level and unit-level applicability flags, and the lookup translation of the associated discontinuation reason type. Because it presents a denormalized, lookup-joined projection of the underlying reason code entity, it serves reporting, validation, and integration consumers that need a ready-to-read list of valid discontinuation reasons without re-implementing the lookup joins themselves. Like most IGS views, it is a read-only construct intended for query and reference rather than for direct DML.
Underlying Base Objects
The documented view text is defined over two objects:
- IGS_EN_DCNT_REASONCD — the primary base table holding reason code records, aliased DR. It supplies the reason code, description, default and system default indicators, closed indicator, reason type, comments, course/unit applicability flags, and standard WHO audit columns.
- IGS_LOOKUPS_VIEW — a lookup view aliased LKUPS, joined to IGS_EN_DCNT_REASONCD on the lookup code and restricted to LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE' and CLOSED_IND = 'N'.
The definition is a UNION of two branches. The first branch returns rows whose S_DISCONTINUATION_REASON_TYPE is not null and joins to the lookup view to populate MEANING and DSP_CLOSED_IND with the translated reason type and the lookup's closed indicator. The second branch returns rows where S_DISCONTINUATION_REASON_TYPE is null and substitutes TO_CHAR(NULL) for MEANING and DSP_CLOSED_IND. Rows are keyed by DR.ROWID as ROW_ID. The ETRM metadata documents no referenced base objects beyond these two, and no additional objects should be assumed.
Key Columns
- ROW_ID — the ROWID of the underlying IGS_EN_DCNT_REASONCD row; used as a surrogate row identifier.
- DISCONTINUATION_REASON_CD — the reason code identifier that answers the user's search term "discontinuation_reason_cd".
- DESCRIPTION — the user-facing description of the reason.
- DFLT_IND / SYS_DFLT_IND — flags marking the default and system default reason, respectively.
- CLOSED_IND — indicates whether the reason code itself is closed (inactive).
- S_DISCONTINUATION_REASON_TYPE — the lookup code classifying the reason type.
- MEANING / DSP_CLOSED_IND — the translated lookup meaning for the reason type and the lookup's closed indicator; both are null when the reason type is null.
- COMMENTS — free-text notes on the reason.
- DCNT_PROGRAM_IND / DCNT_UNIT_IND — flags indicating applicability to programs and to units.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns inherited from the base table.
Common Use Cases and Queries
Typical consumers use this view to populate LOVs, validate discontinuation input, and drive extracts for enrollment reporting. A simple listing of active reasons within a specific reason type can be produced with:
SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS_EN_DCNT_REASONCD_V WHERE CLOSED_IND = 'N' ORDER BY DESCRIPTION;SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS_EN_DCNT_REASONCD_V WHERE MEANING = :reason_type AND CLOSED_IND = 'N';SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS_EN_DCNT_REASONCD_V WHERE DFLT_IND = 'Y';
For program- or unit-specific validation, add predicates on DCNT_PROGRAM_IND and DCNT_UNIT_IND. Because the object is documented as obsolete and not implemented in the current database, these queries are meaningful only in environments where the IGS Student System schema objects remain deployed.
-
View: IGS_EN_DCNT_REASONCD_V 12.1.1
This view incorporates all the reasons that are available for a student to discontinue a course or unit.
APPS.IGS_EN_DCNT_REASONCD_V·↳ IGS_EN_DCNT_REASONCD·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
This entity describes the available list of reasons as to why a student's course attempt course is discontinued. Examples are Non payment of fees, Voluntary withdrawal, No tax file number specified.
-
View: IGS_PR_ACAD_PROGRAM_V 12.1.1
This view contains the details Student Program Attempts, containing statistics information including GPA and Credit Point figures.
APPS.IGS_PR_ACAD_PROGRAM_V·↳ IGS_CA_TEACH_TO_LOAD_V·↳ IGS_EN_DCNT_REASONCD_ALL·↳ IGS_EN_GEN_003·Explore IGS module →
-
View: IGS_PR_STDNT_PS_ATT_V 12.1.1
APPS.IGS_PR_STDNT_PS_ATT_V·↳ HZ_PARTIES·↳ IGS_EN_STDNT_PS_ATT_SV·Explore IGS module →
-
No longer used
APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V·↳ IGS_AS_SCAH_EFFECTIVE_H_V·↳ IGS_AU_GEN_003·↳ IGS_EN_GET_SCAEH_DTL·Explore IGS module →
-
View: IGS_EN_DCNT_REASONCD 12.1.1
This view lists out all the codes that are associated with a discontinuation reason.
APPS.IGS_EN_DCNT_REASONCD·↳ IGS_EN_DCNT_REASONCD_ALL·Explore IGS module →
-
View: IGS_AS_SC_ATTEMPT_H 12.1.1
This view is multi org view
APPS.IGS_AS_SC_ATTEMPT_H·↳ IGS_AS_SC_ATTEMPT_H_ALL·Explore IGS module →
-
This view describes and maintains the student course version of a specific program structure.
APPS.IGS_EN_STDNT_PS_ATT_CRV_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_LOOKUPS_VIEW·↳ IGS_PS_VER·Explore IGS module →
-
View: IGS_EN_STDNT_PS_ATT 12.1.1
This view contains the data of student attempts for a given specific program structure.
APPS.IGS_EN_STDNT_PS_ATT·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →
-
View: IGS_EN_PE_PRG_CTXT_V 12.1.1
This view holds the details of the program context information of a specific student. The information this view holds appears on each form where program units are described. This information is displayed as a context block.
APPS.IGS_EN_PE_PRG_CTXT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_EN_STDNT_PS_ATT_SV·Explore IGS module →
-
View: IGS_EN_STDNT_PS_ATT_SV 12.1.1
This view contains the secured rows in the student program attempt table.
APPS.IGS_EN_STDNT_PS_ATT_SV·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →
-
Used to create effective student program attempt history records in recognition of back dating commencement and discontinuation dates.
APPS.IGS_AS_SCAH_EFFECTIVE_H_V·↳ IGS_AS_SCA_H_V·↳ IGS_AU_GEN_003·↳ IGS_EN_GET_SCAEH_DTL·Explore IGS module →
-
View: IGS_EN_PS_ATT_CH_OPT_V 12.1.1
This view describes the change course option of an enrolled student which also takes course code, location and attempt status into consideration.
APPS.IGS_EN_PS_ATT_CH_OPT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_EN_STDNT_PS_ATT_SV·Explore IGS module →
-
View: IGS_AS_SCA_H_V 12.1.1
This view is used to merge student course attempt history with the current student course attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time peri
APPS.IGS_AS_SCA_H_V·↳ IGS_AS_SC_ATTEMPT_H·↳ IGS_AU_GEN_003·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →
-
View: IGS_AD_STDNT_PS_ATT_V 12.1.1
APPS.IGS_AD_STDNT_PS_ATT_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →
-
No longer used
APPS.IGS_FI_STDNT_PS_ATT_CAT_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_FI_F_CAT_CAL_REL·Explore IGS module →
-
Describes history of changes to student program attempt
-
View: IGS_EN_SCA_V 12.1.1
This view would be used in the form.
APPS.IGS_EN_SCA_V·↳ IGS_CA_INST·↳ IGS_EN_STDNT_PS_ATT_SV·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
Contains the Student Program Attempt (and Research Candidacy) information to be imported into the IGS_EN_STDNT_PS_ATT_ALL (and optionally IGS_RE_CANDIDATURE_ALL) table by the legacy data import process. Rows in this table must correspond t
-
This entity describes a student's attempt at studying a particular course offered by the university.
-
View: IGS_EN_DCNT_REASONCD_V 12.2.2
This view incorporates all the reasons that are available for a student to discontinue a course or unit.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_DCNT_REASONCD 12.2.2
This view lists out all the codes that are associated with a discontinuation reason.
Not implemented in this database·Explore IGS module →
-
View: IGS_PR_STDNT_PS_ATT_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_STDNT_PS_ATT_SV 12.2.2
This view contains the secured rows in the student program attempt table.
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_SC_ATTEMPT_H 12.2.2
This view is multi org view
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_STDNT_PS_ATT 12.2.2
This view contains the data of student attempts for a given specific program structure.
Not implemented in this database·Explore IGS module →
-
This entity describes the available list of reasons as to why a student's course attempt course is discontinued. Examples are Non payment of fees, Voluntary withdrawal, No tax file number specified.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_AS_SCA_H_V 12.1.1
-
Used to create effective student program attempt history records in recognition of back dating commencement and discontinuation dates.
Not implemented in this database·Explore IGS module →
-
No longer used
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_SCA_H_V 12.2.2
This view is used to merge student course attempt history with the current student course attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time peri
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_STDNT_PS_ATT_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_PS_ATT_CH_OPT_V 12.2.2
This view describes the change course option of an enrolled student which also takes course code, location and attempt status into consideration.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_PE_PRG_CTXT_V 12.2.2
This view holds the details of the program context information of a specific student. The information this view holds appears on each form where program units are described. This information is displayed as a context block.
Not implemented in this database·Explore IGS module →