Results for “igr_i_a_itype_v”

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

Overview

IGR_I_A_ITYPE_V is a reporting view in the Oracle E-Business Suite IGS (Student System) product family. It exposes the set of information types that were requested by a prospective applicant or lead during an inquiry or enquiry transaction. The view consolidates data from the IGS inquiry application tables with deliverable and sales-lead reference data, so that enquiry responses can be reported alongside the nature of the enquiry and the associated vehicle response (inquiry method).

Under ETRM 12.2.2 the object is documented as obsolete and is recorded as "Not implemented in this database." Its product classification is "IGS - Student System (Obsolete)," which indicates the view is retained as legacy metadata for reference only and is not expected to exist in a current 12.1.1 or 12.2.2 instance. The view is therefore relevant primarily for historical reporting, migration analysis, and understanding of the pre-existing enquiry model rather than for new development.

Underlying Base Objects

The view is defined over four referenced objects:

• IGR_I_A_ITYPE — the driving table holding the information-type rows associated with an enquiry application, identified by PERSON_ID and ENQUIRY_APPL_NUMBER.
• AMS_P_DELIVERABLES_V — a deliverables view supplying package item name, description, and availability dates, joined on INFO_TYPE_ID = DELIVERABLE_ID.
• IGR_I_APPL_ALL — the enquiry application table providing the enquiry date, joined on PERSON_ID and ENQUIRY_APPL_NUMBER.
• AS_SALES_LEADS_V — the sales-lead view providing the vehicle response code and its meaning, joined on SALES_LEAD_ID.

All joins are equi-joins across these four sources; the view performs no aggregation and simply projects the combined result set. No base tables are separately documented for the view in the supplied metadata beyond those visible in the view text.

Key Columns

• ROW_ID — the ROWID of the underlying IGR_I_A_ITYPE row.
• PERSON_ID, ENQUIRY_APPL_NUMBER — identify the person and the enquiry application to which the information type belongs.
• ENQUIRY_DT — the date of the enquiry, sourced from IGR_I_APPL_ALL.
• INQUIRY_METHOD_CODE — the vehicle response code from AS_SALES_LEADS_V; this is the column commonly searched as "inquiry_method_code."
• INQUIRY_METHOD — the decoded meaning of the vehicle response code.
• INFO_TYPE_ID, PACKAGE_ITEM, DESCRIPTION — the information type identifier and the corresponding deliverable name and description.
• ACTUAL_AVAIL_FROM_DATE, ACTUAL_AVAIL_TO_DATE — availability window for the deliverable.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns from IGR_I_A_ITYPE.

Common Use Cases and Queries

Typical usage centres on analysing which information types prospective students requested and the method by which the inquiry was made. A representative query filters on the inquiry method code:

• SELECT person_id, enquiry_app_number, enquiry_dt, inquiry_method_code, inquiry_method, package_item, description FROM igr_i_a_itype_v WHERE inquiry_method_code = :method_code;
• SELECT enquiry_app_number, COUNT(*) FROM igr_i_a_itype_v GROUP BY enquiry_app_number;
• SELECT package_item, inquiry_method, COUNT(*) FROM igr_i_a_itype_v GROUP BY package_item, inquiry_method ORDER BY 3 DESC;

Because the object is documented as obsolete and not implemented, any query against IGR_I_A_ITYPE_V should be validated against the actual database before being relied upon. Where it is absent, equivalent data must be sourced directly from the underlying enquiry, deliverable, and sales-lead objects.