Search Results s_adm_prcs_type_desc

Overview

IGS_AD_APPL_INST_MKDES_V is an APPS-owned, VALID database view within the IGS (Student System) product of Oracle E-Business Suite, applicable to release levels 12.1.1 and 12.2.2. The view consolidates admissions application instance data for a person and presents it alongside descriptive, code-resolved attributes. Its name and definition indicate it serves as a marketing/description ("MKDES") presentation layer — supplying a flattened, human-readable projection of admissions application records that joins structural admissions data with calendar relation information and lookup descriptions.

In EBS reporting and integration contexts, the view is typically consumed by concurrent programs, Oracle Reports, BI Publisher data templates, and custom SQL that require a comprehensive admissions application profile without re-implementing the multi-object join logic. Because it exposes decoded descriptions (admission category descriptions, basis-for-admission descriptions, lookup meanings), it reduces the need for downstream decode logic in report queries.

Underlying Base Objects

The view text references the following documented source objects:

• IGS_AD_PS_APPL_INST_APLINST_V (APAIAV) — the primary application instance view, supplying person, course, admission application number, calendar, document status, predicted GPA, and admission metadata.
• IGS_CA_INST_ADM_PERD_V (CIAPV) — a calendar relation view supplying academic and admission alternate codes.
• IGS_AD_APPL (AA) — the base admissions application record, providing admission category, application process type, application status, application date, and fee status.
• IGS_AD_CD (AC) — admission code reference, joined to supply ADMISSION_CD_DESC.
• IGS_AD_BASIS_FOR_AD (ABFA) — basis-for-admission reference, joined to supply BASIS_FOR_ADMISSION_TYPE_DESC.
• IGS_LOOKUP_VALUES (LKUPV) — the standard EBS lookup view, joined to derive S_ADM_PRCS_TYPE_DESC for the admission process type.

The join predicates link APAIAV to CIAPV on four keys (ACAD_CAL_TYPE, ACAD_CI_SEQUENCE_NUMBER, ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER), and link the remaining descriptive objects on their respective coded values.

Key Columns

• PERSON_ID — the applicant's person identifier.
• ADMISSION_APPL_NUMBER, SEQUENCE_NUMBER — the application instance identifier; NOMINATED_COURSE_CD identifies the nominated course.
• ACAD_CAL_TYPE / ACAD_CI_SEQUENCE_NUMBER and ADM_CAL_TYPE / ADM_CI_SEQUENCE_NUMBER — academic and admission calendar context.
• ACAD_ALTERNATE_CODE, ADM_ALTERNATE_CODE — alternate calendar codes joined from the calendar relation view; these are the columns most closely associated with the user search term "adm_alternate_code".
• ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, S_ADM_PRCS_TYPE_DESC — admission category and decoded process type.
• ADM_APPL_STATUS, APPL_DT, ADM_FEE_STATUS, ADM_DOC_STATUS — application status and fee/document tracking.
• ADMISSION_CD, ADMISSION_CD_DESC, BASIS_FOR_ADMISSION_TYPE, BASIS_FOR_ADMISSION_TYPE_DESC — coded and decoded admission and basis-for-admission values.
• ACADEMIC_INDEX, PREDICTED_GPA, ADM_ENTRY_QUAL_STATUS — assessment attributes used in selection decisions.

Common Use Cases and Queries

Typical scenarios include admissions reporting, applicant profile extracts, and integrations requiring decoded admission attributes. A representative query filtering on the alternate code column is:

• SELECT adm.admission_appl_number, adm.person_id, adm.acad_alternate_code, adm.adm_alternate_code, adm.admission_cd_desc FROM apps.igs_ad_appl_inst_mkdes_v adm WHERE adm.adm_alternate_code = :p_alternate_code;

Other uses include listing applicants by admission process type using S_ADM_PRCS_TYPE_DESC, or extracting predicted GPA and entry qualification status for selection committees. Queries should still supply an appropriate academic calendar predicate, as the join resolves calendar context explicitly.