Results for “igs_ca_arts_tc_ca_cd”

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

Overview

The IGS_CA_ARTS_TC_CA_CD table is a reference data object within the Oracle E-Business Suite Student System (IGS) product family. It resides in the IGS schema and holds valid and status information. In EBS 12.1.1 and 12.2.2, it plays a supporting role in the academic calendaring and teaching period model, where it defines and constrains the teaching period codes used to derive the semester in which a student is enrolled. Unlike transactional tables that capture enrollment events, this table supplies the controlled vocabulary of teaching calendar type codes referenced by higher-level calendar structures.

From a Data Vault modeling perspective, the heuristic classification for this object is hub-leaning. This suggests that IGS_CA_ARTS_TC_CA_CD functions primarily as a business key registry: its grain is one row per teaching calendar type code, and its unique index enforces the natural key. A Data Vault designer would likely model ARTS_TEACHING_CAL_TYPE_CD as a hub business key, while the descriptive attributes (description, closed indicator, audit columns) would be held in an associated satellite.

Key Information Stored

The documented physical schema contains eight columns. The most significant are:

• ARTS_TEACHING_CAL_TYPE_CD — the business key and sole component of the primary key (IGS_CA_ARTS_TC_CA_CD_PK) and the unique index IGS_CA_ARTS_TC_CA_CD_U1. It identifies the teaching period code that defines the semester of enrollment.
• DESCRIPTION — the human-readable label for the teaching calendar type, used in list of values and reports.
• CLOSED_IND — a status flag indicating whether the code remains active or has been closed to new use.
• CREATED_BY, CREATION_DATE — standard WHO audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification user, date, and login context.

The primary key is the surrogate/business combination ARTS_TEACHING_CAL_TYPE_CD; there is no separate numeric surrogate key documented. The unique index on the same column confirms it as the business-key candidate.

Common Use Cases and Queries

Typical scenarios include validating teaching period codes during calendar setup, populating LOVs in enrollment forms, and reporting on active versus closed teaching calendar types. A simple validation query is:

• SELECT arts_teaching_cal_type_cd, description FROM igs_ca_arts_tc_ca_cd WHERE closed_ind = 'N';
• SELECT * FROM igs_ca_arts_tc_ca_cd WHERE arts_teaching_cal_type_cd = :code;
• Joining to the parent calendar table to reconcile teaching types with calendar instances: SELECT a.arts_teaching_cal_type_cd, a.description, t.* FROM igs_ca_arts_tc_ca_cd a, igs_ca_type t WHERE t.arts_teaching_cal_type_cd = a.arts_teaching_cal_type_cd;

Reporting use cases commonly filter on CLOSED_IND to exclude retired codes and join with enrollment or semester tables to translate stored codes into descriptive teaching periods.

Related Objects

The FK metadata identifies the following dependencies through the relationship on ARTS_TEACHING_CAL_TYPE_CD:

• IGS_CA_TYPE — the principal foreign table, referencing IGS_CA_ARTS_TC_CA_CD via the column IGS_CA_TYPE.ARTS_TEACHING_CAL_TYPE_CD. This is the most significant dependent object.
• IGS_CA_ARTS_TC_CA_CD_PK — the primary key constraint enforcing uniqueness of the business key.
• IGS_CA_ARTS_TC_CA_CD_U1 — the unique index supporting the business-key candidate.

Beyond these documented relationships, this reference table is generally consumed by teaching calendar and enrollment processing logic in the IGS Student System, which resolves teaching period codes to semester enrollment contexts.