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 pull a list of jobs that have an effective date between the payroll date you enter and the current date you enter.

Options

Options	Description

Options	Description
Last Payroll Date	Choose the date to look for employee changes after.
Current Date	Choose the date to look for employee changes before.

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 that had a job effective date within the dates entered.
SPRIDEN_FIRST_NAME	`SPRIDEN.SPRIDEN_FIRST_NAME`	The first name of the Employee that had a job effective date within the dates entered.
SPRIDEN_MI	`SPRIDEN.SPRIDEN_MI`	The middle initial/name of the Employee that had a job effective date within the dates entered.
SPRIDEN_CHANGE_IND	`SPRIDEN.SPRIDEN_CHANGE_IND`	the change indicator used to verify the current name information is the current one.
SPRIDEN_ID	`SPRIDEN.SPRIDEN_ID`	The ID of the Employee that had a job effective date within the dates entered.
NBRJOBS.NBRJOBS_STATUS	`NBRJOBS.NBRJOBS_STATUS`	The status of the change being made
NBRBJOB_BEGIN_DATE	NBRBJOB.NBRBJOB_BEGIN_DATE	the Job begin date it is in the select criteria, and shows in the dashboard, but it is not actually used on the report.
NBRBJOB_END_DATE	NBRBJOB.NBRBJOB_END_DATE	the Job end date it is in the select criteria, and shows in the dashboard, but it is not actually used on the report.
POSN	WHEN SUBSTR(NBRJOBs_POSN,0,1) in ('A','N','C','F','M') THEN nbrjobs_posn ELSE Null END AS	If the Position starts with 'A','N','C','F' or 'M' then return the position, otherwise return null
NBRBJOB_SUFF	NBRBJOB.NBRBJOB_SUFF	The Suffix of the job the change took place for.
NBRJOBS_EFFECTIVE_DATE	NBRJOBS.NBRJOBS_EFFECTIVE_DATE	The effective date of the change the job was made to.

This report is built off SPRIDEN the table for the person information, and the NBRBJOBS table for the job information.