Results for “igs_as_gpc_programs_u2”

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

Overview

IGS.IGS_AS_GPC_PROGRAMS is an Oracle E-Business Suite table owned by the IGS schema (the Student Systems / Academic Records product family, historically delivered under the Oracle Student System and now embedded in the EBS database tier). The table stores grading period cohort program details — that is, the association between a specific grading period and the academic programs (courses and their versions) that participate in that cohort. It functions as a configuration and reference table consumed by grade capture, grade book, and academic period processing logic in the IGS_AS_* (Academic Records, Grading) module family. The object is registered in FND Design Data as IGS.IGS_AS_GPC_PROGRAMS and is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

From a Data Vault modeling perspective, the supplied heuristic classifies this object as satellite-leaning. This is consistent with its shape: the table carries its own system-generated surrogate key (GPC_PROGRAM_ID) but its substantive payload is the descriptive attribute set (GRADING_PERIOD_CD, COURSE_CD, COURSE_VERSION_NUMBER) that qualifies the relationship between a grading period and a program version. In a dimensional or Data Vault target model, this would typically resolve to a satellite hanging off a grading-period/program-version link, rather than a standalone hub.

Key Information Stored

The table contains nine documented columns. The most significant are:

• GPC_PROGRAM_ID (NUMBER, 15) — the system-generated surrogate primary key that uniquely identifies each program row within the cohort. This is the column that backs the unique index IGS_AS_GPC_PROGRAMS_U1 and the primary key constraint IGS_AS_GPC_PROGRAMS_PK. Users typically search this table via this identifier.
• GRADING_PERIOD_CD (VARCHAR2, 30) — the grading period code qualifying which grading cycle the program belongs to.
• COURSE_CD (VARCHAR2, 10) — the program code. Despite the "COURSE" naming convention, the documented comment identifies this as Program Code.
• COURSE_VERSION_NUMBER (NUMBER) — the version number of the program, allowing multiple effective versions of the same program to coexist.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO audit columns that record insert and update context and actor identity.

Two unique indexes are documented. IGS_AS_GPC_PROGRAMS_U1 covers the surrogate key GPC_PROGRAM_ID. IGS_AS_GPC_PROGRAMS_U2 covers the composite business key (GRADING_PERIOD_CD, COURSE_CD, COURSE_VERSION_NUMBER), which is the natural uniqueness rule: a given program version may appear only once per grading period code. Interface and conversion developers should therefore treat the U2 triplet, not the surrogate, as the logical identity when reconciling data loads.

Common Use Cases and Queries

The primary use case is resolving, for a given grading period, the set of programs eligible for grade entry or cohort reporting. A typical reporting query joins this table to grading and program structures:

• Look-up by surrogate: SELECT grading_period_cd, course_cd, course_version_number FROM igs.igs_as_gpc_programs WHERE gpc_program_id = :p_id;
• Cohort listing by period: SELECT * FROM igs.igs_as_gpc_programs WHERE grading_period_cd = :period ORDER BY course_cd, course_version_number;
• Natural-key resolution prior to interface load: SELECT gpc_program_id FROM igs.igs_as_gpc_programs WHERE grading_period_cd = :p AND course_cd = :c AND course_version_number = :v;

These patterns are common in conversion scripts, inbound grading interfaces, and Oracle Discoverer/BI Publisher reports that enumerate participating programs per grading period. Because the table carries full WHO audit columns, it is also a candidate for change-audit queries filtering on last_update_date.

Related Objects

The documented dependency metadata states that IGS_AS_GPC_PROGRAMS references no objects through declared foreign keys other than the noted relationship, and is referenced only by an APPS synonym APPS.IGS_AS_GPC_PROGRAMS. The relationship data identifies one foreign key: COURSE_CD functionally pointing to IGS.IGS_PS_VER_ALL, the program/course version view. In practice, the most significant related objects are:

• IGS.IGS_PS_VER_ALL — joined on COURSE_CD (and typically COURSE_VERSION_NUMBER) to resolve program titles and version attributes.
• APPS.IGS_AS_GPC_PROGRAMS — the APPS-layer synonym through which application code and reports access the table.
• IGS_AS_GPC_* cohort tables — sibling grading-period/cohort configuration objects sharing the GRADING_PERIOD_CD key.
• IGS grading and grade-book tables — consumed downstream where grading period program context is required.
• FND Design Data registration — IGS.IGS_AS_GPC_PROGRAMS — governing object definition and installation.

Developers should confirm any additional join paths against the actual 12.1.1/12.2.2 instance, as the ETRM excerpt documents limited explicit FK dependencies for this object.