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 Next »

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 verify the the Monthly/Yearly Workers Comp OT.

🔘 Options

Options

Description

Fiscal Year

Choose the year the pay happened in

Pay Period

Choose the Pay Period (1-12 referring to the month or All to get the entire fiscal year)

📄 Results

Field Name

Data Source/Logic

Description (sample)

PHRDEDN_YEAR

PHRDEDN.PHRDEDN_YEAR

The year the pay was earned

PHRDEDN_PAYNO

PHRDEDN.PHRDEDN_PAYNO

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

PHRDEDN_BDCA_CODE

PHRDEDN.PHRDEDN_BDCA_CODE

The BDCA code for the record in question

PHRDEDN_EMPLOYEE_AMT

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

The amount the Employee paid into that BDCA code for the PAY Year and Pay Number.

PHRDEDN_EMPLOYER_AMT

PHRDEDN.PHRDEDN_EMPLOYER_AMT

The amount the Employer paid into that BDCA code for the PAY Year and Pay Number.

PTRBDCA_LONG_DESC

PTRBDCA.PTRBDCA_LONG_DESC

The Description of the BDCA code.

SPBPERS_SSN

SPBPERS.SPBPERS_SSN

The SSN of the Employee that paid into the BDCA Code

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_MI

SPRIDEN.SPRIDEN_MI

The middle initial/name of the Employee that paid into the BDCA Code

SSPRIDEN_CHANGE_IND

SPRIDEN.SPRIDEN_CHANGE_IND

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

PHRDEDN_APPLICABLE_GROSS

PHRDEDN.PHRDEDN_APPLICABLE_GROSS

The Gross amount isn’t actually used in the report section and is left in the query as to not change the query in case it messes something up.

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 SPBPERS and SPRIDEN tables for the person information, and the PHRDEDN and PTRBDCA tables for the Amount paid into the BDCA code as well as the description of the code. It comes from Oracle PROD_DB because I am told they need live data.

  • No labels