Results for “waitlist_rank”

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

Overview

IGS_AD_PS_APPL_INST is a view in the Oracle E-Business Suite IGS — Student System product family, delivered historically under the Advanced Admissions module (the "AD" prefix) and specific to the PeopleSoft-integrated admissions data model (the "PS" infix indicates a staging/integration layer used to bridge external Student Information System data with native EBS admissions tables). The view presents admissions application instance data — one logical row per applicant admission application instance — including decision outcomes, waitlist ranking, prior-institution attributes, and financial aid interest indicators.

Per the ETRM metadata, this object is documented under IGS - Student System (Obsolete). The Implementation/DBA Data section states "Not implemented in this database," and the documented referenced base objects list is empty. This is significant: in Oracle EBS 12.1.1 and 12.2.2, IGS_AD_PS_APPL_INST is only conditionally present — it is seeded when the Advanced Admissions / PeopleSoft integration components are licensed and installed. Many instances, including the one from which the ETRM excerpt was captured, do not have the view created at all. The view should therefore be treated as a conditional integration artifact rather than a guaranteed schema object.

Underlying Base Objects

The view text exposes a single driving alias TAB, whose ROWID, ORG_ID, WHO/audit columns (LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) and DFF columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE20) are projected directly. The ETRM did not document the underlying table name behind TAB; based on the IGS_AD_PS_APPL_INST naming convention, it is the PeopleSoft-integration staging table for admission application instances (typically in the IGS_AD_PS_* family). The view adds several derived / placeholder columns via literal NULL — specifically ATHLETIC_GPA and ATHLETIC_ELIGIBILITY_STATUS_ID — indicating these attributes exist in the target canonical model but are not populated from this integration source. Columns are projected with explicit aliases so the view conforms to the canonical IGS_AD_APPL_INST shape used by downstream admissions logic.

Key Columns

• FINAID_APPLY_DATE — the financial aid application date associated with the applicant's answer to the financial aid question. This is the column that matches the search term finaid_apply_date. It is the date on which the applicant applied for financial aid as captured during the admission application.
• APPLY_FOR_FINAID — flag indicating whether the applicant intends to apply for financial aid. LOGICALLY paired with FINAID_APPLY_DATE; the date is typically meaningful only when this flag indicates interest.
• PERSON_ID — the HZ/PER party identifier for the applicant.
• ADMISSION_APPL_NUMBER, SEQUENCE_NUMBER, ADM_CAL_TYPE, ADM_CI_SEQUENCE_NUMBER — identify the admission application instance (application number, sequence, admission calendar and calendar instance).
• DECISION_MAKE_ID, DECISION_DATE, DECISION_REASON_ID, DECISION_NOTES — admission decision outcome and rationale.
• PENDING_REASON_ID, DEFICIENCY_IN_PREP, SPL_CONSIDER_COMMENTS — pending evaluation and special-consideration attributes.
• PREDICTED_GPA, ACADEMIC_INDEX — computed academic metrics.
• WAITLIST_RANK, ATTENT_OTHER_INST_CD, EDU_GOAL_PRIOR_ENROLL_ID — waitlist and prior-institution attributes.
• NOMINATED_COURSE_CD, COURSE_CD, CRV_VERSION_NUMBER, LOCATI… (truncated in source) — course-nomination attributes.
• ORG_ID and the ATTRIBUTE1–20 DFF columns support multi-org security and client extensions.

Common Use Cases and Queries

The primary reporting use case is financial-aid application analysis: identifying applicants who indicated financial aid interest and the dates on which they applied, for downstream packaging and needs-analysis handoff. A representative query joins the view to person and admission application data:

SELECT a.PERSON_ID,
       p.PERSON_NUMBER,
       a.ADMISSION_APPL_NUMBER,
       a.ADM_CAL_TYPE,
       a.APPLY_FOR_FINAID,
       a.FINAID_APPLY_DATE
FROM   IGS_AD_PS_APPL_INST a,
       PER_ALL_PEOPLE_F p
WHERE  a.PERSON_ID = p.PERSON_ID
AND    p.EFFECTIVE_END_DATE = TO_DATE('4712-12-31','YYYY-MM-DD')
AND    a.APPLY_FOR_FINAID = 'Y'
AND    a.ORG_ID = :p_org_id;

A second common pattern aggregates applications by financial-aid date for trend reporting:

SELECT TRUNC(a.FINAID_APPLY_DATE) finaid_day,
       COUNT(*) apps
FROM   IGS_AD_PS_APPL_INST a
WHERE  a.FINAID_APPLY_DATE IS NOT NULL
AND    a.ORG_ID = :p_org_id
GROUP  BY TRUNC(a.FINAID_APPLY_DATE)
ORDER  BY 1;

Because the view is obsolete and only conditionally present, queries referencing it must first verify existence via ALL_VIEWS / ALL_OBJECTS, and integration routines should treat the NULL athletic columns as not sourced. In 12.2.x deployments where the Advanced Admissions integration was never installed, the view will be absent and any query referencing FINAID_APPLY_DATE will raise ORA-00942.