Absence Query Report
- Joshua Metry
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 |
| The Leave Code |
PERLEAV_BEGIN_BALANCE |
| The Balance at the beginning of the Fiscal Year |
PERLEAV_ACCRUED |
| Leave accrued over the entire Fiscal Year |
PERLEAV_TAKEN |
| Leave Taken over the entire Fiscal Year |
PERLEAV_ACTIVITY_DATE |
| The Activity date for the leave |
CURRENT_ACCR |
| The leave amount accrued fro the current Month |
CURRENT_TAKEN |
| The leave amount taken for the current month |
PHRACCR_PAYNO |
| The Month the Pay/Leave is for. |
PEBEMPL_ECLS_CODE |
| the Class Code |
CURRENT_BALANCE |
| PERLEAV.PERLEAV_BEGIN_BALANCE + PERLEAV.PERLEAV_ACCRUED - PERLEAV.PERLEAV_TAKEN A calculated field based off the Fiscal year data to determine how much leave you have now. |
BEGINNING_BALANCE |
| PERLEAV.PERLEAV_BEGIN_BALANCE + PERLEAV.PERLEAV_ACCRUED - PERLEAV.PERLEAV_TAKEN phraccr_curr_taken - phraccr_curr_accr A calculated field based off the Fiscal year data and the current months data to determine how much leave you had at the beginning of the month. |
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.