Results for “prd_information1”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PER_ZA_TIME_PERIODS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PER (Human Resources) product family. Its documented purpose is to support the "Tax Year Value Set" used for South African (ZA) payroll and statutory reporting. The view exposes a consolidated set of payroll time periods together with a derived statutory period identifier stored in the PRD_INFORMATION1 column, which is the attribute referenced in the source search term "prd_information1".
Rather than storing data of its own, the view presents a read-only projection built entirely from the PER_TIME_PERIODS table. Its role in EBS reporting and integration is to supply a clean, consistently labelled list of time periods that downstream value sets, concurrent programs, and statutory extracts can consume when validating or selecting an appropriate tax year period for ZA legislative reporting.
Underlying Base Objects
The ETRM metadata documents a single referenced base object: PER_TIME_PERIODS, exposed in the view definition as a synonym. Internally the view aliases this table twice as P1 and P2. The view text joins PER_TIME_PERIODS to itself on PAYROLL_ID, matching adjacent periods where P1.END_DATE equals P2.START_DATE minus one day, and the reciprocal case where P2.START_DATE equals P1.END_DATE plus one day.
These self-joins propagate the PRD_INFORMATION1 value across consecutive periods within the same payroll. Additional UNION branches handle the boundary cases: the earliest and latest periods for each payroll are identified through MIN and MAX subqueries on START_DATE, and PRD_INFORMATION1 is adjusted by minus one or plus one respectively to extend the statutory numbering to the leading and trailing edges of the payroll calendar.
Key Columns
- PAYROLL_ID — Identifies the payroll to which the time period belongs; the primary grouping key for the self-joins and boundary logic.
- START_DATE — The first day of the time period.
- END_DATE — The last day of the time period.
- PRD_INFORMATION1 — The descriptive flexfield attribute carried on PER_TIME_PERIODS that holds the statutory or tax-year period reference; the view returns and arithmetically extends this value for boundary periods.
Because PRD_INFORMATION1 is manipulated with TO_NUMBER and TO_CHAR arithmetic in the boundary branches, the column behaves as a numeric statutory period sequence for reconciliation purposes.
Common Use Cases and Queries
The view is typically consumed by value sets, validation logic, and ZA statutory reports that must resolve a payroll and date range to the correct tax year period label. A representative query selecting all periods for a given payroll follows:
SELECT payroll_id, start_date, end_date, prd_information1 FROM apps.per_za_time_periods_v WHERE payroll_id = :payroll_id ORDER BY start_date;SELECT prd_information1 FROM apps.per_za_time_periods_v WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date AND payroll_id = :payroll_id;
Analysts also use the view to confirm that the derived PRD_INFORMATION1 sequence is contiguous across period boundaries, since the self-join and MIN/MAX UNION branches are specifically designed to eliminate gaps at the start and end of a payroll's calendar.
-
View: PER_ZA_TIME_PERIODS_V 12.1.1
Used in Tax Year Value Set
APPS.PER_ZA_TIME_PERIODS_V·↳ PER_TIME_PERIODS·Explore PER module →
-
View: PER_ZA_TIME_PERIODS_V 12.2.2
Used in Tax Year Value Set
APPS.PER_ZA_TIME_PERIODS_V·↳ PER_TIME_PERIODS·Explore PER module →
-
Time period definitions for payroll processing and HR budget calendars.
-
Time period definitions for payroll processing and HR budget calendars.
-
View: PER_TIME_PERIODS_V 12.1.1
Used to support user interface
APPS.PER_TIME_PERIODS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PER module →
-
View: PER_TIME_PERIODS_V 12.2.2
Used to support user interface
APPS.PER_TIME_PERIODS_V·↳ HR_API·↳ HR_LOOKUPS·↳ PER_TIME_PERIODS·Explore PER module →
-
APPS.PYZAEXC SQL Statements 12.1.1
-
PACKAGE: APPS.PYZAEXC 12.1.1
-
VIEW: HR.PER_TIME_PERIODS# 12.2.2
-
PACKAGE BODY: APPS.PYZAEXC 12.2.2
-
PACKAGE: APPS.PYZAEXC 12.2.2
-
APPS.PYZAEXC SQL Statements 12.2.2
-
PACKAGE BODY: APPS.PYZAEXC 12.1.1
-
VIEW: HR.PER_TIME_PERIODS# 12.2.2
-
VIEW: APPS.HRBV_TIME_PERIOD 12.1.1
-
VIEW: APPS.HRBV_TIME_PERIOD 12.2.2
-
PACKAGE: APPS.PY_ZA_TAX_REG 12.2.2
-
VIEW: APPS.HRBV_TIME_PERIOD 12.1.1
-
VIEW: APPS.HRBV_TIME_PERIOD 12.2.2