Results for “condition_code”

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

Overview

The IGSFV_UC_APPLICANT_CHOICES view is a full (multi-table) database view belonging to the IGS – Student System product family in Oracle EBS. It presents the full record of applicant choices held within the student system, oriented toward the UCAS (Universities and Colleges Admissions Service) admissions cycle. Its name follows the conventional IGS naming prefix, with the "FV" component denoting a "full view" that consolidates the applicant choice header with its associated descriptive and processing attributes into a single queryable structure.

In practice, this view exposes the complete applicant choice entity — in essence, a denormalized projection of the underlying APPLICANT_CHOICES table in which internal column names are aliased to externally meaningful names (for example, CH.APP_CHOICE_ID becomes APPLICANT_CHOICE_ID and CH.DECISION becomes DECISION). The view therefore acts as the primary reporting and integration interface for applicant choice data, shielding consumers from internal column naming while presenting the same row-level content. It is documented as part of the IGS – Student System, which ETRM classifies as obsolete, and the ETRM metadata records the view as not implemented in the reference database.

Underlying Base Objects

ETRM documents a single referenced base object for this view, identified under the heading "Underlying Base Objects." The view text confirms that the projection is drawn from that base table. Because it is defined as a full view rather than an inventory or summary view, no aggregation, grouping, or outer-join consolidation logic is applied; each row in the base table produces exactly one row in the view.

The following points characterize the relationship to the base object:

• The base table supplies the applicant choice header, including identifiers, decision data, offer data, and processing control columns.
• The view adds no new derivations; it is a pure rename/projection view.
• Fetching through the view returns the same cardinality as the base table, which makes it a safe replacement in read-only reporting queries.

Key Columns

The columns exposed fall into several functional groups. Identification columns include APPLICANT_CHOICE_ID, APPLICANT_ID, APPLICANT_UCAS_NUMBER, APPLICANT_CHOICE_NUMBER, UCAS_CYCLE, and UCAS_SYSTEM_CODE. Course and program routing is represented by UCAS_INSTITUTE_CODE, UCAS_PROGRAM_CODE, OSS_PROGRAM_CODE, OSS_PROGRAM_VERSION, OSS_ATTENDANCE_TYPE, OSS_ATTENDANCE_MODE, UCAS_CAMPUS, OSS_LOCATION, and UCAS_FACULTY. Entry detail includes ENTRY_YEAR, ENTRY_MONTH, and POINT_OF_ENTRY.

Flags and status indicators include HOME_FLAG, DEFERRED_FLAG, ROUTE_B_PREFERENCE_ROUND_FLAG, ROUTE_B_ACTUAL_ROUND_FLAG, CHOICE_CANCELLED_FLAG, and GTTR_PART_TIME. Decision and reply data are carried in CONDITION_CATEGORY, CONDITION_CODE, DECISION, DECISION_DATE, DECISION_NUMBER, REPLY, SUMMARY_OF_CONDITIONS, and ACTION. Offer data appears in OFFERED_COURSE, OFFERED_CAMPUS, OFFERED_COURSE_LENGTH, OFFERED_ENTRY_MONTH, OFFERED_ENTRY_YEAR, OFFERED_ENTRY_POINT, and OFFERED_TEXT. Prior-choice and substitution history is retained via SUBSTITUTION, SUBSTITUTED_DATE, PREVIOUS_INSTITUTION, PREVIOUS_COURSE, and PREVIOUS_CAMPUS. Finally, interface control columns include EXPORT_TO_OSS_STATUS, EXPORT_PROCESS_ERROR_CODE, ADM_IMPORT_PROCESS_BATCH_ID, UCAS_AMENDMENT, WITHDRAWAL_REASON, and DATE_OF_LAST_CHANGE.

Common Use Cases and Queries

Typical uses include admissions reporting, UCAS decision analysis, offer monitoring, and troubleshooting of the OSS export process.

• Decisions by cycle: SELECT UCAS_CYCLE, DECISION, COUNT(*) FROM IGSFV_UC_APPLICANT_CHOICES GROUP BY UCAS_CYCLE, DECISION;
• Applicant's choice list: SELECT APPLICANT_UCAS_NUMBER, APPLICANT_CHOICE_NUMBER, UCAS_PROGRAM_CODE, DECISION, REPLY FROM IGSFV_UC_APPLICANT_CHOICES WHERE APPLICANT_UCAS_NUMBER = :ucas_no ORDER BY APPLICANT_CHOICE_NUMBER;
• Export error triage: SELECT APPLICANT_CHOICE_ID, EXPORT_TO_OSS_STATUS, EXPORT_PROCESS_ERROR_CODE FROM IGSFV_UC_APPLICANT_CHOICES WHERE EXPORT_TO_OSS_STATUS = 'E';

Because the product is documented as obsolete and the view is not implemented in the reference database, some sites will need to substitute the underlying base table name in place of the view name in these statements.