Search Results igs_ad_prcs_cat_ac_v

Overview

IGS_AD_PRCS_CAT_AC_V is an APPS-owned database view in the Oracle E-Business Suite Student System (IGS) product family. It presents a denormalized, human-readable projection of admission processing category configuration data. The view reconciles three distinct data sets: the admission processing category definitions held in IGS_AD_PRCS_CAT, the descriptive text of the associated admission category sourced from IGS_AD_CAT, and the decoded lookup meaning of the admission process type obtained through IGS_LOOKUPS_VIEW. Its principal role is to shield report writers, concurrent programs, and integration interfaces from the multi-table joins and code-to-meaning translation that would otherwise be required. Because ADMISSION_PROCESS_TYPE and ADMISSION_CAT are stored as coded values in the base tables, consumers of this view receive the resolved MEANING and DESCRIPTION values directly, which simplifies extract logic and improves readability in operational reports. The view is marked VALID at the documented release levels of 12.1.1 and 12.2.2, indicating it is a supported, non-obsolete object in those environments.

Underlying Base Objects

Three objects participate in the view definition. The driving table is IGS_AD_PRCS_CAT (aliased APC), which supplies the processing category rows and the audit columns. IGS_AD_CAT (aliased AC) is joined on ADMISSION_CAT to supply the admission category description. IGS_LOOKUPS_VIEW (aliased LKUPV) is joined on the condition that LOOKUP_TYPE equals 'ADMISSION_PROCESS_TYPE' and LOOKUP_CODE equals APC.S_ADMISSION_PROCESS_TYPE. This third join is a lookup decode rather than a foreign key relationship, meaning any active lookup definition matching that lookup type governs the rendered MEANING. The documented metadata lists no referenced base objects, but the view text itself identifies these three sources unambiguously. All joins are equijoins on the category and lookup codes respectively.

Key Columns

• ROW_ID — Surrogate identifier inherited from IGS_AD_PRCS_CAT; useful as a stable join key to the base table.
• ADMISSION_CAT — The admission category code linking the processing category to IGS_AD_CAT.
• DESCRIPTION — The decoded admission category description from IGS_AD_CAT.
• S_ADMISSION_PROCESS_TYPE — The stored (S_) coded value of the admission process type.
• MEANING — The lookup meaning corresponding to the process type code; this is the display-ready value.
• OFFER_RESPONSE_OFFSET — An offset value applied to offer response timing, used by process configuration logic.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle audit columns inherited from the base table.

Common Use Cases and Queries

A frequent use case is generating a reference listing of admission process categories with their decoded process type and category description for review by admissions staff. A representative query is:

SELECT admission_cat, description, s_admission_process_type, meaning, offer_response_offset FROM igs_ad_prcs_cat_ac_v ORDER BY admission_cat, meaning;

A second scenario filters categories by process type, for example WHERE meaning = 'Offer' or by the stored code, to drive downstream processing logic. Integration interfaces can extract the full result set for loading into data warehouses or staging tables, relying on the view to pre-resolve coded values. Finally, the audit columns support incremental extraction patterns, where records changed since a prior run are identified using LAST_UPDATE_DATE. Because the view surfaces decoded values directly, it is generally preferred over ad hoc joins to IGS_LOOKUPS_VIEW in report definitions.