Annual Salary Descending

Owned by Joshua Metry
Last updated: Jun 05, 2024
1 min read

Data Source

Oracle

Job/Process Source (Refresh Interval)

Live Data

Functional User(s)

 Mary Schaefer, Valiree Yzavel Gonzalez, Vick Para

Report Owner

Valiree Yzavel Gonzalez

Data Domain(s)

Payroll

Contains PII

Yes

What It’s Used For

Payroll uses this report to list the Annual Salary of employees descending.

Options

Options

Description

Options

Description

Year

Choose the year the pay happened in

Position

Choose Position (can use % as a wildcard) to pull data for.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_LAST_NAME

The last name of the Employee

SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

The first name of the Employee

SSPRIDEN_CHANGE_IND

SPRIDEN.SPRIDEN_CHANGE_IND

the change indicator used to verify the current name information is the current one.

PERJTOT_YEAR

PERJTOT.PERJTOT_YEAR

The year for the salary

PERJTOT_POSN

PERJTOT.PERJTOT_POSN

the position the person is in

SumOfPERJTOT_GRS

Sum(PERJTOT.PERJTOT_GRS)

the total gross pay for that year/position

PTREARN_CASH_IND

PTREARN.PTREARN_CASH_IND

if the pay was cash

SPRIDEN_ID

SPRIDEN.SPRIDEN_ID

The Employee ID of the person that paid into the BDCA code.

Report Domain

This report is built off SPRIDEN tables for the person information, and the PERJTOT and PTREARN tables for the Amount. It comes from Oracle PROD_DB because I am told they need live data.