Results for “igs_ca_da_cat”

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

Overview

IGS_CA_DA_CAT is a reference table within the Oracle E-Business Suite IGS (Student System) product family. It describes the user-defined categories assigned to a date alias, providing a mechanism to group date aliases into logical classifications. Date aliases in the Student System represent named calendar events or reference dates used throughout enrolment, admissions, and academic calendar processing, and this table supplies the categorical metadata that organizes them.

The IGS product line is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2, and the ETRM metadata explicitly notes that this object is not implemented in the current database. Organizations performing upgrades or historical data analysis should therefore treat IGS_CA_DA_CAT primarily as a legacy or archival structure rather than an actively populated one. Where the object does exist, it is owned by the IGS schema and physically documented with seven columns.

The heuristic Data Vault classification derived from the foreign key structure is hub-leaning. This suggests a modeling interpretation in which IGS_CA_DA_CAT functions as a central reference entity (a hub) whose business key is referenced by dependent tables, rather than as a transactional or link table. Under a Data Vault 2.0 design, DT_CAT would serve as the natural business key of the hub, while descriptive attributes such as DESCRIPTION would be carried in an associated satellite.

Key Information Stored

The table is organized around a single category identifier, DT_CAT, which serves as both the primary key (IGS_CA_DA_CAT_PK) and the unique business key candidate (IGS_CA_DA_CAT_U1). The remaining six columns are standard Oracle EBS audit and descriptive attributes. The most significant columns are:

• DT_CAT — the category code that uniquely identifies a date alias category; the surrogate/business key of the table.
• DESCRIPTION — the user-facing name or explanation of the category, used in list-of-values and lookup rendering.
• CREATED_BY — the application user who created the category record.
• CREATION_DATE — the date and time the record was inserted.
• LAST_UPDATED_BY — the application user who last modified the record.
• LAST_UPDATE_DATE — the date and time of the most recent modification.
• LAST_UPDATE_LOGIN — the login session that performed the last update, used for audit trail and concurrency tracking.

Because DT_CAT is both the primary key and a unique index, no duplicate category codes can exist, and every dependent record in downstream tables resolves to exactly one category definition. The audit columns follow the standard Oracle EBS WHO-column convention and support multi-organization and audit reporting requirements.

Common Use Cases and Queries

The principal business scenario for this table is seeding and validating date alias categories used by the academic calendar. A common query joins the category to its dependent date alias records to produce a categorized calendar view:

• Category lookup: SELECT DT_CAT, DESCRIPTION FROM IGS_CA_DA_CAT ORDER BY DT_CAT;
• Categorized aliases: SELECT c.DT_CAT, c.DESCRIPTION, d.* FROM IGS_CA_DA_CAT c, IGS_CA_DA d WHERE c.DT_CAT = d.DT_CAT;
• Audit review: SELECT DT_CAT, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS_CA_DA_CAT WHERE LAST_UPDATE_DATE > :cutoff;

Reporting use cases include grouping date aliases by category for academic calendar extracts, validating that every alias references a defined category (orphan detection), and reconciling legacy IGS data during migration to successor products. Because the object is obsolete, these queries are most relevant to archival extracts or pre-upgrade assessments.

Related Objects

The foreign key relationships documented in the ETRM metadata identify the following dependencies:

• IGS_CA_DA — the primary dependent table. Its DT_CAT column carries a foreign key referencing IGS_CA_DA_CAT, allowing each date alias to be assigned to a category.
• IGS_CA_DA_CAT_PK / IGS_CA_DA_CAT_U1 — the primary key and unique index on DT_CAT that enforce integrity and support lookups from IGS_CA_DA.

Beyond the documented join, related Student System calendar objects such as date alias validation routines and calendar setup forms would reference this category table for list-of-values rendering. In a Data Vault interpretation, IGS_CA_DA would translate into a link or satellite referencing the IGS_CA_DA_CAT hub. Given the obsolete status, integrators should confirm existence in the target environment before relying on these relationships.