Search Results s_citizenship_type




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_CAT view is a critical multi-org data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Systems (OSS) module. It serves as a filtered interface to the underlying base table, IGS_AD_CAT_ALL, enforcing a security model based on the current operating unit. This design ensures that queries against this view automatically retrieve only the admission category data relevant to the user's organizational context, ignoring records from other operating units. Its primary role is to provide a secure and organizationally aware reference of valid admission categories used throughout the student admissions lifecycle.

Key Information Stored

The view exposes a focused set of columns essential for managing admission categories. The primary identifier is the ADMISSION_CAT code, which is the primary key (IGS_AD_CAT_PK). Each record includes a DESCRIPTION for clarity. A column of particular note, given the user's search context, is S_CITIZENSHIP_TYPE. This field categorizes the admission category in relation to citizenship, such as 'DOMESTIC' or 'INTERNATIONAL', which is vital for compliance, reporting, and fee assessment. The CLOSED_IND flag indicates whether the category is active for use. Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track changes, and the ORG_ID column holds the operating unit identifier filtered by the multi-org view logic.

Common Use Cases and Queries

This view is predominantly used in validation, setup, and reporting scenarios within the admissions process. A common use case is validating an applicant's selected admission category against their citizenship status or ensuring only active categories are used. For reporting, it is frequently joined to application data to analyze admissions by category and citizenship type. Sample queries include retrieving all active categories for a specific citizenship type or listing categories with their descriptions for a lookup list in a custom form or report.

  • Retrieve all active admission categories for international applicants: SELECT admission_cat, description FROM apps.igs_ad_cat WHERE s_citizenship_type = 'INTERNATIONAL' AND closed_ind = 'N';
  • List all admission categories with their audit details: SELECT admission_cat, description, s_citizenship_type, closed_ind, last_updated_by, last_update_date FROM apps.igs_ad_cat ORDER BY admission_cat;

Related Objects

APPS.IGS_AD_CAT is a central reference object with extensive dependencies within the Student Systems module. It is directly referenced by numerous other views, validation packages, and application entities. Key documented relationships include:

  • Primary Source Table: The view draws its data from the multi-org base table APPS.IGS_AD_CAT_ALL.
  • Key Referencing Objects: The ADMISSION_CAT primary key is referenced by critical admissions objects such as APPS.IGS_AD_ADM_REQ (admission requirements), APPS.IGS_AD_PRC_TAC_OFFER (offer processing), and APPS.IGS_AD_SS_APPL_UPD_PAGE (application updates).
  • Validation Logic: Several validation packages, including IGS_AD_VAL_AC and IGS_GE_VAL_PARAM, reference this view to enforce business rules related to admission categories.
  • Reporting Views: It serves as the base for several composite views like IGS_AD_PERD_AD_CAT_V and IGS_AD_PRCS_CAT_V, which combine category data with other entities for reporting and user interfaces.