Search Results test_segment_description

Overview

APPS.IGS_PR_ACAD_EXAM_CREDIT_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, residing within the Student Systems / Student Records (IGS) product family. Its principal role is to consolidate academic examination results with credit that has been awarded through advanced standing (recognition of prior learning or articulation). The view answers the business question: for each student, which admission test segments have produced granted credit for a specific course or program, and what is the aggregated credit point value?

The view is predominantly used for student progression reporting, credit transfer audits, admissions analytics and downstream integrations where an institution needs to reconcile examination-based credit decisions. Because the user searched for the column tst_rslt_dtls_id, it is important to note that this identifier is the linking key in the view: it joins the test-result detail records to the advanced standing unit records on which credit was granted.

Underlying Base Objects

The view is defined over a join of several IGS and HZ objects. The documented base objects referenced in the view text are:

• IGS_AD_TEST_SEG_RESULTS_V (alias ATSR) — a view exposing admission test segment results, including test type, test date, segment name, segment description, test score and the tst_rslt_dtls_id.
• IGS_EN_STDNT_PS_ATT_ALL (alias SPA) — the student program attempt/registration record, supplying person_id and course_cd (program_cd).
• HZ_PARTIES (alias PE) — the trading community party table, supplying the human-readable party_number for the person.
• A derived inline sub-query (alias ADV) built from IGS_AV_STND_UNIT_ALL (alias ASU) and IGS_AV_STND_UNIT_LVL_ALL (alias ASUL), unioned together to collect granted credit points at unit and unit-level granularity.

Joins are established on person_id across SPA, PE, ATSR and ADV, on as_course_cd = spa.course_cd, and critically on adv.tst_rslt_dtls_id = atsr.tst_rslt_dtls_id. The ADV sub-query filters for records where tst_rslt_dtls_id is not null, granting status is 'GRANTED', and, in the unit branch, recognition type is 'CREDIT'.

Key Columns

• PERSON_ID — student identifier linking to the party record.
• PARTY_NUMBER — the logical party number from HZ_PARTIES.
• PROGRAM_CD — the course code from the student program attempt (aliased from course_cd).
• ADMISSION_TEST_TYPE / ADMISSION_TEST_DESCRIPTION — the type and descriptive text of the admission test.
• TEST_DATE — the date on which the test or segment was taken.
• TEST_SEGMENT_NAME / TEST_SEGMENT_DESCRIPTION — identifies and describes the test segment.
• TEST_SCORE — the achieved score for the segment.
• TST_RSLT_DTLS_ID — the unique test result detail identifier that serves as the join key between test segments and granted credit.
• CREDIT_POINTS — the SUM of granted credit points from the ADV sub-query.

Common Use Cases and Queries

A typical query retrieves granted credit attributable to a specific test-result detail, which is the exact fetch pattern implied by the search term:

• SELECT person_id, party_number, program_cd, test_segment_name, credit_points FROM apps.igs_pr_acad_exam_credit_v WHERE tst_rslt_dtls_id = :p_tst_rslt_dtls_id;

Other scenarios include listing all credit awarded per student for a program, auditing test segments that generated credit within a date range, and feeding credit totals into student progression or graduation calculations. Because credit points are aggregated with SUM and grouped by segment attributes, each row represents a unique combination of student, program, admission test and test segment.