SUI Report
- Joshua Metry
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Â Vicky Parra, 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 calculate the State Unemployment Insurance for the quarter.
Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Quarter | Choose the Quarter (First (Months 1-3), Second (Months 4-6), Third (Months 7-9), Fourth (Months 10-12)) |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
PHRDEDN_PIDM |
| The PIDM of the person that earned the money. |
PHRDEDN_YEAR |
| The year the pay was earned |
QUARTER |
| The Quarter (First (Months 1-3), Second (Months 4-6), Third (Months 7-9), Fourth (Months 10-12)) |
CLASSIFICATION |
| The ECLS code converted to be either Classified, Certificated or Student as defined by PAYROLL. |
SPRIDEN_LAST_NAME |
| The Last Name of the employee |
SPRIDEN_FIRST_NAME |
| The First Name of the employee |
SPRIDEN_MI |
| the Middle Initial of the employee |
FEDERAL |
| The Employee Amount when the BDCA_CODE is 800 |
STATE |
| The Employee Amount when the BDCA_CODE is 801 |
FICA |
| The Employee Amount when the BDCA_CODE is 802 |
MEDI |
| The Employee Amount when the BDCA_CODE is 803 |
MEDI_GROSS |
| The Applicable Gross Amount when the BDCA_CODE is 803 |
FICA_GROSS |
| The Applicable Gross Amount when the BDCA_CODE is 802 |
SUI_GROSS |
| The Applicable Gross Amount when the BDCA_CODE is 805 |
SPBPERS_SSN |
| The Social Security Number of the Employee |
SUI_COUNT |
| When BDCA_CODE = 805 and Applicable_Gross is not 0 then this is 1 then grabs the MAX Value for each employee |
FIRSTOFSUMOFPHRHIST_GROSS | SumOfPHRHIST_GROSS | The sum of the PHRHIST_GROSS |
TAXABLE_GROSS |
| The Applicable Gross Amount when the BDCA_CODE is 801 |
Report Domain
This report is built off the PHRDEDN, PHRHIST, and PEBEMPL tables in the PAYROLL schema and the SPRIDEN and SPBPERS tables to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.