Results for “per_emp_number”

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

Overview

PA_R_PROJECT_RESOURCES_TERM_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, denormalized picture of project resources — specifically employees — by joining assignment, person, organization, job, and transaction attribute data. A defining characteristic of this view is that it surfaces actual termination dates through the TERMINATION_DATE column, which is aliased from ACTUAL_TERMINATION_DATE in the underlying HR periods-of-service and periods-of-placement tables.

The view is intended to support reporting and integration scenarios where resource availability, assignment spans, and end-of-employment information must be evaluated together. Because it merges human-resources data with project resource transaction attributes, it acts as a bridge between Oracle HRMS and Oracle Projects, allowing reports to identify whether a person is still an active resource, is scheduled to end an assignment, or has already been terminated.

Underlying Base Objects

The view is defined over thirteen documented base objects, all exposed to APPS through synonyms, plus one package:

• PER_ALL_ASSIGNMENTS_F — the primary driver, supplying assignment dates, organization, supervisor, job, and location.
• PER_ALL_PEOPLE_F — person-level attributes (name, employee number, email, phone, effective dates).
• PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT — unioned in an inline subquery to derive ACTUAL_TERMINATION_DATE, filtered to non-null rows.
• HR_ORGANIZATION_INFORMATION — joined twice (aliased ORG_INFO and ORG_INFO_C) to resolve the default operating unit and calendar ID.
• PER_PERSON_TYPES, PER_PERSON_TYPE_USAGES_F, PER_ASSIGNMENT_STATUS_TYPES — person typing and assignment status classification.
• PER_JOBS, PER_JOB_EXTRA_INFO — job name and job group details.
• PA_ALL_ORGANIZATIONS, PA_RESOURCE_TXN_ATTRIBUTES — project organization context and resource transaction existence flag.
• PA_EXPENDITURES_UTILS — a PL/SQL package invoked via GETORGTLNAME to resolve the organization (business group) name.

Key Columns

• TERMINATION_DATE — sourced from PO.ACTUAL_TERMINATION_DATE; returns the actual termination date from periods of service or placement. This is the column most relevant to searches for "actual_termination_date."
• ASSIGNMENT_START_DATE / ASSIGNMENT_END_DATE — effective span of the assignment record.
• START_DATE — set to SYSDATE at query time.
• NAME, PER_FIRST_NAME, PER_LAST_NAME, PER_MIDDLE_NAME — person naming attributes.
• PER_EMP_NUMBER — employee number or NPW number depending on current-employee flag.
• DEFAULT_OU, CALENDAR_ID, ORG_NAME — organizational and calendar context.
• JOB_NAME, JOB_GROUP_ID — job classification.
• RES_EXISTS — flag ('EXISTS' or 'NOT EXISTS') indicating whether a resource transaction attribute record exists.
• P_TYPE, USER_TYPE — system and user person types.
• RESOURCE_TYPE — hard-coded as 'EMPLOYEE'.

Common Use Cases and Queries

Typical usage includes resource roster reporting, termination-driven availability checks, and integration feeds into scheduling or costing processes. A common requirement is to list active employees along with their termination status.

SELECT person_id,
       name,
       assignment_end_date,
       termination_date
FROM   apps.pa_r_project_resources_term_v
WHERE  termination_date IS NULL
   OR  termination_date > SYSDATE;

To identify resources terminated within a given period:

SELECT person_id,
       name,
       per_emp_number,
       termination_date
FROM   apps.pa_r_project_resources_term_v
WHERE  termination_date BETWEEN :from_date AND :to_date;

Because the view already resolves person, job, and organization names, it reduces the need to rejoin HRMS tables in downstream reports, making it convenient for both operational dashboards and data-extraction interfaces.