Data Source	Snowflake
Job/Process Source (Refresh Interval)	Day-old data ingestion into Snowflake.
Functional User(s)	Keila Reynoso, Linda Reis, Lori Jones, Nancy Yanes, Norma Chavez
Constituent(s)	Keila Reynoso
Report Owner	John Bratsch
Data Domain(s)	Employee
Contains PII	Yes

What It’s Used For

Determining the latest review per employee on the PEAREVW Banner page--completed or otherwise.

Options

Options	Description

Options	Description
Salary Table	Select from the different employee salary tables.
Employee Class	Further filter down employees based on employee class. Defaults to “all”.

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
EMPLOYEE_NAME	`SPRIDEN.SPRIDEN_LAST_NAME` `SPRIDEN.SPRIDEN_FIRST_NAME` `SPRIDEN.SPRIDEN_MI`	Combination of the employee’s last, first, and middle name.
BANNER_ID	`SPRIDEN.SPRIDEN_ID`	Employee’s Banner ID.
DUE_DATE	`PERREVW.PERREVW_REVT_DATE`	Scheduled review date for the employee.
COMPLETE	`PERREVW.PERREVW_REVT_COMPLETE`	Review completion status.
COMPLETED_DATE	`PERREVW.PERREVW_COMPLETED_DATE`	Review completion date.
SAL_TABLE	`NBRJOBS.NBRJOBS_SAL_TABLE`	Salary table.
RANGE	`NBRJOBS.NBRJOBS_SAL_GRADE`	Salary range.
STEP	`NBRJOBS.NBRJOBS_SAL_STEP`	Salary step.
CLASS_CODE	`NBRJOBS.NBRJOBS_ECLS_CODE`	Employee class code.
NBRJOBS_POSN	`NBRJOBS.NBRJOBS_POSN`	Employee position code.

Employees are pulled from the PERREVW table and filtered out if they do not have the PEBEMPL_EMPL_STATUS of 'A' (Active).