Results for “type_of_employment”

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

Overview

IGS_AD_EMP_INT is a reporting and integration view within the Oracle E-Business Suite IGS (Student System) product family. In the ETRM 12.2.2 metadata, the object is documented as "View: IGS_AD_EMP_INT" with a product assignment of IGS – Student System (Obsolete) and an implementation note stating "Not implemented in this database." The view exists to expose the employment history and employment detail data captured for student admissions and records processing, presenting the rows in a flattened, denormalized form suitable for concurrent program processing, interface validation, and downstream reporting.

The view is directly relevant to the search term "type_of_employment" because TYPE_OF_EMPLOYMENT is one of the columns exposed by the view, reflecting the category or classification of an applicant's or student's employment record (for example full-time, part-time, or similar designations defined in the Student System lookup). The view is one of several IGS admissions interface views whose purpose is to surface staged interface rows together with processing status, error, and audit information.

Underlying Base Objects

The documented view definition selects from a single base object: IGS_AD_EMP_INT_ALL, aliased as TAB. The view text applies a ROWID-based ROW_ID column and projects the columns of the base table. Notably, the view performs a form of column renaming and null-padding: DUP_EMPLOYMENT_NUMBER is exposed as DUP_SEQUENCE_NUMBER, and several columns in the view's column list (BRANCH, MILITARY_RANK, SERVED, STATION, PARTY_TYPE, ORG_UNIT_CD) are supplied explicitly as NULL in the underlying SELECT. EMPLOYER_PARTY_NUMBER is passed through without an alias, and REASON_FOR_LEAVING is included as the final projected column.

The ETRM metadata records no additional referenced base objects beyond IGS_AD_EMP_INT_ALL, and no documented owner is listed. Because the document states the object is not implemented in the database, deployments referencing IGS_AD_EMP_INT should verify its existence against the actual 12.1.1 or 12.2.2 instance before relying on it.

Key Columns

• ROW_ID – Derived from the base table ROWID; a unique identifier for each interface row.
• INTERFACE_EMP_ID / INTERFACE_ID – Identifiers linking the employment row to its parent interface record.
• CONTACT – The person or contact associated with the employment record.
• TYPE_OF_EMPLOYMENT – The classification of employment captured for the record; the primary column of interest in the originating search.
• FRACTION_OF_EMPLOYMENT / TENURE_OF_EMPLOYMENT – Quantitative attributes describing the proportion and duration/status of the employment.
• START_DATE / END_DATE – Employment period boundaries.
• POSITION / OCCUPATIONAL_TITLE_CODE / EMPLOYER / EMPLOYED_BY_DIVISION_NAME – Descriptive attributes of the role and employer.
• STATUS / ERROR_CODE / MATCH_IND – Interface processing indicators used to track validation and matching outcomes.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE – Concurrent program audit context for the interface run.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN – Standard WHO audit columns.
• REASON_FOR_LEAVING – Documentation of the termination or separation reason.

Common Use Cases and Queries

Typical usage involves extracting employment interface rows for reconciliation, troubleshooting interface errors, or reporting on employment distribution by type. The following sample selects employment type and related attributes for a given interface run:

SELECT interface_emp_id,
       interface_id,
       contact,
       type_of_employment,
       fraction_of_employment,
       tenure_of_employment,
       start_date,
       end_date,
       status,
       error_code
  FROM igs_ad_emp_int
 WHERE request_id = :p_request_id
 ORDER BY interface_emp_id;

A second common pattern aggregates counts by employment type to validate incoming data:

SELECT type_of_employment,
       COUNT(*) records
  FROM igs_ad_emp_int
 WHERE status = 'E'
 GROUP BY type_of_employment;

Because the object is documented as obsolete and not implemented in the reference database, queries should be tested against the target instance, and any reliance on the NULL-padded columns (BRANCH, MILITARY_RANK, SERVED, STATION, PARTY_TYPE, ORG_UNIT_CD) should be reconsidered, as these are not sourced from the underlying interface table.