Results for “attendance_mode”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_EN_ATD_MODE_ALL is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product family. It describes the attendance modes available to university programs — for example full-time, part-time, or distance/online attendance patterns — that a student may be associated with when enrolled in a program of study. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the IGS schema and is flagged VALID in the ETRM data dictionary. Its role is to provide a controlled vocabulary of attendance modes that is consumed by admissions, enrollment, student records, and fee-calculation processes across the Student System modules.

The relationship metadata classifies this object as hub-leaning under a Data Vault heuristic. This is a modeling suggestion rather than a physical design: ATTENDANCE_MODE acts as a stable business key referenced by many dependent tables, which is characteristic of a hub entity. Because the table also carries descriptive attributes such as DESCRIPTION, GOVT_ATTENDANCE_MODE, and CLOSED_IND, it simultaneously behaves like a satellite holding the descriptive context of each attendance mode.

Key Information Stored

The table is documented with ten columns. The most significant are:

  • ATTENDANCE_MODE — the primary key column, defined by the constraint IGS_EN_ATD_MODE_ALL_PK and reinforced by the unique index IGS_EN_ATD_MODE_ALL_U1. It is the business key referenced by every dependent foreign key in the system.
  • DESCRIPTION — the user-facing label for the attendance mode, typically displayed in enrollment and admissions forms.
  • GOVT_ATTENDANCE_MODE — the government or statutory reporting equivalent of the internal attendance mode, used to satisfy regulatory reporting requirements where attendance categories must map to an external code set.
  • CLOSED_IND — a flag indicating whether the attendance mode is retired or closed for new use, while remaining valid for historical records.
  • ORG_ID — the operating unit / organization identifier that scopes the record within multi-organization deployments.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns (WHO columns) tracking record creation and modification.

The surrogate primary key (ATTENDANCE_MODE) and the business-key candidate (also ATTENDANCE_MODE via the unique index U1) coincide here, reflecting a natural-key design common in reference tables.

Common Use Cases and Queries

Typical uses include validating attendance mode values during admissions and enrollment, driving fee assessment rules tied to attendance load, and producing statutory attendance reporting. A frequent pattern is a lookup join to resolve descriptions:

  • Listing all active attendance modes: SELECT attendance_mode, description FROM igs_en_atd_mode_all WHERE closed_ind = 'N' AND org_id = :org_id;
  • Resolving descriptions for enrolled students by joining IGS_EN_STDNT_PS_ATT_ALL on DERIVED_ATT_MODE, or IGS_PS_OFR_OPT_ALL on ATTENDANCE_MODE.
  • Mapping internal modes to government reporting codes using GOVT_ATTENDANCE_MODE for regulatory extracts.
  • Reporting fee-rate usage by joining IGS_FI_FEE_AS_RT on ATTENDANCE_MODE to analyze fees applied per attendance category.

Related Objects

Numerous Student System tables carry ATTENDANCE_MODE or DERIVED_ATT_MODE as a foreign key to this lookup. The most significant include:

These dependencies confirm the table's role as a central reference hub, so changes to attendance mode values must be managed carefully to preserve referential integrity.