Results for “igs_ad_ter_edu”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_AD_TER_EDU table is a core admissions data object within the Oracle E-Business Suite IGS – Student System product family. It stores tertiary education details reported for applicants and students from other institutions, capturing prior academic history required for admission evaluation, credit transfer, and qualification assessment. The table resides in the IGS schema and is documented as a valid object in both ETRM 12.1.1 and 12.2.2 releases. Each record represents one prior education entry associated with an individual party.

Under a heuristic Data Vault classification, this object is satellite-leaning. The pattern suggests that IGS_AD_TER_EDU functions as a descriptive satellite hanging off the HZ_PARTIES hub (via PERSON_ID), with degenerate business context supplied through lookup relationships to institutions, providers, and reference lists. This modeling suggestion aligns with its design: the descriptive attributes of prior education belong to a person, while the person identity itself is mastered in HZ_PARTIES.

Key Information Stored

The documented physical schema contains 32 columns. The most significant are:

• PERSON_ID — Party identifier referencing HZ_PARTIES; together with SEQUENCE_NUMBER forms the unique key IGS_AD_TER_EDU_U1.
• SEQUENCE_NUMBER — Ordinal distinguishing multiple prior-education records for the same person; a business-key candidate rather than a surrogate.
• INSTITUTION_CD / INSTITUTION_NAME — Code and name of the awarding institution.
• TERTIARY_EDU_LVL_COMP — Level of tertiary education completed, referencing IGS_AD_TER_ED_LV_COM.
• TERTIARY_EDU_LVL_QUAL — Level of the qualification attained, referencing IGS_AD_TER_ED_LVL_QF.
• COURSE_CD / COURSE_TITLE — Identifier and title of the course of study.
• FIELD_OF_STUDY — Subject area, referencing IGS_PS_FLD_OF_STUDY_ALL.
• HONOURS_LEVEL — Honours classification, referencing IGS_GR_HONOURS_LEVEL_ALL.
• GRADE_POINT_AVERAGE — Reported GPA for the prior qualification.
• ENROLMENT_FIRST_YR / ENROLMENT_LATEST_YR — Start and end years of enrolment.
• EQUIV_FULL_TIME_YRS_ENR — Equivalent full-time years of enrolment.
• LANGUAGE_OF_TUITION / LANGUAGE_COMPONENT — Language references against IGS_PE_LANGUAGE_CD.
• STATE_CD / COUNTRY_CD — Location of the institution; COUNTRY_CD references IGS_PE_COUNTRY_CD.
• EXCLUSION_IND — Indicator controlling exclusion of the record from processing.

Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) support concurrency and traceability.

Common Use Cases and Queries

Admissions staff, credit-transfer assessors, and reporting teams query this table to evaluate applicant histories. Typical scenarios include verifying prior qualifications against entry criteria, aggregating average GPA by institution, and reporting on study destinations for students.

SELECT a.person_id, a.sequence_number, a.institution_name,
       a.course_title, a.grade_point_average
FROM   igs_ad_ter_edu a
WHERE  a.person_id = :p_person_id
ORDER  BY a.sequence_number;

SELECT a.institution_cd, a.institution_name,
       COUNT(*) AS edu_records,
       AVG(a.grade_point_average) AS avg_gpa
FROM   igs_ad_ter_edu a
GROUP  BY a.institution_cd, a.institution_name;

Related Objects

The following tables are documented as related through foreign keys or dependents:

• HZ_PARTIES — referenced via PERSON_ID; provides the person identity.
• IGS_AD_TER_ED_UNI_AT — child table referencing IGS_AD_TER_EDU through PERSON_ID and TE_SEQUENCE_NUMBER, storing university attendance detail.
• IGS_AD_TER_ED_LV_COM — lookup for tertiary education level completed.
• IGS_AD_TER_ED_LVL_QF — lookup for tertiary education level qualification.
• IGS_PE_COUNTRY_CD — country reference for COUNTRY_CD.
• IGS_PS_FLD_OF_STUDY_ALL — field-of-study reference.
• IGS_GR_HONOURS_LEVEL_ALL — honours level reference.
• IGS_PE_LANGUAGE_CD — language reference for tuition and component.