Results for “quarter_start_date”

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

Overview

PAY_SRS_QUARTER_PERIODS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PAY (Payroll) product. It presents a consolidated, business-group-level listing of calendar quarters derived from the payroll time periods defined in the application. Because payroll statutory reporting in the United States is frequently organized by quarter — most notably quarterly tax filings such as Form 941 — the view provides a standardized quarter dimension that downstream reports can join to without recalculating quarter boundaries from PER_TIME_PERIODS.

The view is commonly associated with the Standard Reporting System (SRS) and Statement of Earnings style reporting used in Oracle Payroll. Its status is documented as VALID in the ETRM metadata for 12.2.2. It exposes a quarter name in the human-readable form "QUARTER n YYYY" — for example, "QUARTER 1 2013" — which is the element a user typically searches for when locating a quarter identifier such as quarter_name.

Underlying Base Objects

The documented base objects referenced by this view are:

• PER_TIME_PERIODS (SYNONYM) — the source of payroll period start and end dates from which quarter start and end dates are derived.
• PAY_PAYROLLS_F (VIEW) — supplies the payroll definition and the BUSINESS_GROUP_ID used to group quarters by business group.
• HR_GENERAL (PACKAGE) — supporting date and utility logic used within Payroll-secured objects.
• HR_SECURITY (PACKAGE) — enforces business-group and security-profile filtering typical of HRMS-secured views.

The view text joins PER_TIME_PERIODS to PAY_PAYROLLS_F on PAYROLL_ID. Quarter start dates are computed using TRUNC(START_DATE, 'Q'), and quarter end dates are derived by adding three months to the quarter start and subtracting one day. A UNION ALL branch produces an additional row set specifically for the state of New York (PAY_US_STATES filtering on STATE_ABBREV = 'NY'), supporting New York quarterly reporting requirements, where the fourth quarter start date is normalized to the beginning of the year via a DECODE expression.

Key Columns

• BUSINESS_GROUP_ID — the business group that owns the payroll and time periods; the principal grouping and security key.
• QUARTER_START_DATE — the first day of the calendar quarter, computed with TRUNC(date, 'Q').
• QUARTER_END_DATE — the last day of the quarter, calculated as the quarter start plus three months minus one day.
• QUARTER_NAME — the display label in the form "QUARTER Q YYYY" (for example, "QUARTER 2 2013"), built from the quarter number and four-digit year.
• QUARTER_START_DATE_NYQ4 — a New York-specific quarter start date; for quarter 4 this resolves to the start of the year, otherwise it equals the quarter start date.
• QUARTER_STATE_FLAG — a flag column populated as 'XX' for the general (non-state) rows and with the state abbreviation (for example, 'NY') for the state-specific rows produced by the UNION ALL branch.

Common Use Cases and Queries

The view is principally used as a quarter lookup dimension for payroll reporting, particularly where quarterly tax or statutory extracts must be tied to a business group's payroll calendar. A typical query selecting the quarter name is:

• SELECT business_group_id, quarter_name, quarter_start_date, quarter_end_date FROM apps.pay_srs_quarter_periods_v WHERE business_group_id = :p_bg_id ORDER BY quarter_start_date;
• SELECT quarter_name, quarter_state_flag FROM apps.pay_srs_quarter_periods_v WHERE quarter_state_flag = 'NY';

Because the view aggregates on TRUNC(START_DATE, 'Q'), filters against a date range should be applied to QUARTER_START_DATE and QUARTER_END_DATE rather than to the underlying period tables. Access is subject to the HR security packages, so effective business-group and security-profile context must be initialized before querying in a reporting or concurrent-program context.