Disposition
- ludmilag
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 check the disposition between 05 and 70.
Options
Options | Description |
|---|---|
Disposition | Choose between disposition equal to 5 or greater than 5 |
Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
LAST_NAME |
| Last Name |
FIRST_NAME |
| First Name |
ID |
| Banner ID |
CHANGE_IND |
| Change Indicator |
YEAR |
| The year of the payroll |
CODE | PHRHIST_PICT_CODE | PAYROLL IDENTIFICATION CODE: The pay id of the event. |
PAYNO | PHRHIST_PAYNO | PAYROLL NUMBER: The pay number of the year for this payroll |
SEQ | SPRIDEN.PHRHIST_SEQ_NO | SEQUENCE NUMBER: The sequence number of the event. |
DISP | PHRHIST_DISP | DISPOSITION: Indicates the status of this pay event through the pay cycle. |
Report Domain
This report is built off the PHRHIST, SPBPERS, and SPRIDEN tables in the PAYROLL schema and the SPRIDEN and SPBPERS tables to get person information from the SATURN schema. It comes from Oracle PROD_DB because I am told they need live data.