Social Security Match Up

Owned by ludmilag
Last updated: Jun 11, 2024
1 min read

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 search SSN on employees based on the selected year.

Options

Options

Description

Options

Description

Year

Choose the year the pay happened in

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

PERETOT_YEAR

PERETOT.PERETOT_YEAR

The year the pay was earned

SPBPERS_SSN

SPBPERS.SPBPERS_SSN

SSN

LAST_NAME

SPRIDEN.SPRIDEN_LAST_NAME

Last Name

FIRST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

First Name

SPRIDEN_MI

SPRIDEN.SPRIDEN_MI

Middle Name

SPBPERS_BIRTH_DATE

SPBPERS.SPBPERS_BIRTH_DATE

Birth Date

SPBPERS_SEX

SPRIDEN.SPBPERS_SEX

Gender

SPRIDEN_CHANGE_IND

SPRIDEN.SPRIDEN_CHANGE_IND

Change Indicator

SPRIDEN_ID

SPRIDEN.SPRIDEN_ID

Banner ID

Report Domain

This report is built off the PERETOT, SPBPERS, and SPRIDEN 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.