Search Results ghr_mt_interface_v




Overview
Explore in AI Chat

Overview

GHR_MT_INTERFACE_V is a VALID database view owned by the APPS schema within the GHR — US Federal Human Resources product family in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to support mass transfer processing, both inbound and outbound, by staging the person and assignment data required for the data transfer step. The view serves as the consolidated interface presentation layer through which the mass transfer concurrent programs read and write records, converting the string-based staging columns into typed values (numbers and dates) and truncating character fields to their target lengths.

Functionally, the view projects records drawn from the mass transfer interface staging tables after those records have been joined to the person, assignment, element entry, position, and miscellaneous data views. Because it exposes both the coded values and their corresponding meaning/description columns (for example CITIZENSHIP and CITIZENSHIP_DESC), it is suitable for both programmatic processing and human-readable verification of a mass transfer run. The GHR product labeling indicates the view is relevant primarily to US Federal implementations, where the mass transfer action is used to move employees between agencies, bargaining units, or position structures without breaking service computation history.

Underlying Base Objects

The view text defines GHR_MT_INTERFACE_V over a set of mass transfer source views rather than directly over base tables. The documented referenced objects are:

Notably, the view performs its own type conversion on the way out: MT_PERSON_ID is cast with TO_NUMBER, and DATE_OF_BIRTH, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and START_DATE are cast with TO_DATE using the 'DD/MMM/YYYYY' format mask, implying that the underlying staging columns are stored as character strings. Character columns are wrapped in SUBSTR with explicit limits — for example FIRST_NAME and LAST_NAME to 150, FULL_NAME to 240, MIDDLE_NAMES to 60, and MARITAL_STATUS, SEX, NATIONALITY, and NATIONAL_IDENTIFIER to 30 — which enforces the destination column widths during the transfer.

Key Columns

Common Use Cases and Queries

The view is typically queried to validate a mass transfer batch before or after the concurrent process executes, and to reconcile staged records against the resulting person and assignment rows.

Reviewing outstanding records for a transfer run:

  • SELECT MT_NAME, MT_PERSON_ID, MT_STATUS, MT_PROCESS_DATE FROM GHR_MT_INTERFACE_V WHERE MT_STATUS = 'PENDING';

Producing a readable roster of transfer participants with their federal attributes:

  • SELECT FULL_NAME, CITIZENSHIP_DESC, VETERANS_PREFERENCE_DESC, FERS_COVERAGE_DESC, APPOINTMENT_TYPE, AGENCY_CODE_TRANSFER_FROM FROM GHR_MT_INTERFACE_V WHERE MT_NAME = :batch_name;

Confirming date conversion for a specific employee:

  • SELECT MT_PERSON_ID, START_DATE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE FROM GHR_MT_INTERFACE_V WHERE MT_PERSON_ID = :person_id;

Identifying inter-bargaining-group transfers in a batch:

  • SELECT MT_PERSON_ID, LAST_NAME, FIRST_NAME FROM GHR_MT_INTERFACE_V WHERE MT_INTER_BG_TRANSFER = 'Y';

Because the view applies TO_DATE and TO_NUMBER during selection, queries that filter or sort on those columns force conversion at runtime; restricting rows by MT_NAME or MT_STATUS first generally yields better performance. All access should be performed under a responsibility authorized for GHR mass transfer functions.