select from pay type more accurately