Search Results igs_en_atd_type_load




Overview
Explore in AI Chat

Overview

IGS_EN_ATD_TYPE_LOAD is a secured (organization-striped) view in the APPS schema belonging to the IGS – Student System product family. It exposes the attendance-type load definition data used by Oracle Student System to calculate a student's load factor. The load factor derives from the attendance type combined with a lower enrolment load range, an upper enrolment load range, and the corresponding total student units (expressed through the DEFAULT_EFTSU column). The view presents this configuration data for reporting and integration consumption; it is not a transactional table but a filtered projection over its underlying ALL table, applying Oracle EBS multi-org security so that each query session sees only the rows belonging to the organization identified in the session's CLIENT_INFO context.

Underlying Base Objects

The view is defined as a SELECT over IGS_EN_ATD_TYPE_LOAD_ALL, projecting every column of that table plus a synthesized ROWID column aliased ROW_ID. The WHERE clause implements multi-org access control: it compares NVL(ORG_ID, -99) against the organization identifier extracted from USERENV('CLIENT_INFO') using the standard SUBSTRB/DECODE pattern. When CLIENT_INFO is blank or its first character is a space, the expression resolves to NULL and then to -99, matching rows whose ORG_ID is likewise null or -99. In practice, this means IGS_EN_ATD_TYPE_LOAD returns the attendance-type load records of the current operating unit only. The ETRM metadata documents no additional referenced base objects beyond the ALL table from which it directly selects.

Key Columns

  • ROW_ID – The Oracle ROWID of the underlying row, exposed for row-level addressing.
  • ORG_ID – Operating unit (organization) identifier used by the multi-org security predicate.
  • CAL_TYPE – Calendar type to which the attendance-type load definition applies.
  • ATTENDANCE_TYPE – The attendance type (for example full-time or part-time) that drives the load calculation.
  • LOWER_ENR_LOAD_RANGE – Lower bound of the enrolment load range associated with the attendance type.
  • UPPER_ENR_LOAD_RANGE – Upper bound of the enrolment load range associated with the attendance type.
  • DEFAULT_EFTSU – Default Equivalent Full-Time Student Unit value applied to students falling within the range; the core numeric used to derive the load factor.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns recording who inserted and last altered each row and when.

Common Use Cases and Queries

Typical use is to retrieve the attendance-type load bands for a given operating unit and calendar so that student enrolment loads can be evaluated or reconciled against institutional policy. Because the view resolves ORG_ID from CLIENT_INFO, it is normally queried in a session (or through a concurrent program/BC4J application) that has already initialized the multi-org context. A representative query follows:

SELECT attendance_type,
       cal_type,
       lower_enr_load_range,
       upper_enr_load_range,
       default_eftsu
FROM   apps.igs_en_atd_type_load
WHERE  cal_type = :p_cal_type
ORDER  BY lower_enr_load_range;

Another common pattern joins the view to student enrolment data to determine which load band a student falls into, using DEFAULT_EFTSU as the load factor source. Reporting against IGS_EN_ATD_TYPE_LOAD should always account for the organization filter; querying it without a properly set CLIENT_INFO context returns only the null/-99 organization rows, which is a frequent cause of apparently missing configuration data in IGS enquiries.