Search Results enquiry_characteristic_type




Overview
Explore in AI Chat

Overview

The IGS_IN_APPL_CHAR_TYP table is a data storage object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing under the IGS (iGrants) schema. Its core function is to record the association between a person's enquiry and specific, user-defined characteristic types that classify that enquiry. These characteristics, such as 'school leaver', 'TAFE graduate', 'domestic', or 'international', provide categorical context to the enquiry process. It is critical to note that the provided ETRM documentation explicitly marks this table as "Obsolete." This designation indicates the table is part of a legacy data model that may be deprecated, and its use in new developments or integrations is strongly discouraged. The table is stored in the APPS_TS_TX_DATA tablespace.

Key Information Stored

The table's structure is centered on linking a person, their specific enquiry, and a characteristic type. The primary key is a composite of three columns, ensuring a unique combination for each record. Key columns include:

Common Use Cases and Queries

Given its obsolete status, primary use cases involve historical data analysis, legacy report maintenance, or data migration projects. A typical query would retrieve all characteristic types associated with a specific person's enquiry for auditing or reporting on historical applicant profiles. The fundamental SQL pattern involves joining with the person (HZ_PARTIES) and characteristic type lookup tables.

Sample Query: Retrieving all enquiry characteristics for a specific person identifier. SELECT eact.ENQUIRY_CHARACTERISTIC_TYPE, eact.ENQUIRY_APPL_NUMBER, hp.party_name
FROM IGS.IGS_IN_APPL_CHAR_TYP eact
JOIN HZ_PARTIES hp ON hp.party_id = eact.PERSON_ID
WHERE eact.PERSON_ID = :person_id
ORDER BY eact.ENQUIRY_APPL_NUMBER;

Reporting use cases would focus on generating counts or lists of enquiries segmented by these characteristic types, such as the number of domestic versus international enquiries received within a date range, filtered by the CREATION_DATE.

Related Objects

The table's relationships are defined through its primary and foreign keys. The documented relationships are:

  • Primary Key Constraint (IGS_IN_APPL_CHAR_TYP_PK): Enforces uniqueness on the combination of PERSON_ID, ENQUIRY_APPL_NUMBER, and ENQUIRY_CHARACTERISTIC_TYPE.
  • Foreign Key Reference (Outbound): The ENQUIRY_CHARACTERISTIC_TYPE column references a lookup table, documented as IGS_IN_ENQ_CHAR_TYPE, to validate the characteristic code.
  • Foreign Key Reference (Outbound): The PERSON_ID column is a foreign key to HZ_PARTIES.PARTY_ID, linking the enquiry characteristic to a person/party in the TCA registry.
  • Dependency: The table is referenced by a synonym (IGS_IN_APPL_CHAR_TYP) under the APPS schema, which is the standard access point for EBS application code.