I50 Report
- Joshua Metry
Data Source | Oracle |
|---|---|
Job/Process Source (Refresh Interval) | Live Data |
Functional User(s) | Â Vicky Parra, 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 I50 amount for the chosen time frame. This report has a yearly run that happens at the end of July and covers this information from May-July.
Options
Options | Description |
|---|---|
Year | Choose the year the pay happened in |
Pay Period | Choose the pay period (1-12 for the month, All for all months in the year, or Yearly Run for May, June, and July) for the pay period you want to look at. |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
PERDTOT_PIDM |
| The PIDM of the person that earned the money. |
PERDTOT_YEAR |
| The year the pay was earned |
SPRIDEN_LAST_NAME |
| The Last Name of the employee |
SPRIDEN_FIRST_NAME |
| The First Name of the employee |
SPRIDEN_ID |
| the Banner ID of the employee |
PERDTOT_BDCA_CODE |
| The BDCA_CODE when the BDCA_CODE is I50 |
PERDTOT_EMPL_AMT |
| The Employee Amount when the BDCA_CODE is I50 |
PERDTOT_EMPR_AMT |
| The Employer Amount when the BDCA_CODE is I50 |
PERDTOT_APPL_GRS |
| The Gross Amount when the BDCA_CODE is I50 |
Report Domain
This report is built off the PERDTOT 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.