SQL Query Support Request: Payroll Run Results with Payment Status

Alex_of_Wincanton

Hi,

I'm using a data model to query payroll run results, but I'm only interested in the calculated amounts that were processed to payment. I'm struggling to link the results to a relevant table that holds the payment status. Is anyone able to assist in where this information can be sourced? Current tables being queried:

PER_ALL_PEOPLE_F per
left join PAY_PAY_RELATIONSHIPS_DN paypr on per.person_id = paypr.PERSON_ID
left join PAY_RELATIONSHIP_TYPES_TL payprt on paypr.RELATIONSHIP_TYPE_ID = payprt.RELATIONSHIP_TYPE_ID
left join PAY_REL_GROUPS_DN payrg on payrg.PAYROLL_RELATIONSHIP_ID = paypr.PAYROLL_RELATIONSHIP_ID
left join PAY_RUN_RESULTS payrr on payrg.RELATIONSHIP_GROUP_ID = payrr.PAYROLL_ASSIGNMENT_ID
left join PAY_ELEMENT_TYPES_TL payet on payet.ELEMENT_TYPE_ID = payrr.ELEMENT_TYPE_ID
left join PAY_RUN_RESULT_VALUES payrrv on payrrv.RUN_RESULT_ID = payrr.RUN_RESULT_ID
left join PAY_INPUT_VALUES_F payiv on payrrv.INPUT_VALUE_ID = payiv.INPUT_VALUE_ID
left join PAY_INPUT_VALUES_TL payivtl on payrrv.INPUT_VALUE_ID = payivtl.INPUT_VALUE_ID
left join PAY_PAYROLL_REL_ACTIONS payra on payrr.PAYROLL_REL_ACTION_ID = payra.PAYROLL_REL_ACTION_ID
left join PAY_PAYROLL_ACTIONS payac on payra.PAYROLL_ACTION_ID = payac.PAYROLL_ACTION_ID

Help please.