Results for “igs_ad_prd_ad_prc_ca”

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

Overview

IGS_AD_PRD_AD_PRC_CA is a reference table within the Oracle E-Business Suite IGS (Student System) product family, a module that is documented as obsolete in ETRM for releases 12.1.1 and 12.2.2. The table holds the record that describes the relationship among admission periods, admission process types, and admission categories. In practical terms, it acts as a cross-reference object that qualifies which admission process types are valid for a given combination of admission calendar, admission calendar instance, and admission category. This qualification governs downstream admissions processing, including application capture, offers of admission, and option processing.

Under the heuristic Data Vault classification mined from its foreign key topology, the object is described as hub-leaning. As a modeling suggestion, this implies the table behaves primarily as a set of uniquely identified business keys rather than a purely descriptive satellite. Each row is uniquely identified by the composite business key of admission calendar, calendar instance sequence, admission category, and admission process type, which reinforces its hub-like character within the admissions subject area.

Key Information Stored

The documented physical schema for release 12.1.1 lists twelve columns owned by the IGS schema. The most significant columns are the four key attributes, augmented by control flags and standard audit columns.

• ADM_CAL_TYPE — the admission calendar type, identifying the admissions cycle to which the relationship applies.
• ADM_CI_SEQUENCE_NUMBER — the admission calendar instance sequence number, uniquely distinguishing a specific occurrence of the calendar type.
• ADMISSION_CAT — the admission category, indicating the applicant classification governed by the row.
• S_ADMISSION_PROCESS_TYPE — the admission process type associated with the category and period.
• CLOSED_IND — indicates whether the relationship is closed and therefore unavailable for new admissions activity.
• SINGLE_RESPONSE_FLAG — controls whether a single response is permitted for the associated process type and category.
• INCLUDE_SR_IN_ROLLOVER_FLAG — governs whether single-response records participate in rollover processing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording row creation and maintenance.

No separate surrogate primary key column is documented. The primary key constraint IGS_AD_PRD_AD_PRC_CA_PK is defined over the four business attributes, and the unique index IGS_AD_PRD_AD_PRC_CA_U1 mirrors the same four columns, confirming that the business key is the primary identifier for this object.

Common Use Cases and Queries

Reporting and validation scenarios typically resolve the valid process types for a given admission period and category, or check whether a relationship has been closed. A representative query filters active relationships:

• SELECT admission_cat, s_admission_process_type FROM igs_ad_prd_ad_prc_ca WHERE adm_cal_type = :cal_type AND adm_ci_sequence_number = :seq AND closed_ind = 'N';
• Joining to IGS_AD_PRCS_CAT_ALL to retrieve category and process type descriptions for enrollment reporting.
• Validating incoming application records in IGS_AD_APPL_ALL against this table to ensure the referenced period, category, and process type combination is legitimate.
• Driving rollover and single-response logic by inspecting SINGLE_RESPONSE_FLAG and INCLUDE_SR_IN_ROLLOVER_FLAG.

Because the module is obsolete, these patterns are most relevant to legacy reporting, historical data migration, or archive reconciliation rather than new development.

Related Objects

The referential integrity documented in ETRM establishes the object's position within the admissions schema. The table references IGS_AD_PERD_AD_CAT on ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, and ADMISSION_CAT, and references IGS_AD_PRCS_CAT_ALL on ADMISSION_CAT together with S_ADMISSION_PROCESS_TYPE. In the reverse direction, several admissions tables depend on it.

• IGS_AD_PERD_AD_CAT — parent defining admission period and category combinations.
• IGS_AD_PRCS_CAT_ALL — parent defining valid process types per category.
• IGS_AD_APPL_ALL — applications table referencing the same four key columns.
• IGS_AD_PECRS_OFOP_DT — prerequisite or offer detail records referencing the key columns.
• IGS_AD_PRD_PS_OF_OPT — period process option records referencing the key columns.