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 search SSN on employees based on the selected year.
🔘 Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
PERETOT_YEAR |
| The year the pay was earned |
SPBPERS_SSN |
| SSN |
LAST_NAME |
| Last Name |
FIRST_NAME |
| First Name |
SPRIDEN_MI |
| Middle Name |
SPBPERS_BIRTH_DATE | SPBPERS.SPBPERS_BIRTH_DATE | Birth Date |
SPBPERS_SEX | SPRIDEN.SPBPERS_SEX | Gender |
SPRIDEN_CHANGE_IND | SPRIDEN.SPRIDEN_CHANGE_IND | Change Indicator |
SPRIDEN_ID | SPRIDEN.SPRIDEN_ID | Banner ID |
🗺 Report Domain
This report is built off the PERETOT, SPBPERS, and SPRIDEN tables in the PAYROLL schema and the SPRIDEN and SPBPERS tables to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.
0 Comments