Payroll Monthly by Account

Owned by Joshua Metry
Jul 11, 2024
1 min read

Data Source

Oracle

Job/Process Source (Refresh Interval)

Live Data

Functional User(s)

 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 reconcile payroll.

Options

Options

Description

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)

 

Field Name

Data Source/Logic

Description (sample)

 

NHRDIST_ACCT_CODE

NHRDIST.NHRDIST_ACCT_CODE

The Accounting Code from NHRDIST

 

FTVACCT_TITLE

FTVACCT.FTVACCT_TITLE

The Title from FTVACCT that matches to the Accounting code from NHRDIST

 

NHRDIST_YEAR

NHRDIST.NHRDIST_YEAR

The year the pay was earned

 

NHRDIST_PAYNO

NHRDIST.NHRDIST_PAYNO

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

 

SumOfNHRDIST_AMT

SUM(NHRDIST.NHRDIST_AMT)

the sum of the NHRDIST_AMT grouped by the Accounting Code

 

NHRDIST.NHRDIST_SEQ_NO

NHRDIST.NHRDIST_SEQ_NO

the NHRDIST Sequence Number

 

Report Domain

This report is built off the NHRDIST table and the FTVACCT table for the description of the Accounting Code. It comes from Oracle PROD_DB because I am told they need live data.

Â