Payroll Prelist Report
- Joshua Metry
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Â Mary Schaefer, 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 assist in their payroll processes and make sure the numbers are what they expect them to be.
Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Pay Period | Choose the Pay Period (1-12 referring to the month) |
Classification | Certificated, Classified or Student |
Earn Class | The type of Pay earned (can use Wild Card to get multiple that are similar) |
Position | The position of the worker (can use Wild Card to get multiple that are similar) |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
PHRDEDN_YEAR |
| The year the pay was earned |
PHRDEDN_PAYNO |
| the month (numerically) the pay was earned within that year. |
CLASSIFICATION |
| The ECLS code converted to be either Classified, Certificated or Student as defined by PAYROLL. |
PHRDEDN_EARN_CODE |
| the Earn Code the pay is under. |
PHRDEDN_HRS |
| The Hrs worked for that earn code |
PHRDEDN_RATE |
| The rate at which those hrs are paid for the position and that earn code. |
PHRDEDN_AMT |
| The Amount earned based off multiplying the Hrs and the Rate. |
SPBPERS_SSN |
| The SSN of the Employee that earned the money. |
SPRIDEN_LAST_NAME |
| The last name of the Employee that earned the money. |
SPRIDEN_FIRST_NAME |
| The first name of the Employee that earned the money. |
SPRIDEN_MI |
| The middle initial/name of the Employee that earned the money. |
SUMOFFEDERAL |
| the sum of the amount paid to federal for this income determined by the BDCA code of 800 |
SUMOFSTATE |
| Tthe sum of the amount paid to state for this income determined by the BDCA code of 801 |
SUMOFFICA |
| the sum of the amount paid to FICAfor this income determined by the BDCA code of 802 |
SUMOFMEDI |
| the sum of the amount paid to MEDI for this income determined by the BDCA code of 803 |
SUMOFRETIREMENT |
| the sum of the amount paid to retirement for this income determined by the BDCA code of 1R1, 1R2, 1R6, 1R7 OR 1R5 as told to us by Payroll |
SUMOFTAX_SHELTER | PHRDEDN.PHRDEDN_EMPLOYEE_AMT | the sum of the amount paid to Tax Shelter for this income determined by the BDCA codes 1st character being 9 |
SUMOFVOL_DED | PHRDEDN.PHRDEDN_EMPLOYEE_AMT | the sum of the amount paid to Tax Shelter for this income determined by the BDCA codes 1st character being 0, 2, 3, 4, 5, 7 or the 1st 2 being 1A,1D,1H OR 1L |
SUMOFPHRHIST_GROSS | PHRHIST.PHRHIST_GROSS | the sum of the PHRHIST_GROSS |
SUMOFPHRHIST_NET | PHRHIST.PHRHIST_NET | the sum of the PHRHIST_NET |
PHRDEDN_PICT_CODE |
| Used to join the proper PHRDEDN Record and PHRHIST records as well as PHRDEDN and PHREARN records.. Shows up in the data grid because we didn’t exclude it, however is not actually used in the report that was built off this query that Payroll uses. |
PHRHIST_TYPE_IND | PHRHIST.PHRHIST_TYPE_IND | This is used as part of the criteria for the data, however is not actually used in the report that was built off this query that Payroll uses. |
PHRHIST_EVENT_DATE | PHRHIST.PHRHIST_EVENT_DATE | the date the data was written to the PHRHIST table. |
PHRDEDN_SEQ_NO |
| The sequence number associated with the event |
PHREARN_POSN | PHREARN.PHREARN_POSN | The Position this entry is for. |
Report Domain
This report is built off the COS_PAYROLL_PRELIST view which is built of the several tables in the PAYROLL schema and a few tables to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.