Usage: url.ownerID and url.ownerType

Defaulting url.datasource = #url.datasource#

Optional params url.claimId and url.requestId

Tool checks tbl_TPM_RequestPartners and adds as follows:
  • where claimContracts claimReconciled == 'Y'
  • where claims claimAmount == reconciledAmount
  • where not already on the table exclusive by ownerId, type, requestId, partnerType, partnerId
  • sets primaryPartner = N, claimPartner = Y on new adds (makes no modification to existing records)
  • when run without a claimId or requestId, hits everything that qualifies

Filling in missing Request Partner data for owner #url.ownerType# #url.ownerID#:

Updates:

  1. RequestId: #htmleditformat(_requestId)# -- OwnerType: #htmleditformat(_type)# -- OwnerId: #htmleditformat(_Id)#

No records added