Search Results igs_ad_missing_items_letter_v




Overview
Explore in AI Chat

Overview

IGS_AD_MISSING_ITEMS_LETTER_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It is a central component of the Admissions (IGS_AD) module, which governs the processing of student applications from initial receipt through decision. During application processing, the admissions module expects a defined set of supporting documents — transcripts, identification, photographs, test scores, and similar evidence. When an applicant fails to submit, or partially submits, one or more of these required items, the outstanding documents are classified as missing items. This view returns exactly that set: the missing items associated with a student's application, together with the party and admission context required to generate a reminder or follow-up letter.

The view is therefore fundamentally a correspondence-driver. It is designed to feed letter generation, applicant notification, and follow-up reporting so that admissions staff can identify which applicants have incomplete files and contact them for the outstanding documents. Because it is a view rather than a table, it exposes no independent storage; it is a read-only projection assembled at query time from the underlying party, application, and document-matching data.

Underlying Base Objects

The documented view text reveals the principal sources joined together to produce the missing-item result set:

The ETRM metadata lists no referenced base objects explicitly, so the object list above is derived from the documented view text. In practice the view depends on the IGS admissions checklist and document-status model plus TCA party data.

Key Columns

  • PARTY_ID, PARTY_NAME, PARTY_NUMBER — identify the applicant for addressing the letter.
  • ADDRESS1–ADDRESS4, CITY, STATE, POSTAL_CODE, COUNTRY, EMAIL_ADDRESS — postal and electronic routing for correspondence.
  • ADMISSION_APPL_NUMBER, SEQUENCE_NUMBER — the specific application and its instance sequence.
  • NOMINATED_COURSE_CD — the course the applicant applied for.
  • ADM_DOC_STATUS — the document status flag distinguishing received from outstanding items.
  • DESCRIPTION (ITM and STEP) — human-readable names of the missing item and its processing step.
  • COMPLETION_DUE_DT — the deadline by which the document must be submitted.
  • SYSDATE formatting expression — generates the current date text for the letter body.

Common Use Cases and Queries

The view supports admissions follow-up letters, incomplete-file reporting, and applicant self-service status checks. A representative query follows:

  • SELECT party_name, admission_appl_number, nominated_course_cd, description, completion_due_dt FROM igs_ad_missing_items_letter_v WHERE adm_doc_status = 'MISSING' ORDER BY completion_due_dt; — lists applicants with outstanding documents, sorted by deadline, ready for merge into a reminder letter.
  • SELECT party_number, email_address, description FROM igs_ad_missing_items_letter_v WHERE admission_appl_number = :appl_no; — retrieves the missing items for a single application during enquiry.
  • Join to letter/merge templates to produce bulk correspondence, filtering by admission calendar or course to notify a specific intake cohort.

Because the view is read-only and joins several modules, queries should be filtered by admission calendar or application to maintain performance on large applicant populations.