Search Results s_job_name




Overview
Explore in AI Chat

Overview

The IGS_CO_TYPE_JO table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically for the IGS (Oracle Student Management) module. Its primary function is to establish a link between a system-generated correspondence type and a specific job within the EBS job scheduler facility. This linkage is critical for automating the generation and output of institutional documents, such as enrollment confirmations, fee invoices, and certificates. The table acts as a cross-reference, ensuring that when a particular correspondence type is triggered, the system knows which concurrent job to execute and which specific output from that job to associate with the correspondence.

Key Information Stored

The table's structure is designed to capture the essential mapping data alongside standard audit columns. The core business columns are:

  • CORRESPONDENCE_TYPE (VARCHAR2(10)): A mandatory code representing an institution-defined type of correspondence. This includes both system-generated documents (e.g., invoices, certificates) and non-system documents.
  • S_JOB_NAME (VARCHAR2(30)): The name of the specific concurrent job (from the job scheduler) that is linked to a system-generated correspondence type. This column is central to the user's search context.
  • OUTPUT_NUM (NUMBER): Identifies the specific output number from the linked job, allowing a single job with multiple outputs to be correctly mapped.
  • Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for tracking data changes.

The unique constraint IGS_CO_TYPE_JO_U1 on CORRESPONDENCE_TYPE, S_JOB_NAME, and OUTPUT_NUM ensures that each combination of these three key identifiers is unique within the system.

Common Use Cases and Queries

This table is primarily used for setup, administration, and troubleshooting of automated correspondence generation. A common operational query is to list all job mappings for a given correspondence type to verify or audit configurations.

SELECT correspondence_type,
       s_job_name,
       output_num
FROM   igs.igs_co_type_jo
WHERE  correspondence_type = 'ENRL_CONF'; -- Example type code

Another frequent use case is identifying all correspondence types linked to a specific concurrent job, which is valuable when a job is being modified or retired.

SELECT correspondence_type,
       output_num
FROM   igs.igs_co_type_jo
WHERE  s_job_name = 'XXIGS_GEN_CERT_PROG'; -- Example job name

For reporting and system documentation, administrators often execute a full extract of the mapping logic to understand the automation landscape for student communications.

Related Objects

Based on the provided ETRM metadata, the IGS_CO_TYPE_JO table does not have documented foreign key dependencies referencing other objects. However, it is a referenced object itself. The primary relationship is with the APPS synonym IGS_CO_TYPE_JO, which provides public access to the table within the EBS environment. The table's design suggests it is a child table, likely referencing a master table defining valid CORRESPONDENCE_TYPE codes (not listed in the provided dependencies) and is referenced by the job scheduler subsystem to determine which program to run for a given correspondence request. The unique index (IGS_CO_TYPE_JO_U1) is the defining structural relationship for the data it contains.