You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to differentiate Payment Amount type between Percentage and remaining Pay at database level

edited Nov 9, 2020 6:02PM in Payroll and Global Payroll Interface (GPI)

Summary

Unable to differentiate Payment Amount type between Percentage and remaining Pay at database level

Content

HI All,

We have a requirement to fetch below details in BI report from Personal Payment methods screen under person Management.

Procession Order
Name
Percentage

 

In front end some of the employees having two personal payment method one with payment amount type as ‘Percentage’ and second one is showing remaining pay(entered by user) ,while running the below query I am unable to identify which row indicates the payment amount type as ‘Percentage’ and which one is showing as ‘Remaining Pay’ for an employee. Percentage column is showing 100 for both the rows.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!