Results for “igs_pr_ru_appl_all”

38 results




Overview
Explore in AI Chat

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

Overview

The IGS_PR_RU_APPL_ALL table is a core table within the Oracle E-Business Suite Student System (IGS) product family. It stores progression rule application records — the mechanism by which progression rules defined at an abstract level are bound to concrete system elements such as a course version, course type, organizational unit, or an individual student course attempt. In institutional terms, this table answers the question of "where and to whom does this academic progression rule actually apply?" It therefore sits at the junction between rule definition and rule enforcement across a student's academic career.

The physical table resides in the IGS schema and is owned by IGS, with documentation status VALID in ETRM 12.1.1. It contains 31 documented columns. The primary key constraint is IGS_PR_RU_APPL_PK, defined over PROGRESSION_RULE_CAT and SEQUENCE_NUMBER, and a corresponding unique index IGS_PR_RU_APPL_ALL_U1 carries the same business-key columns. From a heuristic Data Vault modeling perspective, this entity classifies as satellite-leaning: it holds descriptive, context-qualified attributes about a progression rule application, keyed by a composite business key, with predominantly foreign-key relationships to surrounding hubs and links rather than being a hub or link itself.

Key Information Stored

The composite primary key PROGRESSION_RULE_CAT and SEQUENCE_NUMBER uniquely identifies each rule application row; PROGRESSION_RULE_CAT also functions as the foreign key back to IGS_PR_RULE_ALL, making it the principal business-key candidate. The column PROGRESSION_RULE_CD references the rule code, while RUL_SEQUENCE_NUMBER and REFERENCE_CD further qualify the specific rule and its reference context.

Target-element columns determine where the rule applies. CRV_COURSE_CD and CRV_VERSION_NUMBER point to a specific course version via IGS_PS_VER_ALL; COURSE_TYPE points to IGS_PS_TYPE_ALL; OU_ORG_UNIT_CD and OU_START_DT identify the organizational unit. The columns SCA_PERSON_ID and SCA_COURSE_CD tie the application to an individual student course attempt in IGS_EN_STDNT_PS_ATT_ALL, while SPO_PERSON_ID, SPO_COURSE_CD, and SPO_SEQUENCE_NUMBER reference IGS_PR_STDNT_PR_OU_ALL. ATTENDANCE_TYPE links to IGS_EN_ATD_TYPE_ALL, and IGS_PR_CLASS_STD_ID links to IGS_PR_CLASS_STD. Parent-rule chaining is captured through PRO_PROGRESSION_RULE_CAT, PRO_PRA_SEQUENCE_NUMBER, and PRO_SEQUENCE_NUMBER. Credit boundaries are represented by MIN_CP and MAX_CP. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ORG_ID) and LOGICAL_DELETE_DT and MESSAGE complete the structure.

Common Use Cases and Queries

Typical usage centers on reporting which rules apply to which academic elements, and on verifying rule coverage during configuration or progression cycle processing. A common query retrieves all applications for a given rule category:

  • SELECT PROGRESSION_RULE_CAT, SEQUENCE_NUMBER, PROGRESSION_RULE_CD, CRV_COURSE_CD, CRV_VERSION_NUMBER, COURSE_TYPE, OU_ORG_UNIT_CD FROM IGS_PR_RU_APPL_ALL WHERE PROGRESSION_RULE_CAT = :cat;
  • Join to IGS_PR_RULE_ALL to obtain rule descriptions: ... FROM IGS_PR_RU_APPL_ALL a, IGS_PR_RULE_ALL r WHERE a.PROGRESSION_RULE_CAT = r.PROGRESSION_RULE_CAT;
  • Join to IGS_PS_VER_ALL on CRV_COURSE_CD and CRV_VERSION_NUMBER to resolve course version details.
  • Filter by student attempts using SCA_PERSON_ID and SCA_COURSE_CD for individual student progression audits.
  • Reporting on credit ceilings via MIN_CP and MAX_CP per rule application.

Because LOGICAL_DELETE_DT is present, queries should generally filter active rows. The ORG_ID column supports multi-organization security filtering in R12 environments.

Related Objects

The following objects are the most significant dependencies based on the documented foreign-key relationships:

  • IGS_PR_RULE_ALL — parent rules; joined on PROGRESSION_RULE_CAT and PROGRESSION_RULE_CD.
  • IGS_PS_VER_ALL — course versions; joined on CRV_COURSE_CD and CRV_VERSION_NUMBER.
  • IGS_PS_TYPE_ALL — course types; joined on COURSE_TYPE.
  • IGS_EN_ATD_TYPE_ALL — attendance types; joined on ATTENDANCE_TYPE.
  • IGS_EN_STDNT_PS_ATT_ALL — student course attempts; joined on SCA_PERSON_ID and SCA_COURSE_CD.
  • IGS_PR_STDNT_PR_OU_ALL — student progression organizational units; joined on SPO_PERSON_ID, SPO_COURSE_CD, SPO_SEQUENCE_NUMBER.
  • IGS_PR_RU_OU_ALL, IGS_PR_RU_CA_TYPE_ALL, and IGS_PR_SDT_PR_RU_CK_ALL — child tables referencing this table on PROGRESSION_RULE_CAT and PRA_SEQUENCE_NUMBER.

These relationships confirm the table's role as the central anchor connecting progression rules to the courses, organizations, and student records they govern.