A PeopleSoft Global Payroll specialist who maintains and support the system have to frequently query a set of tables very frequently. Lets see what are those.
The below tables contain the calculation results and are source of data that is displayed in the page Result by Calendar Group
PS_GP_PYE_PRC_STAT (Contains all the resolved calendars)
PS_GP_PYE_SEG_STAT (Contains all the resolved segments calendar-wise)
PS_GP_RSLT_ERN_DED (Contains payroll earnings and deduction results under each segments calendar-wise)
PS_GP_RSLT_DELTA (Contains retro delta results calendar-wise)
PS_GP_RSLT_ACUM (Contains accumulator results calendar-wise)
PS_GP_RSLT_PIN (Contains supporting element results (bracket, formula, variables etc..) calendar-wise)
PS_GP_RSLT_PI_DATA (Contains positive input results calendar-wise)
The below tables contain triggers created from various sources and can be seen in the page Review Triggers
PS_GP_RTO_TRGR (Contains retro triggers)
PS_GP_SEG_TRGR (Contains segmentation triggers)
PS_GP_ITER_TRGR (Contains iterative triggers)
This one contains the error/warning messages associated with payees calendar-wise after the pay calculation process is run and can be seen through the page Payee Messages
PS_GP_MESSAGES
When we run the payroll with debug and trace option enabled, the audit trail is stored in the below table and can be seen through the page Element Resolution Chain
PS_GP_AUDIT_TBL
The payee level data is stored and maintained in below tables
PS_GP_PI_MNL_DATA (The earnings and deductions assigned to a payee, Page - One Time (Positive Input))
PS_GP_PAYEE_DATA(The retro limit at payee level, page Assign Retro Limit)
PS_GP_PYE_OVRD (Elements assigned to a payee for a specific period, page -Element Assignment by Payee)
Calendar Group Definitions are stored in this table:
PS_GP_CAL_RUN
Payments processing details and results are stored in below tables:
PS_GP_PMT_PREPARE (Payment processing details for a calendar group, page -Run Payment Prep Process)
PS_GP_PAYMENT (Payment processing results for a calendar group)
GP-GL processing detail and result are stored in below tables:
PS_GP_GL_PREPARE (GP-GL processing details for a calendar group)
PS_GP_GL_DATA (GP-GL processing results)
The below tables contain the calculation results and are source of data that is displayed in the page Result by Calendar Group
PS_GP_PYE_PRC_STAT (Contains all the resolved calendars)
PS_GP_PYE_SEG_STAT (Contains all the resolved segments calendar-wise)
PS_GP_RSLT_ERN_DED (Contains payroll earnings and deduction results under each segments calendar-wise)
PS_GP_RSLT_DELTA (Contains retro delta results calendar-wise)
PS_GP_RSLT_ACUM (Contains accumulator results calendar-wise)
PS_GP_RSLT_PIN (Contains supporting element results (bracket, formula, variables etc..) calendar-wise)
PS_GP_RSLT_PI_DATA (Contains positive input results calendar-wise)
The below tables contain triggers created from various sources and can be seen in the page Review Triggers
PS_GP_RTO_TRGR (Contains retro triggers)
PS_GP_SEG_TRGR (Contains segmentation triggers)
PS_GP_ITER_TRGR (Contains iterative triggers)
This one contains the error/warning messages associated with payees calendar-wise after the pay calculation process is run and can be seen through the page Payee Messages
PS_GP_MESSAGES
When we run the payroll with debug and trace option enabled, the audit trail is stored in the below table and can be seen through the page Element Resolution Chain
PS_GP_AUDIT_TBL
The payee level data is stored and maintained in below tables
PS_GP_PI_MNL_DATA (The earnings and deductions assigned to a payee, Page - One Time (Positive Input))
PS_GP_PAYEE_DATA(The retro limit at payee level, page Assign Retro Limit)
PS_GP_PYE_OVRD (Elements assigned to a payee for a specific period, page -Element Assignment by Payee)
Calendar Group Definitions are stored in this table:
PS_GP_CAL_RUN
Payments processing details and results are stored in below tables:
PS_GP_PMT_PREPARE (Payment processing details for a calendar group, page -Run Payment Prep Process)
PS_GP_PAYMENT (Payment processing results for a calendar group)
GP-GL processing detail and result are stored in below tables:
PS_GP_GL_PREPARE (GP-GL processing details for a calendar group)
PS_GP_GL_DATA (GP-GL processing results)
Nice Blog ! If you need instant help, you can contact us at our Quickbooks Support Phone Number 800-986-4607. We provide solutions for every of quickbooks versions. We have QuickBooks experts who have years of experience and knowledge and delivers the best solutions to you.
ReplyDeleteusefull info thanks a lot
ReplyDeleteAs per Indian Governemnt, NorthEast region for SC/ST employee are completly exmept from TAX deduction, kindly let me know how to configure this in system
ReplyDeleteThis read is quite confusing for me as I'm not code-friendly but I can conclude what it is about. Thanks for sharing.
ReplyDeletepaystub maker
paycheck stub online
free check stub template
This comment has been removed by the author.
ReplyDeletePay stub creator This particular is usually apparently essential and moreover outstanding truth along with for sure fair-minded and moreover admittedly useful My business is looking to find in advance designed for this specific useful stuffs…
ReplyDeleteI wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. Payroll Software in India
ReplyDeleteI really like you words and appreciate your article post. Really Cool please keep writing.
ReplyDeleteExcellent post. Thanks for sharing such great and helpful info with us. Keep it up. I appreciate this informative post. Want to know about QuickBooks Visit here.
ReplyDeleteQuickBooks enterprises support!
This insightful blog post delves into frequently queried tables in PeopleSoft Global Payroll. For those interested in streamlining their payroll processes in India, this article serves as a valuable resource. Discover how to enhance your payroll management with the top 10 payroll software in India, providing efficiency and ease of use.
ReplyDeleteNavigating PeopleSoft's global payroll tables can be complex. For businesses considering outsourcing, especially in Mumbai, understanding these tables is vital. This blog sheds light on the intricacies, valuable for both Payroll Outsourcing Companies In Mumbai and their clients.
ReplyDeleteCreate Paycheck Stubs quickly, easily, and based on your convenience. Try paycheck stub right now and we are sure, we won’t disappoint you! Generate online paystub in less than one minute and you will be ready to download
ReplyDelete