Results for “igs_ca_type_u1”

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

Overview

IGS.IGS_CA_TYPE is a reference (lookup) table in the Oracle E-Business Suite Student System (the "IGS" schema) that describes the available calendar types defined for an institution. In Oracle EBS 12.1.1 and 12.2.2 it functions as a foundational control table within the Student Systems calendar model, providing the categories that determine how a calendar type may be used. Business logic such as the rule that units can only be offered in instances of TEACHING calendars is driven directly from values held in this table. The table resides in the APPS_TS_TX_DATA tablespace with 10 percent PCTFREE, and its indexes reside in APPS_TS_TX_IDX.

Relationship mining suggests a hub-leaning classification under a Data Vault model: CAL_TYPE is a stable, unique business key that is referenced by a large number of dependent transactional and configuration entities. It is best modelled as a hub, with descriptive attributes such as DESCRIPTION, ABBREVIATION, NOTES, and CLOSED_IND treated as satellite content.

Key Information Stored

The most significant columns, drawn from the documented 12-column physical schema, are:

• CAL_TYPE (VARCHAR2(10), mandatory) — the institution-defined name of the calendar type and the primary key column of IGS_CA_TYPE_PK. It is also the single column of the unique index IGS_CA_TYPE_U1, making it the definitive business-key candidate.
• S_CAL_CAT (VARCHAR2(30)) — the system-defined categorization that tells the application how the calendar type may be used; for example, only types categorized as TEACHING permit unit offerings.
• DESCRIPTION (VARCHAR2(60)) — the human-readable description, such as "STANDARD ACADEMIC YEAR" or "SEMESTER 1 TEACHING PERIOD".
• ABBREVIATION (VARCHAR2(30)) — a short-form label used in reports and list-of-values displays.
• ARTS_TEACHING_CAL_TYPE_CD — the code linking the type to the ARTS (Automated Results Transfer System) teaching calendar; this column carries a nonunique index (IGS_CA_TYPE_N1) and a foreign key to IGS_CA_ARTS_TC_CA_CD.
• CLOSED_IND — indicates whether the calendar type is open or closed; a closed type cannot be selected for new calendar instance records.
• NOTES (VARCHAR2(2000)) — free-text field for additional institutional detail.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO audit columns that record row provenance.

Two indexes support retrieval: the unique IGS_CA_TYPE_U1 on CAL_TYPE, and the nonunique IGS_CA_TYPE_N1 on ARTS_TEACHING_CAL_TYPE_CD. A second nonunique index, IGS_CA_TYPE_N2, is documented on S_CAL_CAT, supporting category-based filtering.

Common Use Cases and Queries

Typical use cases include validating the calendar types available to a student or program, driving list-of-values lookups in forms and concurrent programs, and reporting on calendar type usage and status.

• Retrieve all active teaching calendar types: SELECT cal_type, description, abbreviation FROM igs_ca_type WHERE s_cal_cat = 'TEACHING' AND (closed_ind IS NULL OR closed_ind = 'N');
• Look up a specific type by business key: SELECT description, s_cal_cat, closed_ind FROM igs_ca_type WHERE cal_type = :p_cal_type;
• Identify closed types: SELECT cal_type, description FROM igs_ca_type WHERE closed_ind = 'Y';
• Reporting joins against dependent offer or enrolment tables using the shared CAL_TYPE column to group activity by calendar category.

Related Objects

IGS_CA_TYPE is referenced by many downstream objects via the CAL_TYPE column. The most significant dependent tables include:

• IGS_PS_OFR_ALL.CAL_TYPE — program offering records that are scoped to a type of calendar.
• IGS_PS_UNIT_OFR.CAL_TYPE — unit offerings, which are only valid for TEACHING category types.
• IGS_PS_PAT_STUDY_PRD.TEACH_CAL_TYPE and IGS_PS_PAT_OF_STUDY.ADMISSION_CAL_TYPE — student program and admission calendar assignments.
• IGS_EN_CONFIG_ENR_CP.CAL_TYPE — enrolment configuration control points.
• IGS_ST_DFT_LOAD_APPO.TEACH_CAL_TYPE — default study load appointment calendars.
• IGS_PS_FEE_TRG.CAL_TYPE and IGS_FI_UNIT_FEE_TRG.CAL_TYPE — fee trigger configuration keyed to calendar types.
• IGS_PR_S_PRG_CAL.PRG_CAL_TYPE and related program calendar system tables.
• IGS_CA_ARTS_TC_CA_CD — referenced by the ARTS_TEACHING_CAL_TYPE_CD foreign key.

Together these relationships confirm the table's role as a stable reference hub for the institutional calendar model in Oracle Student Systems.