Results for “alias_value”

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

Overview

IGS_PS_OFR_PAT_APCOOD_PAT_V is a valid, predefined Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. Its documented purpose is to display admission period program offering pattern dates for the concurrent program form ADMF2M62, which is associated with the Student System admissions module. The view cannot be queried directly against a single base table; instead it consolidates data from multiple Student System operational entities and invokes two database functions (IGS_AD_GEN_003.ADMP_GET_ADM_PERD_DT and IGS_AD_GEN_013.ADMS_GET_COO_CRV, IGS_AD_GEN_013.ADMS_GET_COO_ADMPERD) to resolve derived attributes at runtime.

The user search term "igs_ad_gen_013" points directly to one of the packages whose functions are referenced in the view text. This relationship makes the view a useful reference object when tracing the dependencies of admissions processing logic and when diagnosing why a particular program offering pattern fails to appear in ADMF2M62.

Underlying Base Objects

According to the documented view text, the following base objects are joined:

• IGS_PS_OFR_PAT COP — program offering pattern; supplies course code, version number, calendar type, location, attendance mode and attendance type.
• IGS_CA_INST_REL CIR — calendar instance relationship linking the offering pattern calendar instance to its admission calendar instance.
• IGS_AD_PRD_AD_PRC_CA APAPC — admission period / admission process calendar assignment.
• IGS_PS_VER CRV — program version; provides titles and responsible organizational unit details.
• IGS_CA_DA_INST DAI — calendar instance date alias used for date resolution.
• IGS_PS_OF_OPT_AD_CAT COOAC — sub-query restricting results to offering option / admission category combinations.

These objects are joined using calendar type and sequence number keys, with an additional correlated sub-query filter keyed on course code, version number, calendar type, location, attendance mode and attendance type.

Key Columns

• COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE — program offering pattern identity.
• DT_ALIAS — date alias sourced from DAI, used as input to the admission period date function.
• ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER, ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE — admission period and process context from APAPC.
• TITLE, SHORT_TITLE, RESPONSIBLE_ORG_UNIT_CD, RESPONSIBLE_OU_START_DT — program version descriptive attributes from CRV.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns inherited from the offering pattern.

Common Use Cases and Queries

Typical use is to retrieve admission period dates for a given program offering pattern in support of ADMF2M62 or custom reporting. A sample query:

SELECT COURSE_CD, VERSION_NUMBER, ADM_CAL_TYPE, ADMISSION_CAT, TITLE
FROM APPS.IGS_PS_OFR_PAT_APCOOD_PAT_V
WHERE ADMISSION_CAT = :p_admission_cat;

Because the view calls IGS_AD_GEN_013 functions, performance can degrade when queried unfiltered; restrict by COURSE_CD, ADM_CAL_TYPE, or ADMISSION_CAT. It is also used diagnostically to confirm whether an offering pattern's admission category passes the ADMS_GET_COO_CRV and ADMS_GET_COO_ADMPERD evaluations, which determine visibility in the admission period display.