Results for “employment_end_date”

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

Overview

IGS_SV_CPT_CNCL_EMPL_BLK_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGS (Student System) product family. Its documented purpose is to fetch cancelled Curricular Practical Training (CPT) employment records for use in student immigration and employment processing. Within the broader Oracle Student System, CPT records track off-campus employment authorized for eligible international students, and this view isolates the subset of records that have been cancelled. The view therefore functions as a targeted reporting and integration object rather than a transactional entity: it presents a pre-filtered result set that downstream processes, concurrent programs, forms, and reports can consume without embedding the underlying selection logic. It is marked VALID in the data dictionary and is available in both EBS 12.1.1 and 12.2.2 environments, with the ETRM documentation for 12.2.2 recording no additional referenced base objects beyond those in the view definition itself.

Underlying Base Objects

The view is defined over a single base table, IGS_SV_EMPL_INFO, which stores employment information records in the Student System. The ETRM metadata lists no other referenced base objects. The defining query selects from this table with two hard-coded filter predicates: EMPL_REC_TYPE = 'C' and ACTION_CODE = 'C'. In the IGS employment model, EMPL_REC_TYPE distinguishes the category of employment record, while ACTION_CODE captures the lifecycle action applied to that record, with 'C' denoting cancellation. The conjunction of these predicates produces the view's characteristic behavior: only employment rows that were cancelled are surfaced. No joins, outer-joins, unions, or aggregation are present, so the view is a straightforward restrictive projection of IGS_SV_EMPL_INFO. Because the view performs no aggregation and applies constant predicates, it is fully updatable in principle with respect to its underlying table, though it is conventionally treated as a query object.

Key Columns

The view exposes seven columns, several of which are aliased to more descriptive names:

• BATCH_ID — Identifier of the batch to which the employment record belongs, used for grouping records processed together.
• PERSON_ID — The unique identifier of the person (student) associated with the employment record; the principal link to person and student records.
• PRINT_FORM — Flag or indicator controlling whether a form should be printed for the record.
• EMPLOYMENT_START_DATE — Aliased from EMPL_START_DATE; the start date of the employment period.
• EMPLOYMENT_END_DATE — Aliased from EMPL_END_DATE; the end date of the employment period.
• EMPLOYMENT — Aliased from EMPL_TIME; information describing the employment, such as the time or effort commitment.
• EMPLOYER_NAME — Aliased from EMPL_NAME; the name of the employer. This is the column most frequently targeted by users searching this view.

The aliasing from the underlying EMPL_* columns to business-friendly names is significant for reporting, since it allows queries and reports to reference meaningful labels without knowledge of the base table's column naming.

Common Use Cases and Queries

Typical use cases include auditing cancelled CPT employment records, reconciling employer data for cancelled authorizations, verifying batch and print-form status for cancelled records, and driving concurrent or integration programs that must process only cancelled rows. The view is particularly useful when an administrator needs to identify the employer associated with a cancelled CPT record, which is the object of the common "employer_name" lookup.

A minimal query retrieving cancelled employment records with employer details:

SELECT person_id, employer_name, employment_start_date, employment_end_date FROM apps.igs_sv_cpt_cncl_empl_blk_v;

A query filtering by a specific person:

SELECT batch_id, employer_name FROM apps.igs_sv_cpt_cncl_empl_blk_v WHERE person_id = :p_person_id;

A query scoped to a batch to inspect cancellation records prepared for printing:

SELECT person_id, employer_name, print_form FROM apps.igs_sv_cpt_cncl_empl_blk_v WHERE batch_id = :p_batch_id;

Because the cancellation predicates are built into the view, callers need not supply them, ensuring consistent retrieval of cancelled CPT employment across all consumers.