...
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)Used in Monthly version of report only. |
Quarter | Choose the Quarter (First, Second, Third or Fourth) Used in Quarterly version of report only. |
📄 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 | FEDERAL |
| PHRDEDN_HRS |
| The Hrs worked for that earn code | PHRDEDN_RATEEMPLOYEE_AMT Where BDCA code = 800 and |
FICA_ER |
| The rate at which those hrs are paid for the position and that earn code. | PHRDEDN | PHRDEDN.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_EMPLOYER_AMT Where BDCA code = 802 | ||||||
FICA_EE |
| Tthe sum of the amount paid to state for this income determined by the BDCA code of 801 | SUMOFFICA | PHRDEDN.PHRDEDN_EMPLOYEE_AMT the sum of the amount paid to FICAfor this income determined by the Where BDCA code of = 802 | ||
SUMOFMEDIFICA_MEDI_ER |
| the sum of the amount paid to MEDI for this income determined by the BDCA code of 803 | SUMOFRETIREMENT | PHRDEDN.PHRDEDN_EMPLOYEEEMPLOYER_AMT | 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_SHELTERWhere BDCA code = 803 |
FICA_MEDI_EE |
| 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. | ||||
Where BDCA code = 803 | ||||||
STATE |
| PHRDEDN_EMPLOYEE_AMT Where BDCA code = 801 | ||||
FICA_MEDI_Addl_EE |
| PHRDEDN_EMPLOYEE_AMT Where BDCA code = 806 |
🗺 Report Domain
This report is built off the COS_PAYROLL_PRELIST view which is built of the several tables PHRDEDN table in the PAYROLL schema and a few tables to get person information from the SPRIDEN schema. It comes from Oracle PROD_DB because I am told they need live data.
...