Search Results igs_ad_perstmt_int

Overview

IGS_AD_PERSTMT_INT is an interface (staging) table within the Oracle E-Business Suite Student System module (IGS), which is documented as obsolete in EBS 12.1.1 and 12.2.2. The table holds personal statement details that must be imported for an applicant's admission application. Rather than storing the final, validated personal statement record, it acts as a landing zone for inbound data — typically populated by an external source, a batch load, or a concurrent program — which is subsequently validated and transferred into the production admissions tables by an import process.

Within the ETRM metadata, the table is documented with a physical schema owned by IGS containing 19 columns, and the primary key is defined as IGS_AD_PERSTMT_INT_PK on the INTERFACE_PERSTMT_ID column. The metadata notes that this object is "not implemented in this database," which is consistent with the obsolete status of the IGS product line in current EBS releases. From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone. This suggests the table can be modelled as an independent satellite-style staging entity anchored to its own interface key, since its single documented foreign key relationship points outward to another interface table rather than forming a hub-to-hub link construct.

Key Information Stored

The most significant columns in IGS_AD_PERSTMT_INT fall into three groups: identity, relationship, and process-control attributes.

• INTERFACE_PERSTMT_ID — The surrogate primary key (IGS_AD_PERSTMT_INT_PK) that uniquely identifies each staged personal statement row. This is the documented unique index and the only business-key candidate.
• INTERFACE_APPL_ID — The foreign key linking the personal statement to its parent admission application record in IGS_AD_APL_INT. This is the documented referential relationship that ties a statement to the application it belongs to.
• PERSL_STAT_TYPE — The personal statement type classification, distinguishing categories of statements submitted with an application.
• DATE_RECEIVED — The date the personal statement was received, used for tracking submission timing and processing SLAs.
• PERSON_ID — The identifier of the person (applicant) associated with the statement.
• ADMISSION_APPL_NUMBER — The human-readable admission application number, useful for reconciliation and reporting.
• STATUS and ERROR_CODE / ERROR_TEXT — Interface processing status and the diagnostic codes/messages generated when a row fails validation during import.
• INTERFACE_RUN_ID, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Concurrent program and interface run identifiers that group rows by load batch, essential for tracing which job populated or processed the data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each staging row.

Common Use Cases and Queries

The primary use case is monitoring and troubleshooting the admissions interface. Functional and technical teams query this table to identify rows that failed import, to reconcile counts against the source extract, and to purge successfully processed records.

• Identifying failed rows: SELECT INTERFACE_PERSTMT_ID, INTERFACE_APPL_ID, STATUS, ERROR_CODE, ERROR_TEXT FROM IGS_AD_PERSTMT_INT WHERE STATUS = 'ERROR';
• Grouping by load batch to assess throughput: SELECT INTERFACE_RUN_ID, COUNT(*) FROM IGS_AD_PERSTMT_INT GROUP BY INTERFACE_RUN_ID;
• Joining to the parent application interface to correlate statements with applications: SELECT p.INTERFACE_PERSTMT_ID, p.ADMISSION_APPL_NUMBER, a.INTERFACE_APPL_ID FROM IGS_AD_PERSTMT_INT p JOIN IGS_AD_APL_INT a ON p.INTERFACE_APPL_ID = a.INTERFACE_APPL_ID;
• Reporting on receipt volume over time using DATE_RECEIVED for admissions-cycle analytics.

Related Objects

• IGS_AD_APL_INT — The parent application interface table. The documented foreign key IGS_AD_PERSTMT_INT.INTERFACE_APPL_ID references IGS_AD_APL_INT, so this is the principal join path.
• IGS_AD_PERSTMT_INT_PK — The primary key constraint/index on INTERFACE_PERSTMT_ID defining row uniqueness.
• IGS_AD_PERSTMT — The presumed production personal statement table into which validated interface rows are ultimately imported (supplementary knowledge; not documented above).
• IGS admissions import concurrent programs and the associated application programming interfaces that consume IGS_AD_APL_INT and its dependent interface tables, including this statement staging table.

Given the obsolete status of the IGS Student System, implementations on 12.1.1 and 12.2.2 should treat IGS_AD_PERSTMT_INT as a legacy or non-implemented object and confirm its presence before relying on it for integration or reporting.