Results for “psp_enc_payroll_assignment_v”

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

Overview

PSP_ENC_PAYROLL_ASSIGNMENT_V is a VALID APPS-owned view in the Oracle E-Business Suite Labor Distribution (PSP) module. It presents the setup data used when configuring payroll assignments for labor encumbrances, exposing the relationship between employees, their assignments, and the encumbrance payroll definitions to which those assignments are linked. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a reporting and integration layer over the underlying encumbrance payroll assignment configuration tables. Rather than querying the base transaction tables directly, reports, concurrent programs, and integrations can consume this view to determine which payroll assignments participate in encumbrance processing, along with their inclusion or exclusion flags.

Underlying Base Objects

The view is defined as a UNION of two SELECT statements. The first branch joins PSP_ENC_PAYROLL_ASSIGNMENTS to PER_PEOPLE_F, PER_ASSIGNMENTS_F, PSP_ENC_PAYROLLS, and PER_ASSIGNMENT_STATUS_TYPES, returning assignments already explicitly configured against an encumbrance payroll. The second branch returns payroll assignments that are not yet configured, driving them from PER_ASSIGNMENTS_F and PAY_PAYROLLS_F with an outer join to PSP_ENC_PAYROLLS.

The documented base objects include the following:

• PER_PEOPLE_F (VIEW) and its synonym PER_ALL_PEOPLE_F — the effective-dated person records supplying FULL_NAME.
• PER_ASSIGNMENTS_F (VIEW) and synonym PER_ALL_ASSIGNMENTS_F — the effective-dated assignment records supplying ASSIGNMENT_ID, ASSIGNMENT_NUMBER, and PAYROLL_ID.
• PER_ASSIGNMENT_STATUS_TYPES (SYNONYM) — used to restrict results to active assignments via PER_SYSTEM_STATUS = 'ACTIVE_ASSIGN'.
• PSP_ENC_PAYROLL_ASSIGNMENTS (SYNONYM) — the configuration table holding assignment-to-encumbrance-payroll mappings.
• PSP_ENC_PAYROLLS (SYNONYM) — the encumbrance payroll definitions.
• PAY_PAYROLLS_F (VIEW) — the standard payroll definitions used in the second UNION branch.
• HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (PACKAGES) — supporting date-tracked and security utilities.

Key Columns

The view exposes the following principal columns:

• ASSIGNMENT_ID — the unique identifier of the assignment.
• ASSIGNMENT_NUMBER — the human-readable assignment number from PER_ASSIGNMENTS_F.
• ENC_PAYROLL_ID — the encumbrance payroll the assignment relates to.
• ENC_PAYROLL_ASSIGNMENT_ID — the surrogate key on PSP_ENC_PAYROLL_ASSIGNMENTS (0 for the unconfigured branch).
• BUSINESS_GROUP_ID and SET_OF_BOOKS_ID — the HR business group and ledger context for the encumbrance.
• INCLUDE / EXCLUDE — derived flags from the INC_EXC_FLAG on PSP_ENC_PAYROLLS, indicating whether the assignment is included in or excluded from the encumbrance.
• FULL_NAME — the employee name from PER_PEOPLE_F.
• PAYROLL_ID — the payroll linked to the assignment or encumbrance payroll.

Common Use Cases and Queries

This view is typically used to report which assignments are set up for labor encumbrances, to reconcile configured versus unconfigured assignments, and to feed encumbrance processing. Because the user searched for per_people_f, a common requirement is joining the assignment configuration to the person record to display employee names alongside encumbrance payroll details.

• Identify all active assignments included in a given encumbrance payroll.
• List assignments that are not yet configured against any encumbrance payroll.
• Produce employee-level encumbrance assignment listings using FULL_NAME.

A representative query is:

SELECT assignment_id, assignment_number, full_name, enc_payroll_id, include, exclude FROM apps.psp_enc_payroll_assignment_v WHERE business_group_id = :bg_id AND include = 'Y' ORDER BY full_name;

Because the view already applies effective-date logic against SYSDATE and restricts to active assignments, it returns the currently valid assignment population, making it suitable for encumbrance reconciliation and setup validation reporting.