Results for “passport_expiry_date”

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

Overview

IGSBV_PASSPORTS is a read-only database view within the Oracle E-Business Suite Student System (IGS) product family. As reflected in the ETRM documentation for release 12.2.2, the view is classified under IGS - Student System (Obsolete) and is described as an entity that "contains information about a person's passport details." Its purpose is to expose passport data recorded against a person—typically a student, applicant, or related party—in a flattened, report-friendly format suitable for inquiries, extracts, and integration interfaces.

The view consolidates passport attributes from the person passport table with the party identifier from the trading community model, so consumers do not need to join those structures manually. It is defined with the WITH READ ONLY clause, confirming that it is intended strictly for query and reporting access rather than for DML operations. In the documented environment the object is noted as "Not implemented in this database," indicating availability depends on the specific instance and whether the IGS passport functionality has been deployed.

Underlying Base Objects

The view text joins two base objects: IGS_PE_PASSPORT (aliased PEP) and HZ_PARTIES (aliased HZP). The join predicate is PEP.PERSON_ID = HZP.PARTY_ID, linking each passport record to its owning party. Although the ETRM metadata lists referenced base objects as "none documented," the embedded view text establishes these two tables as the authoritative sources.

• IGS_PE_PASSPORT – Stores the passport-level detail: passport number, country code, expiry date, person identifier, and standard audit columns.
• HZ_PARTIES – Supplies the PARTY_NUMBER, presented in the view as PERSON_NUMBER, providing the human-readable party identifier.

Key Columns

• PERSON_NUMBER – The party number from HZ_PARTIES, identifying the person to whom the passport belongs.
• PASSPORT_NUMBER – The passport's identifying number.
• PASSPORT_COUNTRY_CODE – The issuing country. The view exposes this value and also defines a descriptive column labeled "_LA:PASSPORT_COUNTRY," which resolves the code against the HR_LOOKUPS lookup type PER_US_COUNTRY_CODE using the MEANING attribute. This is directly relevant to searches on passport_country_code, as the stored code is the primary filter attribute for country-based queries.
• PASSPORT_EXPIRY_DATE – The date on which the passport expires, commonly used for validity checks.
• PERSON_ID and PASSPORT_ID – Surrogate keys for the person and the passport record respectively.
• CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE – Standard audit columns for change tracking.

Common Use Cases and Queries

Typical uses include verifying passport nationality for admissions, monitoring documents nearing expiry, and feeding downstream systems with person-level passport data. A frequent pattern is filtering by the issuing country code:

• SELECT person_number, passport_number, passport_country_code, passport_expiry_date FROM igsbv_passports WHERE passport_country_code = 'US';
• SELECT person_number, passport_number, passport_expiry_date FROM igsbv_passports WHERE passport_expiry_date < SYSDATE + 180;
• Joining the view back to student or person tables on PERSON_ID for consolidated reporting.

Because the view is read-only and its availability is instance-dependent, developers should confirm its presence before embedding it in production reporting logic.