Search Results igs_ca_inst_all

Overview

The IGS_CA_INST_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS), which is documented as obsolete in the provided metadata for releases 12.1.1 and 12.2.2. It functions as the master table for calendar instances, describing a specific temporal occurrence of a defined calendar type. Each record represents a unique instance, such as "Fall Semester 2023" or "Academic Year 2022-2023," characterized by a start date, end date, and status. Its primary role is to provide a standardized temporal reference point for numerous academic, administrative, and financial processes across the Student System and integrated modules like Financial Aid (IGF).

Key Information Stored

The table's structure is designed to uniquely identify and describe a calendar instance. The primary keys emphasize the importance of the combination of CAL_TYPE, SEQUENCE_NUMBER, and the date range (START_DT, END_DT). Key columns include CAL_TYPE, which defines the category of calendar (e.g., ACADEMIC, ADMISSION, LOAD); SEQUENCE_NUMBER, which orders instances within a calendar type; and START_DT and END_DT, which bound the instance. Additional critical columns are CAL_STATUS, indicating the instance's state (e.g., PLANNED, ACTIVE, CLOSED), and PRIOR_CI_SEQUENCE_NUMBER, which can establish a sequence or hierarchy between consecutive instances of the same calendar type.

Common Use Cases and Queries

This table is central to time-based reporting and process execution. A common use case is determining the active academic calendar for a given date to drive enrollment, billing, or financial aid disbursement rules. For instance, a query to find the current academic term would filter on CAL_TYPE, a status of 'ACTIVE', and a date within START_DT and END_DT. In the context of the user's search for "igf_aw_coa_group_all," this table is indirectly relevant as the calendar instance often governs the period for which a Cost of Attendance (COA) group is valid. Sample SQL for joining to a financial aid table would typically involve the CAL_TYPE and SEQUENCE_NUMBER columns, as seen in the foreign key relationships to tables like IGF_AW_AWD_DISB_ALL.

Related Objects

As evidenced by the extensive foreign key relationships, IGS_CA_INST_ALL is a fundamental parent table referenced by numerous entities across the EBS suite. Key documented relationships include:

• IGF_AW_AWD_DISB_ALL: Links via TP_CAL_TYPE/TP_SEQUENCE_NUMBER and LD_CAL_TYPE/LD_SEQUENCE_NUMBER to define the disbursement and load calendar periods for financial aid awards.
• IGF_AW_AWD_CERT_RESPS & IGF_AW_LOAN_LIMIT_ALL: Reference CI_CAL_TYPE and CI_SEQUENCE_NUMBER for certification and loan limit contexts.
• IGS_AD_PS_APPL_INST_ALL: References the table multiple times for admission, deferred admission, and future academic calendars using columns like ADM_CAL_TYPE/ADM_CI_SEQUENCE_NUMBER.
• IGS_AS_ANON_ID_ASS & IGS_AS_ANON_NUMBER: Use LOAD_CAL_TYPE and LOAD_CI_SEQUENCE_NUMBER to associate anonymous assessment data with an academic load period.
• IGF_AP_ATTEND_MAP_ALL: Joins on CAL_TYPE and SEQUENCE_NUMBER for attendance mapping.
• IGS_CA_STAT & IGS_CA_INST_ALL (self-reference): For status validation and linking to prior calendar instances, respectively.

These relationships underscore its role as a central temporal dimension table.