Search Results igs_pe_ev_form_stat_pk




Overview
Explore in AI Chat

Overview

IGS_PE_EV_FORM_STAT is a transaction-detail table within the Oracle E-Business Suite IGS — Student System product family, which Oracle has designated as obsolete in releases 12.1.1 and 12.2.2. The table records the status history of forms submitted by students, capturing each status-changing action taken against an event form together with the effective date of that action. Its functional purpose is to let the application determine the current state of a form — for example, whether it is pending, approved, or terminated — by reading the most recent qualifying row for a given form.

From a dimensional or Data Vault modeling perspective, the mined relationship metadata classifies this object as satellite-leaning. This is a modeling suggestion rather than a normative statement: the table is keyed by a surrogate identifier, holds descriptive attributes (remarks, termination reasons, program dates), and carries a foreign key to a parent form entity, which is characteristic of a satellite attached to a parent hub. Its structure also carries limited link-like behavior, since each row associates a form with a dated action type.

Key Information Stored

The table contains 14 documented columns. The most significant are the following.

  • EV_FORM_STAT_ID — the surrogate primary key, uniquely identifying each status record. It is backed by the IGS_PE_EV_FORM_STAT_PK unique index and should be treated as a system-generated identifier with no business meaning.
  • EV_FORM_ID — foreign key to IGS_PE_EV_FORM, identifying the student's event form to which the status row belongs. This is the primary linkage between status history and the form itself.
  • ACTION_DATE — the date the status-changing action was performed; central to determining which status record is most recent.
  • ACTION_TYPE — the code indicating the nature of the action applied to the form (for example submission, approval, or termination).
  • PRGM_START_DATE and PRGM_END_DATE — the program period associated with the form status.
  • REMARKS — free-text notes recorded by the user performing the action.
  • TERMINATION_REASON and END_PROGRAM_REASON — coded or descriptive reasons explaining why a form or program was ended.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns tracking who created and last modified each row and when.

The business-key candidate is defined by the IGS_PE_EV_FORM_STAT_U1 unique index over (EV_FORM_ID, ACTION_DATE, ACTION_TYPE), meaning that a given form cannot have two identical actions recorded on the same date. This composite is the natural identifier; EV_FORM_STAT_ID is the surrogate.

Common Use Cases and Queries

The dominant use case is deriving the current status of a student form by selecting the latest action row. A typical query pattern is:

  • Latest status per form: SELECT ev_form_id, action_type, action_date FROM igs_pe_ev_form_stat s WHERE action_date = (SELECT MAX(action_date) FROM igs_pe_ev_form_stat WHERE ev_form_id = s.ev_form_id).
  • Status audit trail: retrieving the full ordered history of actions for a form using ORDER BY action_date filtered on EV_FORM_ID.
  • Termination reporting: joining to reason columns to analyze how many forms ended and why, grouped by ACTION_TYPE or TERMINATION_REASON.
  • Date-range extracts: reporting all status changes within a period using ACTION_DATE and the standard audit columns for change tracking.

Because the object is obsolete and reported as not implemented in the reference database, these patterns are primarily relevant to legacy data migration, historical reporting, or reconciliation of archived Student System data rather than to active EBS development.

Related Objects

The single documented foreign key relationship links this table upward to its parent form entity, and the standard EBS audit conventions imply additional dependencies.

  • IGS_PE_EV_FORM — the parent form table referenced through IGS_PE_EV_FORM_STAT.EV_FORM_ID. This is the primary join path for any status-to-form query.
  • IGS_PE_EV_FORM_STAT_PK — the primary key index on EV_FORM_STAT_ID.
  • IGS_PE_EV_FORM_STAT_U1 — the composite unique index on (EV_FORM_ID, ACTION_DATE, ACTION_TYPE) enforcing the business key.
  • Standard EBS identity and date columns (CREATED_BY, LAST_UPDATED_BY) implicitly reference FND_USER and the FND audit framework.
  • Action and reason attributes (ACTION_TYPE, TERMINATION_REASON, END_PROGRAM_REASON) conventionally resolve to IGS lookup codes and reference tables.

Given the obsolete status of the IGS Student System, no supported public APIs are documented for this table in releases 12.1.1 or 12.2.2. Any access should be treated as read-only historical analysis of a legacy schema.