Data Source	Oracle
Job/Process Source (Refresh Interval)	Live Data
Functional User(s)	Mary Schaefer, Valiree Yzavel Gonzalez
Report Owner	Valiree Yzavel Gonzalez
Data Domain(s)	Payroll
Contains PII	Yes

What It’s Used For

Payroll uses this report to assist in their payroll processes and make sure the numbers are what they expect them to be.

Options

Options	Description

Options	Description
Year	Choose the year the pay happened in
Quarter	Choose the Quarter (First (Months 1-3), Second (Months 4-6), Third (Months 7-9), Fourth (Months 10-12))

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
PHRHIST_YEAR	`PHRHIST.PHRHIST_YEAR`	The year the pay was earned
QUARTER	`Form Drop Down for Quarter sent in and returned.`	The Quarter sent in from the dropdown is returned for use in the report.
PHRHIST_PAYNO	`PHRHIST.PHRHIST_PAY_NO`	The Month within the Quarter that pay was earned in.
SUMOFPHRHIST_GROSS	`PHRHIST.PHRHIST_GROSS`	the SUM of PHRHIST.PHRHIST_GROSS
SUMOFPHRHIST_NET	`PHRHIST.PHRHIST_NET`	The Sum of PHRHIST.PHRHIST_NET

This report is built off the PHRHIST table in the PAYROLL schema. It comes from Oracle PROD_DB because I am told they need live data.