Search Results total_credit_point_attempted

Overview

The view IGSFV_ACAD_TRANSCRIPT_TERMS belongs to the IGS — Student System product family within Oracle E-Business Suite, and is documented as an obsolete object in ETRM for releases 12.1.1 and 12.2.2. Its stated purpose is to expose transcript term details, presenting one row per term-level academic record associated with a student transcript. The view consolidates header-level transcript attributes (term, dates, transcript identifiers) with aggregated academic performance measures such as attempted credit points, earned credit points, unit grade points, GPA units, and grade point average.

The "FV" naming convention indicates a foreign or derived view used principally for reporting, inquiry, and integration rather than for transactional maintenance. Because the product line is marked obsolete, the view should be regarded as a legacy interface retained for backward compatibility. ETRM records that the object is not implemented in this database, meaning that in the documented environment the underlying IGS Student System tables are absent and the view cannot be queried. The view is also defined WITH READ ONLY, confirming that it is non-updatable and intended strictly for retrieval. The presence of _LA: tokens in the projection list further indicates that the definition is intended for localization or secure-view processing, where transcript type and status are resolved to user-facing meaning values at runtime.

Underlying Base Objects

The view is defined over two base tables joined on the transcript identifier:

• IGS_AD_TERM_DETAILS TD — the driving table supplying term-level academic aggregates and audit columns.
• IGS_AD_TRANSCRIPT TR — the transcript header table supplying issuance and receipt dates.

The join predicate is TD.TRANSCRIPT_ID = TR.TRANSCRIPT_ID, giving a one-to-many relationship where a single transcript header supports multiple term detail rows. ETRM lists no formally documented referenced base objects beyond those appearing in the view text, and no owner is recorded. Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) are projected from the term details table, reflecting the row-level provenance of each term record.

Key Columns

The columns most relevant to the search term total_credit_point_earned and to transcript reporting are:

• TERM — the academic term identifier for the row.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — aliases of TD.START_DATE and TD.END_DATE, bracketing the term period.
• TOTAL_CREDIT_POINT_ATTEMPTED — alias of TD.TOTAL_CP_ATTEMPTED, credit points attempted.
• TOTAL_CREDIT_POINT_EARNED — alias of TD.TOTAL_CP_EARNED, the credit points successfully earned in the term; this is the column users typically search for when reconciling earned credit.
• TOTAL_UNIT_GRADE_POINT — alias of TD.TOTAL_UNIT_GP, the summed grade points used in GPA computation.
• TOTAL_GPA_UNITS — the GPA denominator units.
• GRADE_POINT_AVERAGE — alias of TD.GPA, the term grade point average.
• "_LA:TRANSCRIPT_TYPE" and "_LA:TRANSCRIPT_STATUS" — localized meaning values resolved from IGS_LOOKUP_VALUES for the TRANSCRIPT_TYPE and TRANSCRIPT_STATUS lookups.
• DATE_OF_ISSUE / DATE_OF_RECEIPT — transcript issuance and receipt dates from the header table.
• TERM_DETAILS_ID and TRANSCRIPT_ID — surrogate keys linking back to the base tables.

Common Use Cases and Queries

Typical uses include transcript reprints, academic standing evaluations, credit-transfer reconciliation, and extracts for downstream student records systems. A representative query returning earned credit by term is:

• SELECT term, effective_start_date, total_credit_point_earned, grade_point_average FROM igsfv_acad_transcript_terms WHERE transcript_id = :p_transcript_id ORDER BY effective_start_date;

Aggregation of cumulative earned credit across terms can be achieved with a simple sum over total_credit_point_earned. Because the view is read-only and the IGS product is obsolete, consumers should verify availability in the target environment before relying on it, and plan migration to supported Student System alternatives.