Search Results time_frame

Overview

IGS_DA_XML_GPA_V is a read-only view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) module. It is part of the Diploma Supplement / Academic Transcript XML generation facility, surfacing data required by the GPAType XML element, a child of AcademicProgram in the transcript XML schema. The view returns the Grade Point Average stored or calculated for a student, keyed by person, program code, calendar instance, and time frame. In EBS 12.1.1 and 12.2.2 it is classified as VALID and is consumed primarily by the XML publishing layer rather than by end-user forms.

The row source is highly relevant to the search term "time_frame." The view's driving predicate restricts output to rows where INS.TIMEFRAME IN ('CUMULATIVE', 'BOTH'), and it emits the literal string 'CUMULATIVE' into the TIME_FRAME column. This means the view is intentionally scoped to cumulative academic performance and excludes term-only or other time frame definitions.

Underlying Base Objects

The view is defined over three documented base objects:

• IGS_CA_INST_ALL (alias CI) — the calendar instance table, supplying the calendar type (CAL_TYPE) and sequence number (SEQUENCE_NUMBER).
• IGS_DA_REQ_STDNTS (alias DRS) — the requested students driver table, supplying PERSON_ID, PROGRAM_CODE, BATCH_ID, and IGS_DA_REQ_STDNTS_ID.
• IGS_PR_INST_STAT (alias INS) — the institution status table, filtered on STANDARD_IND = 'Y' and the time frame predicate noted above.

No additional referenced base objects are documented in the ETRM metadata. A significant portion of the GPA figures is not stored in these tables at all; it is computed at query time through packaged functions in IGS_DA_XML_PKG, including GET_CUM_ATTEMPTED_CP, GET_CUM_EARNED_CP, GET_CUM_GPA, GET_CUM_GPA_CP, and GET_CUM_GPA_QP. Each function is invoked with the person, program, calendar type, sequence number, and status type.

Key Columns

• GPA_CATEGORY — populated with the literal 'CUMULATIVE'; identifies the GPA aggregation category.
• TIME_FRAME — the time frame qualifier central to the view's filtering; cumulative by design.
• ATTEMPTED_CREDIT_POINTS and EARNED_CREDIT_POINTS — cumulative credit points attempted and earned, from the package functions.
• CALCULATED_GPA, GPA_CREDIT_POINTS, GPA_QUALITY_POINTS — the computed grade point average and its credit and quality point components.
• PERSON_ID, PROGRAM_CODE, LOAD_CAL_TYPE, LOAD_CI_SEQUENCE_NUMBER — student and program/calendar identification carried from the driver tables.
• SESSION_ID, BATCH_ID, IGS_DA_REQ_STDNTS_ID — process, batch, and driver-row identifiers linking the output to a specific XML run.

Common Use Cases and Queries

Typical use is validating or debugging GPA output for a transcript XML run, or extracting cumulative GPA for downstream reporting. Callers should expect row-level granularity of person, program, and calendar instance.

Example 1 — cumulative GPA for a person and program:

• SELECT person_id, program_code, time_frame, calculated_gpa FROM apps.igs_da_xml_gpa_v WHERE person_id = :p_person AND program_code = :p_prog;

Example 2 — all output rows for a batch:

• SELECT batch_id, person_id, attempted_credit_points, earned_credit_points, calculated_gpa FROM apps.igs_da_xml_gpa_v WHERE batch_id = :p_batch ORDER BY person_id;

Because the underlying measures are computed by PL/SQL functions, performance of the view is sensitive to function execution; queries benefit from the same person/program/batch predicates that limit the driver set. In 12.1.1 and 12.2.2 the definition and validity are unchanged.