Results for “te_sequence_number”

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

Overview

IGS_AD_TER_ED_UNI_AT is a transactional table in the IGS (Student System) product module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It describes unit attempts for tertiary education declared by an applicant in support of admission or advanced standing evaluation. Each record captures one attempted unit of study at a prior institution, forming the detailed academic history that admissions officers assess when granting credit, exemption, or advanced standing toward a program at the receiving institution.

The table sits beneath the applicant's tertiary education header record (IGS_AD_TER_EDU), providing line-level granularity for units attempted within a given education entry. Under a heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link, since it associates a person/education context with a discipline group and unit result rather than acting as a standalone hub or a pure descriptive satellite.

Key Information Stored

The 15 documented columns divide into identifier, academic content, and audit groups. The primary key, IGS_AD_TER_ED_UNI_AT_PK, is a composite business key comprising PERSON_ID, TE_SEQUENCE_NUMBER, UNIT_CD, and SEQUENCE_NUMBER. The same four columns are also exposed through the unique index IGS_AD_TER_ED_UNI_AT_U1, making them the definitive business-key candidates for deduplication and upsert logic.

• PERSON_ID — identifies the applicant (party/person) whose prior study is recorded.
• TE_SEQUENCE_NUMBER — sequence that ties the unit attempt to its parent tertiary education row in IGS_AD_TER_EDU.
• UNIT_CD — the code of the unit or subject attempted at the prior institution.
• SEQUENCE_NUMBER — discriminator allowing multiple attempts of the same unit to be retained.
• ENROLLED_YR — the academic year in which the applicant enrolled in the unit.
• RESULT_TYPE — classification of the result outcome (for example graded, ungraded, or withdrawn).
• TITLE — descriptive name of the unit attempted.
• CREDIT_POINTS — credit value attributed to the unit, used in advanced standing calculations.
• GRADE — the grade achieved, a primary driver of credit decisions.
• DISCIPLINE_GROUP_CD — the discipline group to which the unit belongs, referencing IGS_PS_DSCP_ALL.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns tracking row provenance and change history.

Common Use Cases and Queries

Admissions and credit-transfer reporting rely heavily on this table. Typical queries join the unit attempts to the parent education record and to the discipline group to produce an applicant's prior-study transcript for evaluation.

SELECT u.PERSON_ID, u.TE_SEQUENCE_NUMBER, u.UNIT_CD,
       u.TITLE, u.GRADE, u.CREDIT_POINTS, u.ENROLLED_YR
FROM   IGS.IGS_AD_TER_ED_UNI_AT u
WHERE  u.PERSON_ID = :person_id
ORDER  BY u.TE_SEQUENCE_NUMBER, u.SEQUENCE_NUMBER;

Advanced standing analysis aggregates credit points by discipline group to determine eligibility for exemption:

SELECT u.DISCIPLINE_GROUP_CD, SUM(u.CREDIT_POINTS) total_credits
FROM   IGS.IGS_AD_TER_ED_UNI_AT u
WHERE  u.PERSON_ID = :person_id
  AND  u.RESULT_TYPE = :passing_result_type
GROUP  BY u.DISCIPLINE_GROUP_CD;

Common scenarios include validating that declared units map to valid discipline groups, reconciling submitted transcripts against entered data, and extracting applicant academic history for interfacing into external credit-assessment systems.

Related Objects

The documented foreign keys anchor this table to two principal parents:

• IGS_AD_TER_EDU — parent tertiary education record; joined on PERSON_ID and TE_SEQUENCE_NUMBER. Deleting or amending the education header cascades contextually to its unit attempts.
• IGS_PS_DSCP_ALL — discipline group reference; joined on DISCIPLINE_GROUP_CD to resolve valid discipline definitions.
• IGS_AD_TER_ED_UNI_AT_PK / _U1 — primary key and unique index enforcing the business key across PERSON_ID, TE_SEQUENCE_NUMBER, UNIT_CD, and SEQUENCE_NUMBER.
• Person/party tables — PERSON_ID commonly resolves against the person and party layer (for example HZ_PARTIES, PER_ALL_PEOPLE_F) for applicant demographics in reporting joins.

Together these relationships position IGS_AD_TER_ED_UNI_AT as the detailed academic-history link beneath applicant admission data in the Student System.