Retirement Report for Parity
- Joshua Metry
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Vicky Parra, 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 replace the the two Microsoft Access Queries, “PERS 1R7 Deduction 6% Query” and STRS 1R5 Deduction 2% at 62 Query”. The two lists those reports provided return are combined into one output here. Then Vicky requested I add in the 1R6 BDCA code as well
Options
Options | Description |
|---|---|
BDCA CODE | Choose the BDCA Code you want to look at or All for all three BDCA Code options. |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
SPRIDEN_LAST_NAME |
| The Last Name of the employee |
SPRIDEN_FIRST_NAME |
| The First Name of the employee |
SPRIDEN_ID |
| the Banner ID of the employee |
PDRDEDN_BDCA_CODE |
| The BDCA_CODE when the BDCA_CODE is 1R7 or 1R5 or 1R6 |
PDRDEDN_OPT_CODE1 |
| Uses the Option Code E2 or EE for BDCA Code 1R7 and Option Code 62 or E for BDCA Code 1R5 or Option Code E for BDCA Code 1R6 |
PDRDEDN_EFFECTIVE_DATE |
| The Employer Amount when the BDCA_CODE is I50 |
Report Domain
This report is built off the PDRDEDN and PEBEMPL tables in the PAYROLL schema and the SPRIDEN table to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.