Results for “category_code”

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

Overview

IGS_SV_EV_CRT_BIO_V is a database view owned by the APPS schema in the Oracle E-Business Suite, delivered as part of the IGS (Student System) product family. Its documented purpose is to fetch biographic information for new Exchange Visitor students. The view is categorized as an Exchange Visitor (EV) data-access object: it surfaces the personal, demographic, and immigration-related attributes that the Student System captures for individuals entering the institution under an Exchange Visitor program, such as those administered in connection with the J-1 visa category.

Rather than acting as a transactional entity, the view functions as a read-only reporting and integration layer. It consolidates a single row of biographic detail per person and per processing batch, and it renames several of the source columns with an EV_ prefix so that consuming reports, concurrent programs, and downstream interfaces can reference Exchange Visitor-specific terminology without embedding the underlying column names. Because it joins or derives from staging-style biographic data, the view is typically used prior to, or alongside, formal record creation for newly arrived Exchange Visitor students.

In the context of the user search term ev_first_name, the view is the documented source of that attribute: the first name of the Exchange Visitor is exposed under the alias EV_FIRST_NAME, mapped directly from the underlying FIRST_NAME column.

Underlying Base Objects

Per the documented view text, IGS_SV_EV_CRT_BIO_V is defined over a single base object: IGS_SV_BIO_INFO. The SELECT statement draws all of its columns from this one table, aliased as BIO, which indicates a straightforward projection rather than a complex multi-table join. No additional referenced base tables are documented in the ETRM metadata for this view.

The relationship is therefore one-to-one with the rows of IGS_SV_BIO_INFO. The view does not aggregate, filter, or restrict the source rows in the documented SQL; instead it performs column-level aliasing and selection. The core identifying keys carried through from the base table are BATCH_ID, presumably identifying the processing or load batch under which the biographic record was captured, and PERSON_ID, the unique person identifier. Every other column is a descriptive attribute attached to those keys.

Because the view is a direct projection, any change to the structure of IGS_SV_BIO_INFO that removes or renames a referenced column would invalidate the view; the ETRM status is recorded as VALID, confirming the projection currently resolves successfully against its base table.

Key Columns

• BATCH_ID — Identifier of the batch associated with the biographic record; useful for grouping newly created Exchange Visitor records by load or processing run.
• PERSON_ID — The person identifier, the principal join key to other Student System person-level objects.
• EV_FIRST_NAME — First name of the Exchange Visitor (from FIRST_NAME); the attribute matched by the search term ev_first_name.
• EV_LAST_NAME, EV_MIDDLE_NAME, EV_SUFFIX — Surname, middle name, and name suffix for the Exchange Visitor.
• EV_BIRTH_DATE — Date of birth.
• EV_GENDER — Gender of the Exchange Visitor.
• EV_BIRTH_CITY, EV_BIRTH_CNTRY_CODE — City of birth and its country code.
• EV_CITIZEN_CNTRY_CODE — Country of citizenship.
• EV_PERM_RES_CNTRY_CODE — Country of permanent residence (sourced from LEGAL_RES_CNTRY_CODE).
• EV_VISA_TYPE — Visa type recorded for the Exchange Visitor.
• CATEGORY_CODE — Exchange Visitor category code (not prefixed in the projection).
• BIRTH_CNTRY_RESN_CODE — Birth country reason code.

Common Use Cases and Queries

The view supports reporting and integration for newly created Exchange Visitor student records, particularly where biographic and immigration attributes must be extracted from the staging area into external systems such as SEVIS-related interfaces, visa processing utilities, or institutional reporting extracts. A frequent pattern is lookup by name or person to confirm captured biographic details.

Sample query retrieving biographic details for a specific person:

SELECT batch_id, person_id, ev_first_name, ev_last_name,
       ev_birth_date, ev_citizen_cntry_code, ev_visa_type, category_code
FROM   apps.igs_sv_ev_crt_bio_v
WHERE  person_id = :p_person_id;

Sample query locating an Exchange Visitor by first name:

SELECT person_id, ev_first_name, ev_last_name, ev_visa_type
FROM   apps.igs_sv_ev_crt_bio_v
WHERE  UPPER(ev_first_name) = UPPER(:p_first_name);

Sample query listing all Exchange Visitors captured in a batch:

SELECT person_id, ev_last_name, ev_first_name, ev_birth_cntry_code
FROM   apps.igs_sv_ev_crt_bio_v
WHERE  batch_id = :p_batch_id
ORDER  BY ev_last_name, ev_first_name;

Because the view exposes only biographic and immigration attributes and no address or contact columns, it is normally used alongside other Exchange Visitor views when a complete person profile is required.