Search Results arts_teaching_cal_type_cd




Overview
Explore in AI Chat

Overview

The IGS_CA_ARTS_TC_CA_CD table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, as indicated by the IGS schema. Its primary function is to manage the Automated Results Transfer System (ARTS) teaching calendar type codes. These codes are critical for defining the 'semester enrolled' period when transferring applicant results data to tertiary admission centers. The table serves as a master list of valid teaching period codes, controlling their availability and providing descriptive context for integration and reporting processes related to admissions and student results.

Key Information Stored

The table stores a concise set of columns focused on code definition and lifecycle management. The central column is ARTS_TEACHING_CAL_TYPE_CD, a mandatory VARCHAR2 field holding the unique identifier for the teaching period. The DESCRIPTION column provides a 60-character explanation of the code's purpose. A key control column is CLOSED_IND, a single-character flag (typically 'Y' or 'N') that determines if the code is open for use in new or modified teaching calendar records; setting it to 'closed' prevents its future assignment. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing. Data integrity is enforced by the unique index IGS_CA_ARTS_TC_CA_CD_U1 on the ARTS_TEACHING_CAL_TYPE_CD column.

Common Use Cases and Queries

This table is primarily referenced during configuration and transactional processes involving applicant results transfer. Administrators use it to maintain the list of valid teaching periods for ARTS integrations. A common reporting need is to list all active (non-closed) codes for setup in other calendar definitions. The standard query pattern, as indicated by the ETRM, is a direct SELECT from all columns. For functional use, filtered queries are typical.

  • Retrieving all active ARTS teaching calendar codes: SELECT arts_teaching_cal_type_cd, description FROM igs.igs_ca_arts_tc_ca_cd WHERE closed_ind = 'N' ORDER BY 1;
  • Validating a specific code for use in a teaching calendar setup.
  • Providing a list of values (LOV) for a field requiring an ARTS teaching period code in related forms or interfaces.

Related Objects

Based on the provided dependency information, the IGS_CA_ARTS_TC_CA_CD table is a referenced object, meaning other database objects likely use its primary key as a foreign key to ensure data consistency. While the specific referencing tables are not listed in the excerpt, they would typically exist within the IGS schema and relate to calendar definitions (likely tables with names containing "CA_" for calendar) and potentially to interfaces or staging tables for the Automated Results Transfer System. The table itself does not reference any other objects, confirming its role as a standalone reference or lookup table. In the APPS environment, it is accessed via the synonym IGS_CA_ARTS_TC_CA_CD.