Search Results govt_attendance_type




Overview
Explore in AI Chat

Overview

APPS.IGS_EN_ATD_TYPE is a reporting and integration view in the Oracle E-Business Suite student system (the IGS product family), exposed in the APPS schema. It presents attendance type definitions used by the institution to classify how a student is registered against a program or course — for example, full-time, part-time, or other load-based attendance categories. Because attendance type drives enrollment load ranges, research percentage calculations, and government statutory reporting, the view is a foundational reference for enrollment, load, and regulatory extract processes.

The object is documented in ETRM 12.2.2 and is present in both 12.1.1 and 12.2.2 EBS environments where the student system is licensed. It is a multi-org (Operating Unit) view: rows are filtered automatically in the database session so that only records for the session's operating unit — plus shared global records — are visible. This is the reason the same view can be used by concurrent programs, OAF pages, and custom reports without each component re-implementing the operating unit filter.

Underlying Base Objects

The view is defined over a single base table, IGS_EN_ATD_TYPE_ALL, which is the "_ALL" table that stores attendance type definitions across operating units. The view text selects every column of interest from that table and applies an ORG_ID filter derived from the USERENV('CLIENT_INFO') session attribute, the standard mechanism used by the multi-org (Multi-Org) architecture for views without a separate "_V" variant.

The filter compares NVL(ORG_ID, ...) against the operating unit decoded from the first ten characters of CLIENT_INFO. Records where ORG_ID is null are treated as global/shared and are matched using the sentinel value -99, allowing them to be returned for any operating unit context.

Key Columns

  • ROW_ID — the ROWID of the underlying row, exposed for update-oriented and row-level identity use.
  • ORG_ID — the operating unit that owns the attendance type definition; null denotes a shared record.
  • ATTENDANCE_TYPE — the primary key code identifying the attendance category.
  • DESCRIPTION — the descriptive text shown to users and printed on reports.
  • GOVT_ATTENDANCE_TYPE — the government-defined attendance classification, used for statutory returns. This is the column associated with searches on "govt_attendance_type".
  • LOWER_ENR_LOAD_RANGE / UPPER_ENR_LOAD_RANGE — the minimum and maximum enrollment load boundaries associated with the attendance type.
  • RESEARCH_PERCENTAGE — the proportion of the load treated as research, used in load and funding calculations.
  • CLOSED_IND — indicates whether the attendance type is inactive and should be excluded from new entries.
  • Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN for audit and change tracking.

Common Use Cases and Queries

Typical uses include validating attendance type codes during enrollment data loads, mapping institutional attendance types to government reporting codes, and resolving load ranges for enrollment load calculations. A basic lookup is:

SELECT attendance_type, description, govt_attendance_type, lower_enr_load_range, upper_enr_load_range, closed_ind FROM apps.igs_en_atd_type WHERE closed_ind = 'N' ORDER BY attendance_type;

To resolve the government mapping used by regulatory extracts:

SELECT attendance_type, description, govt_attendance_type FROM apps.igs_en_atd_type WHERE govt_attendance_type IS NOT NULL ORDER BY govt_attendance_type;

Because the view is operating-unit filtered, run such queries from within an initialized session — for example, after setting CLIENT_INFO through the standard multi-org initialization routine — so that the correct ORG_ID context is applied. Direct SQL against IGS_EN_ATD_TYPE_ALL is not recommended in concurrent or report code, since it bypasses the security filter supplied by the view.