Search Results term_assign




Overview
Explore in AI Chat

Overview

APPS.GHR_SF113_V is a reporting view in the Oracle E-Business Suite Human Resources (HR) module, owned by the APPS schema. It presents a filtered, denormalized snapshot of primary employee assignments together with their system status, grade, position, and location attributes. The view is part of the GHR (Global HR) family of views commonly consumed by Oracle HRMS self-service, discoverer workbooks, and downstream interfaces. Its primary role is to expose a concise roster of persons whose primary assignment holds either an active or terminated system status, while excluding certain assignment types and grade classifications. In the context of a search for term_assign, this view is relevant because it explicitly surfaces the PER_SYSTEM_STATUS value of TERM_ASSIGN and maps it to a numeric status flag, enabling reporting on terminated assignments alongside active ones. ETRM documents the object for both 12.1.1 and 12.2.2, and the definition is consistent across those releases.

Underlying Base Objects

The view is defined over a join of five business objects, all referenced through the APPS schema:

  • PER_ASSIGNMENTS_F (view) — the effective-dated assignment fact source, supplying assignment identifiers, dates, position, grade, location, primary flag, and assignment type.
  • PER_ASSIGNMENT_STATUS_TYPES (synonym) — supplies the PER_SYSTEM_STATUS classification used to filter and decode assignment status.
  • PER_PEOPLE_F (view) — provides person identity and effective dating for the person record.
  • PER_GRADES (synonym) — links the assignment grade to its grade definition.
  • PER_GRADE_DEFINITIONS (synonym) — supplies SEGMENT1, which is used to exclude grades whose first two characters are CC, NA, NL, or NS.

ETRM also lists HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY as referenced package objects, indicating that security and name-formatting logic may be applied when the view is consumed through HRMS security profiles. The joins are keyed on ASSIGNMENT_STATUS_TYPE_ID, GRADE_ID, GRADE_DEFINITION_ID, and PERSON_ID.

Key Columns

  • PERSON_ID — unique identifier of the person, joined from PER_PEOPLE_F.
  • STATUS — a DECODE of the assignment system status: ACTIVE_ASSIGN yields 1, TERM_ASSIGN yields 2, and all other values yield 0.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the effective date range of the assignment record.
  • ASSIGNMENT_ID — the assignment identifier for the primary assignment.
  • POSITION_ID, GRADE_ID, LOCATION_ID — foreign keys to the position, grade, and location of the assignment.

The SELECT DISTINCT clause eliminates duplicate person rows arising from the join.

Common Use Cases and Queries

Typical usage includes extracting active versus terminated headcount, feeding HR interfaces, and supporting audits of assignment status. A representative query filtering on the term_assign status is:

  • SELECT person_id, status, effective_start_date, effective_end_date, assignment_id FROM apps.ghr_sf113_v WHERE status = 2; — returns persons whose primary assignment is TERM_ASSIGN.
  • SELECT person_id, assignment_id, grade_id, location_id FROM apps.ghr_sf113_v WHERE status = 1; — returns active primary assignments.
  • SELECT status, COUNT(*) FROM apps.ghr_sf113_v GROUP BY status; — summarizes the active/terminated population.

Because the view already excludes non-primary assignments (PRIMARY_FLAG = 'Y'), business group assignments (ASSIGNMENT_TYPE 'B'), and the specified grade segments, consumers can rely on it for consistent, security-aware HR reporting without reapplying those filters.