Search Results igs_pe_nonimg_empl




Overview
Explore in AI Chat

Overview

The IGS_PE_NONIMG_EMPL table resides in the IGS schema, which supports the Oracle E-Business Suite Student System product family. Its documented purpose is to store all student-related employment information required by SEVIS (the Student and Exchange Visitor Information System), the United States government system used to track foreign students and exchange visitors holding F, M, and J visas. In practice, this table captures employment records that must be reported to SEVIS for non-immigrant students, including the type of employment, authorization dates, and whether the employment was recommended or rescinded by a Designated School Official (DSO). The table carries eighteen documented columns in the 12.1.1 ETRM release and is classified as VALID.

The heuristic Data Vault classification mined from the foreign key structure is link. This reflects the table's role as an associative entity that connects a party (the employed student, via EMPL_PARTY_ID to HZ_PARTIES) with a SEVIS non-immigrant form record (via NONIMG_FORM_ID to IGS_PE_NONIMG_FORM). Treating it as a link is a modeling suggestion for downstream data warehouse or integration work; in the operational EBS schema it is a transactional detail table with its own surrogate key.

Key Information Stored

The table is anchored by the surrogate primary key NONIMG_EMPL_ID, enforced through the unique index IGS_PE_NONIMG_EMPL_PK. No separate business-key unique index is documented, so NONIMG_EMPL_ID serves as the sole documented unique identifier. The most significant columns are:

  • NONIMG_EMPL_ID — surrogate primary key for each employment record.
  • NONIMG_FORM_ID — foreign key to IGS_PE_NONIMG_FORM, tying the employment record to the student's SEVIS non-immigrant form.
  • EMPL_PARTY_ID — foreign key to HZ_PARTIES, identifying the employing party or the student party record.
  • EMPL_TYPE — classification of the employment (for example, on-campus, curricular practical training, or optional practical training categories used by SEVIS).
  • RECOMMEND_EMPL and RESCIND_EMPL — flags capturing whether the DSO recommended or rescinded the employment authorization.
  • EMPL_START_DATE and EMPL_END_DATE — the effective date range of the employment.
  • COURSE_RELEVANCE — indicator of whether the employment is related to the student's course of study.
  • EMPL_TIME — the amount or schedule of employment time reported.
  • REMARKS — free-text notes accompanying the record.
  • ACTION_CODE and PRINT_FLAG — processing and output control fields.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for standard EBS who-did-what auditing.

Common Use Cases and Queries

Typical use cases center on SEVIS reporting and compliance auditing for international students. Reporting queries join to HZ_PARTIES for student or employer identity and to IGS_PE_NONIMG_FORM for the governing SEVIS form:

  • Listing active employment for a student within a date window, filtering on EMPL_START_DATE and EMPL_END_DATE.
  • Identifying records awaiting authorization, using RECOMMEND_EMPL and RESCIND_EMPL status.
  • Extracting all employment tied to a specific SEVIS form for batch transmission to SEVIS.
  • Auditing employment types and course relevance for internal compliance review.

A representative join pattern is: SELECT e.NONIMG_EMPL_ID, e.EMPL_TYPE, e.EMPL_START_DATE, e.EMPL_END_DATE FROM IGS.IGS_PE_NONIMG_EMPL e JOIN IGS.IGS_PE_NONIMG_FORM f ON e.NONIMG_FORM_ID = f.NONIMG_FORM_ID JOIN HZ.HZ_PARTIES p ON e.EMPL_PARTY_ID = p.PARTY_ID WHERE e.EMPL_END_DATE IS NULL OR e.EMPL_END_DATE >= SYSDATE.

Related Objects

The documented foreign key relationships define the principal dependencies:

  • IGS_PE_NONIMG_FORM — parent table referenced through NONIMG_FORM_ID; the primary operational driver for employment data.
  • HZ_PARTIES — referenced through EMPL_PARTY_ID; supplies party (person or organization) identity.
  • HZ_PARTY_SITES and related HZ location tables — commonly joined when address detail for the party is required.
  • IGS_PE_NONIMG_EMPL_PK — the primary key index enforcing uniqueness on NONIMG_EMPL_ID.

Collectively, these relationships position IGS_PE_NONIMG_EMPL as the employment detail link between SEVIS form data and the parties model within the Student System.