Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

🔘 Options

Options

Description

Year

Choose the year the pay happened in

📄 Results

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.

  • No labels