Search Results igf_se_payment_int_u1

Overview

IGF.IGF_SE_PAYMENT_INT is an interface (staging) table within the Oracle E-Business Suite Internet Grants Foundation (IGF) product schema, tightly coupled with the Student Employment / Federal Work-Study (FWS) business entity. Its display name in the ETRM repository is "Student Employment - Upload Payroll Information." The table functions as an inbound landing zone where an external HRMS or payroll system uploads payment detail records associated with student work-study awards. Once records are staged, the FA (Financial Aid) process consumes the rows and migrates them into the permanent IGF_SE_PAYMENT table. Rows that migrate successfully are subsequently deleted from the interface table.

In Oracle EBS 12.1.1 and 12.2.2 the object carries FND Design Data registration under IGF.IGF_SE_PAYMENT_INT, has a status of VALID, and resides in the APPS_TS_INTERFACE tablespace — the standard EBS tablespace reserved for open-interface staging objects. Because it is an interface table rather than a transactional entity, it is transient by design and does not participate in rich foreign-key relationships. The provided Data Vault heuristic classifies this object as standalone, meaning no durable hub, link, or satellite structure is implied; the interface row is effectively a short-lived staging capture rather than a modeled business entity. This is a modeling suggestion only — as an EBS interface table, its primary role remains operational staging, not dimensional persistence.

Key Information Stored

The table contains 19 documented columns. The most significant are:

• TRANSACTION_ID (NUMBER 15) — the surrogate primary key, defined by PK IGF_SE_PAYMENT_INT_PK and enforced by unique index IGF_SE_PAYMENT_INT_U1. It uniquely identifies every staged record.
• PAYROLL_ID (NUMBER) and AUTH_ID (NUMBER 15) — together these form the business-key candidate IGF_SE_PAYMENT_INT_U2, which is unique. This composite identifies the payroll record in the context of the authorizing award.
• BATCH_ID (NUMBER 15) — a unique identifier grouping each payroll upload batch.
• PAYROLL_DATE (DATE) — the payroll run date, or, when a record is entered manually, the paid date.
• PERSON_ID (NUMBER 15) — the unique person identifier of the paid student worker.
• FUND_ID (NUMBER 15) — the fund source from which the payment was made.
• PAID_AMOUNT (NUMBER 15) — the amount paid from the fund to the student in lieu of work-study.
• ORG_UNIT_CD (VARCHAR2 360) — the name of the organization that paid the amount (note: this is not an organization unit code placeholder, despite the column name).
• STATUS (VARCHAR2 10) — the processing state: NEW for newly staged rows, DONE for rows already migrated to IGF_SE_PAYMENT, and ERROR for rows that failed migration.
• ERROR_CODE (VARCHAR2) — populated when a row fails processing.
• LD_CAL_TYPE, LD_SEQUENCE_NUMBER, and HRS_WORKED — retained columns that are no longer used.
• The standard EBS audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are present.

Common Use Cases and Queries

Administrators and FA batch operators query this table to monitor upload completion and to isolate failed records. A typical pattern is to retrieve all staged rows pending migration:

SELECT TRANSACTION_ID, PAYROLL_ID, AUTH_ID, PERSON_ID, PAID_AMOUNT, ORG_UNIT_CD
FROM IGF.IGF_SE_PAYMENT_INT
WHERE STATUS = 'NEW';

Error reconciliation is equally common, listing rows flagged during migration along with their codes (joining to any IGF_SE_PAYMENT_INT_ERR table if present, per standard interface design):

SELECT TRANSACTION_ID, BATCH_ID, PAYROLL_ID, ERROR_CODE
FROM IGF.IGF_SE_PAYMENT_INT
WHERE STATUS = 'ERROR';

Batch-level validation uses BATCH_ID to reconcile expected totals against summed PAID_AMOUNT, and the unique index IGF_SE_PAYMENT_INT_U2 aids duplicate detection when an external HRMS feed is re-sent.

Related Objects

• IGF.IGF_SE_PAYMENT — the destination table populated by the FA process; rows are deleted from the interface table after successful migration.
• JTF_XML_INV_AUTHS — referenced via FK from IGF_SE_PAYMENT_INT.AUTH_ID, providing the authorization details for the payment.
• IGF_SE_PAYMENT_INT_U1 and IGF_SE_PAYMENT_INT_U2 — unique indexes on TRANSACTION_ID and on (PAYROLL_ID, AUTH_ID) respectively.
• IGF_SE_PAYMENT_INT_PK — the primary key constraint on TRANSACTION_ID.
• PER_ALL_PEOPLE_F / HRMS person entities — joined via PERSON_ID to resolve student worker identity (standard HRMS dependency; not formally an FK in the metadata).