Results for “igs_pr_ou_awd”
31 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_PR_OU_AWD table is a component of the Oracle E-Business Suite Student System product family (IGS), a module now classified as obsolete in Release 12.1.1 and 12.2.2. The table stores the award records that are associated with a positive-outcome rule within the progression and outcomes processing framework. In practical terms, it defines which academic awards may be granted when a student satisfies a specific progression rule evaluated as a positive outcome.
The documented metadata for this object indicates that it is not implemented in the reference database, meaning the deployment examined does not instantiate the table. Nevertheless, the definition remains catalogued because it forms part of the historical IGS schema shipped with earlier releases. From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure identifies this table as a link. That classification should be treated as a modeling suggestion rather than a prescriptive fact: the table's composite business key resolves relationships between progression rules and awards, which is characteristic of a link construct.
Key Information Stored
The table contains nine documented columns. Four of these constitute the business key and are also the components of the primary key constraint IGS_PR_OU_AWD_PK and the unique index IGS_PR_OU_AWD_U1:
- PROGRESSION_RULE_CAT — identifies the progression rule category to which the award association belongs.
- PRA_SEQUENCE_NUMBER — the sequence number identifying the specific progression rule category instance.
- PRO_SEQUENCE_NUMBER — the sequence number identifying the specific positive-outcome rule definition.
- AWARD_CD — the code of the academic award granted when the rule evaluates to a positive outcome.
There is no separate surrogate key column documented; the primary key is a natural composite key formed by the four business columns above. The remaining documented columns are the standard Oracle EBS audit and concurrency attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These support row-level auditing and are populated automatically by the EBS framework.
Common Use Cases and Queries
The principal use case is determining which awards are available for a given progression rule. A typical reporting query joins the table to IGS_PS_AWD to resolve the award description and to IGS_PR_RU_OU_ALL to resolve the progression rule context:
- Listing all awards attached to a positive-outcome rule:
SELECT a.AWARD_CD, b.DESCRIPTION FROM IGS_PR_OU_AWD a, IGS_PS_AWD b WHERE a.AWARD_CD = b.AWARD_CD AND a.PROGRESSION_RULE_CAT = :cat AND a.PRA_SEQUENCE_NUMBER = :pra AND a.PRO_SEQUENCE_NUMBER = :pro; - Auditing rule configuration changes by filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY.
- Validating award-code integrity by checking for orphaned AWARD_CD values that do not exist in IGS_PS_AWD.
- Extracting the full progression rule to award mapping for migration or reconciliation to a successor student system.
Because the table is documented as not implemented, queries against a live 12.1.1 or 12.2.2 instance may return an "object does not exist" error; the DDL should be treated as reference metadata.
Related Objects
The following objects are the most significant dependencies based on the documented foreign-key relationships:
- IGS_PS_AWD — referenced through IGS_PR_OU_AWD.AWARD_CD; holds the award definition and description.
- IGS_PR_RU_OU_ALL — referenced through the composite columns PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and PRO_SEQUENCE_NUMBER; stores the positive-outcome progression rule definitions.
- IGS_PR_OU_AWD_PK — the primary key constraint on the four business columns.
- IGS_PR_OU_AWD_U1 — the unique index enforcing the same four-column business key.
These relationships confirm the table's role as a junction between progression rules and award definitions within the IGS progression and outcomes subsystem.
-
Stores the awards associated with the rule for positive outcomes.
-
SYNONYM: APPS.IGS_PR_OU_AWD 12.1.1
-
TABLE: IGS.IGS_PR_OU_AWD 12.1.1
-
Table: IGS_PR_OU_AWD 12.2.2
Stores the awards associated with the rule for positive outcomes.
Not implemented in this database·Explore IGS module →
-
View: IGS_PR_OU_AWD_V 12.1.1
This view stores the awards associated with the rule for positive outcomes.
APPS.IGS_PR_OU_AWD_V·↳ IGS_PR_OU_AWD·↳ IGS_PS_AWD·Explore IGS module →
-
View: IGS_PR_OU_AWD_V 12.2.2
This view stores the awards associated with the rule for positive outcomes.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_PR_OU_AWD_V 12.1.1
-
Table: IGS_PS_AWD 12.2.2
This entity describes an award offered by the university.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PR_RU_OU_ALL 12.2.2
This table describes the outcomes applicable to failure of the related progression rule in the way described by the attributes of the outcome. A given rule may have multiple outcomes for any given failure type if required.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_PR_OU_AWD_V 12.1.1
-
PACKAGE: APPS.IGS_PR_GEN_006 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design 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'.