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 calculate the leave balances.
🔘 Options
Options | Description |
---|---|
Year | Choose the year the pay happened in |
Pay Period | Choose the Numerical Month to run this report for. |
Employee/Student | Choose to run this report for Employees or for Students |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
---|---|---|
PHRHIST_YEAR |
| The year the pay was earned |
PHRHIST_PAYNO |
| the month (numerically) the pay was earned within that year. |
PHRHIST_PIDM |
| Count of the |
PR_NAME |
| The ECLS code converted to be either Classified, Certificated or Student as defined by PAYROLL. |
SPRIDEN_ID |
| The Quarter (First (Months 1-3), Second (Months 4-6), Third (Months 7-9), Fourth (Months 10-12)) |
PERLEAV_LEAV_CODE |
| |
PERLEAV_BEGIN_BALANCE |
| |
PERLEAV_ACCRUED |
| |
PERLEAV_TAKEN |
| |
PERLEAV_ACTIVITY_DATE |
| |
CURRENT_ACCR |
| |
CURRENT_TAKEN |
| |
PHRACCR_PAYNO |
| |
PEBEMPL_ECLS_CODE |
| |
CURRENT_BALANCE |
| PERLEAV.PERLEAV_BEGIN_BALANCE + PERLEAV.PERLEAV_ACCRUED - PERLEAV.PERLEAV_TAKEN |
BEGINNING_BALANCE |
| PERLEAV.PERLEAV_BEGIN_BALANCE + PERLEAV.PERLEAV_ACCRUED - PERLEAV.PERLEAV_TAKEN phraccr_curr_taken - phraccr_curr_accr |
🗺 Report Domain
This report is built off the PERLEAV, PHRACCR, PHRHIST, and PEBEMPL tables in the PAYROLL 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.
0 Comments