Search Results upper_enr_load_range




Overview
Explore in AI Chat

Overview

IGS_EN_ATD_TYPE is a reporting view in the Oracle E-Business Suite IGS (Student System) product line, which is documented as obsolete in the ETRM reference for releases 12.1.1 and 12.2.2. The view exposes the set of attendance types available within the institution, such as full-time and part-time classifications, and is intended to serve as a secured, operating-unit-filtered read layer over the underlying attendance type definition table. Rather than functioning as a transactional entity, it acts as a lookup-style reporting and integration object that allows downstream queries, concurrent programs, and external interfaces to resolve attendance type codes, their descriptive text, enrolment load boundaries, and government reporting equivalents without directly accessing the maintenance table.

The ETRM metadata states explicitly that the view is not implemented in the documented database. Consequently, it should be treated as a definition of record rather than a guaranteed runtime object in every environment. Where the object does exist, it follows the standard Oracle multi-org security pattern applied to key flexfield-adjacent setup data.

Underlying Base Objects

The view is defined over a single documented base object, IGS_EN_ATD_TYPE_ALL. The "_ALL" suffix indicates that the table stores rows across all operating units, with organization context carried in the ORG_ID column. The view applies the standard Oracle multiorg predicate by comparing the organization identifier held in the session client information against the table's ORG_ID value, defaulting to a sentinel of -99 when no client information is available.

This construction means IGS_EN_ATD_TYPE behaves as an operating-unit (Org ID) secured view: rows belonging to other operating units are filtered out automatically, and records with a null ORG_ID are surfaced only through the sentinel comparison logic. Because the underlying table is an "_ALL" table, no additional join to a base translation table is present in the documented view text, and no other base objects are documented as referenced.

Key Columns

  • ROW_ID – The row identifier derived from the table ROWID, used for optimistic locking and unique row addressing.
  • ORG_ID – The operating unit that owns the attendance type record.
  • ATTENDANCE_TYPE – The code identifying the attendance type, for example a full-time or part-time classification.
  • DESCRIPTION – The descriptive name of the attendance type presented to users.
  • GOVT_ATTENDANCE_TYPE – The corresponding government or statutory attendance classification used for external reporting.
  • LOWER_ENR_LOAD_RANGE / UPPER_ENR_LOAD_RANGE – The lower and upper bounds of the enrolment load range associated with the attendance type.
  • RESEARCH_PERCENTAGE – The proportion of the load attributable to research activity.
  • CLOSED_IND – Indicator of whether the attendance type is closed to new use.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle audit columns recording who created and last modified each row.

Common Use Cases and Queries

The principal use case is validating and reporting enrolment load classifications. A typical query lists active attendance types for the current operating unit with their load ranges:

  • SELECT attendance_type, description, govt_attendance_type, lower_enr_load_range, upper_enr_load_range, research_percentage FROM igs_en_atd_type WHERE NVL(closed_ind, 'N') = 'N';
  • SELECT attendance_type, description FROM igs_en_atd_type ORDER BY attendance_type;
  • SELECT a.attendance_type, a.govt_attendance_type, a.research_percentage FROM igs_en_atd_type a WHERE a.org_id = :org_id;

Because the object is documented as obsolete and not implemented, any interface or report referencing it should first verify object existence and confirm that the equivalent setup data is maintained through the supported Student System setup path. Where the view is absent, equivalent information must be sourced directly from the corresponding attendance type maintenance table, observing the same operating unit filter semantics described above.