Appendix: Global Payroll Queries

This appendix provides a list of delivered queries for PeopleSoft Enterprise Global Payroll.

See Also

Enterprise PeopleTools PeopleBook: PeopleSoft Query

Click to jump to parent topicDelivered Queries

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.

See Viewing Delivered Elements.

  • Used By

  • Country

  • Category

  • Element Name

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.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_ABS

Displays all of the absence results for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_ACM_USER_ADJ

Displays all of the adjustments made to accumulator values for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_DELTA

Displays all of the retro deltas for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_ERN_DED

Displays all earning and deductions results for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_MESSAGES

Displays all batch processing messages for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

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.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_PI_DATA

Displays the positive input results for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_PI_SOVR

Displays the supporting elements for positive input for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

  • Element Name

GP_RESULT_PRC_STAT

Displays the process stat record for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

GP_RESULT_SEG_STAT

Displays the segment stat records for a given calendar group.

  • Calendar Group

  • Pay Group

  • EmplID

GP_SET_ERNDED_END_DATE

Lists payees whose assigned earnings or deductions had an end date change for a given calendar group.

Calendar Group