Search Results igsfv_ad_adm_ps_appl

Overview

IGSFV_AD_ADM_PS_APPL is a read-only Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It consolidates admission application program data for prospective students, joining the core application record to party, person profile, and lookup tables so that a single query returns a fully described row per application. The "FV" prefix follows the Oracle convention for a user-facing "form/view" object intended for inquiry and reporting rather than transactional maintenance, and the view text terminates with the WITH READ ONLY clause, confirming that it cannot be used for DML.

In an EBS 12.1.1 or 12.2.2 environment, this view serves as a reporting and integration access point over the Student System admission tables. Because IGS admission data is normalized across several base tables, the view spares report authors and downstream interface developers from reconstructing the joins between application, person, and lookup data. The view is documented as VALID in the ETRM repository, meaning its underlying dependencies resolved successfully at the time of extraction.

Underlying Base Objects

The view is defined over five documented base objects:

• IGS_AD_PS_APPL_ALL — the primary admission application table (aliased APA), supplying person, application number, course nomination, admission basis, and admission code.
• IGS_AD_BASIS_FOR_AD — the basis-for-admission lookup (aliased BFA), outer-joined on BASIS_FOR_ADMISSION_TYPE to supply the descriptive text for the admission basis.
• HZ_PARTIES — the trading community party record (aliased P), inner-joined on PERSON_ID = PARTY_ID, providing PARTY_NUMBER.
• HZ_PERSON_PROFILES — the person profile (aliased PP), joined on PARTY_ID and filtered to CONTENT_SOURCE_TYPE = 'USER_ENTERED'; the effective-dating predicate SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE, SYSDATE) restricts output to the currently effective profile row and supplies PERSON_NAME.
• IGS_AD_CD — the admission code table (aliased CD), outer-joined on ADMISSION_CD to supply the code description.

Both the basis-for-admission and admission-code joins are outer joins, so applications missing a matching lookup value are still returned, with the corresponding description columns null. The party and person-profile joins are inner joins, meaning an application row is only visible when a matching party and a current user-entered person profile exist.

Key Columns

• PERSON_ID / PARTY_NUMBER / PERSON_NAME — identity of the applicant, resolved from the application, HZ_PARTIES, and HZ_PERSON_PROFILES respectively.
• ADMISSION_APPL_NUMBER — the admission application number exposed as ADMISSION_APPLICATION_NUMBER; the primary human-readable identifier for the application.
• NOMINATED_COURSE_CD / TRANSFER_COURSE_CD — the nominated program code and any transfer program code associated with the application.
• BASIS_FOR_ADMISSION_TYPE and BASIS_FOR_ADMISSION_TYPE_DESC — the admission basis code and its lookup description.
• ADMISSION_CD and BASIS_FOR_ADMISSION_CODE_DESC — the admission code and its description from IGS_AD_CD.
• COURSE_RANK_SET / PROGRAM_RANK_SET and COURSE_RANK_SCHEDULE / PROGRAM_RANK_SCHEDULE — the ranking set and schedule applied to the applicant's course preferences.
• "_LA:REQ_FOR_RECO_IND_FLAG" and "_LA:REQ_FOR_ADV_ST_IND_FLAG" — derived columns generated from IGS_LOOKUP_VALUES using the YES_NO lookup type; these expose the "request for reconsideration" and "request for advanced standing" indicators as descriptive meaning values rather than raw flags.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns inherited from the application table.

Common Use Cases and Queries

Typical uses include admission office reporting, applicant tracking extracts, and integration feeds into external student systems or data warehouses. Because the view is read-only and already resolves the descriptive lookups, it is well suited to ad hoc querying by functional users with report responsibilities.

A representative query listing applications for a nominated program:

• SELECT admission_application_number, person_number, person_name, nominated_program_code, basis_for_admission_type_desc, basis_for_admission_code_desc FROM igsfv_ad_adm_ps_appl WHERE nominated_program_code = :program_code ORDER BY person_name;

To identify applicants requesting reconsideration or advanced standing, query the derived indicator columns directly:

• SELECT admission_application_number, person_name, "_LA:REQ_FOR_RECO_IND_FLAG", "_LA:REQ_FOR_ADV_ST_IND_FLAG" FROM igsfv_ad_adm_ps_appl WHERE "_LA:REQ_FOR_RECO_IND_FLAG" = 'Yes';

Because the indicator column names contain a colon and start with a quote-delimited prefix, they must be referenced with double quotes exactly as defined. Note also that the effective-dating filter on HZ_PERSON_PROFILES is evaluated at query time against SYSDATE, so results reflect the applicant's currently effective person profile record.