Results for “igs_ps_ver_ru”
37 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_VER_RU is a rules-assignment table within the Oracle E-Business Suite Student System (IGS) product family, documented as "Program version rules." It belongs to the legacy Student System schema, which Oracle classifies as obsolete in EBS 12.1.1 and 12.2.2. The table associates a specific program version — identified by the combination of COURSE_CD and VERSION_NUMBER in the IGS_PS_VER_ALL structure — with a rule call defined in IGS_RU_CALL, thereby recording which validation, derivation, or processing rules apply to that version.
Functionally, this is an intersection or cross-reference object. It does not store descriptive attribute history of its own; instead it records the existence of a relationship between a program version and a rule invocation. Under the heuristic Data Vault classification derived from its foreign key structure, IGS_PS_VER_RU is best modeled as a link table. It resolves a many-to-many association between program versions and rule calls, with RUL_SEQUENCE_NUMBER providing ordering context for rule evaluation. The table is documented as "Not implemented in this database" in the reference ETRM extract, meaning it appears in the data model but may not be physically present in every environment.
Key Information Stored
The documented physical schema contains nine columns in the IGS schema. The most significant are:
- COURSE_CD — the program (course) code identifying the version to which rules apply; part of the primary key and a foreign key to IGS_PS_VER_ALL.
- VERSION_NUMBER — the program version number; part of the primary key and, together with COURSE_CD, references IGS_PS_VER_ALL.
- S_RULE_CALL_CD — the rule call code, part of the primary key and a foreign key to IGS_RU_CALL; identifies which rule invocation is bound to the version.
- RUL_SEQUENCE_NUMBER — ordering value, foreign key to IGS_RU_RULE, indicating the position of the rule within the call.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing row creation and modification metadata.
The surrogate primary key is enforced by IGS_PS_VER_RU_PK over (COURSE_CD, VERSION_NUMBER, S_RULE_CALL_CD). A unique index, IGS_PS_VER_RU_U1, covers the same three columns, so it coincides with the primary key rather than representing a separate business-key candidate. Notably, RUL_SEQUENCE_NUMBER participates in a foreign key but not in the primary key, allowing a version's rule call to reference ordered rule entries.
Common Use Cases and Queries
Typical usage involves resolving which rules are attached to a given program version, or inversely, which versions depend on a particular rule call before that rule is altered. Reporting queries commonly join this link to its parent tables:
- Retrieve all rule calls bound to a version: select S_RULE_CALL_CD from IGS_PS_VER_RU where COURSE_CD = :course and VERSION_NUMBER = :version.
- Join to IGS_PS_VER_ALL to obtain version descriptions for a rule call listing.
- Join to IGS_RU_CALL and IGS_RU_RULE to trace a rule call to its constituent rules in RUL_SEQUENCE_NUMBER order.
- Impact analysis: identify affected versions before modifying or retiring a rule call record.
- Audit reporting on CREATION_DATE and LAST_UPDATE_DATE to track configuration changes over time.
Related Objects
- IGS_PS_VER_ALL — parent program version table; joined on COURSE_CD and VERSION_NUMBER.
- IGS_RU_CALL — parent rule call table; joined on S_RULE_CALL_CD.
- IGS_RU_RULE — parent rule definition table; joined on RUL_SEQUENCE_NUMBER.
- IGS_PS_VER_RU_PK / IGS_PS_VER_RU_U1 — the primary key constraint and unique index enforcing row uniqueness.
Because the Student System is obsolete in 12.1.1 and 12.2.2, new development should treat these objects as read-only legacy references rather than integration points; the standard EBS audit columns remain the only maintained attributes in environments where the table is physically deployed.
-
Program version rules
-
SYNONYM: APPS.IGS_PS_VER_RU 12.1.1
-
TABLE: IGS.IGS_PS_VER_RU 12.1.1
-
Table: IGS_PS_VER_RU 12.2.2
Program version rules
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_VER_RU_V 12.1.1
APPS.IGS_PS_VER_RU_V·↳ IGS_PS_VER·↳ IGS_PS_VER_RU·↳ IGS_RU_CALL·Explore IGS module →
-
VIEW: APPS.IGS_PS_VER_RU_V 12.1.1
-
View: IGS_PS_VER_RU_V 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_RU_RULE 12.2.2
Rules
Not implemented in this database·Explore IGS module →
-
Table: IGS_RU_CALL 12.2.2
Rule call name
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_PS_VER_RU_V 12.1.1
-
Table: IGS_PS_VER_ALL 12.2.2
This entity describes the versions of programs which are offered by the university, covering both award and non-award programs.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_PR_GEN_005 12.1.1
-
PACKAGE: APPS.IGS_RU_GEN_001 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 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'.
-
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'.