Results for “igs_ad_emp_int_all”

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

Overview

IGS_AD_EMP_INT_ALL is a staging (interface) table within the IGS – Student System product of Oracle E-Business Suite, owned by the IGS schema. As its ETRM description states, the table "contains the person's employment details to be imported." It functions as the landing zone for employment history records that are validated and subsequently loaded into the permanent student employment structures by the IGS admissions/registration interface concurrent programs.

In EBS 12.1.1 and 12.2.2 the object is documented as VALID with 37 columns and a single-column primary key, IGS_AD_EMP_INT_PK, defined on INTERFACE_EMP_ID. The heuristic Data Vault classification mined from the foreign-key structure is standalone; from a modeling perspective this suggests the table behaves as an independent staging satellite rather than participating in a hub-and-link topology, consistent with the transient nature of interface staging objects. Records carry ORG_ID and are stamped with the standard WHO columns plus the concurrently request columns, indicating multi-org and request-driven loading.

Key Information Stored

The 37 documented columns capture employment attributes for import. The most significant are:

• INTERFACE_EMP_ID – surrogate primary key; the unique identifier of each interface row.
• ORG_ID – operating unit / organization context for the record.
• INTERFACE_ID and INTERFACE_RUN_ID – identify the batch/run that submitted the employment data.
• PARTY_TYPE and CONTACT – the person/party reference being imported.
• ORG_UNIT_CD, EMPLOYER, EMPLOYER_PARTY_NUMBER – employer identification details.
• START_DATE, END_DATE – employment period.
• TYPE_OF_EMPLOYMENT, FRACTION_OF_EMPLOYMENT, TENURE_OF_EMPLOYMENT – nature and intensity of the employment relationship.
• POSITION, OCCUPATIONAL_TITLE_CODE, WEEKLY_WORK_HRS – role and workload.
• MILITARY_RANK, SERVED, STATION – military service details.
• STATUS, MATCH_IND, ERROR_CODE – processing state; ERROR_CODE holds validation failures, MATCH_IND indicates a matched target record.
• DUP_EMPLOYMENT_NUMBER and REASON_FOR_LEAVING, COMMENTS – duplicate detection and free-text detail.
• Oracle WHO/request columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) audit the load.

The surrogate primary key is INTERFACE_EMP_ID; where unique business keys are enforced they typically combine an ORG_ID/INTERFACE_ID context with party and employer data, though no additional unique index is documented in the ETRM excerpt.

Common Use Cases and Queries

Practitioners query this table to inspect pending employment imports, diagnose failures, and reconcile loaded records.

• Count rows by processing status and error condition: SELECT STATUS, ERROR_CODE, COUNT(*) FROM IGS.IGS_AD_EMP_INT_ALL GROUP BY STATUS, ERROR_CODE;
• Locate failed rows for correction: SELECT INTERFACE_EMP_ID, EMPLOYER, START_DATE, END_DATE, ERROR_CODE FROM IGS.IGS_AD_EMP_INT_ALL WHERE ERROR_CODE IS NOT NULL;
• Trace a batch run: SELECT * FROM IGS.IGS_AD_EMP_INT_ALL WHERE REQUEST_ID = :request_id;
• Identify duplicates flagged by the interface using DUP_EMPLOYMENT_NUMBER and MATCH_IND.

Related Objects

Because the ETRM relationship data classifies this object as standalone, no hard foreign keys are documented. Logically it relates to:

• IGS_AD_EMP_INT_PK – its primary key constraint.
• IGS interface control/run tables keyed through INTERFACE_ID and INTERFACE_RUN_ID.
• Party tables referenced by PARTY_TYPE, CONTACT, and EMPLOYER_PARTY_NUMBER.
• Employer/organization tables keyed by ORG_UNIT_CD and EMPLOYER.
• The staging/validation concurrent programs (REQUEST_ID, PROGRAM_ID) that populate and consume the rows.
• Downstream student employment history tables loaded from this interface.