Results for “dcnt_reason_cd”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_EN_SU_ATTEMPT_H is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It exposes historical student unit attempt records, providing a reporting and integration layer over the underlying attempt history table. The view implements the "student unit attempt" concept for historical data, which is distinct from the current, transactional attempt data. In the ETRM 12.1.1 and 12.2.2 documentation, the object carries a VALID status, confirming it is a supported and active database object.
The view is important because it enforces multi-organization (multi-tenant/ORG_ID) security at the database level. Its defining WHERE clause uses USERENV('CLIENT_INFO') to derive the active organization context and filters rows to match that value, defaulting to -99 when no context exists. This makes the view the preferred access path for reports and concurrent programs that must respect the current operating unit or organization.
Underlying Base Objects
Per the ETRM metadata, the view is defined over a single base object: IGS_EN_SU_ATTEMPT_H_ALL. The _ALL suffix denotes the underlying table that stores records across all organizations, with ORG_ID as the partitioning/discriminating key. No other referenced base objects are documented in the ETRM record, though the view's column list indicates denormalized attributes (such as AUS_DESCRIPTION, ALTERNATIVE_TITLE, and ELO_DESCRIPTION) that are likely sourced directly from the _ALL table rather than joined at query time.
The relationship is therefore one of controlled projection: IGS_EN_SU_ATTEMPT_H_ALL holds the complete historical dataset, while IGS_EN_SU_ATTEMPT_H presents an organization-filtered subset. The view also synthesizes a ROW_ID column from the table's ROWID, and aliases UOO_ID explicitly, providing stable identifiers for downstream use.
Key Columns
- ORG_ID — Organization identifier driving the security predicate; central to multi-org filtering.
- PERSON_ID — The student (person) associated with the unit attempt.
- COURSE_CD, UNIT_CD, VERSION_NUMBER — Identify the course, unit, and version attempt.
- CAL_TYPE, CI_SEQUENCE_NUMBER — Calendar type and calendar instance sequence for the teaching period.
- HIST_START_DT, HIST_END_DT, HIST_WHO — Date-effective history tracking columns recording the validity window and the actor of each historical version.
- UNIT_ATTEMPT_STATUS, ADMINISTRATIVE_UNIT_STATUS, AUS_DESCRIPTION — Status indicators for the attempt and its administrative state.
- DCNT_REASON_CD — Reason code for discontinuation of the unit attempt; this is the column the user searched for. It captures why an attempt was discontinued and is commonly reported alongside DISCONTINUED_DT.
- DISCONTINUED_DT, RULE_WAIVED_DT, RULE_WAIVED_PERSON_ID — Discontinuation and rule-waiver tracking.
- NO_ASSESSMENT_IND, GRADING_SCHEMA_CODE — Assessment and grading configuration.
- OVERRIDE_* columns (ENROLLED_CP, EFTSU, ACHIEVABLE_CP, OUTCOME_DUE_DT, CREDIT_REASON) — Administrative overrides applied to credit and outcome values.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.
Common Use Cases and Queries
Typical scenarios include extracting discontinued unit attempts with their reasons, reconciling historical enrollment against the current attempt table, and feeding student-record integrations. Because the view is organization-filtered, queries executed under a defined CLIENT_INFO context return only the relevant organization's data.
Sample query returning discontinuation detail:
SELECT person_id, course_cd, unit_cd, version_number, discontinued_dt, dcnt_reason_cdFROM apps.igs_en_su_attempt_hWHERE dcnt_reason_cd IS NOT NULLAND discontinued_dt BETWEEN :start_date AND :end_date;
A second common pattern aggregates attempts per organization:
SELECT org_id, unit_cd, COUNT(*) attempt_countFROM apps.igs_en_su_attempt_hWHERE unit_attempt_status = :statusGROUP BY org_id, unit_cd;
When using this view, note that the security predicate cannot be bypassed without altering the session context; callers requiring cross-organization data must query IGS_EN_SU_ATTEMPT_H_ALL directly, subject to appropriate privileges.
-
View: IGS_EN_SU_ATTEMPT_H 12.1.1
IGS_EN_SU_ATTEMPT_H implements the student unit attempt.
APPS.IGS_EN_SU_ATTEMPT_H·↳ IGS_EN_SU_ATTEMPT_H_ALL·Explore IGS module →
-
View: IGS_EN_SU_ATTEMPT 12.1.1
Implements the student unit attempt.
APPS.IGS_EN_SU_ATTEMPT·↳ IGS_EN_SU_ATTEMPT_ALL·Explore IGS module →
-
View: IGS_EN_SUA_RULCHK_V 12.1.1
This view contains Unit Attempt records with failed unit rule details.
APPS.IGS_EN_SUA_RULCHK_V·↳ IGS_EN_SU_ATTEMPT_SV·↳ IGS_LOOKUP_VALUES·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →
-
This entity describes the history of changes made to a student unit attempt, including changes to status, location, class, etc.
-
View: IGS_EN_SU_ATTEMPT_SV 12.1.1
This view contains the secured rows in the student unit attempt table.
APPS.IGS_EN_SU_ATTEMPT_SV·↳ IGS_EN_SU_ATTEMPT_ALL·Explore IGS module →
-
View: IGS_AS_SUA_H_V 12.1.1
This view is used to merge student unit attempt history with the current student unit attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_AS_SUA_H_V·↳ HZ_PARTIES·↳ IGS_AU_GEN_003·↳ IGS_EN_SU_ATTEMPT·Explore IGS module →
-
View: IGS_EN_SUA_V 12.1.1
This view incorporates the student unit attempt record and its details such as the enrolled date, the administrative status unit associated with it and any discontinuation in the units and the corresponding reasons.
APPS.IGS_EN_SUA_V·↳ HZ_PARTIES·↳ IGS_CA_GEN_001·↳ IGS_EN_GEN_014·Explore IGS module →
-
View: IGS_EN_SUA_WLST_V 12.1.1
This view describes the data pertaining to the student unit attempt waitlist.
APPS.IGS_EN_SUA_WLST_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_EN_SU_ATTEMPT_SV·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →
-
Contains the Student Unit Attempt (and optionally outcome) information to be imported into the IGS_EN_SU_ATTEMPT_ALL (and optionally IGS_AS_SU_STMPTOUT_ALL) table by the legacy data import process. Rows in this table must correspond to a ba
-
This entity describes a student's attempt at studying a particular unit offered by the university. This table is modified to capture the Organizational unit code for the student finance requirements.
-
View: IGS_SS_EN_SUA_DTLS_V 12.1.1
It will display all the sections for the student
APPS.IGS_SS_EN_SUA_DTLS_V·↳ IGS_CA_INST·↳ IGS_EN_GEN_008·↳ IGS_EN_SU_ATTEMPT·Explore IGS module →
-
View: IGS_EN_SU_ATTEMPT_H 12.2.2
IGS_EN_SU_ATTEMPT_H implements the student unit attempt.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_SU_ATTEMPT_SV 12.2.2
This view contains the secured rows in the student unit attempt table.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_SU_ATTEMPT 12.2.2
Implements the student unit attempt.
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_SUA_H_V 12.2.2
This view is used to merge student unit attempt history with the current student unit attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_SUA_WLST_V 12.2.2
This view describes the data pertaining to the student unit attempt waitlist.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_AS_SUA_H_V 12.1.1
-
VIEW: APPS.IGS_EN_SU_ATTEMPT 12.1.1
-
View: IGS_EN_SUA_RULCHK_V 12.2.2
This view contains Unit Attempt records with failed unit rule details.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_SUA_V 12.2.2
This view incorporates the student unit attempt record and its details such as the enrolled date, the administrative status unit associated with it and any discontinuation in the units and the corresponding reasons.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_EN_SUA_WLST_V 12.1.1
-
VIEW: APPS.IGS_EN_SUA_V 12.1.1
-
VIEW: APPS.IGS_AS_SUA_H_V 12.1.1
-
View: IGS_SS_EN_SUA_DTLS_V 12.2.2
It will display all the sections for the student
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_EN_SUA_V 12.1.1
-
VIEW: APPS.IGS_EN_SUA_WLST_V 12.1.1
-
VIEW: APPS.IGS_EN_SU_ATTEMPT 12.1.1
-
Lookup Type: IGS_FI_LOCKBOX 12.1.1
Concurrent Log Parameter Column Titles
-
Lookup Type: IGS_FI_LOCKBOX 12.2.2
Concurrent Log Parameter Column Titles