Search Results igs_ad_fee_int_n1

Overview

IGS.IGS_AD_FEE_INT is an open-interface (staging) table in the Oracle E-Business Suite Student System (product code IGS, formerly Oracle iRecruitment/Admissions components under the IGS schema). It holds admission fee details for each person to be imported into the terminal table IGS_AD_APP_REQ by the Admission Import concurrent process. The table is classified with the FND Design Data object name IGS.IGS_AD_FEE_INT, resides in the APPS_TS_INTERFACE tablespace (PCT Free 10), and is designated a BUSINESS_ENTITY member of the IGS_ADM_APPLICATION category with a public scope and active lifecycle.

Heuristically, per Data Vault modeling conventions, this object classifies as a satellite rather than a hub or link: its unique identifier (INTERFACE_FEE_ID) is a purely technical surrogate key generated for the staging row, while the substantive business linkage is carried by the foreign key INTERFACE_APPL_ID referencing IGS_AD_APL_INT. The ETRM relationship metadata flags this object as standalone, meaning no downstream table declares a foreign key back to it — it is an inbound feeder only.

Key Information Stored

The most functionally significant columns documented for this table are:

• INTERFACE_FEE_ID — NUMBER(15), mandatory, the surrogate primary key (unique index IGS_AD_FEE_INT_PK). No business meaning; it exists solely to uniquely identify each staging row.
• INTERFACE_APPL_ID — NUMBER(15), the interface application identifier, indexed non-uniquely (IGS_AD_FEE_INT_N1) and the sole documented foreign key to IGS_AD_APL_INT.
• APPLICANT_FEE_TYPE_ID and APPLICANT_FEE_STATUS_ID — NUMBER(15) descriptors identifying the fee classification and the applicant fee status (the column corresponding to the "applicant_fee_status_id" search term).
• FEE_DATE — DATE; per the documented comment, it must be greater than the application date.
• FEE_AMOUNT — NUMBER; per the documented comment, it must be greater than zero.
• REFERENCE_NUM — VARCHAR2(60), the external payment or receipt reference.
• MATCH_IND — VARCHAR2 match indicator with the documented domain: 20 (match to be reviewed for discrepancy), 21 (reviewed and to be imported), 22 (reviewed and do not import), 23 (reviewed, no discrepancy, retain existing values).
• ERROR_CODE and ERROR_TEXT — validation failure diagnostics populated during import.
• STATUS — VARCHAR2 row status (indexed by IGS_AD_FEE_INT_N2).
• DUP_APP_REQ_ID — NUMBER(15), duplicate application requirement identifier used when the discrepancy rule is set to "Review".
• INTERFACE_RUN_ID and REQUEST_ID / PROGRAM_ID — NUMBER columns identifying the importing concurrent request and program run (IGS_AD_FEE_INT_N3 indexes INTERFACE_RUN_ID).
• PERSON_ID and ADMISSION_APPL_NUMBER — NUMBER(15) and VARCHAR2 respectively, resolving the fee to a person and admission application number.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID — standard "Who" audit columns.

Common Use Cases and Queries

The primary use case is validating and importing staged admission fee records via the Admission Import process. A prerequisite integrity query checks whether the referenced application exists before import:

SELECT f.interface_fee_id, f.interface_appl_id, f.applicant_fee_status_id
FROM igs_ad_fee_int f
WHERE NOT EXISTS (SELECT 1 FROM igs_ad_apl_int a WHERE a.interface_appl_id = f.interface_appl_id);

A discrepancy-review query isolates rows stuck awaiting manual reconciliation:

SELECT interface_fee_id, match_ind, error_code, error_text
FROM igs_ad_fee_int
WHERE match_ind = '20' AND status = 'ERROR';

A per-run reporting query aggregates fee amounts for concurrent request reconciliation:

SELECT interface_run_id, SUM(fee_amount), COUNT(*)
FROM igs_ad_fee_int
GROUP BY interface_run_id;

Related Objects

• IGS.IGS_AD_APL_INT — the interface application table joined via INTERFACE_APPL_ID to FEE_INT (documented FK).
• IGS.IGS_AD_APP_REQ — the terminal destination table populated by the Admission Import process.
• IGS.IGS_AD_FEE_INT_PK / _N1 / _N2 / _N3 — the indexes over INTERFACE_FEE_ID, INTERFACE_APPL_ID, STATUS and INTERFACE_RUN_ID.
• FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS — joinable on REQUEST_ID and PROGRAM_ID for concurrent-process auditing.
• PER_ALL_PEOPLE_F — referenced through PERSON_ID to resolve the applicant identity.
• Admission import PL/SQL APIs/concurrent program units consuming this table during the IGS_ADM_APPLICATION import lifecycle.