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, Vick Para

Report Owner

Valiree Yzavel Gonzalez

Data Domain(s)

Payroll

Contains PII

Yes

🛠 What It’s Used For

Payroll uses this report for payroll processing.

🔘 Options

Options

Description

Year

Choose the year the pay happened in

Pay Period

Choose the Pay Period (1-12 referring to the month)

📄 Results

Field Name

Data Source/Logic

Description (sample)

SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_LAST_NAME

The last name of the Employee that paid into the BDCA Code

SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

The first name of the Employee that paid into the BDCA Code

SPRIDEN_ID

SPRIDEN.SPRIDEN_ID

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

PHREARN_YEAR

PHREARN.PHREARN_YEAR

The year the pay was earned

PHREARN_PAYNO

PHREARN.PHREARN_PAYNO

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

PHREARN_EARN_CODE

PHREARN.PHREARN_EARN_CODE

The EARN code for the record in question

PHREARN_AMT

PHREARN.PHREARN_AMT

The amount the the employee earned

🗺 Report Domain

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


  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.