Search Results admission_test_description

Overview

The IGS_PR_ACAD_EXAM_CREDIT_V view is a reporting object within the Oracle E-Business Suite Student System (IGS) product family, owned by the APPS schema. In Oracle EBS 12.1.1 and 12.2.2, it exposes details of academic credit that has been granted to a student through advanced standing, where that credit originates from an Admissions Exam structure rather than from conventional prior learning or transfer articulation. The distinctive characteristic of this view is that credit is presented only as an aggregated summary figure. Rather than listing each individual advanced standing unit or unit level, the view rolls the underlying credit points into a single CREDIT_POINTS value per student, program, and admission test result combination. This makes the view suitable for reporting, verification, and downstream integration scenarios where a consolidated credit position is required without the granularity of the source advanced standing records.

Underlying Base Objects

The view is defined over several base and derived objects. The principal tables and views referenced are:

• IGS_AD_TEST_SEG_RESULTS_V — the admissions test segment results view, supplying test type, description, date, segment details, score, and the result detail identifier (TST_RSLT_DTLS_ID).
• IGS_EN_STDNT_PS_ATT_ALL — the student program attempt table, providing the person, program (course) code, and linking the student to their current program of study.
• HZ_PARTIES — the Trading Community Architecture party table, supplying the human-readable PARTY_NUMBER.
• A derived inline set combining IGS_AV_STND_UNIT_ALL and IGS_AV_STND_UNIT_LVL_ALL, filtered to records where TST_RSLT_DTLS_ID IS NOT NULL, the granting status is 'GRANTED', and (for unit records) the recognition type is 'CREDIT'.

The joins relate person identifiers across the test results, student attempt, party, and advanced standing sources, and additionally match the advanced standing course code to the student's program code and the test result detail identifier to the admissions test segment result. Aggregation is performed via SUM(ADV.CREDIT_POINTS), grouped by person, party number, program, and the test attributes.

Key Columns

• PERSON_ID — the internal identifier of the student (person).
• PARTY_NUMBER — the externally meaningful TCA party number for the student.
• PROGRAM_CD — the program (course) code against which the credit applies, aliased from SPA.COURSE_CD.
• ADMISSION_TEST_TYPE / ADMISSION_TEST_DESCRIPTION — the admissions test type code and its descriptive text.
• TEST_DATE — the date the admissions test was taken.
• TEST_SEGMENT_NAME / TEST_SEGMENT_DESCRIPTION — the test segment code and description.
• TEST_SCORE — the score achieved on the test segment.
• TST_RSLT_DTLS_ID — the test result detail identifier linking credit to a specific test result.
• CREDIT_POINTS — the aggregated sum of credit points granted through advanced standing based on the admissions exam.

Common Use Cases and Queries

Typical applications include verifying how much credit a student has gained through admissions exams, extracting consolidated credit summaries for an articulation report, and supporting integration feeds. A representative query follows:

• Retrieve aggregated credit for a student: SELECT person_id, party_number, program_cd, admission_test_description, test_date, credit_points FROM igs_pr_acad_exam_credit_v WHERE person_id = :p_person_id;
• List all admissions-exam credit by program: SELECT program_cd, COUNT(DISTINCT person_id), SUM(credit_points) FROM igs_pr_acad_exam_credit_v GROUP BY program_cd;
• Filter by test type or date range: SELECT * FROM igs_pr_acad_exam_credit_v WHERE test_date BETWEEN :start_date AND :end_date;

Because credit is aggregated, consumers requiring per-unit breakdowns should query the advanced standing unit tables directly. All access should respect the APPS schema and standard EBS security and reporting conventions.