Results for “rul_sequence_number”

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

Overview

The table IGS.IGS_AD_APCTR_RU_ALL is a valid table in the Oracle E-Business Suite Student System (IGS) product family. It captures admission process category tracking rules, functioning as a configuration store that governs how admission categories are processed and evaluated against rule calls during the admissions lifecycle. In Oracle EBS 12.1.1 and 12.2.2, this object is owned by the IGS schema and is documented in the ETRM repository with eleven physical columns and two unique indexes.

From a heuristic Data Vault classification perspective, this table exhibits satellite-leaning behavior. It carries a surrogate primary key column, APC_TRK_RU_ID, and multiple descriptive and foreign-key attributes that a Data Vault model would typically place in a satellite hanging off a rule or admission-process hub. This classification is a modeling suggestion mined from the foreign-key structure rather than an Oracle-declared designation.

Key Information Stored

The table records the rules that tie admission categories to admission process types and rule calls. The most significant columns are:

• APC_TRK_RU_ID — The surrogate primary key defined by the constraint IGS_AD_APCTR_RU_ALL_PK. It uniquely identifies each admission process category tracking rule row.
• ADMISSION_CAT — The admission category to which the tracking rule applies.
• S_ADMISSION_PROCESS_TYPE — The admission process type associated with the rule.
• S_RULE_CALL_CD — The rule call code that determines when or how the rule is invoked.
• RUL_SEQUENCE_NUMBER — A sequence number that orders rule evaluation and serves as the foreign key to IGS_RU_RULE.
• ORG_ID — The operating unit or organization identifier, enabling multi-org access control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified each rule.

Two unique indexes serve as business-key candidates. IGS_AD_APCTR_RU_ALL_U1 is defined on APC_TRK_RU_ID alone, mirroring the primary key. IGS_AD_APCTR_RU_ALL_U2 is the composite business key spanning ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, S_RULE_CALL_CD, RUL_SEQUENCE_NUMBER, and ORG_ID, which enforces uniqueness of a rule combination within an operating unit.

Common Use Cases and Queries

Typical scenarios involve retrieving the rules that apply to a given admission category and process type, validating rule sequences during admission processing, and reporting on rule configuration by operating unit. Because ORG_ID participates in the business key, most queries should be filtered or joined by operating unit to respect multi-org security.

• Listing all tracking rules for an admission category: SELECT * FROM igs.igs_ad_apctr_ru_all WHERE admission_cat = :cat AND org_id = :org_id;
• Joining to the rule definition to resolve sequence details: SELECT a.apc_trk_ru_id, a.rul_sequence_number, r.* FROM igs.igs_ad_apctr_ru_all a, igs.igs_ru_rule r WHERE a.rul_sequence_number = r.rul_sequence_number;
• Auditing recently changed rules: SELECT * FROM igs.igs_ad_apctr_ru_all WHERE last_update_date >= :since;

These patterns support setup verification, rule troubleshooting, and extract reporting for downstream admissions analytics.

Related Objects

The most significant dependency is the foreign key from RUL_SEQUENCE_NUMBER to IGS_RU_RULE, which anchors each category tracking rule to its underlying rule definition. Related objects include:

• IGS.IGS_RU_RULE — Referenced by IGS_AD_APCTR_RU_ALL.RUL_SEQUENCE_NUMBER; provides the rule master data.
• IGS_AD_APCTR_RU_ALL_PK / _U1 / _U2 — The primary and unique indexes enforcing row identity and business-key uniqueness.
• Admission configuration and process-type validation sets referenced by S_ADMISSION_PROCESS_TYPE S_RULE_CALL_CD, and ADMISSION_CAT.
• Student admissions process tables in the IGS schema that consume these tracking rules during category evaluation.

Together these objects form the rule-driven configuration layer for admission process category tracking.