Results for “igs_ad_prd_ps_of_opt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_AD_PRD_PS_OF_OPT is a relationship table within the IGS (Student System) product family of Oracle E-Business Suite, documented as VALID in the IGS schema. Its stated purpose is to describe the relationship among admission periods, admission process types, admission categories, and program offering options. In practice, the table acts as a cross-referencing construct that allows an institution to control the admission configuration available for a specific academic program offering — that is, which admission calendar, admission category, admission process type, attendance characteristics, and location apply when an applicant is considered for a given program version.
Because the table is entirely composed of foreign key references that connect independent master entities (admission periods, offering options, attendance modes, attendance types, and locations), the heuristic Data Vault classification supplied in the metadata is link. This classification is a modeling suggestion rather than a physical attribute of the EBS table; it reflects the fact that the table represents an intersecting relationship among hubs rather than an entity with its own descriptive lifecycle.
Key Information Stored
The primary key, IGS_AD_PRD_PS_OF_OPT_PK, is a composite that spans the full business-key candidate set, and it is duplicated by the unique index IGS_AD_PRD_PS_OF_OPT_U1. The table carries 21 documented columns in the 12.1.1 ETRM schema.
- ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE — together identify the admission period, its calendar instance, the admission category, and the admission process type, joining to IGS_AD_PRD_AD_PRC_CA.
- COURSE_CD, VERSION_NUMBER, ACAD_CAL_TYPE, SEQUENCE_NUMBER — identify the program offering option and academic calendar context, joining to IGS_PS_OFR_ALL.
- LOCATION_CD — the location at which the admission configuration applies, joining to IGS_AD_LOCATION_ALL.
- ATTENDANCE_MODE, ATTENDANCE_TYPE — constraining attendance characteristics, joining to IGS_EN_ATD_MODE_ALL and IGS_EN_ATD_TYPE_ALL respectively.
- ROLLOVER_INCLUSION_IND — indicates whether the configuration participates in rollover processing.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID — the standard EBS WHO audit columns.
- PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — identifiers and timestamp associating the row with the originating concurrent program or data-load process.
Common Use Cases and Queries
Typical scenarios include validating that an admission period is properly wired to an offering option before opening applications, reporting which locations and attendance modes are permitted per program version, and diagnosing "no admission category available" errors during applicant intake.
A representative query joins the four principal masters:
- SELECT o.ADM_CAL_TYPE, o.ADMISSION_CAT, o.S_ADMISSION_PROCESS_TYPE, o.COURSE_CD, o.VERSION_NUMBER, o.LOCATION_CD, o.ATTENDANCE_MODE FROM IGS.IGS_AD_PRD_PS_OF_OPT o WHERE o.COURSE_CD = :course AND o.ACAD_CAL_TYPE = :cal;
- Left-outer joins to IGS_PS_OFR_ALL and IGS_AD_PRD_AD_PRC_CA confirm that every configured row resolves to a valid offering option and admission process-category combination.
- Reporting on ROLLOVER_INCLUSION_IND flags rows requiring review before a rollover run.
Related Objects
- IGS_AD_PRD_AD_PRC_CA — parent on ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE.
- IGS_PS_OFR_ALL — parent on COURSE_CD, VERSION_NUMBER, ACAD_CAL_TYPE, SEQUENCE_NUMBER.
- IGS_AD_LOCATION_ALL — parent on LOCATION_CD.
- IGS_EN_ATD_MODE_ALL — parent on ATTENDANCE_MODE.
- IGS_EN_ATD_TYPE_ALL — parent on ATTENDANCE_TYPE.
These relationships define the integrity envelope of the link; any delete or update on a parent master will be restricted while dependent rows exist here.
-
Describes the relationship among admission periods, admission process types, admission categories, and program offering options
-
Table: IGS_AD_PRD_PS_OF_OPT 12.2.2
Describes the relationship among admission periods, admission process types, admission categories, and program offering options
Not implemented in this database·Explore IGS module →
-
APPS.IGSFV_PGM_OFR_ADM_PAT_RESTRCTN·↳ IGS_AD_CAT_ALL·↳ IGS_AD_LOCATION_ALL·↳ IGS_AD_PRD_PS_OF_OPT·Explore IGS module →
-
APPS.IGSFV_PGM_OFR_PAT_ADM_PERD·↳ IGS_AD_CAT_ALL·↳ IGS_AD_LOCATION_ALL·↳ IGS_AD_PRD_PS_OF_OPT·Explore IGS module →
-
APPS.IGSBV_PGM_OFR_ADM_PAT_RESTRCTN·↳ IGS_AD_PRD_PS_OF_OPT·Explore IGS module →
-
APPS.IGSBV_PGM_OFR_PAT_ADM_PERD·↳ IGS_AD_PRD_PS_OF_OPT·Explore IGS module →
-
Table: IGS_PS_OFR_ALL 12.2.2
This entity describes an offering of a university program within a calendar type.
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_PRD_AD_PRC_CA 12.2.2
Holds the record that describes the relationship among admission periods, admission process types, and admission categories
Not implemented in this database·Explore IGS module →
-
Table: IGS_EN_ATD_MODE_ALL 12.2.2
Describes available university program attendance modes
Not implemented in this database·Explore IGS module →
-
Table: IGS_EN_ATD_TYPE_ALL 12.2.2
Describes available university program attendance types
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_LOCATION_ALL 12.2.2
Describes available geographic locations at which programs and units may be offered or taught
Not implemented in this database·Explore IGS module →