SUI Count Report

Owned by Joshua Metry
Last updated: Apr 22, 2024
1 min read

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 calculate the State Unemployment Insurance for the quarter.

Options

Options

Description

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)

Field Name

Data Source/Logic

Description (sample)

PERDTOT_YEAR

PERDTOT.PERDTOT_YEAR

The year the pay was earned

PERDTOT_PAYNO

PERDTOT.PERDTOT_PAYNO

the month (numerically) the pay was earned within that year.

NUM_EMP

pebempl.pebempl_ecls_code

Count of the pebempl.pebempl_ecls_code

CLASSIFICATION

pebempl.pebempl_ecls_code

The ECLS code converted to be either Classified, Certificated or Student as defined by PAYROLL.

QUARTER

PERDTOT.PERDTOT_MONTH

The Quarter (First (Months 1-3), Second (Months 4-6), Third (Months 7-9), Fourth (Months 10-12))

Report Domain

This report is built off the PERDTOT, PXRW2ST, and PEBEMPL tables in the PAYROLL schema and the SPRIDEN table to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.