Results for “igs_ca_da_inst”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_CA_DA_INST is a Student System calendar table that describes an instance of a date alias within a specific calendar instance. In Oracle EBS terminology, a calendar instance (IGS_CA_INST_ALL) represents a concrete occurrence of a calendar type, and a date alias (IGS_CA_DA) is a named, symbolic point within that calendar — for example, an enrollment open date, a fee due date, or a term start date. IGS_CA_DA_INST binds the two: it materializes each date alias into an actual dated position inside a given calendar instance, storing the resolved value in ABSOLUTE_VAL alongside a sequence number that disambiguates repeated occurrences of the same alias.

The table belongs to the IGS - Student System product, which is flagged as obsolete in current Oracle EBS documentation and is not implemented in modern 12.1.1/12.2.2 database instances. It remains relevant for legacy data migration, historical reporting, and understanding inter-module dependencies in institutions that ran the pre-12.x Student System. From a dimensional modeling perspective, the FK structure suggests a hub-leaning classification: the primary key is composed entirely of business identifiers rather than a synthetic surrogate, and the table is referenced as a foreign key target by a wide set of dependent objects, which is characteristic of a hub entity in a Data Vault model. This classification is a heuristic suggestion, not a documented Oracle designation.

Key Information Stored

The composite primary key, IGS_CA_DA_INST_PK, consists of DT_ALIAS, SEQUENCE_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER. This same four-column combination is also defined as unique index IGS_CA_DA_INST_U1, confirming there is no separate surrogate key — the business key is the identity of the row.

  • DT_ALIAS — the date alias identifier; foreign key to IGS_CA_DA. Distinguishes which named date (e.g., term start, census date) is being instantiated.
  • SEQUENCE_NUMBER — disambiguates multiple instances of the same date alias within one calendar instance.
  • CAL_TYPE — the calendar type, forming part of the reference into IGS_CA_INST_ALL.
  • CI_SEQUENCE_NUMBER — the calendar instance sequence number, jointly identifying the parent calendar instance with CAL_TYPE.
  • ABSOLUTE_VAL — the resolved absolute date/time value for this alias instance, the principal payload column.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS WHO-column auditability.

Common Use Cases and Queries

Typical usage resolves a symbolic date alias to its actual date within a calendar instance, or enumerates all date aliases defined for a given term. A representative query joining the parent calendar instance and the alias definition:

  • SELECT dai.DT_ALIAS, dai.ABSOLUTE_VAL FROM IGS_CA_DA_INST dai WHERE dai.CAL_TYPE = :cal_type AND dai.CI_SEQUENCE_NUMBER = :ci_seq;
  • Joining to IGS_CA_DA to retrieve the alias description, and to IGS_CA_INST_ALL to confirm the calendar instance start and end dates.
  • Fee and enrollment reporting frequently resolves start, end, and retroactive date aliases referenced by IGS_FI_F_CAT_CA_INST and IGS_FI_F_TYP_CA_INST_ALL to determine effective windows for charges and refunds.
  • Offset analysis uses IGS_CA_DA_INST_OFST to relate one alias instance to another by a defined offset.

Related Objects

The table sits at the center of the calendar date-alias model and is referenced by numerous downstream objects:

  • IGS_CA_DA — parent alias definition, joined on DT_ALIAS.
  • IGS_CA_INST_ALL — parent calendar instance, joined on CAL_TYPE and CI_SEQUENCE_NUMBER.
  • IGS_CA_DA_INST_OFST — offset relationships, referencing DT_ALIAS and OFFSET_DT_ALIAS.
  • IGS_CA_DA_INST_PAIR — paired alias relationships via RELATED_DT_ALIAS.
  • IGS_FI_F_CAT_CA_INST — fee category calendar instances, referencing START/END/RETRO date aliases.
  • IGS_FI_F_TYP_CA_INST_ALL — fee type calendar instances, same alias references.
  • IGS_FI_FEE_ENCMB, IGS_FI_FEE_PAY_SCHD, IGS_FI_FEE_RET_SCHD — fee encumbrance, payment, and refund schedules keyed on DT_ALIAS.
  • IGS_AD_PECRS_OFOP_DT — admissions open/offer date references.