Search Results empl_party_id

Overview

The view IGS_PE_NONIMG_EMPL_V belongs to the IGS – Student System product family, a legacy Oracle E-Business Suite module that is documented as obsolete in ETRM. It presents the records held in the IGS_PE_NONIMG_EMPL base entity, which stores employment details captured against non-image forms in the student system. In the context of Oracle EBS 12.1.1 and 12.2.2, this view functions strictly as a reporting and integration surface: it flattens the employment header information, joins descriptive lookup meanings, and resolves the party identifier to a human-readable party name. Because the module is obsolete, the view carries no implementation in a current database, and the ETRM record lists no referenced base objects outside the view text itself. Consequently, the view is encountered primarily in historical data models, migration extracts, and legacy report definitions where the column EMPL_PARTY_ID is the principal search key.

Underlying Base Objects

Per the documented view text, the definition draws on four objects:

• IGS_PE_NONIMG_EMPL — the primary driving table, aliased PV, supplying all employment attributes including the foreign key EMPL_PARTY_ID.
• IGS_LOOKUP_VALUES — referenced twice, as L1 for lookup type PE_SV_EMPL_TYPE and as L2 for lookup type PE_SV_EMPL_TIME, translating coded values into meanings.
• HZ_PARTIES — aliased EP, joined on PV.EMPL_PARTY_ID = EP.PARTY_ID (+) to return the employer's party name.

The joins are non-enforcing for the lookup time and party tables (outer joins marked with (+)), while the employment type lookup is enforced. No further base objects are documented for this view.

Key Columns

• ROW_ID — the row identifier derived from PV.ROWID; useful for de-duplication in extracts.
• NONIMG_EMPL_ID / NONIMG_FORM_ID — primary key of the employment record and its parent non-image form.
• EMPL_PARTY_ID — the party identifier of the employer, the column most frequently searched when tracing employment records back to HZ_PARTIES.
• EMPL_PARTY_NAME — the resolved PARTY_NAME from HZ_PARTIES; NULL when the party join fails.
• EMPL_TYPE / EMPL_TYPE_DESC — coded employment type and its PE_SV_EMPL_TYPE meaning.
• EMPL_TIME / EMPL_TIME_DESC — coded time commitment and its PE_SV_EMPL_TIME meaning.
• RECOMMEND_EMPL, RESCIND_EMPL, REMARKS, COURSE_RELEVANCE — assessment and narrative attributes.
• EMPL_START_DATE / EMPL_END_DATE — validity window of the employment.
• ACTION_CODE and the standard who/audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical uses include employer verification reports, migration scripts mapping legacy student employment records to HZ_PARTIES, and ad-hoc reconciliation of lookup values. The following query retrieves all employment rows for a given employer party:

SELECT v.nonimg_empl_id,
       v.empl_party_id,
       v.empl_party_name,
       v.empl_type_desc,
       v.empl_time_desc,
       v.empl_start_date,
       v.empl_end_date,
       v.action_code
  FROM igs_pe_nonimg_empl_v v
 WHERE v.empl_party_id = :p_party_id
 ORDER BY v.empl_start_date DESC;

To list records whose employer could not be resolved — a common symptom of orphaned legacy data — query where EMPL_PARTY_NAME IS NULL while EMPL_PARTY_ID IS NOT NULL. Because the module is obsolete and unimplemented, validation should always confirm the view exists in the target instance before executing such queries.