Results for “igs_ad_perd_ad_cat”

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

Overview

IGS_AD_PERD_AD_CAT is a table in the Oracle E-Business Suite Student System (IGS) product family, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table describes the combination of an admission category and an admission calendar instance that together define an admission period. In functional terms, it is a junction-style entity that associates admission categories with the calendar instances against which admissions processing occurs for a given period, bounded by start and end dates.

From a data-modeling perspective, the metadata's heuristic Data Vault classification identifies this object as satellite-leaning. This suggests that IGS_AD_PERD_AD_CAT is best understood as a descriptive structure attached to surrounding hub and link constructs, providing attribute context (admission category, calendar instance, and validity dates) rather than acting as a central hub of business identity.

It should be noted that ETRM documentation indicates the table is not implemented in the current database for the sampled environment, and IGS is flagged as obsolete. Any use should therefore be treated as legacy or migration-related, not as part of an actively supported configuration.

Key Information Stored

The table is documented with fourteen physical columns. The most significant are the primary key and business-key components that identify each admission period definition:

• ADM_CAL_TYPE — Admission calendar type; part of the composite primary key.
• ADM_CI_SEQUENCE_NUMBER — Calendar instance sequence number identifying the specific admission calendar instance; part of the composite primary key.
• ADMISSION_CAT — Admission category; part of the composite primary key and a foreign key to IGS_AD_CAT_ALL.
• CI_START_DT — Start date of the calendar instance interval associated with the admission period.
• CI_END_DT — End date of the calendar instance interval associated with the admission period.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording initial insertion.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent change.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns used by Oracle's standard auditing and traceability conventions.

The unique index IGS_AD_PERD_AD_CAT_PK covers (ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT), making that triple the documented business-key candidate. There is no separate surrogate single-column key; the composite itself serves as the primary key.

Common Use Cases and Queries

Typical reporting asks which admission categories are active for a given admission calendar instance, and how those periods are bounded in time. A representative query joins the table to its parent lookup tables:

• List periods by calendar instance: SELECT p.ADMISSION_CAT, p.ADM_CAL_TYPE, p.ADM_CI_SEQUENCE_NUMBER, p.CI_START_DT, p.CI_END_DT FROM IGS_AD_PERD_AD_CAT p WHERE p.ADM_CAL_TYPE = :cal_type AND p.ADM_CI_SEQUENCE_NUMBER = :seq;
• Resolve category descriptions: join to IGS_AD_CAT_ALL on ADMISSION_CAT to obtain the descriptive admission category name.
• Validity-window checks: filter on CI_START_DT and CI_END_DT to identify open versus closed admission periods for a given term or cycle.
• Downstream impact analysis: because IGS_AD_PRD_AD_PRC_CA and IGS_AD_PECRS_OFOP_DT reference this table by (ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT), period definitions drive admission process calendar assignments and course offering open/close date logic.

Related Objects

The significant related objects, drawn from the documented foreign-key relationships, are:

• IGS_AD_CAT_ALL — referenced by IGS_AD_PERD_AD_CAT.ADMISSION_CAT; supplies admission category definitions.
• IGS_CA_INST_ALL — referenced (twice, via calendar type and instance sequence) by ADM_CAL_TYPE and ADM_CI_SEQUENCE_NUMBER; provides the calendar instance context.
• IGS_AD_PRD_AD_PRC_CA — references this table on (ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT); links admission periods to admission process calendar assignments.
• IGS_AD_PECRS_OFOP_DT — references this table on the same three columns; relates periods to course offering open/close dates.

Collectively these relationships confirm IGS_AD_PERD_AD_CAT as a dependent, satellite-leaning definition table within the legacy IGS admission calendar model.