Search Results igs_rc_i_a_chartyp_pk

Overview

The table IGS_RC_I_A_CHARTYP is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a transactional table designed to record and manage the specific characteristics or types of enquiries submitted by a person during the application or enquiry process. Its primary role is to provide a detailed, auditable link between an applicant (person), their application instance, and the defined categories of information they are seeking or providing. This table is essential for segmenting and analyzing applicant interests and enquiry data, supporting targeted communication and reporting within the student recruitment and admissions lifecycle.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each recorded enquiry characteristic for an applicant. The key columns are PERSON_ID, which identifies the individual; ENQUIRY_APPL_NUMBER, which specifies the particular application or enquiry instance for that person; and ENQUIRY_CHARACTERISTIC_TYPE, which stores the code for the type of characteristic or enquiry. This design allows a single person and application to be associated with multiple characteristic types. The table does not store descriptive text for the characteristic type itself; that information is maintained in the referenced code table, IGS_RC_I_E_CHARTYP.

Common Use Cases and Queries

A primary use case is generating reports on applicant interests to inform recruitment strategies. For example, an admissions office may analyze the distribution of enquiry types to understand which academic programs or student services generate the most interest. Common SQL queries involve joining this table to the main application table (IGS_RC_I_APPL_ALL) and the characteristic type code table to produce meaningful reports. A typical pattern would be:

• Listing all characteristic types for a specific applicant: SELECT ert.enquiry_characteristic_type, ert.description FROM igs_rc_i_a_chartyp act, igs_rc_i_e_chartyp ert WHERE act.enquiry_characteristic_type = ert.enquiry_characteristic_type AND act.person_id = :p_person_id AND act.enquiry_appl_number = :p_appl_number;
• Counting applicants by enquiry type for a recruitment cycle: SELECT act.enquiry_characteristic_type, COUNT(DISTINCT act.person_id) FROM igs_rc_i_a_chartyp act GROUP BY act.enquiry_characteristic_type;

Related Objects

The IGS_RC_I_A_CHARTYP table is centrally connected to two other critical tables in the IGS module via foreign key constraints, ensuring referential integrity.

• IGS_RC_I_APPL_ALL: This is the primary application header table. IGS_RC_I_A_CHARTYP references it via the combined columns PERSON_ID and ENQUIRY_APPL_NUMBER. This relationship ties each recorded characteristic to a valid application record.
• IGS_RC_I_E_CHARTYP: This is the code lookup table that defines valid enquiry characteristic types. IGS_RC_I_A_CHARTYP references it via the ENQUIRY_CHARACTERISTIC_TYPE column, ensuring that only predefined characteristic codes are stored against an applicant.

The table's primary key, IGS_RC_I_A_CHARTYP_PK, enforces uniqueness on the combination of these three columns, preventing duplicate characteristic entries for a single application.