This appendix provides a list of delivered queries for PeopleSoft Enterprise Global Payroll.
See Also
Enterprise PeopleTools PeopleBook: PeopleSoft Query
This table lists all queries delivered with PeopleSoft Enterprise Global Payroll:
Query |
Description |
Search Keys |
GP_ELEMENTS |
Lists all elements for a specific country. You can further refine the search to include a Category or Element Name. Note. Specific instructions on how to run this query are provided in the Viewing Delivered Elements chapter of this PeopleBook. |
|
GP_PMT_BY_STATUS |
Lists all payees by a given payment status. |
Payment Status |
GP_RESULTS_ACM |
Displays all accumulator results for a given calendar group. |
|
GP_RESULT_ABS |
Displays all of the absence results for a given calendar group. |
|
GP_RESULT_ACM_USER_ADJ |
Displays all of the adjustments made to accumulator values for a given calendar group. |
|
GP_RESULT_DELTA |
Displays all of the retro deltas for a given calendar group. |
|
GP_RESULT_ERN_DED |
Displays all earning and deductions results for a given calendar group. |
|
GP_RESULT_MESSAGES |
Displays all batch processing messages for a given calendar group. |
|
GP_RESULT_PAYMENT |
Displays the results from running the banking process for a given calendar group. |
Calendar Group |
GP_RESULT_PIN |
Displays the supporting elements results for a given calendar group. |
|
GP_RESULT_PI_DATA |
Displays the positive input results for a given calendar group. |
|
GP_RESULT_PI_SOVR |
Displays the supporting elements for positive input for a given calendar group. |
|
GP_RESULT_PRC_STAT |
Displays the process stat record for a given calendar group. |
|
GP_RESULT_SEG_STAT |
Displays the segment stat records for a given calendar group. |
|
GP_SET_ERNDED_END_DATE |
Lists payees whose assigned earnings or deductions had an end date change for a given calendar group. |
Calendar Group |