Payroll DPA Report
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | ย Vicky Parra, Valiree Yzavel Gonzalez |
Report Owner | Vicky Parra |
Data Domain(s) | Payroll |
Contains PII | Yes |
What Itโs Used For
Payroll uses this report to assist in their payroll processes and see the money earned under the DPA earn code.
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) |
|---|---|---|
SPRIDEN_ID |
| the Faculty Banner ID. |
SPRIDEN_LAST_NAME |
| The last name of the Faculty. |
SPRIDEN_FIRST_NAME |
| The first name of the Faculty. |
PHREARN_POSN |
| returns the Employees position that earned the money. |
PHREARN_AMT |
| returns the amount the employee earned under that earn code. |
PHREARN_EARN_CODE |
| The earn code of DPA. |
PHREARN_YEAR |
| The year of the earned amount. |
PHREARN_PAYNO |
| the month of the earned amount. |
Report Domain
This report is built off the PHREARN table in the PAYROLL schema and SPRIDEN table from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.