Search Results igs_ps_nsus_rtn_v

Overview

IGS_PS_NSUS_RTN_V is a seeded Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. Its documented description states that it stores information about Retention master setup, referring to the non-standard usec retention configuration used by the Student System to determine how retention or duration-based calculations apply to enrollment and fee processing. The view is marked VALID in the ETRM repository and is present across the 12.1.1 and 12.2.2 releases, making it a stable, read-only reporting artifact.

Rather than holding data itself, the view presents a denormalized, business-friendly projection of retention setup rows together with their associated lookup meanings and fee type descriptions. This design allows reports, concurrent programs, and integration extracts to join a single view instead of repeatedly resolving lookup codes and fee type identifiers against their respective master tables.

Underlying Base Objects

The view text is defined over three objects joined in a single SELECT:

• IGS_PS_NSUS_RTN (aliased NR) — the primary retention master setup table supplying the core retention attributes.
• IGS_LOOKUP_VALUES (aliased LV) — joined on DEFINITION_CODE = LOOKUP_CODE with LOOKUP_TYPE fixed to 'DEFINITION_LEVEL', resolving the meaning of the definition level code.
• IGS_FI_FEE_TYPE_ALL (aliased FEE) — an outer join (FEE.FEE_TYPE (+)) on FEE_TYPE, supplying the fee type description where a matching fee type exists.

The documented ETRM metadata for this view lists no referenced base objects, so the relationships above are established directly from the published view text. Because IGS_FI_FEE_TYPE_ALL is outer-joined, retention rows are retained even when no corresponding fee type record exists, in which case FEE_TYPE_DESC is null. The inner joins to IGS_LOOKUP_VALUES mean only retention rows whose definition code resolves to a lookup value of type DEFINITION_LEVEL are returned.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_PS_NSUS_RTN row, useful for direct row addressing.
• NON_STD_USEC_RTN_ID — primary identifier of the non-standard usec retention setup record.
• UOO_ID — identifier of the associated unit of study offering or organizational unit context.
• FEE_TYPE / FEE_TYPE_DESC — the fee type code and its description from IGS_FI_FEE_TYPE_ALL.
• DEFINITION_CODE / DEFINITION_CODE_MEANING — the definition level code and its decoded lookup meaning.
• FORMULA_METHOD — the formula method applied to the retention calculation.
• ROUND_METHOD — the rounding method applied to computed retention values.
• INCL_WKEND_DURATION_FLAG — flag indicating whether weekend days are included in duration calculations.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

The view is typically used to validate and report on retention master configuration. A basic listing of all configured retention rules can be produced with:

• SELECT NON_STD_USEC_RTN_ID, UOO_ID, FEE_TYPE_DESC, DEFINITION_CODE_MEANING, FORMULA_METHOD, ROUND_METHOD, INCL_WKEND_DURATION_FLAG FROM APPS.IGS_PS_NSUS_RTN_V;

Filtered lookups support setup verification, for example restricting to a definition level or rounding method:

• ... WHERE DEFINITION_CODE_MEANING = :p_meaning AND ROUND_METHOD = :p_round;
• ... WHERE FEE_TYPE = :p_fee_type;

Because row identity is exposed through ROW_ID, the view also supports troubleshooting workflows that trace a displayed retention rule back to its base table record. All access should be performed as a read-only query; DML is not supported through this view.