Sweet Street Transaction Summary
select * from tbl_TPM_ClaimContracts cc with (nolock)
where ownerId = 54
and ownerType = 'MFR'
and reconciledDate >=
and reconciledDate <=
and reconciled = 'Y'
select * from tbl_WRK_Tasks with (nolock)
where ownerId = 54
and ownerType = 'MFR'
and subjectType = 'TMC'
and createDate >=
and createDate <=
Period: #lsdateformat( url.startDate, "MM/DD/YYYY")# - #lsdateformat( url.endDate, "MM/DD/YYYY")#
Sub-Claims Cleared: #lsnumberformat( qmd_subclaims.recordCount )#
Tasks Issued: #lsnumberformat( qmd_tasks.recordCount )#