Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Mary Schaefer, Valiree Yzavel Gonzalez, Vick Para |
Report Owner | Valiree Yzavel Gonzalez |
Data Domain(s) | Payroll |
Contains PII | Yes |
🛠 What It’s Used For
Payroll uses this report to list the Annual Salary of employees descending.
🔘 Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Position | Choose Position (can use % as a wildcard) to pull data for. |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
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 |
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. |
PERJTOT_YEAR |
| The year for the salary |
PERJTOT_POSN |
| the position the person is in |
SumOfPERJTOT_GRS |
| the total gross pay for that year/position |
PTREARN_CASH_IND |
| if the pay was cash |
SPRIDEN_ID |
| The Employee ID of the person that paid into the BDCA code. |
🗺 Report Domain
This report is built off SPRIDEN tables for the person information, and the PERJTOT and PTREARN tables for the Amount. It comes from Oracle PROD_DB because I am told they need live data.
Add Comment