Results for “step_catalog_id”

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

Overview

IGS_TR_STP_CTL_TYPE is a configuration table within the Oracle E-Business Suite IGS (Student System) product family. As documented in the ETRM metadata, it stores the system tracking type records associated with Catalog entries. In practical terms, the table defines which system-level tracking types are enabled or valid for a given step catalog, providing the control linkage between a catalog definition and the tracking mechanisms applied to students as they progress through that catalog.

The metadata explicitly flags this object as belonging to an obsolete module, and the implementation note states "Not implemented in this database." This is a significant caveat: in many Oracle EBS 12.1.1 and 12.2.2 environments, the IGS schema objects are either absent or vestigial, having been superseded by the higher-education Oracle Student System (OUS) or by later releases of the Student Information System. Deployments still running the legacy IGS schema may retain the table for historical or migration purposes. Its Data Vault classification is described heuristically as satellite-leaning, meaning it is best modeled as a satellite surrounding a catalog hub or link rather than as an independent hub or link itself — a modeling suggestion rather than an enforced design rule.

Key Information Stored

The table is defined with eight physical columns. The most important are:

• STEP_CATALOG_ID — Identifies the parent step catalog. This column participates in both the composite primary key and the foreign key to IGS_TR_STEP_CTLG_ALL.
• S_TRACKING_TYPE — The system tracking type code. Together with STEP_CATALOG_ID, it forms the composite primary key IGS_TR_STP_CTL_TYPE_PK.
• CLOSED_IND — A status indicator marking whether the tracking type association is closed or inactive.
• CREATED_BY — The user who created the record.
• CREATION_DATE — The date the record was created.
• LAST_UPDATED_BY — The user who last modified the record.
• LAST_UPDATE_DATE — The timestamp of the last modification.
• LAST_UPDATE_LOGIN — The login session identifier associated with the last update.

The primary key IGS_TR_STP_CTL_TYPE_PK (STEP_CATALOG_ID, S_TRACKING_TYPE) is the only documented unique index and therefore serves as the business-key candidate. There is no separate surrogate key column; the composite business key functions directly as the primary key. The trailing WHO columns (CREATED_BY through LAST_UPDATE_LOGIN) are standard Oracle EBS audit columns maintained by the framework.

Common Use Cases and Queries

Typical usage centers on determining which tracking types are configured for a catalog. Reporting queries join to the parent catalog table to resolve catalog descriptions:

• List active tracking types for a catalog: SELECT s.STEP_CATALOG_ID, s.S_TRACKING_TYPE FROM IGS_TR_STP_CTL_TYPE s WHERE s.CLOSED_IND = 'N' AND s.STEP_CATALOG_ID = :catalog_id;
• Catalog-to-tracking join: SELECT c.CATALOG_CODE, s.S_TRACKING_TYPE FROM IGS_TR_STEP_CTLG_ALL c, IGS_TR_STP_CTL_TYPE s WHERE c.STEP_CATALOG_ID = s.STEP_CATALOG_ID;
• Audit/change tracking: Filter on LAST_UPDATE_DATE to identify recently modified control records.

Because the table is satellite-leaning, analytics teams migrating IGS data into a warehouse should treat it as an attribute set attached to the catalog hub, keyed by STEP_CATALOG_ID and S_TRACKING_TYPE, and should preserve the CLOSED_IND flag as a historized status attribute rather than a natural key component.

Related Objects

• IGS_TR_STEP_CTLG_ALL — Parent table referenced by the foreign key on STEP_CATALOG_ID; the primary join partner for catalog resolution.
• IGS_TR_STP_CTL_TYPE_PK — The composite primary key constraint defining uniqueness over STEP_CATALOG_ID and S_TRACKING_TYPE.
• Related IGS_TR_STP_* control tables — Sibling tables in the step control family that share catalog linkages.
• IGS_TR_STEP_* catalog definition tables — Broader catalog hierarchy objects used in reporting joins.
• Standard EBS audit columns — Maintained by the framework, linking back to FND user and session tables.

Given the obsolete status, verify object existence before referencing it in any 12.1.1 or 12.2.2 environment, and prefer current Oracle Student System equivalents where available.