Search Results govt_attendance_mode




Overview
Explore in AI Chat

Overview

IGS_EN_ATD_MODE is a secured (organization-striped) view belonging to the Oracle Student System / Student Records schema (IGS) and exposed through the APPS synonyms layer. In Oracle EBS 12.1.1 and 12.2.2, it presents the list of attendance modes used in enrollment processing — the coded values that describe how a student attends a course, such as full-time, part-time, evening, distance, or block mode. The view is the reporting and integration–facing projection of the attendance mode setup; the underlying _ALL object is the multi-organization table that holds the definition rows, while the view applies a row-level security predicate so each operating unit or organization only sees the attendance mode rows relevant to it.

The column name GOVT_ATTENDANCE_MODE is directly relevant to the user search term "govt_attendance_mode". This column carries the reporting code that must be reported to a government or statutory body (for example, a funding council or education ministry return). It allows an institution to maintain an internal attendance mode for operational use while mapping it to a standardized government attendance classification used in regulatory extracts.

Underlying Base Objects

The view is defined over a single base object, IGS_EN_ATD_MODE_ALL, which is the multi-organization ("_ALL") table storing attendance mode definitions. The view text selects the relevant columns and appends the ROWID, exposed as ROW_ID, so the view can be treated as an updatable entity by Oracle Forms and other tooling.

The defining predicate is the standard Oracle multi-org security clause. It resolves the current organization from the session context (USERENV('CLIENT_INFO')), converts that value to a number, and compares it against ORG_ID on the base table, using NVL(...,-99) to handle rows with a null organization. As a result, the view is not a naive projection: it filters the underlying table dynamically based on the environment that the querying session operates in. Queries against this view therefore return only the attendance mode rows visible to the caller's organization context.

Key Columns

  • ROW_ID — the ROWID of the underlying row, used as a surrogate identifier, particularly by Oracle Forms.
  • ATTENDANCE_MODE — the primary business key or code identifying the attendance mode.
  • DESCRIPTION — the descriptive name or label for the attendance mode.
  • GOVT_ATTENDANCE_MODE — the government or statutory attendance mode code, matched by the user's search term. Used in regulatory and funding returns.
  • CLOSED_IND — indicates whether the attendance mode is closed to new use (typically Y/N).
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns.
  • ORG_ID — the organization (operating unit) owning the row, and the basis for the view's security filter.

Common Use Cases and Queries

The view is typically used to validate, report, and integrate attendance mode data: joining it to enrollment records for internal analytics; driving validation in an inbound interface; populating government returns by selecting GOVT_ATTENDANCE_MODE; and de-duplicating internal codes against statutory codes.

The simplest usage lists the available modes:

  • SELECT attendance_mode, description, govt_attendance_mode FROM apps.igs_en_atd_mode WHERE NVL(closed_ind,'N') = 'N' ORDER BY attendance_mode;

To report the government mapping for regulatory extracts:

  • SELECT attendance_mode, govt_attendance_mode, org_id FROM apps.igs_en_atd_mode WHERE govt_attendance_mode IS NOT NULL;

Because multi-org filtering is embedded in the view, no additional ORG_ID predicate is normally required in reports run within a correctly initialized session; teams that must add one should use apps.fnd_profile.value('ORG_ID') rather than hard-coding a value. Any query should reference the application synonym (APPS.IGS_EN_ATD_MODE) rather than the IGS base object, so that the security predicate and organization defaults maintained by Oracle are honored.