Search Results psp_payroll_source_types_v




Overview
Explore in AI Chat

Overview

PSP_PAYROLL_SOURCE_TYPES_V is a read-only database view owned by the APPS schema within Oracle E-Business Suite. It belongs to the PSP product family, which is the Labor Distribution module used primarily by public sector, government, and project-driven organizations to allocate labor costs across projects, grants, and cost centers. The view presents a simple, denormalized lookup of payroll source types together with their descriptive meanings. Specifically, it exposes the set of payroll source codes that qualify as valid source types, joined to the human-readable description maintained in the lookups table.

The view plays a supporting role in reporting and integration rather than transactional processing. It serves as a reference list that forms, concurrent programs, and custom reports use to populate choice lists or translate stored source type codes into meaningful labels. Because it is a view rather than a base table, it carries no data of its own; it derives its content entirely from the payroll sources and lookups data already present in the instance. Its status is documented as VALID in ETRM, confirming that it compiles cleanly in the supported 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The documented definition of the view draws from two underlying objects: PSP_PAYROLL_SOURCES and PSP_LOOKUPS. Per the ETRM metadata, PSP_PAYROLL_SOURCES is exposed to the view through a synonym, while PSP_LOOKUPS is a view in its own right. The join logic is as follows:

  • The view selects from PSP_PAYROLL_SOURCES (aliased A) and PSP_LOOKUPS (aliased B).
  • The join is constrained so that LOOKUP_TYPE equals 'PSP_SOURCE_TYPE' and LOOKUP_CODE equals A.SOURCE_TYPE.
  • The result is further restricted to lookup codes in the set ('N', 'P'), limiting the output to the qualifying payroll source type codes.
  • A DISTINCT clause eliminates duplicate rows, ensuring each source type appears once.

PSP_PAYROLL_SOURCES stores the payroll source definitions used by Labor Distribution, while PSP_LOOKUPS is the standard Oracle lookups view that maps lookup codes to their meanings. The view therefore acts as a filtered intersection of these two objects.

Key Columns

The view exposes two documented columns, which together provide the code and its label:

  • SOURCE_TYPE — The payroll source type code, sourced from A.SOURCE_TYPE in PSP_PAYROLL_SOURCES. It is the key value used to identify a payroll source category and is constrained to the codes 'N' and 'P'.
  • DESCRIPTION — The descriptive meaning of the source type, sourced from B.MEANING in PSP_LOOKUPS. Although the view text aliases the column as MEANING, the documented output column name is DESCRIPTION, which supplies the readable text associated with each source type.

No additional columns are documented for this view in ETRM, so consumers should treat SOURCE_TYPE as the join key and DESCRIPTION as its label.

Common Use Cases and Queries

The view is most often used to resolve payroll source type codes into labels for reporting, to validate reference data during integration loads, and to populate list-of-values or parameter prompts in concurrent programs and OAF pages. A representative query retrieves the full reference list:

  • SELECT source_type, description
      FROM apps.psp_payroll_source_types_v
     ORDER BY source_type;
  • To resolve a specific code: SELECT description FROM apps.psp_payroll_source_types_v WHERE source_type = 'P';
  • To drive a lookup prompt: SELECT source_type, description FROM apps.psp_payroll_source_types_v WHERE source_type IN ('N','P');

Because the view is lightweight and DISTINCT-filtered, it is safe to reference in reporting queries and inline views. When troubleshooting unexpected results, verify that the required lookup codes exist in PSP_LOOKUPS under LOOKUP_TYPE 'PSP_SOURCE_TYPE', since missing or disabled lookup entries will cause rows to be excluded from the view output.