Results for “points_override_ind”

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

Overview

IGS_PS_LGCY_UV_INT is a staging and integration interface table owned by the IGS schema within the Oracle E-Business Suite Student System (IGS) product family. Its documented description identifies it as the Legacy Unit Version Interface Table, which positions it as a conduit for migrating or synchronizing unit (course) version records from a legacy or external academic system into the Oracle Student System core tables.

The object is documented as VALID in the ETRM repository for Oracle EBS 12.1.1 and remains present in the 12.2.2 schema lineage, carrying 119 documented columns. As an interface table, it is not intended to serve transactional student enrollment or curriculum delivery directly; rather, it holds inbound records awaiting validation, transformation, and loading into the canonical unit version tables. The heuristic Data Vault classification mined from its foreign key structure is standalone, meaning it is not modeled as a hub, link, or satellite but as an independent staging artifact whose primary key does not participate in a broader normalized vault pattern.

Key Information Stored

The table's surrogate primary key is UNIT_VERSION_INT_ID, enforced by the unique index and constraint IGS_PS_LGCY_UV_INT_PK. This is the sole documented business-key candidate (unique index), so it functions both as the technical identifier and as the primary correlation handle for interface processing.

• BATCH_ID — groups a set of interface rows loaded in a single import run, enabling bulk reconciliation and rollback.
• UNIT_CD and VERSION_NUMBER — the business identifier of the legacy unit version, used to match against existing core records.
• TITLE, SHORT_TITLE, ABBREVIATION — descriptive attributes of the unit version.
• START_DT, END_DT, REVIEW_DT, EXPIRY_DT — the effective-dating window that governs when the version is active.
• UNIT_STATUS — the lifecycle state of the incoming unit version.
• CREDIT_POINT_DESCRIPTOR, ACHIEVABLE_CREDIT_POINTS, ENROLLED_CREDIT_POINTS — credit-bearing and workload metrics.
• CURRICULUM_ID — foreign key to IGS_PS_UNT_CRCLM_ALL, linking the unit version to its curriculum context.
• IMPORT_STATUS — the processing state of the interface row (loaded, validated, errored, or posted).
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — concurrent program audit context for the loading job.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — the WHO audit columns.

Common Use Cases and Queries

Typical scenarios include legacy curriculum migration, periodic batch synchronization from feeder systems, and reconciliation reporting on inbound unit version loads. A common pattern is to inspect the status of a given batch:

• SELECT batch_id, import_status, COUNT(*) FROM igs_ps_lgcy_uv_int GROUP BY batch_id, import_status; — summarises load outcomes per batch.
• SELECT * FROM igs_ps_lgcy_uv_int WHERE unit_version_int_id = :id; — retrieves a single interface record by primary key.
• SELECT i.unit_cd, i.version_number, i.title, c.curriculum_description FROM igs_ps_lgcy_uv_int i JOIN igs_ps_unt_crclm_all c ON i.curriculum_id = c.curriculum_id; — resolves curriculum context.
• SELECT * FROM igs_ps_lgcy_uv_int WHERE import_status = 'ERROR' AND batch_id = :batch; — isolates failed rows for correction.

Related Objects

The documented foreign key relationship ties this interface table to the curriculum master:

• IGS_PS_UNT_CRCLM_ALL — joined via CURRICULUM_ID; provides the parent curriculum definition.
• IGS_PS_UNT_CRCLM_ALL (by CURRICULUM_DESCRIPTION, CURRICULUM_CLOSED_IND) — denormalized attributes carried into the interface.
• The core unit version tables in the IGS_PS_* family, which are the intended load targets for validated interface rows.
• Concurrent program and request objects referenced through REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID.
• Descriptive flexfield definition tables referenced through ATTRIBUTE_CATEGORY.