WC2 Query
- 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 for payroll processing.
Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Pay Period | Choose the Pay Period (1-12 referring to the month) |
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 |
PHREARN_YEAR |
| The year the pay was earned |
PHREARN_PAYNO |
| the month (numerically) the pay was earned within that year. |
PHREARN_EARN_CODE |
| The EARN code for the record in question |
PHREARN_AMT |
| The amount the the employee earned |
Report Domain
This report is built off SPRIDEN tables for the person information, and the PHREARN table for the Amount. It comes from Oracle PROD_DB because I am told they need live data.