Search Results appl_pgmapprv_id




Overview
Explore in AI Chat

Overview

IGS_AD_APPL_PGMAPPRV_V is a seeded Oracle E-Business Suite view owned by the APPS schema and delivered as part of the IGS (Student System) product family. Its documented purpose is to show the program approval status and associated details for a particular person. In practice, the view denormalizes the program-approval assignment records held against an admission application, resolving the raw approval status code to its descriptive lookup meaning and joining to the person base view to expose the approver's name and person number. This makes the view suitable for both operational enquiry screens and downstream reporting or integration extracts where program approvals must be presented in a human-readable form.

The object is documented as VALID in ETRM 12.2.2 and behaves identically in the 12.1.1 code line, as the underlying IGS table structures and this view definition were not materially changed between the two releases. It is a read-only presentation object: no DML should be issued against it.

Underlying Base Objects

The view text is defined over three sources:

The relationships are inner joins in all cases, so a row is returned only where a valid lookup meaning and a matching person record exist. Because the approver join uses PGM_APPROVER_ID and IGS_PE_PERSON_BASE_V, the person attributes exposed describe the approver, not the applicant.

Key Columns

Common Use Cases and Queries

Typical uses include approval workload reporting, applicant tracking, and integration extracts feeding external student systems. A frequent requirement is locating approvals assigned on or after a given date, which is exactly the assign_date search pattern.

SELECT person_id, person_number, admission_appl_number,
       full_name, assign_type, assign_date,
       program_approval_status, meaning
FROM   apps.igs_ad_appl_pgmapprv_v
WHERE  assign_date >= :p_from_date
ORDER  BY assign_date;

To review all approvals for one approver, filter on full_name or pgm_approver_id. Because the view is defined in APPS, it is normally queried from a reporting or read-only responsibility rather than exposed directly for data entry.