SQL to pull general deductions for pay end date
I'm trying to determine what rows the pay calculation should pull in from the ps_genl_deduction (general deduction) table. Does anyone know of the stored statement that pulls in the general deductions or the sql statement used?
I believe it does something with effective date, goal balance and end date.