Results for “s_encumbrance_cat”

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

Overview

IGS_PR_OU_TYPE_V is a validation view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite. It exposes the contents of the IGS_PR_OU_TYPE base table — which stores progression outcome type definitions and their default restrictions — enriched with descriptive attributes resolved from lookup, attendance type, and encumbrance type sources. The view carries a status of VALID and is available in both EBS 12.1.1 and 12.2.2 environments.

The name itself reflects the three functional areas it draws together: PR (progression rules), OU (organizational unit / outcome), and TYPE (the classification records). Its primary role is to supply friendly descriptions for coded values so that forms, concurrent programs, and reports can present progression outcome configurations without repeatedly joining the underlying lookup and reference tables. This is particularly relevant to the DFLT_RESTRICTED_ATT_TYPE column, which defines the default restricted attendance type applied to students when a progression outcome is recorded. Consumers searching on "dflt_restricted_att_type" are typically investigating how attendance restrictions are defaulted at the outcome level.

Underlying Base Objects

The view is defined over four documented sources. The driving table is IGS_PR_OU_TYPE (aliased DRVTAB), which holds the core progression outcome type records. It is outer-joined to two reference tables and inner-joined to one lookup view:

• IGS_PR_OU_TYPE (DRVTAB) — the primary driver, supplying progression outcome type, description, positive outcome indicator, closed indicator, encumbrance type, default restricted enrolment CP, default restricted attendance type, and comments.
• IGS_LOOKUPS_VIEW (LKUP) — joined on LOOKUP_TYPE = 'PROGRESSION_OUTCOME_TYPE' and LOOKUP_CODE = DRVTAB.S_PROGRESSION_OUTCOME_TYPE, yielding the lookup MEANING and lookup closed indicator.
• IGS_EN_ATD_TYPE (ATTYP) — outer-joined on ATTENDANCE_TYPE = DRVTAB.DFLT_RESTRICTED_ATT_TYPE, supplying the attendance type description and its closed indicator.
• IGS_FI_ENCMB_TYPE (ET) — outer-joined on ENCUMBRANCE_TYPE = DRVTAB.ENCUMBRANCE_TYPE, supplying the encumbrance description, category, and closed indicator.

The lookup join is mandatory, meaning any progression outcome type whose short code has no corresponding PROGRESSION_OUTCOME_TYPE lookup value will be excluded from the result set. The attendance type and encumbrance joins are outer joins, so records persist even where those defaults are null.

Key Columns

• ROW_ID — the ROWID of the base table row, useful for updates or identifying a specific record.
• PROGRESSION_OUTCOME_TYPE / DESCRIPTION — the outcome code and its descriptive text from the base table.
• S_PROGRESSION_OUTCOME_TYPE / MEANING — the lookup short code and its resolved meaning from IGS_LOOKUPS_VIEW.
• DFLT_RESTRICTED_ATT_TYPE — the default restricted attendance type code applied when the outcome is assigned.
• ATT_TYP_DESCRIPTION / ATT_TYP_CLOSED_IND — the attendance type description and whether that type is closed.
• ENCUMBRANCE_TYPE / ENCUMB_DESCRIPTION / S_ENCUMBRANCE_CAT — encumbrance type code, description, and category.
• POSITIVE_OUTCOME_IND / CLOSED_IND — flags indicating whether the outcome is positive and whether the configuration is closed to new use.
• DFLT_RESTRICTED_ENROLMENT_CP — default restricted enrolment check point.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include verifying which attendance type is defaulted for a given progression outcome, reporting on active outcomes, and validating that all outcome types resolve to a lookup meaning. A common query:

• SELECT progression_outcome_type, meaning, dflt_restricted_att_type, att_typ_description, encumbrance_type, encumb_description FROM igs_pr_ou_type_v WHERE closed_ind = 'N';
• Filtering specifically on the attendance restriction: SELECT progression_outcome_type, meaning, att_typ_description FROM igs_pr_ou_type_v WHERE dflt_restricted_att_type IS NOT NULL;
• Listing restricted outcomes with their encumbrance defaults to reconcile configuration before term rollover.