Results for “igs_rc_i_a_pkgitm”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_RC_I_A_PKGITM is a table within the Oracle E-Business Suite Student System (IGS) product family. It stores the details of an enquiry package, capturing the association between a prospective applicant, an enquiry application, and the individual package items that comprise that enquiry. In the context of Oracle EBS 12.1.1 and 12.2.2, this object supports recruitment and admissions functionality, where enquiry packages group together the items (such as documents, requirements, or program offerings) presented to or associated with an applicant during the enquiry lifecycle.
The ETRM metadata classifies this object heuristically as a link table under the Data Vault modeling convention. This classification reflects its intersection-style structure: it resolves a many-to-many style relationship between enquiry applications/persons on one side and package items on the other, rather than acting as a hub of independent business entities or a satellite of descriptive attributes.
Key Information Stored
The table is defined by a composite primary key, IGS_RC_I_A_PKGITM_PK, consisting of three columns that together uniquely identify each row:
- ENQUIRY_APPL_NUMBER — The enquiry application number, identifying the enquiry application context for which package item details are recorded. This is the primary business-key component linking to the enquiry application.
- PERSON_ID — The person identifier of the prospective applicant associated with the enquiry. This is the primary business identifier for the individual.
- PACKAGE_ITEM_ID — The identifier of the specific package item included in the enquiry package, referencing the package item definition.
Because the primary key is composed entirely of these three business-meaningful columns, no separate surrogate key column is documented. The combination functions simultaneously as the uniqueness constraint and the join path to related entities. Descriptive attributes, if present in additional columns, are not enumerated in the provided metadata; the documented structure focuses on the key and foreign-key columns that define the relationship.
Common Use Cases and Queries
Typical use cases include reporting on which package items are attached to a given prospective applicant's enquiry, auditing the composition of enquiry packages across recruitment cycles, and reconciling enquiry records against the underlying application and package item definitions. A representative query joins the link table to both parent objects:
SELECT a.enquiry_appl_number,
a.person_id,
p.package_item_id
FROM igs_rc_i_a_pkgitm a,
igs_rc_i_pkg_item p,
igs_rc_i_appl_all ap
WHERE a.package_item_id = p.package_item_id
AND a.person_id = ap.person_id
AND a.enquiry_appl_number = ap.enquiry_appl_number;
Reporting scenarios frequently aggregate counts of package items per applicant or per enquiry application number. Because this object is reported as not implemented in the documented database instance, administrators should verify deployment status in their own environment before relying on it for live reporting.
Related Objects
- IGS_RC_I_PKG_ITEM — Referenced by IGS_RC_I_A_PKGITM.PACKAGE_ITEM_ID. Holds the package item definitions that are associated with enquiry packages.
- IGS_RC_I_APPL_ALL — Referenced by IGS_RC_I_A_PKGITM.PERSON_ID and IGS_RC_I_A_PKGITM.ENQUIRY_APPL_NUMBER. Holds the enquiry application records for prospective applicants.
These two parent tables are the primary dependencies: IGS_RC_I_APPL_ALL supplies the applicant and enquiry application context, while IGS_RC_I_PKG_ITEM supplies the package item definition. Any query resolving the complete enquiry package picture must join through both. Additional IGS recruitment and admissions views may reference this link table indirectly through these foreign-key relationships.
-
Table: IGS_RC_I_A_PKGITM 12.1.1
Stores the details of enquiry package.
Not implemented in this database·Explore IGS module →
-
Table: IGS_RC_I_A_PKGITM 12.2.2
Stores the details of enquiry package.
Not implemented in this database·Explore IGS module →
-
Table: IGS_RC_I_PKG_ITEM 12.2.2
Junction table to OMO deliverables table, used to store both Package Item and information Type.
Not implemented in this database·Explore IGS module →
-
Table: IGS_RC_I_PKG_ITEM 12.1.1
Junction table to OMO deliverables table, used to store both Package Item and information Type.
Not implemented in this database·Explore IGS module →
-
View: IGS_RC_I_A_PKGITM_V 12.1.1
Package Items requested during Inquiry
Not implemented in this database·Explore IGS module →
-
View: IGS_RC_I_A_PKGITM_V 12.2.2
Package Items requested during Inquiry
Not implemented in this database·Explore IGS module →
-
Table: IGS_RC_I_APPL_ALL 12.1.1
Describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information.
Not implemented in this database·Explore IGS module →
-
Table: IGS_RC_I_APPL_ALL 12.2.2
Describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information.
Not implemented in this database·Explore IGS module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2