Search Results psp_source_type

Overview

APPS.PSP_PAYROLL_SOURCE_TYPES_V is a reporting view in the Oracle EBS Payroll and PSP (Payroll Service Provider / third-party payroll) product family. It presents the subset of payroll source types that are flagged as relevant to source-type processing — specifically those with lookup codes 'N' and 'P' in the PSP_SOURCE_TYPE lookup — joined to their user-facing meaning. The view exposes only two columns, SOURCE_TYPE and MEANING, giving a concise, denormalized list suitable for LOVs, reports, and integration payloads.

Its role in reporting and integration is to serve as a lookup/reference source rather than a transactional entity. Downstream logic, concurrent programs, and interfaces that must validate or translate a payroll source code into a display label can query this view directly, avoiding repeated joins against PSP_LOOKUPS and PSP_PAYROLL_SOURCES. Because it filters to a small, curated set of source types, it is typically consumed in dropdown-driven UI and in data extracts where a human-readable meaning is required.

Underlying Base Objects

The view is defined over two documented referenced objects: PSP_LOOKUPS (a VIEW) and PSP_PAYROLL_SOURCES (a SYNONYM). The join is performed on lookup code: LOOKUP_CODE = A.SOURCE_TYPE, with a fixed predicate restricting LOOKUP_TYPE to 'PSP_SOURCE_TYPE' and LOOKUP_CODE IN ('N','P'). The DISTINCT keyword collapses duplicate source-type rows that may arise from multiple payroll sources sharing the same source type.

• PSP_PAYROLL_SOURCES — supplies the SOURCE_TYPE values that actually exist in the payroll sources setup. It is documented as a SYNONYM in the APPS schema.
• PSP_LOOKUPS — supplies the MEANING (display label) for each source type via the PSP_SOURCE_TYPE lookup type. It is documented as a VIEW.

The view therefore depends on both the payroll source configuration and the PSP lookup definitions; changes to either are reflected immediately, and no additional filtering or transformation occurs beyond the documented WHERE clause.

Key Columns

• SOURCE_TYPE — the lookup code identifying the payroll source type (drawn from PSP_PAYROLL_SOURCES, restricted to 'N' and 'P').
• MEANING — the descriptive, user-facing text for the source type, resolved from PSP_LOOKUPS on the PSP_SOURCE_TYPE lookup type.

Both columns are character/string values. The DISTINCT clause guarantees that each SOURCE_TYPE/MEANING pair appears at most once, making the view suitable for direct use in list-of-values and reference joins without further deduplication.

Common Use Cases and Queries

Typical use cases include populating source-type selection lists in PSP configuration screens, driving validation of imported payroll source types, and producing reference extracts for downstream reporting. A simple query to retrieve all available source types is:

• SELECT SOURCE_TYPE, MEANING FROM APPS.PSP_PAYROLL_SOURCE_TYPES_V ORDER BY SOURCE_TYPE;

To validate a specific code or retrieve its label during an interface run:

• SELECT MEANING FROM APPS.PSP_PAYROLL_SOURCE_TYPES_V WHERE SOURCE_TYPE = :p_source_type;

For reporting joins, the view can be outer-joined to transactional tables that store a source type, substituting the MEANING column for the raw code. Because the view filters only to lookup codes 'N' and 'P', any source type outside this set will not appear; consumers should account for that when using it as a validation source. All access is read-only, and the view carries no DML capability.