Results for “igs_ca_type”

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

Overview

IGS_CA_TYPE is the calendar type reference table within the Oracle E-Business Suite Student System (IGS) product family. It defines the categories of academic calendars that the institution uses to organize teaching periods, admissions cycles, fee assessments, enrollment configurations, and program delivery. Every functional calendar record in the Student System is qualified by a calendar type, making IGS_CA_TYPE a foundational control table rather than a transactional one.

The table resides in the IGS schema and is marked VALID in the ETRM 12.1.1 / 12.2.2 data dictionary. The documented physical schema contains twelve columns, with a primary key constraint IGS_CA_TYPE_PK on the CAL_TYPE column. A unique index, IGS_CA_TYPE_U1, also exists on CAL_TYPE as the business-key candidate.

Under the heuristic Data Vault classification derived from the foreign-key structure, this table is hub-leaning. In practice that means IGS_CA_TYPE functions as a stable list of business keys (calendar type codes) that downstream transactional and configuration tables reference. Modeling it as a hub, with descriptive attributes such as DESCRIPTION and ABBREVIATION carried as satellite context, is a reasonable design suggestion.

Key Information Stored

The most significant columns in IGS_CA_TYPE are:

• CAL_TYPE — The calendar type code. It is both the surrogate primary key (IGS_CA_TYPE_PK) and the documented unique business key (IGS_CA_TYPE_U1). All referencing tables join on this column.
• DESCRIPTION — The human-readable name of the calendar type, used in list-of-values displays and reports.
• ABBREVIATION — A short code used where display space is limited.
• S_CAL_CAT — The system calendar category, which classifies the calendar type for processing logic.
• ARTS_TEACHING_CAL_TYPE_CD — A self-referencing attribute pointing to a related calendar type row, typically used for articulation or teaching-calendar linkage.
• CLOSED_IND — An indicator that the calendar type is closed to further use or assignment.
• NOTES — Free-form annotation maintained by administrative users.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns populated automatically by the application.

The self-referencing foreign key on ARTS_TEACHING_CAL_TYPE_CD targets IGS_CA_ARTS_TC_CA_CD, indicating a specialized articulation teaching-calendar relationship.

Common Use Cases and Queries

Typical reporting and integration scenarios resolve calendar type codes into readable descriptions, or validate that referenced codes remain open.

A common lookup pattern joins a referencing table such as IGS_PS_UNIT_OFR to its calendar type description:

• SELECT u.CAL_TYPE, t.DESCRIPTION FROM IGS_PS_UNIT_OFR u, IGS_CA_TYPE t WHERE u.CAL_TYPE = t.CAL_TYPE;

An administrative query validates open calendar types:

• SELECT CAL_TYPE, DESCRIPTION, S_CAL_CAT FROM IGS_CA_TYPE WHERE CLOSED_IND = 'N';

Queries over enrollment configuration (IGS_EN_CONFIG_ENR_CP), fee triggers (IGS_PS_FEE_TRG, IGS_FI_UNIT_FEE_TRG), student default load appointments (IGS_ST_DFT_LOAD_APPO), and program calendar views (IGS_PR_S_PRG_CAL) all depend on this table for decoding and filtering.

Related Objects

IGS_CA_TYPE is referenced by numerous tables and one self-reference through foreign keys. The most significant relationships are:

• IGS_CA_ARTS_TC_CA_CD — referenced by IGS_CA_TYPE.ARTS_TEACHING_CAL_TYPE_CD (self-link on articulation teaching calendar).
• IGS_PS_UNIT_OFR — via CAL_TYPE, linking offered units to their calendar type.
• IGS_PS_OFR_ALL — via CAL_TYPE, linking all offers.
• IGS_PS_FEE_TRG and IGS_FI_UNIT_FEE_TRG — via CAL_TYPE, used for fee trigger definition.
• IGS_EN_CONFIG_ENR_CP — via CAL_TYPE, governing enrollment configuration.
• IGS_PS_PAT_STUDY_PRD and IGS_PS_PAT_OF_STUDY — via TEACH_CAL_TYPE and ADMISSION_CAL_TYPE, defining study patterns.
• IGS_PR_S_PRG_CAL, IGS_PR_S_OU_PRG_CAL, and IGS_PR_S_CRV_PRG_CAL — via PRG_CAL_TYPE, for program calendar views.
• IGS_ST_DFT_LOAD_APPO — via TEACH_CAL_TYPE, for default load appointments.
• IGS_AS_ANON_METHOD — via LOAD_CAL_TYPE, and IGS_AD_CAL_CONF — via INQ_CAL_TYPE, for admissions calendar configuration.