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. There are two reports on this dashboard to replace what was two separate reports that were virtually identical, the only difference being one was just the totals from the other.
🔘 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) |
Voluntary Deduction Code | The BDCA code payroll wants to see information for. |
📄 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_EARNBDCA_CODE |
| the Earn Code the pay is under. | PHRDEDN_HRSThe BDCA code for the record in question | ||
PHRDEDN_EMPLOYEE_AMT |
| The Hrs worked for that earn codePHRDEDN_RATEamount the Employee paid into that BDCA code for the PAY Year and Pay Number. | |||
PHRDEDN_EMPLOYER_AMT |
| 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 Rateamount the Employer paid into that BDCA code for the PAY Year and Pay Number. |
PTRBDCA_LONG_DESC |
| The Description of the BDCA code. | |||
SPBPERS_SSN |
| The SSN of the Employee that earned the money.paid into the BDCA Code | |||
SPRIDEN_LAST_NAME |
| The last name of the Employee that earned the money.paid into the BDCA Code | |||
SPRIDEN_FIRST_NAME |
| The first name of the Employee that earned the money.paid into the BDCA Code | |||
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. | |||
paid into the BDCA Code | |||||
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. | |||
PHRDEDN_APPLICABLE_GROSS |
| The Gross amount isn’t actually used in the report section and is left in the query as to not change the query in case it messes something up. | |||
SPRIDEN_ID |
| The Employee ID of the person that paid into the BDCA code. |
🗺 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 SPRIDEN schemaSPRIDEN SPBPERS and SPRIDEN tables for the person information, and the PHRDEDN and PTRBDCA tables for the Amount paid into the BDCA code as well as the description of the code. It comes from Oracle PROD_DB because I am told they need live data.
...