Voluntary Deduction Roster/Totals
- Joshua Metry
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. There are two reports on this dashboard to replace what was two separate reports that were virtually identical, the only difference being one was just the totals from the other.
Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Pay Period | Choose the Pay Period (1-12 referring to the month) |
Voluntary Deduction Code | The BDCA code payroll wants to see information for. |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
PHRDEDN_YEAR |
| The year the pay was earned |
PHRDEDN_PAYNO |
| the month (numerically) the pay was earned within that year. |
PHRDEDN_BDCA_CODE |
| The BDCA code for the record in question |
PHRDEDN_EMPLOYEE_AMT |
| The amount the Employee paid into that BDCA code for the PAY Year and Pay Number. |
PHRDEDN_EMPLOYER_AMT |
| The amount the Employer paid into that BDCA code for the PAY Year and Pay Number. |
PTRBDCA_LONG_DESC |
| The Description of the BDCA code. |
SPBPERS_SSN |
| The SSN of the Employee that paid into the BDCA Code |
SPRIDEN_LAST_NAME |
| The last name of the Employee that paid into the BDCA Code |
SPRIDEN_FIRST_NAME |
| The first name of the Employee that paid into the BDCA Code |
SPRIDEN_MI |
| The middle initial/name of the Employee that paid into the BDCA Code |
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. |
PHRDEDN_APPLICABLE_GROSS |
| The Gross amount isn’t actually used in the report section and is left in the query as to not change the query in case it messes something up. |
SPRIDEN_ID |
| The Employee ID of the person that paid into the BDCA code. |
Report Domain
This report is built off SPRIDEN SPBPERS and SPRIDEN tables for the person information, and the PHRDEDN and PTRBDCA tables for the Amount paid into the BDCA code as well as the description of the code. It comes from Oracle PROD_DB because I am told they need live data.