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
Pay Period	Choose the Pay Period (1-12 referring to the month) Used in Monthly version of report only.
Quarter	Choose the Quarter (First, Second, Third or Fourth) Used in Quarterly version of report only.

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
PHRDEDN_YEAR	`PHRDEDN.PHRDEDN_YEAR`	The year the pay was earned
PHRDEDN_PAYNO	`PHRDEDN.PHRDEDN_PAYNO`	the month (numerically) the pay was earned within that year.
FEDERAL	`PHRDEDN.PHRDEDN_EMPLOYEE_AMT`	PHRDEDN_EMPLOYEE_AMT Where BDCA code = 800 and
FICA_ER	`PHRDEDN.PHRDEDN_EMPLOYER_AMT`	PHRDEDN_EMPLOYER_AMT Where BDCA code = 802
FICA_EE	`PHRDEDN.PHRDEDN_EMPLOYEE_AMT`	PHRDEDN_EMPLOYEE_AMT Where BDCA code = 802
FICA_MEDI_ER	`PHRDEDN.PHRDEDN_EMPLOYER_AMT`	PHRDEDN_EMPLOYER_AMT Where BDCA code = 803
FICA_MEDI_EE	`PHRDEDN.PHRDEDN_EMPLOYEE_AMT`	PHRDEDN_EMPLOYEE_AMT Where BDCA code = 803
STATE	`PHRDEDN.PHRDEDN_EMPLOYEE_AMT`	PHRDEDN_EMPLOYEE_AMT Where BDCA code = 801
FICA_MEDI_Addl_EE	`PHRDEDN.PHRDEDN_EMPLOYEE_AMT`	PHRDEDN_EMPLOYEE_AMT Where BDCA code = 806

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