Results for “pro_pra_sequence_number”

46 results




Overview
Explore in AI Chat

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

Overview

IGS_PR_RU_APPL_V is a reporting view in the Oracle EBS Student System (IGS) product, owned by the APPS schema and valid in release 12.1.1 and 12.2.2. It exposes the attribute rows that Oracle's Student System uses to evaluate progression rules against a student's academic record. In ETRM terminology, the "RU" prefix denotes a rule definition object, and "APPL" denotes the application or applicability record that binds a rule to concrete criteria. The view therefore presents the resolved applicability list for one or more progression rules, projected through the standard EBS audit and multi-tenant key columns (ROW_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

The view is primarily used for institutional reporting, extract programs, and interfaces that need to read progression rule applicability data without joining the full underlying rule hierarchy. It is the recommended read surface for the progression rule applicability entity in IGS.

Underlying Base Objects

The view is defined as a simple projection over a single base object. The documented view text is:

The only referenced base object is IGS_PR_RU_APPL. No joins, outer joins, or database links are present in the documented definition; every column in the view maps one-to-one to a column of the same name in the base table. Because the definition performs no filtering or aggregation, all row-level validation and logical deletion semantics travel through from the base table.

Key Columns

The columns in this view fall into several logical groups:

  • ROW_ID — the primary key of the applicability record.
  • PROGRESSION_RULE_CAT, PROGRESSION_RULE_CD, SEQUENCE_NUMBER, RUL_SEQUENCE_NUMBER — identify the parent progression rule and the sequence position of the applicability row. RUL_SEQUENCE_NUMBER is the specific column a user would query when searching for rule sequence numbering.
  • S_RELATION_TYPE, REFERENCE_CD — indicate the relationship type and referenced code that qualify the applicability entry.
  • ATTENDANCE_TYPE, OU_ORG_UNIT_CD, OU_START_DT, COURSE_TYPE — organisational unit, attendance and course-type filters.
  • CRV_COURSE_CD, CRV_VERSION_NUMBER, SCA_PERSON_ID, SCA_COURSE_CD, SPO_PERSON_ID, SPO_COURSE_CD, SPO_SEQUENCE_NUMBER — course/version and student-person applicability qualifiers.
  • PRO_* columns — carry the parent progression rule category, sequence number and progression sequence number, allowing self-referencing hierarchy queries.
  • LOGICAL_DELETE_DT, MESSAGE — logical delete date and a rule-generated message attribute.
  • MIN_CP, MAX_CP, POSITIVE_RULE_IND, IGS_PR_CLASS_STD_ID, CLASS_STANDING — credit-point thresholds, forward/reverse rule indicator, class-standing link and class standing for progression evaluation.

Common Use Cases and Queries

Typical usages include reporting progression rule applicability for a given rule category, driving extracts for external student systems, and supporting troubleshooting of rule resolution.

  • Retrieve all applicability rows for a progression rule category:
    SELECT ROW_ID, PROGRESSION_RULE_CAT, PROGRESSION_RULE_CD, SEQUENCE_NUMBER, RUL_SEQUENCE_NUMBER FROM IGS_PR_RU_APPL_V WHERE PROGRESSION_RULE_CAT = :cat AND LOGICAL_DELETE_DT IS NULL ORDER BY SEQUENCE_NUMBER;
  • Find rows referencing a specific rule sequence number:
    SELECT * FROM IGS_PR_RU_APPL_V WHERE RUL_SEQUENCE_NUMBER = :seq;
  • List course-version applicability entries:
    SELECT ROW_ID, CRV_COURSE_CD, CRV_VERSION_NUMBER, ATTENDANCE_TYPE FROM IGS_PR_RU_APPL_V WHERE CRV_COURSE_CD IS NOT NULL;

Because the view exposes the base table columns directly, all queries follow standard EBS conventions: always filter on LOGICAL_DELETE_DT IS NULL for current rows and restrict by PROGRESSION_RULE_CAT or RUL_SEQUENCE_NUMBER for indexed access.