Results for “igs_en_spa_terms”

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

Overview

IGS_EN_SPA_TERMS is a table in the IGS (Student System) product schema of Oracle E-Business Suite, documented as VALID in both release 12.1.1 and 12.2.2. Its ETRM description defines it as holding "Program attempt attributes based on Term Calendar," which positions the table as the term-level extension of a student's program attempt. Where the parent program attempt record captures the overall enrolment of a person in a program, IGS_EN_SPA_TERMS stores the calendar-term-specific attributes that apply to that attempt, such as the term calendar instance, fee category, class standing, and offering option reference.

The object carries 45 documented columns and is owned by the IGS schema. Heuristic Data Vault classification mined from the foreign-key structure identifies this table as a link. In modeling terms, this suggests IGS_EN_SPA_TERMS behaves as an associative structure connecting a program attempt (person plus program) to a term calendar instance and to supporting reference entities such as fee categories, class standings, and offering options.

Key Information Stored

The surrogate primary key is TERM_RECORD_ID, enforced by the IGS_EN_SPA_TERMS_PK unique index. This column is the technical identity of each row and should be used for direct row access and for joins where the business key is not convenient.

A second unique index, IGS_EN_SPA_TERMS_U1, defines the business-key candidate: PERSON_ID, PROGRAM_CD, TERM_CAL_TYPE, and TERM_SEQUENCE_NUMBER. Together these four columns identify a program attempt within a specific term calendar and sequence, preventing duplicate term records for the same person, program, and term.

• PERSON_ID — the student or person to whom the program attempt belongs; joins to IGS_EN_STDNT_PS_ATT_ALL.
• PROGRAM_CD / PROGRAM_VERSION — the program and its version associated with the attempt.
• TERM_CAL_TYPE / TERM_SEQUENCE_NUMBER — the term calendar instance and sequence; these join to IGS_CA_INST_ALL.
• ACAD_CAL_TYPE — the academic calendar context for the attempt.
• FEE_CAT — the fee category applicable to the term record; references IGS_FI_FEE_CAT_ALL.
• CLASS_STANDING_ID — the class standing (for example, year level) applicable to the attempt; references IGS_PR_CLASS_STD.
• COO_ID — the offering option reference; joins to IGS_PS_OFR_OPT_ALL.
• LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE — delivery and attendance attributes for the term.
• KEY_PROGRAM_FLAG — indicates whether the program is treated as a key program for the attempt.
• PLAN_SHT_STATUS — the planning sheet status associated with the record.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — links back to the originating program application and program definition.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard Oracle EBS descriptive flexfield columns for client-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID — standard WHO audit and concurrent request columns.

Common Use Cases and Queries

Typical usage centres on term-level reporting for a student's program attempt: fee category determination, class standing tracking across terms, and attendance mode analysis. A common pattern joins the term record to the parent program attempt and to the term calendar instance:

• Retrieving all term records for a person and program, ordered by term sequence, to build a progression history.
• Listing term records with their fee category and class standing for billing or fee assessment extracts.
• Reporting attendance mode and location by term for cohort or delivery analysis.
• Joining to IGS_CA_INST_ALL to translate TERM_CAL_TYPE and TERM_SEQUENCE_NUMBER into calendar dates for time-based reporting.

A representative query skeleton uses the business key columns and the FK relationships:

• SELECT t.term_record_id, t.person_id, t.program_cd, t.term_cal_type, t.term_sequence_number, t.fee_cat, t.class_standing_id FROM igs.igs_en_spa_terms t WHERE t.person_id = :person_id AND t.program_cd = :program_cd ORDER BY t.term_sequence_number;
• Join to igs.igs_ca_inst_all c ON c.cal_type = t.term_cal_type AND c.sequence_number = t.term_sequence_number to obtain term dates.
• Join to igs.igs_fi_fee_cat_all f ON f.fee_cat = t.fee_cat for fee category descriptions.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign-key relationships:

• IGS_EN_STDNT_PS_ATT_ALL — parent program attempt table; joined on PERSON_ID (and PROGRAM_CD).
• IGS_CA_INST_ALL — calendar instance table; joined on TERM_CAL_TYPE and TERM_SEQUENCE_NUMBER.
• IGS_PS_OFR_OPT_ALL — offering option table; joined on COO_ID.
• IGS_FI_FEE_CAT_ALL — fee category reference; joined on FEE_CAT.
• IGS_PR_CLASS_STD — class standing reference; joined on CLASS_STANDING_ID.
• IGS_EN_SPA_TERMS_PK / IGS_EN_SPA_TERMS_U1 — the enforcing unique indexes for the surrogate key and business-key candidate respectively.

These relationships make IGS_EN_SPA_TERMS a central link between program attempt data and term calendar, fee, standing, and offering-option reference data within the Oracle Student System.