Search Results citizenship1_id




Overview
Explore in AI Chat

Overview

IGS_SS_INQ_PERSON is a self-service inquiry view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite. Its documented status is VALID, and it is described in the ETRM metadata as the "Self Service Inquiry Person View." The object type is a view, and the implementation exposes selected person and inquiry attributes from the underlying IGS_SS_INQ_PERSON_ALL table through a column-renaming SELECT. In practice, the view presents a denormalized, read-oriented projection of prospective or inquiry persons used by student self-service inquiry flows, reporting, and integration extracts. Because it is a view rather than a base table, it carries no independent data storage and reflects the current state of its underlying base object at query time.

Underlying Base Objects

The documented view text defines IGS_SS_INQ_PERSON over a single base object, IGS_SS_INQ_PERSON_ALL, aliased as TAB. Each output column is a direct alias of a corresponding base column, with TAB.ROWID exposed as ROW_ID. The base table is an _ALL suffixed object, which in the Oracle EBS multi-tenant convention implies the presence of an ORG_ID column supporting multi-organization or operating-unit filtering; ORG_ID is indeed projected by the view. The documented ETRM metadata lists no additional referenced base objects beyond IGS_SS_INQ_PERSON_ALL, and no joins, unions, or function-based expressions appear in the view text, so the relationship to the base object is strictly one-to-one at the row level prior to any predicate applied by the caller. No database link or synonym indirection is indicated.

Key Columns

Common Use Cases and Queries

The view is typically used for self-service inquiry, recruitment prospect reporting, and downstream extraction into data warehouses or CRM systems. Because CITIZENSHIP2_ID is commonly searched, the following query is representative:

  • Filter by second citizenship: SELECT INQ_PERSON_ID, GIVEN_NAME, SURNAME, CITIZENSHIP1_ID, CITIZENSHIP2_ID, STATUS FROM APPS.IGS_SS_INQ_PERSON WHERE CITIZENSHIP2_ID IS NOT NULL AND ORG_ID = :p_org_id;
  • Active inquiries by program: SELECT INQ_PERSON_ID, SURNAME, PROGRAM_ID, STATUS FROM APPS.IGS_SS_INQ_PERSON WHERE PROGRAM_ID = :p_program_id AND STATUS = 'ACTIVE';
  • Recent updates for integration: SELECT INQ_PERSON_ID, LAST_UPDATE_DATE, IMP_SOURCE_TYPE_ID FROM APPS.IGS_SS_INQ_PERSON WHERE LAST_UPDATE_DATE > :p_since_date;

Queries should observe multi-org security by binding ORG_ID where the client implementation enforces operating unit access, and should reference the APPS schema prefix in production SQL.