Search Results igs_ad_transcript_pk

Overview

The IGS_AD_TRANSCRIPT table belongs to the IGS (Student System) product family within Oracle E-Business Suite. In the ETRM documentation set covering releases 12.1.1 and 12.2.2, this object is explicitly flagged as Obsolete and, notably, is not implemented in the reference database shipped with those releases. Its documented purpose is to hold transcript details — the administrative and academic summary of a student's prior or external academic record as received and evaluated by the institution, including entrance qualifications, converted grade point averages, and class ranking metrics.

Because the table is obsolete and unpopulated in the standard EBS 12.1.1/12.2.2 schema, any work involving it should be treated as legacy or migration-oriented rather than as part of an active functional flow. In practice, IGS_AD_TRANSCRIPT is only encountered in older IGS/Student System implementations, historical data extracts, or in schemas that predate the deprecation of the IGS admissions components.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. It describes attributes and measures (status, GPA, rank, dates) about a central business entity — the transcript — whose identifying key is the surrogate TRANSCRIPT_ID. The term satellite-leaning is a heuristic suggestion only; the table also carries descriptive foreign keys to code lookups and to HZ_EDUCATION, which gives it mild link characteristics, but the dominant pattern is attribute storage around a single subject.

Key Information Stored

The table is documented with 33 columns in ETRM 12.1.1, owned by the IGS schema. The most significant are:

• TRANSCRIPT_ID — the surrogate primary key, enforced by IGS_AD_TRANSCRIPT_PK, and the single documented unique index/business-key candidate. All child tables join to this column.
• EDUCATION_ID — foreign key to HZ_EDUCATION, tying the transcript to a specific education record (institution/credential) in the Trading Community model.
• TRANSCRIPT_STATUS and TRANSCRIPT_TYPE — administrative classification of the transcript record.
• TRANSCRIPT_SOURCE — foreign key to IGS_AD_CODE_CLASSES, indicating where the transcript originated.
• DATE_OF_RECEIPT and DATE_OF_ISSUE — when the transcript was received by the institution and when it was issued by the source.
• ENTERED_GPA and CONV_GPA — the GPA as entered and the institution-converted GPA, with associated ENTERED_GS_ID and CONV_GS_ID lookup references to IGS_AD_CODE_CLASSES for grading scheme.
• RANK_IN_CLASS, CLASS_SIZE, APPROXIMATE_RANK, WEIGHTED_RANK — class-standing metrics.
• DECILE_RANK / QUARTILE_RANK / QUINTILE_RANK / PERCENTILE_RANK — derived distributional rank indicators.
• CORE_CURRICULUM_VALUE and TERM_TYPE — curriculum and term categorisation used in admission evaluation.
• OVERRIDE, OVERRIDE_ID, OVERRIDE_DATE — audit fields for manual overrides of computed values.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and REQUEST_ID for concurrent program traceability.

Common Use Cases and Queries

Reporting on this object typically supports admissions evaluation: comparing entered versus converted GPA, reviewing class-rank percentiles, and reconciling transcripts to their education records. A representative join pattern is:

• Join IGS_AD_TRANSCRIPT t to HZ_EDUCATION e ON t.EDUCATION_ID = e.EDUCATION_ID to retrieve the institution behind each transcript.
• Join to IGS_AD_CODE_CLASSES c ON t.TRANSCRIPT_SOURCE = c.CODE (and similarly for ENTERED_GS_ID/CONV_GS_ID) to resolve coded values.
• Aggregate child IGS_AD_TERM_DETAILS rows via TRANSCRIPT_ID to obtain term-level detail behind each transcript.

Typical query: SELECT t.TRANSCRIPT_ID, t.ENTERED_GPA, t.CONV_GPA, t.RANK_IN_CLASS, t.CLASS_SIZE FROM IGS_AD_TRANSCRIPT t WHERE t.TRANSCRIPT_STATUS = :status. Given the table's obsolete status, any such query should first confirm whether the object exists and is populated in the target schema.

Related Objects

The following dependencies are documented in ETRM and are the most significant for impact analysis:

• IGS_AD_TERM_DETAILS — references TRANSCRIPT_ID; holds the term-level breakdown of each transcript.
• HZ_EDUCATION — referenced by this table via EDUCATION_ID; stores education/institution records.
• IGS_AD_CODE_CLASSES — referenced three times, via TRANSCRIPT_SOURCE, ENTERED_GS_ID, and CONV_GS_ID; supplies coded lookup values.
• IGS_AD_TXCPT_INT — interface table referencing TRANSCRIPT_ID; used for transcript exception processing.
• IGS_AD_TUNDT_INT — interface table referencing TRANSCRIPT_ID; undergraduate transcript data intake.
• IGS_AD_TRMDT_INT — interface table referencing TRANSCRIPT_ID; term-detail intake.

Because the _INT tables are interface (staging) objects, they indicate that transcript data was historically loaded in bulk through concurrent intake processes keyed on TRANSCRIPT_ID. Any migration or archival effort should therefore account for the full dependency chain of these six related objects.