Search Results authorising_person_number




Overview
Explore in AI Chat

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

Overview

IGS_AV_LGCY_LVL_INT is an interface (staging) table within the Oracle E-Business Suite IGS — Student System product family. Its documented purpose is to store Advance Standing Unit Level Legacy data — records migrated or loaded from a legacy student administration system representing advance standing (advanced academic credit or exemption) at the unit level, prior to validation and promotion into the live Advance Standing schema. The IGS Student System module is flagged as Obsolete in the ETRM 12.1.1 documentation, and the table is explicitly recorded as "Not implemented in this database," meaning it exists in the shipped schema definition but is not instantiated in a standard installation. In EBS 12.2.2, the same obsolescence posture applies, and no online product functionality depends on it.

The documented physical schema places the table under owner IGS with 48 columns. The single documented unique index, IGS_AV_LGCY_LVL_INT_PK, keys on LEGACY_LVL_INT_ID, which serves as the surrogate primary key. The metadata's heuristic Data Vault classification is standalone, with no foreign-key relationships mined from the FK structure. From a modeling perspective, this object is best treated as a standalone staging hub/satellite hybrid rather than a link, since the batch-scoped legacy key (BATCH_ID plus PERSON_NUMBER/PROGRAM_CD) supplies the natural business identifier while the remaining columns describe the attribute payload.

Key Information Stored

The table holds the surrogate key and the legacy business identifiers that establish record identity, together with a broad exemption/qualification payload. The most significant columns are:

Common Use Cases and Queries

Because the object is a legacy interface table, its practical role is migration reconciliation, not transactional reporting. Typical patterns include verifying batch completeness and identifying records that have failed or stalled validation.

  • Batch load status: SELECT IMPORT_STATUS, COUNT(*) FROM IGS.IGS_AV_LGCY_LVL_INT GROUP BY IMPORT_STATUS;
  • Student-level exemption extract: SELECT PERSON_NUMBER, PROGRAM_CD, UNIT_LEVEL, TOTAL_EXMPTN_GRANTED, GRANTED_DT FROM IGS.IGS_AV_LGCY_LVL_INT WHERE BATCH_ID = :batch AND IMPORT_STATUS = 'VALIDATED';
  • Concurrent request trace: join on REQUEST_ID against FND_CONCURRENT_REQUESTS to reconcile a load run with its log.
  • Reconciliation: compare granted exemption totals against CREDIT_POINTS to detect pre-conversion data discrepancies.

Related Objects

The documented relationship classification is standalone, so no FK topology is asserted. In practice, the objects most relevant to its processing are the concurrent manager and the live advance-standing destination tables.

  • FND_CONCURRENT_REQUESTS — join on REQUEST_ID to trace the import program run.
  • IGS_AV_LGCY_LVL_INT_PK — the primary key/unique index constraint itself.
  • Live advance standing tables (e.g., IGS_AS_* advance-standing family) that receive validated rows.
  • HZ_PARTIES / PER_ALL_PEOPLE_F — resolve PERSON_NUMBER to a person record.
  • FND_USER — resolve CREATED_BY and LAST_UPDATED_BY.

Given the Obsolete designation, integration should be limited to historical migration and data archival exercises.