Search Results igs_pr_sdt_pr_ru_ck_all




Overview
Explore in AI Chat

Overview

The table IGS_PR_SDT_PR_RU_CK_ALL is a core data repository within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as an audit and results table for the progression rules engine. Its primary function is to store a historical record of every instance a specific progression rule is evaluated against a student's course attempt. Each row captures the rule details, the context of the check, and the calculated outcome (pass/fail or other status), providing a complete audit trail for academic progression, probation, and exclusion processes.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each rule check event. The key columns are PERSON_ID and COURSE_CD, identifying the student and their program of study. The PRG_CAL_TYPE and PRG_CI_SEQUENCE_NUMBER specify the academic calendar period for the progression evaluation. The PROGRESSION_RULE_CAT and PRA_SEQUENCE_NUMBER pinpoint the exact rule that was checked, linking to its master definition. Finally, RULE_CHECK_DT records the timestamp of the evaluation. Additional columns, implied by its purpose, would store the result of the check (e.g., 'PASS', 'FAIL', 'WARNING') and potentially detailed messages or derived values from the rule calculation.

Common Use Cases and Queries

This table is central to auditing and troubleshooting the progression process. Common use cases include generating reports on which rules students have triggered, analyzing trends in academic performance, and validating the outcomes of batch progression runs. A typical query would join to student and course tables to retrieve a student's rule check history. For example:

  • Student Progression Audit: SELECT * FROM igs_pr_sdt_pr_ru_ck_all ck WHERE ck.person_id = :stu_id AND ck.course_cd = :course_cd ORDER BY ck.rule_check_dt DESC;
  • Rule Failure Analysis: Identifying all students who failed a specific rule in a given term by filtering on the progression rule category, sequence number, and result.
  • Data Integrity Checks: Verifying that for every outcome recorded in related summary tables, corresponding detailed rule check records exist in this table.

Related Objects

The table maintains defined foreign key relationships with other critical progression tables, ensuring referential integrity. As per the provided metadata, the key relationships are:

  • IGS_PR_RU_APPL_ALL: This is the master table for progression rule applications. The foreign key via columns (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER) ensures each check record references a valid, defined rule.
  • IGS_PR_STDNT_PR_OU_ALL: This table typically stores summarized progression outcomes for a student. The foreign key relationship indicates that detailed rule check records in IGS_PR_SDT_PR_RU_CK_ALL are child records to a broader student progression outcome. They are linked by the full composite key (PERSON_ID, COURSE_CD, PRG_CAL_TYPE, PRG_CI_SEQUENCE_NUMBER, PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, RULE_CHECK_DT).
  • Table: IGS_PR_SDT_PR_RU_CK_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_SDT_PR_RU_CK_ALL,  object_name:IGS_PR_SDT_PR_RU_CK_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains details of progression rules which have been checked against the related student course attempt. Details of each rule are stored along with the result. ,  implementation_dba_data: IGS.IGS_PR_SDT_PR_RU_CK_ALL , 

  • View: IGSBV_PR_SDT_PR_RU_CK 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PR_SDT_PR_RU_CK,  object_name:IGSBV_PR_SDT_PR_RU_CK,  status:VALID,  product: IGS - Student System ,  description: Describes Student Progression Rule Check ,  implementation_dba_data: APPS.IGSBV_PR_SDT_PR_RU_CK , 

  • Table: IGS_PR_RU_APPL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_RU_APPL_ALL,  object_name:IGS_PR_RU_APPL_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a progression rule as it is applied to one of the allowable system elements - a course version, course type, org unit or individual student course attempt. ,  implementation_dba_data: IGS.IGS_PR_RU_APPL_ALL , 

  • View: IGSFV_PR_SDT_PR_RU_CK 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PR_SDT_PR_RU_CK,  object_name:IGSFV_PR_SDT_PR_RU_CK,  status:VALID,  product: IGS - Student System ,  description: Describes Student Progression Rule Check ,  implementation_dba_data: APPS.IGSFV_PR_SDT_PR_RU_CK , 

  • View: IGS_PR_SDT_PR_RU_CK 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_SDT_PR_RU_CK,  object_name:IGS_PR_SDT_PR_RU_CK,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_PR_SDT_PR_RU_CK , 

  • Table: IGS_PR_STDNT_PR_OU_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_STDNT_PR_OU_ALL,  object_name:IGS_PR_STDNT_PR_OU_ALL,  status:VALID,  product: IGS - Student System ,  description: This table describes a progression outcome applied to a student, either manually or by the system, as a result of failing a progression rule. This detail is subject to approval, waiving etc. prior to application to the student. ,  implementation_dba_data: IGS.IGS_PR_STDNT_PR_OU_ALL ,