Results for “nr_rul_sequence_number”
11 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_RU_CALL_RULE is a reference table within the IGS (Student System) product family in Oracle EBS 12.1.1 and 12.2.2. The table stores system reference codes that define call rules — that is, the coded identifiers used by the rules engine to determine which rule or rule sequence should be invoked in a given processing context. Per the ETRM metadata, the object is documented with seven columns and is owned by the IGS schema.
The product designation carries an important caveat: IGS is flagged as obsolete, and the ETRM record explicitly notes "Not implemented in this database." This means the table is documented for reference and historical completeness rather than as a live, populated object in a standard EBS installation. Consultants encountering the name igs_ru_call_rule are typically working with legacy documentation, a customized or localized deployment, or an upgrade assessment involving the Student System module.
From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is satellite-leaning. This indicates the table is best understood as a descriptive companion to a parent business entity — here IGS_RU_NAMED_RULE — holding attributes that qualify and contextualize the parent rather than acting as an independent hub or a pure many-to-many link.
Key Information Stored
The documented columns are limited to seven, of which the most significant are described below.
- CALLED_RULE_CD — The primary key column and the sole component of the IGS_RU_CALL_RULE_PK constraint. It also participates in the unique index IGS_RU_CALL_RULE_U1, making it both the surrogate primary key and the principal business-key candidate. It holds the reference code that identifies the rule being called.
- NR_RUL_SEQUENCE_NUMBER — The foreign-key column linking this row to IGS_RU_NAMED_RULE. It carries the sequence number that ties each call rule back to its parent named rule, establishing the dependence of this table on the named rule definition.
- CREATED_BY, CREATION_DATE — Standard EBS audit columns recording the user who inserted the row and the timestamp of the insert.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing the most recent modification, its author, its timestamp, and the login session under which it occurred.
The presence of the full WHO-column audit set alongside a single business-key code and one foreign key confirms the satellite-leaning classification: the table is narrow, descriptive, and anchored to a parent entity.
Common Use Cases and Queries
Because the table is marked obsolete and unimplemented, the dominant use cases are analytical and migration-oriented rather than operational. Typical scenarios include tracing how a named rule resolves to one or more called rules, and validating referential integrity before decommissioning.
A basic lookup joining the call rule to its parent named rule follows the documented foreign key:
SELECT c.called_rule_cd,
c.nr_rul_sequence_number,
c.last_update_date
FROM igs_ru_call_rule c,
igs_ru_named_rule n
WHERE c.nr_rul_sequence_number = n.nr_rul_sequence_number;
Reporting queries commonly filter on CALLED_RULE_CD to confirm a rule code is registered, or group by NR_RUL_SEQUENCE_NUMBER to count how many call rules attach to each named rule. For audit and upgrade work, a query restricted to rows where LAST_UPDATE_DATE exceeds a cutoff date supports impact analysis. Given the obsolete status, any production query should first confirm the table exists in the target instance, since the ETRM metadata records it as not implemented.
Related Objects
The relationship data identifies one documented foreign-key dependency, which forms the core of the object's join graph.
- IGS_RU_NAMED_RULE — The parent table referenced through IGS_RU_CALL_RULE.NR_RUL_SEQUENCE_NUMBER. This is the primary and only documented foreign-key relationship; every call rule row depends on the named rule it points to.
- IGS_RU_CALL_RULE_PK — The primary-key constraint enforcing uniqueness of CALLED_RULE_CD.
- IGS_RU_CALL_RULE_U1 — The unique index on CALLED_RULE_CD, serving as the documented business-key candidate and reinforcing the code's role as the natural identifier.
- IGS_RU_* family — Sibling rule-engine tables within the IGS Student System that share the RU naming prefix and jointly define rule resolution behavior.
Beyond IGS_RU_NAMED_RULE, no additional FK relationships are documented, so integration points should be validated against the specific instance rather than assumed.
-
This table contains system reference codes for rules.
-
TABLE: IGS.IGS_RU_CALL_RULE 12.1.1
-
PACKAGE: APPS.IGS_RU_GEN_001 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.