Results for “igs_ad_cat”

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

Overview

The IGS_AD_CAT view is a reporting and integration object within the Oracle E-Business Suite IGS — Student System product family. In the ETRM 12.2.2 metadata it is classified as Obsolete, and the corresponding documentation explicitly notes that the object is Not implemented in this database. The view is a secured, organization-filtered (multi-org) projection of admission category reference data. Its stated purpose is to expose admission category definitions — the coded categories used to classify applicants and students by administrative or citizenship-related attributes — so that external reports, concurrent programs, and integration layers can read a single, consistent row set.

Functionally, IGS_AD_CAT sits on top of the _ALL table variant, which is the multi-org storage form. The view applies an ORG_ID predicate derived from the session CLIENT_INFO environment value, ensuring that a querying session only sees categories belonging to its current operating unit. This is the classic Oracle EBS "org-secured view" pattern.

Underlying Base Objects

The view is defined over a single base object: IGS_AD_CAT_ALL. The ETRM metadata lists no other referenced objects, and the view text confirms a straightforward single-table SELECT with a WHERE clause. The relationship is one-to-one: every row returned by IGS_AD_CAT corresponds to a row in IGS_AD_CAT_ALL whose ORG_ID matches the session's operating unit context.

The org-security predicate is:

• NVL(CAT.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

In practice, the first ten (or, if blank, "unknown") characters of CLIENT_INFO supply the operating unit identifier. When no client info is set, the expression resolves to -99, which is the sentinel used to include rows that carry a NULL ORG_ID. This design allows global or shared categories to remain visible alongside operating-unit-specific ones.

Key Columns

• ROW_ID — The underlying table ROWID, useful for direct row identification and for building correlated updates or deletes in custom code.
• ORG_ID — The operating unit (organization) identifier; the column that drives the view's multi-org security behavior.
• ADMISSION_CAT — The admission category code, the primary business key exposed by the view.
• DESCRIPTION — The descriptive name of the admission category.
• S_CITIZENSHIP_TYPE — The system (seed) citizenship type associated with the category, used to drive classification logic.
• CLOSED_IND — Indicator that flags whether the category is closed (inactive) and therefore should not be assigned to new applicants.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row, and when.

Common Use Cases and Queries

Typical uses include validating admission category values loaded through interfaces, populating LOVs or reference reports, and reconciling category definitions across operating units. A simple listing of active categories is the most frequent query:

SELECT admission_cat, description, s_citizenship_type
FROM   igs_ad_cat
WHERE  closed_ind = 'N';

To trace a category back to its physical row for troubleshooting or data correction, the ROW_ID is exposed:

SELECT row_id, org_id, admission_cat, last_update_date
FROM   igs_ad_cat
WHERE  admission_cat = :p_category;

Note that because the object is documented as obsolete and not implemented in the reference database, existing code that references IGS_AD_CAT should be reviewed during upgrades to 12.2.2 and migrated to the current supported admission category objects where the IGS Student System is still deployed.