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

Stakeholder

🛠 What It’s Used For

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

🔘 Options

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)
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).

...