Results for “igs_ca_da_v”

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

Overview

IGS_CA_DA_V is a reporting view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. The object name resolves to "IGS Calendar Date Alias" and exposes the date-alias definitions used by the Oracle Student System academic calendar engine. A date alias is a named reference to a specific calendar date (or date pattern) that other IGS components — enrollment, term setup, fee calculation, and scheduling — can reference symbolically rather than by hard-coded date. The view is read-only by design and is intended for reporting, inquiry, and integration extraction rather than direct maintenance, which is performed against the base tables through the Student System forms.

Because the view is defined in the APPS schema and does not carry an application-specific synonym in the documented metadata, access is typically granted through the standard APPS data model with appropriate IGS responsibility or custom read grants.

Underlying Base Objects

The view text documented in ETRM shows a UNION ALL of two branches over three base objects:

• IGS_CA_DA — the primary calendar date alias table, holding alias code, description, category, abbreviation, system calendar category, closed indicator, notes, and standard WHO audit columns.
• IGS_CA_DA_CAT — the date alias category table, joined on DA.DT_CAT = DAC.DT_CAT in both branches to supply the category description (DAC_DESCRIPTION).
• IGS_LOOKUP_VALUES — the standard IGS lookup view, joined on LOOKUP_CODE = DA.S_CAL_CAT with LOOKUP_TYPE = 'CAL_CAT' in the first branch only.

The UNION ALL is required because a date alias may or may not have a system calendar category (S_CAL_CAT). The first branch returns aliases where S_CAL_CAT is populated and resolves the lookup meaning; the second branch returns aliases where S_CAL_CAT IS NULL and deliberately supplies NULL for the MEANING column. In both branches the row identity is preserved via DA.ROWID exposed as ROW_ID.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_CA_DA row; useful for drilling back to the base record.
• DT_ALIAS — the alias code, the primary business key used in lookups and foreign references.
• DESCRIPTION / ABBREVIATION — the descriptive name and short form of the date alias.
• DT_CAT / DAC_DESCRIPTION — the category code and its decoded description from IGS_CA_DA_CAT.
• S_CAL_CAT / MEANING — the system calendar category code and its decoded meaning from the CAL_CAT lookup; MEANING is NULL when S_CAL_CAT is not set.
• CLOSED_IND — flag indicating whether the alias is closed for use.
• NOTES — free-text annotation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include validating date alias setup before term rollover, populating custom reports of academic calendar definitions, and feeding integration extracts that map external calendar identifiers to IGS aliases. The following query lists open aliases with their categories:

SELECT dt_alias, description, dac_description, meaning
FROM apps.igs_ca_da_v
WHERE NVL(closed_ind,'N') = 'N'
ORDER BY dt_cat, dt_alias;

To find aliases lacking a system calendar category, filter on s_cal_cat IS NULL; to reconcile counts against the base table, compare COUNT(*) from the view with IGS_CA_DA. Because the definition is a UNION ALL over the base table, no aggregation or DISTINCT is applied, so row counts match one-for-one except where the category join is expected to be mandatory (it is an inner join in both branches, so orphaned DT_CAT values would be excluded). Reports should always qualify the view as APPS.IGS_CA_DA_V to avoid synonym ambiguity.