Search Results institution_state




Overview
Explore in AI Chat

Overview

IGS_PR_ACAD_TRANS_CREDIT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Student System (IGS) product family. It consolidates academic transfer credit information for students, joining data from the student program attempt records, academic history, higher-education party (institution) information, and advanced standing unit detail. The view exposes a flattened, denormalized result set suitable for reporting on credit awarded to a learner in recognition of prior learning, prior academic achievement, or transfer coursework from other institutions.

The name components reflect its purpose: "ACAD_TRANS" (academic transfer) and "CREDIT." The view is typically consumed by institution-facing extracts, credit-transfer reporting, admissions evaluation screens, and integration interfaces that feed downstream credit articulation or student-record systems. Because it aggregates credit points across the student's advanced-standing unit records, it provides a single authoritative row per student, program, and institution combination, making it convenient for financial-aid, graduation-audit, and external-transcript reporting.

The view also carries institution location attributes such as city, state, and postal code, surfaced through the HZ geography join. This makes the institution_state column (aliased from HZ.STATE within the HZ_PARTIES join) directly available for jurisdictional and state-level reporting, which is often the reason users search for this object.

Underlying Base Objects

Based on the documented view text, the following objects are referenced directly or through inline subqueries:

  • IGS_EN_STDNT_PS_ATT_ALL (alias SPA) — student program attempt records; supplies person, course/program code.
  • HZ_PARTIES (aliases PE and HZ) — party master records; PE provides the person party number, HZ supplies institution city/state/postal code.
  • IGS_AD_ACAD_HISTORY_V (alias AHV) — academic history view; supplies institution code, name, type, program type attempted/earned, dates, education ID.
  • IGS_AD_TRANSCRIPT, IGS_AD_TERM_DETAILS, IGS_AD_TERM_UNITDTLS — transcript and term structure used in the inline advanced-standing subqueries.
  • IGS_AV_STND_UNIT_ALL and IGS_AV_STND_UNIT_LVL_ALL — advanced standing unit and unit-level records; these are the sources of credit points, filtered to GRANTED status and CREDIT recognition type.
  • IGS_PE_HZ_PARTIES (alias IPZ) — external organization unit mapping used in an outer join to associate institution codes with parties.

The view is therefore a multi-table join with an internal UNION ALL over two advanced-standing sources, aggregated by student and program.

Key Columns

Common Use Cases and Queries

Typical consumers query the view to produce credit-transfer summaries, graduation audits, and jurisdiction reporting.

Sample SQL to retrieve total transfer credit per student by institution and state:

SELECT person_number, program_cd, institution_name, institution_state,
       SUM(credit_points) total_credit
FROM   apps.igs_pr_acad_trans_credit_v
GROUP BY person_number, program_cd, institution_name, institution_state
ORDER BY person_number;

A state-restricted variant, often triggered by the "institution_state" search term:

SELECT person_id, institution_name, credit_points
FROM   apps.igs_pr_acad_trans_credit_v
WHERE  institution_state = 'CA';

Because the view aggregates advanced-standing credit records filtered by GRANTED status and CREDIT recognition type, results reflect only confirmed credit awards, not proposed or pending evaluations. Analysts should note the outer join on IGS_PE_HZ_PARTIES, which may return null institution-city/state values where no party mapping exists.