Results for “pra_sequence_number”

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

Overview

The IGS_PR_OU_FND table resides in the IGS schema within the Oracle EBS Student System (IGS) module. It stores the exclude fund codes associated with a particular progression rule outcome. In the Oracle Student System progression and outcomes model, progression rules determine how a student advances through an academic program based on outcome rules; those outcome rules can be further qualified by fund codes that must be excluded from consideration. This table captures that exclusion list, tying each combination of progression rule category, outcome rule sequence, and outcome sequence to one or more fund codes.

From a Data Vault modeling perspective, the metadata's heuristic classification of this entity is satellite-leaning. The table's composite primary key is entirely a foreign-key inheritance from its parent (IGS_PR_RU_OU_ALL), and the only descriptive attribute beyond audit columns is FUND_CODE. This structure is characteristic of a satellite (a descriptive child) rather than an independent hub or a link, since no new business key is introduced here.

Key Information Stored

The table is documented with 9 columns in ETRM 12.1.1. The most important columns are:

• PROGRESSION_RULE_CAT — The progression rule category code. Part of the composite primary key and the leading column of the foreign key back to IGS_PR_RU_OU_ALL.
• PRA_SEQUENCE_NUMBER — Sequence number identifying the specific outcome-rule record within the progression rule category. Also part of the primary key and foreign key.
• PRO_SEQUENCE_NUMBER — Sequence number identifying the progression rule outcome. Together with the two columns above, it completes the parent-side key.
• FUND_CODE — The fund code to be excluded. This is the primary payload of the table and the fourth component of the composite primary key.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit/WHO columns recording row creation and modification metadata.

The surrogate/unique key is IGS_PR_OU_FND_PK, composed of (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, PRO_SEQUENCE_NUMBER, FUND_CODE). Note that because the entire primary key is also the foreign key, the business-key candidate and the FK are coextensive—there is no independent surrogate identifier.

Common Use Cases and Queries

The table is typically queried when validating progression rule outcomes or when reproducing the exclusion logic applied during student progression. A representative join retrieves the parent outcome details alongside excluded funds:

SELECT r.PROGRESSION_RULE_CAT,
       r.PRA_SEQUENCE_NUMBER,
       r.PRO_SEQUENCE_NUMBER,
       f.FUND_CODE
FROM   IGS.IGS_PR_RU_OU_ALL r,
       IGS.IGS_PR_OU_FND   f
WHERE  r.PROGRESSION_RULE_CAT   = f.PROGRESSION_RULE_CAT
AND    r.PRA_SEQUENCE_NUMBER    = f.PRA_SEQUENCE_NUMBER
AND    r.PRO_SEQUENCE_NUMBER    = f.PRO_SEQUENCE_NUMBER
AND    f.PROGRESSION_RULE_CAT   = :category;

Typical scenarios include: auditing which fund codes are blocked for a given outcome, feeding reports on progression rule configuration, and troubleshooting progression failures caused by unintended fund exclusions. Because the table is small and purely descriptive, it is often joined into larger reporting extracts of the IGS progression configuration.

Related Objects

• IGS_PR_RU_OU_ALL — The parent outcome rule table. The FK IGS_PR_OU_FND.PROGRESSION_RULE_CAT references this table; the join spans PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and PRO_SEQUENCE_NUMBER.
• IGS_PR_OU_FND_PK — The unique index enforcing the composite primary key.
• IGS_PR_RU_CAT — Progression rule category definitions referenced upstream via the parent's key.
• IGS_PR_RULES — Progression rule header records forming the broader configuration context.
• FND_FLEX_VALUES / fund-code lookup tables — Source of valid FUND_CODE values validated against the shared flexfield setup.

These objects collectively define the fund-exclusion behavior applied during student progression processing in the Oracle Student System.