Search Results gpc_unit_set_cd

Overview

The IGS_AS_GPC_UNIT_SETS_V view belongs to the IGS product family — the Oracle Student System module, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The view presents grading period assignments associated with unit sets, combining configuration data from the grading period unit set table, the lookup definitions, and the unit set catalog. Its purpose is to expose a denormalized, human-readable representation of the relationship between a unit set (and its specific version) and the grading period code assigned to it.

As a reporting and integration construct, the view allows consumers to retrieve grading period information for unit sets without performing multi-table joins in application or integration code. The view resolves the raw grading period code into its descriptive meaning through the IGS_LOOKUPS_VIEW, and resolves the unit set code and version into a descriptive title through IGS_EN_UNIT_SET. It is important to note that the ETRM records this object as not implemented in the database and marked obsolete, so it reflects legacy Student System data structures rather than an actively supported feature in current EBS releases.

Underlying Base Objects

Based on the documented view text, the view is defined over three referenced objects:

• IGS_AS_GPC_UNIT_SETS (aliased GUS) — the primary base table holding the association between a grading period code and a unit set code/version, along with standard WHO audit columns.
• IGS_LOOKUPS_VIEW (aliased LKUP) — the lookup view used to translate the grading period code into a descriptive meaning, filtered by lookup type AS_GRADING_PERIOD.
• IGS_EN_UNIT_SET (aliased USET) — the unit set definition table, providing the descriptive title for a given unit set code and version number.

The joins are inner joins: grading period code equals the lookup code (restricted to the AS_GRADING_PERIOD lookup type), and the unit set code plus version number match the corresponding columns in IGS_EN_UNIT_SET. Although the ETRM metadata lists no independently documented referenced base objects, the view text explicitly names these three sources.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_AS_GPC_UNIT_SETS row, useful for uniquely identifying the source record.
• GPC_UNIT_SET_ID — the primary identifier associated with the grading period/unit set combination; this is the column most commonly referenced by the search term "gpc_unit_set_id".
• GRADING_PERIOD_CD — the coded grading period value stored on the base table.
• GRADING_PERIOD — the descriptive meaning of the grading period code as resolved from the lookup view.
• UNIT_SET_CD and UNIT_SET_VERSION_NUMBER — the unit set identifier and its version, forming the join key to the unit set definition.
• UNIT_SET_TITLE — the descriptive title of the unit set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns inherited from the base table.

Note that the ETRM column list shows GPC_UNIT_SET_CD while the view text aliases the column GPC_UNIT_SET_ID as GPC_UNIT_SET_ID; the identifier column is the stable key, whereas the display columns are resolved through the joins.

Common Use Cases and Queries

Typical use cases include reporting the grading periods configured against unit sets, validating lookup-driven grading period assignments, and integrating Student System configuration data into downstream systems. A basic query retrieving grading period details for unit sets is:

SELECT gpc_unit_set_id, grading_period_cd, grading_period, unit_set_cd, unit_set_version_number, unit_set_title FROM igs_as_gpc_unit_sets_v;

To locate a specific record by its identifier:

SELECT gpc_unit_set_id, grading_period, unit_set_title FROM igs_as_gpc_unit_sets_v WHERE gpc_unit_set_id = :p_id;

To list all grading periods for a given unit set:

SELECT grading_period, unit_set_version_number FROM igs_as_gpc_unit_sets_v WHERE unit_set_cd = :p_unit_set_cd ORDER BY unit_set_version_number;

Because the view is documented as obsolete and not implemented, these queries are relevant primarily to legacy Student System environments or historical migration efforts; deployments upgraded to current EBS 12.1.1 or 12.2.2 releases should verify object availability before relying on this view.