Results for “igs_rc_i_a_lines”

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

Overview

IGS_RC_I_A_LINES is a junction table within the IGS – Student System product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata describes it as a "Junction table for Sales Lead Line table," indicating that its purpose is to associate records from the Sales Lead Line entity with related person or enquiry data. In the Oracle EBS data model, junction tables such as this resolve many-to-many relationships between two or more parent entities, and IGS_RC_I_A_LINES performs precisely that role by binding a person party, an enquiry/application number, and a sales lead line identifier into a single associative record.

From a data-modeling perspective, the heuristic Data Vault classification assigned to this object is link. This classification is derived from the foreign key structure: the table contains no descriptive attributes of its own beyond the composite key, and it exists solely to connect two referenced parent tables. Under a Data Vault 2.0 modeling approach, IGS_RC_I_A_LINES would be modeled as a link table whose grain is defined by the combination of its three business key columns, with hubs sourcing from HZ_PARTIES and AS_SALES_LEAD_LINES.

It is important to note that the ETRM metadata explicitly states this table is "Not implemented in this database." The object is therefore documented for completeness and lineage purposes, but it may not be physically present or populated in a given EBS environment. Consultants encountering references to it should verify physical existence before writing dependent queries.

Key Information Stored

The column set documented for this table is compact and entirely key-oriented; there are no descriptive or transactional attributes recorded in the metadata. The principal columns are:

• PERSON_ID – The party identifier referencing HZ_PARTIES, representing the individual associated with the sales lead line.
• ENQUIRY_APPL_NUMBER – The enquiry or application number, a business-key component linking the record to the recruitment or admissions enquiry context.
• SALES_LEAD_LINE_ID – The identifier of the sales lead line, referencing AS_SALES_LEAD_LINES.

The primary key, IGS_RC_I_A_LINES_PK, is a composite key defined over PERSON_ID, ENQUIRY_APPL_NUMBER, and SALES_LEAD_LINE_ID. This composite structure is significant because it confirms that the table's grain is the unique combination of these three values; no single column functions as a surrogate key, and all three columns together constitute both the primary key and the effective business-key candidate. There are no documented unique indexes beyond the primary key, which reinforces that all three columns are required to uniquely identify a row.

Common Use Cases and Queries

The most common use case for this object is reconstructing the relationship between a person, their enquiry or application, and the sales lead line that generated or is associated with that enquiry. Reporting on recruitment funnel activity — for example, determining which sales leads converted into submitted applications — relies on traversing this junction.

A representative query joining the table to its parent entities would resemble:

• SELECT l.PERSON_ID, l.ENQUIRY_APPL_NUMBER, l.SALES_LEAD_LINE_ID FROM IGS_RC_I_A_LINES l WHERE l.PERSON_ID = :p_person_id;
• Joining to HZ_PARTIES via PERSON_ID to retrieve party names and party numbers for reporting.
• Joining to AS_SALES_LEAD_LINES via SALES_LEAD_LINE_ID to obtain lead source, status, and campaign details.
• Aggregating counts of distinct SALES_LEAD_LINE_ID per enquiry number to measure lead-to-application ratios.

Because the table is documented as obsolete and not implemented, any such query should be guarded by a check for object existence or by confirming that the IGS recruitment and admissions modules are licensed and installed.

Related Objects

The FK metadata identifies two direct parent relationships, which define the primary related objects:

• HZ_PARTIES – joined on IGS_RC_I_A_LINES.PERSON_ID = HZ_PARTIES.PARTY_ID; supplies the person or organization identity.
• AS_SALES_LEAD_LINES – joined on IGS_RC_I_A_LINES.SALES_LEAD_LINE_ID = AS_SALES_LEAD_LINES.SALES_LEAD_LINE_ID; supplies the sales lead line detail.

Beyond these, related objects in the IGS recruitment and admissions domain include the enquiry and application header tables referenced conceptually by ENQUIRY_APPL_NUMBER, as well as AS_SALES_LEADS, which owns the header-level sales lead data. The Obsolete designation signals that these dependencies persist for historical lineage but may not be actively maintained in current releases.