Results for “igs_ca_da”

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

Overview

IGS_CA_DA is a reference (setup) table within the Oracle EBS Student System product family, classified under the IGS module. The ETRM documentation describes it as a table that "describes available date alias types." In the Student System calendaring architecture, a date alias is an abstract, symbolic name for a date or a rule for deriving a date (for example, the start of an academic period or an enrollment cutoff). Rather than hard-coding literals, the application stores these aliases once and lets configuration and institutional calendar tables reference them, which allows date logic to be resolved consistently across admissions, enrollment, assessment, financial, and progression processes.

The table sits within the broader IGS calendaring (IGS_CA) schema and is currently flagged as obsolete and "not implemented in this database," meaning it may not exist in a given 12.1.1 or 12.2.2 instance depending on which Student System modules were installed. From a Data Vault modeling perspective, the metadata's heuristic classification is hub-leaning: DT_ALIAS functions as a durable business key, making IGS_CA_DA a natural candidate for a hub, with its descriptive columns representing satellite attributes. This is a modeling suggestion, not a documented Oracle design classification.

Key Information Stored

The documented physical schema contains twelve columns owned by IGS. The most significant are:

• DT_ALIAS — the primary key (IGS_CA_DA_PK) and the business key. It uniquely identifies each date alias and is also the single column backing the unique index IGS_CA_DA_U1.
• DT_CAT — the date alias category; a foreign key to IGS_CA_DA_CAT, used to group aliases by function.
• DESCRIPTION — the human-readable description of the alias.
• ABBREVIATION — a short code or label for display and reporting.
• S_CAL_CAT — a system/calendar category indicator, likely used to scope the alias to a calendar context.
• CLOSED_IND — a status flag marking whether the alias is closed or inactive for use.
• NOTES — free-text commentary for administrators.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO audit columns tracking record creation and modification.

The surrogate primary key is DT_ALIAS itself; there is no separate numeric ID column documented, so DT_ALIAS serves simultaneously as PK and business-key candidate.

Common Use Cases and Queries

The primary use case is looking up and validating date alias definitions before they are consumed by calendar configuration and transaction-processing tables. Typical queries include retrieving all aliases in a category, filtering to active aliases, or resolving an alias to its description and abbreviation for reporting.

• Listing active aliases by category:

  SELECT dt_alias, description, abbreviation, dt_cat
  FROM   igs_ca_da
  WHERE  dt_cat = :p_category
  AND    NVL(closed_ind,'N') = 'N';

• Resolving a single alias for display:

  SELECT description, abbreviation
  FROM   igs_ca_da
  WHERE  dt_alias = :p_alias;

• Finding every configuration table that points at a given alias, to gauge impact before changing or disabling it — joining IGS_EN_CAL_CONF, IGS_AD_CAL_CONF, IGS_AS_CAL_CONF, and IGS_FI_CONTROL_ALL on their respective DT_ALIAS columns.
• Data quality reporting on aliases that are inactive but still referenced by active configuration rows.

These queries support functional analysts validating institution calendar setup and DBAs auditing orphaned or disabled aliases.

Related Objects

IGS_CA_DA is a heavily referenced hub. The most significant dependent objects, with actual join columns, include:

• IGS_CA_DA_CAT — the parent category table, joined via IGS_CA_DA.DT_CAT = IGS_CA_DA_CAT.DT_CAT.
• IGS_CA_DA_INST — institution-specific alias instances, joined on DT_ALIAS.
• IGS_CA_DA_OFST — offset definitions, joined on DT_ALIAS and OFFSET_DT_ALIAS.
• IGS_CA_DA_PAIR — related alias pairings, joined on DT_ALIAS and RELATED_DT_ALIAS.
• IGS_EN_CAL_CONF — enrollment calendar configuration, referencing many alias columns (planning/schedule open dates, commencement, cutoff, and others).
• IGS_AD_CAL_CONF — admissions calendar configuration, referencing admission application date aliases.
• IGS_AS_CAL_CONF — assessment calendar configuration, referencing mark/grading schedule aliases.
• IGS_FI_CONTROL_ALL — financial control settings, joined on RES_DT_ALIAS and REFUND_DT_ALIAS.
• IGF_AW_TP_INSTMT_ALL and IGF_AW_DP_TEACH_PRDS — award installment and teaching period tables, joined on TP_OFFSET_DA and DATE_OFFSET_CD respectively.
• IGS_PE_USR_ARG_ALL — person user arguments, referencing record open, cutoff, graduation schedule, and update audit aliases.

Together these confirm that IGS_CA_DA is foundational reference data; changes to an alias ripple through admissions, enrollment, assessment, financial, and progression configuration across the Student System.