Search Results igs_ad_apctr_ru_all

Overview

The table IGS_AD_APCTR_RU_ALL is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to define and store the rules that govern how an applicant's progress is tracked through different stages of an admission process. This table acts as a configuration repository, linking specific admission categories and process types to the underlying business rules (RU) that determine the sequence and logic for tracking an application. The presence of the ORG_ID column confirms it is a multi-organization table, meaning it stores data partitioned by operating unit, a standard architectural pattern in Oracle EBS.

Key Information Stored

The table's structure is designed to uniquely identify a tracking rule configuration and its associated logic. The primary and unique key constraints highlight the most critical columns. The surrogate key APC_TRK_RU_ID serves as the primary identifier. The unique key combination defines the rule's context: ADMISSION_CAT (the category of admission), S_ADMISSION_PROCESS_TYPE (the type of process), and S_RULE_CALL_CD (likely a code indicating when the rule is invoked). The RUL_SEQUENCE_NUMBER is a foreign key that directly links to the IGS_RU_RULE table, pointing to the specific rule definition containing the executable logic or condition. The ORG_ID completes the context by specifying the operating unit.

Common Use Cases and Queries

This table is central to the automated tracking of admission applications. A common use case is during an application's lifecycle, where the system queries this table to determine the next set of rules to execute based on the applicant's admission category and current process stage. For reporting and administration, queries often join this table to the rule definition to audit or modify tracking workflows. A typical SQL pattern would retrieve all tracking rules for a specific admission category within an operating unit:

• SELECT apctr.*, rul.rule_cd FROM igs_ad_apctr_ru_all apctr JOIN igs_ru_rule rul ON apctr.rul_sequence_number = rul.rul_sequence_number WHERE apctr.admission_cat = 'UG_FRESHMAN' AND apctr.org_id = 123;

Another critical use case is during implementation or upgrade, where data scripts populate this table to map new admission processes to the appropriate tracking rule sequences.

Related Objects

The primary documented relationship for IGS_AD_APCTR_RU_ALL is with the rule definition table. As per the provided foreign key metadata:

• IGS_RU_RULE: This is the parent table for the rule logic. The column IGS_AD_APCTR_RU_ALL.RUL_SEQUENCE_NUMBER is a foreign key referencing IGS_RU_RULE.RUL_SEQUENCE_NUMBER. This relationship is fundamental, as the tracking rule table stores the context and linkage, while the rule table stores the actual condition or action to be performed.

While not explicitly listed in the provided excerpt, this table would logically be referenced by the application tracking engine and may have child relationships with tables logging individual applicant tracking events or statuses, which would use the APC_TRK_RU_ID as a foreign key.