Employee Count - CCAF 351 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 assist in their payroll processes and make sure the numbers are what they expect them to be.
Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Pay Period | Choose the Pay Period (1-12 referring to the month) |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
PHRDEDN_YEAR |
| The year the pay was earned |
PHRDEDN_PAYNO |
| the month (numerically) the pay was earned within that year. |
SPBPERS_SSN |
| The SSN of the Employee that earned the money. |
SPRIDEN_LAST_NAME |
| The last name of the Employee that earned the money. |
SPRIDEN_FIRST_NAME |
| The first name of the Employee that earned the money. |
SPRIDEN_MI |
| The middle initial/name of the Employee that earned the money. |
PHRHIST_TYPE_IND | PHRHIST.PHRHIST_TYPE_IND | This is used as part of the criteria for the data, however is not actually used in the report that was built off this query that Payroll uses. |
CLASSIFICATION |
| The ECLS code converted to be either Classified, Certificated or Student as defined by PAYROLL. |
Report Domain
This report is built off the REPORTSNET.PAYROLL_EMPLOYEE_COUNT_CCAF_351 that is built on the COS_PAYROLL_PRELIST view which is built of the several tables in the PAYROLL schema and a few tables to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.