...
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) | |
|---|---|---|---|
PHRDEDNPHREARN_YEAR |
| The year the pay was earned | |
PHRDEDNPHREARN_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_PHREARN_EARN_CODE |
| the Earn Code the pay is under. | |
PTREARN_CASH_IND |
| Indicates if the earnings are cash or non-cash earnings | |
PHREARN_HRS |
| The Hrs worked for that earn code | |
PHRDEDNPHREARN_RATE |
| The rate at which those hrs are paid for the position and that earn code. | |
PHRDEDNPHREARN_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 | PHRDEDN.PHRDEDNPHREARN_PICT_CODE |
| The Payroll Identification Code |
PHREARN_PIDM |
| The PIDMof the Employee that earned the money. | |
PHREARN_SEQ_NO |
| The sequence number associated with the event | |
PHREARN_POSN |
| The Position this entry is for. | |
PHREARN_SUFF |
| The Suffix for the postion that earned the money. |
🗺 Report Domain
This report is built off the COS_PAYROLL_PRELIST view which is built of the several PHREARN and PTREARN tables 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.
...