Workers Comp OT Report
- Joshua Metry
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 verify the the Monthly/Yearly Workers Comp OT.
Options
Options | Description |
|---|---|
Fiscal Year | Choose the year the pay happened in |
Pay Period | Choose the Pay Period (1-12 referring to the month or All to get the entire fiscal year) |
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 Employee ID of the person |
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. |
PHRJOBS_YEAR |
| The year the pay was earned |
PHRJOBS_PAYNO |
| 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 |
Report Domain
This report is built off SPRIDEN tables for the person information, and the PTRCALN, PHREARN, PHRJOBS, and tables for the Amount. It comes from Oracle PROD_DB because I am told they need live data.