Search Results default_code_comb_id

Overview

GHR_MT_ASSIGNMENTS_F_V is an APPS-owned database view within the GHR — US Federal Human Resources product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to support the Mass Transfer in and out processes, which move assignment and person data between business groups and organizations during federal HR reorganizations, transfers, and conversions. The view does not store data itself; it presents a denormalized, position-based projection of the staging records held in the GHR mass-transfer interface so that the transfer programs and concurrent processes can read assignment attributes in a structured column layout.

Because the definition maps generic INFORMATION1 through INFORMATION51 slots to meaningful HR column names, the view acts as a decoding layer between the raw interface table and the business attributes consumed by the mass transfer logic. Status is VALID in both the 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The documented base object referenced by this view is GHR_INTERFACE, accessed through an APPS synonym. Each row in GHR_INTERFACE represents one pending change record for a mass transfer operation, identified by INTERFACE_ID and typed by SOURCE_NAME (aliased MT_SOURCE in the view). The view selects from this table, renames the positional INFORMATION columns to descriptive aliases, and filters the rows appropriate to assignment-level transfers through the mass transfer process logic.

Related assignments and person data referenced by the aliased columns (ASSIGNMENT_ID, PERSON_ID, BUSINESS_GROUP_ID, POSITION_ID, JOB_ID, and similar) ultimately resolve to the standard HR base tables — PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, and PER_JOBS / PER_POSITIONS — but the view text itself is defined solely over the GHR_INTERFACE staging object.

Key Columns

• GHR_INTERFACE_ID, MT_PROCESS_DATE, MT_SOURCE: identity of the interface row, the date the record was processed, and the source that supplied it.
• MT_EFFECTIVE_DATE, MT_NAME, MT_STATUS, MT_PERSON_ID: core transfer control attributes used to sequence and validate processing.
• MT_TABLE_NAME, MT_INFORMATION_TYPE, MT_INTER_BG_TRANSFER: indicate the target entity, the type of information carried, and whether the transfer crosses business groups.
• ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE: the assignment being created or modified and the date range of the change.
• BUSINESS_GROUP_ID, ORGANIZATION_ID, PEOPLE_GROUP_ID, SUPERVISOR_ID, POSITION_ID, JOB_ID, GRADE_ID, LOCATION_ID, PAYROLL_ID: the organizational and assignment determinants applied by the transfer.
• ASSIGNMENT_NUMBER, ASSIGNMENT_SEQUENCE, ASSIGNMENT_TYPE, PRIMARY_FLAG, ASSIGNMENT_STATUS_TYPE_ID: assignment-level identity and status attributes.
• PROBATION_PERIOD (INFORMATION46) and PROBATION_UNIT (INFORMATION47): the probation length and its unit of measure (for example days, weeks, or months), paired with DATE_PROBATION_END (INFORMATION36), which holds the computed probation end date. These are the columns most relevant to the search term "probation_unit."
• PROBATION-related and review columns: PERF_REVIEW_PERIOD, PERF_REVIEW_PERIOD_FREQUENCY, SAL_REVIEW_PERIOD, SAL_REVIEW_PERIOD_FREQUENCY, and NORMAL_HOURS define the assignment terms applied during transfer.

Common Use Cases and Queries

Typical usage is troubleshooting or auditing mass transfer staging records before the transfer process is run, and verifying that probation, review, and organizational attributes are populated correctly on assignment-level interface rows.

• List pending assignment transfers with their probation terms: SELECT GHR_INTERFACE_ID, MT_SOURCE, ASSIGNMENT_ID, BUSINESS_GROUP_ID, DATE_PROBATION_END, PROBATION_PERIOD, PROBATION_UNIT FROM GHR_MT_ASSIGNMENTS_F_V WHERE MT_PERSON_ID = :person_id ORDER BY MT_PROCESS_DATE.
• Identify inter-business-group transfers: SELECT GHR_INTERFACE_ID, MT_PERSON_ID, MT_INTER_BG_TRANSFER FROM GHR_MT_ASSIGNMENTS_F_V WHERE MT_INTER_BG_TRANSFER = 'Y'.
• Audit assignments missing probation data: SELECT ASSIGNMENT_ID, PROBATION_PERIOD, PROBATION_UNIT FROM GHR_MT_ASSIGNMENTS_F_V WHERE PROBATION_PERIOD IS NULL OR PROBATION_UNIT IS NULL.

Because the view is read-only over the interface, all corrective action occurs against GHR_INTERFACE rather than the view.