...
Payroll uses this report to verify the the Monthly/Yearly Workers Comp OTlist the Annual Salary of employees descending.
🔘 Options
Options | Description |
|---|---|
Fiscal Year | Choose the year the pay happened in |
Pay PeriodPosition | Choose the Pay Period (1-12 referring to the month or All to get the entire fiscal year)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 CodeSPRIDEN_ID |
| The Employee ID of the person that paid into the BDCA code. |
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. | ||
PHRJOBSPERJTOT_YEAR |
| The year for the pay was earnedsalary | ||
PHRJOBSPERJTOT_PAYNOPOSN |
| the month (numerically) the pay was earned within that year. | ||
PHREARN_EARN_CODE |
| The EARN code for the record in question | ||
PHREARN_RATE |
| The rate of pay the employee earns | ||
AMOUNT |
| The amount the the employee earned | ||
CLASSIFICATION |
| The ECLS code converted to Classified or Other. | ||
PTRCALN_FISC_CODE |
| The Fiscal year the OT was earned in. | ||
PHREARN_HRS |
| The number of hours of OT earned. | ||
PTRCALN_PAYNO |
| the month (numerically) the pay was earned within that year. | ||
WC_AMOUNT | .5 * PHREARN.PHREARN_AMT/ 1.5 | The Workers Comp Amount | ||
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 PTRCALN, PHREARN, PHRJOBS, and PERJTOT and PTREARN tables for the Amount. It comes from Oracle PROD_DB because I am told they need live data.
...