Results for “igs_ca_inst”

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

Overview

IGS_CA_INST is a reporting and integration view within the Oracle E-Business Suite IGS – Student System product. In the Oracle EBS 12.1.1 and 12.2.2 releases, the IGS product line is documented as obsolete, meaning it is retained for backward compatibility only and receives no new functional development. This view presents calendar instance data, exposing the state and attributes of academic calendar instances that drive term-based processing across the Student System. Its documented purpose is to capture the enrollment method type related to self-service, which allows downstream reports and integrations to distinguish calendar instances that were created or managed through self-service channels from those maintained administratively.

Within the ETRM metadata the view is explicitly marked as "Not implemented in this database." This is significant: the object definition exists in the data dictionary documentation but the view itself is not deployed in every environment. Consumers must therefore verify physical existence before referencing it in a query or an interface. Where present, it functions as a standard EBS security-scoped view, resolving to a single organization context rather than returning all rows.

Underlying Base Objects

The view text selects from a single base table, IGS_CA_INST_ALL, aliased as TAB. No other referenced base objects are documented. IGS_CA_INST_ALL is the multi-organization ("_ALL") table that stores calendar instance records across all operating units, and IGS_CA_INST is the organization-secured single-organization view defined over it.

Organization filtering is implemented in the WHERE clause through a comparison of NVL(TAB.ORG_ID, ...) against the current session's organization identifier, derived from USERENV('CLIENT_INFO') using SUBSTRB, DECODE, and TO_NUMBER. When no organization context is supplied, both sides of the predicate evaluate to the sentinel value -99, which surfaces rows lacking an ORG_ID. This pattern is the standard Oracle multi-org secured view idiom, and it means query results are constrained by the MO: Operating Unit profile setting and the client information passed at connect time.

Key Columns

• ROW_ID — the base table ROWID, provided for uniquely addressing the underlying row from within the view.
• CAL_TYPE, SEQUENCE_NUMBER — the calendar type and sequence identifying a particular calendar instance.
• START_DT, END_DT — the effective start and end dates of the calendar instance.
• CAL_STATUS — the current status of the calendar instance, the primary column for lifecycle reporting.
• SUP_CAL_STATUS_DIFFER_IND — the indicator of whether the superior (parent) calendar status differs from this instance's status. This is the column referenced in the searched term "sup_cal_status_differ_ind" and is central to detecting status divergence between a calendar instance and its parent.
• PRIOR_CI_SEQUENCE_NUMBER — the sequence number of the prior calendar instance, supporting audit and change tracking.
• ALTERNATE_CODE, DESCRIPTION — descriptive identifiers for the instance.
• SS_DISPLAYED, IVR_DISPLAY_IND — self-service and IVR display flags controlling channel visibility.
• TERM_INSTRUCTION_TIME, PLANNING_FLAG, SCHEDULE_FLAG, ADMIN_FLAG — functional attributes governing scheduling, planning, and administrative handling.
• ORG_ID — the organization identifier used by the multi-org security predicate.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include validating calendar instance status, identifying instances whose status diverges from the parent calendar, and reporting instances visible in self-service. A representative query filtering on the searched column follows:

• SELECT CAL_TYPE, SEQUENCE_NUMBER, START_DT, END_DT, CAL_STATUS, SUP_CAL_STATUS_DIFFER_IND, ALTERNATE_CODE FROM IGS_CA_INST WHERE SUP_CAL_STATUS_DIFFER_IND = 'Y';
• SELECT SEQUENCE_NUMBER, CAL_STATUS, SS_DISPLAYED FROM IGS_CA_INST WHERE TRUNC(START_DT) >= TRUNC(SYSDATE) ORDER BY START_DT;

Because the object is not implemented in all databases, queries should be preceded by a check against ALL_VIEWS. Where absent, the underlying IGS_CA_INST_ALL can be queried directly, subject to the appropriate organization filter.