Termination Employee Listing Report
- Joshua Metry
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Â Mary Schaefer, Valiree Yzavel Gonzalez, Vicky Para |
Report Owner | Valiree Yzavel Gonzalez |
Data Domain(s) | Payroll |
Contains PII | Yes |
What It’s Used For
Payroll uses this report to see the employees that have been terminated since the last payroll. If multiple positions are terminated it grabs the positions on the closest date. If multiple positions for the closest date then all those positions will be shown.
Options
Options | Description |
|---|---|
Last Payroll Date | Choose the date, usually the last payroll date, to find terminated employees after. |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
SPRIDEN_LAST_NAME |
| LAST NAME OF THE TERMINATED EMPLOYEE |
SPRIDEN_FIRST_NAME |
| FIRST NAME OF THE TERMINATED EMPLOYEE |
SPRIDEN_MI |
| MIDDLE INITIAL OF THE TERMINATED EMPLOYEE |
BANNER_ID |
| SPRIDEN ID |
POSITION |
| THE POSITION CODE FOR THE POSITION THAT ENDED |
END DATE |
| THE END DATE FOR THE POSITION THAT ENDED |
Report Domain
This report is built off the NBRBJOB table in the POSNCTL schema and the SPRIDEN table to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.