select assignedContractNbr, contractName from tbl_TPM_Contracts with (nolock) where ownerId = and ownerType = and contractId = update tbl_TPM_Contracts set flaggedForRecalc = '?' where ownerId = and ownerType = and contractId = update tbl_TPM_Contracts set flaggedForRecalc = 'N', flaggedForRecalcTime = null where ownerId = and ownerType = and contractId =

Contracted Sales Updated for #qmd_contract.assignedContractNbr# - #htmleditformat( qmd_contract.contractName )#

#getTickCount() - _startTicks# ms.

Cannot find contractId #_config.contractId#

select fileFormat from tbl_EAI_inboundFileProcessors with (nolock) where ownerid = and ownerType = and fileProcessor = '/mstrcfmod/TPM/batch/claimDetailsETL.cfm' insert into tbl_EAI_inboundFileProcessors ( ownerId, ownerType, fileName, fileProcessor, fileFormat, clientProcessEmail, fseProcessEmail, allowUpload, processingWindowStartHr24, processingWindowLengthHR, repeating, repeatTime, defaultBatchClass, notifications ) values( , , '', '/mstrcfmod/TPM/batch/claimDetailsETL.cfm', '$ClaimDetailsETL', 'data-czar@system-message.com', 'michael.griffin@system-message.com', 'N', 0, 24, 'Y', '04:30AM', 'A', 'N' ) select name from sysobjects where name = 'tbl_DW_OperatorAnalyzer#_analyzerTableSuffix#' and xType = 'U' and 1 = 2 with outOfSync as ( select distinct ct.ownerId, ct.ownerType, ct.contractId from tbL_TPM_CLaimContracts cc with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownerType = cc.ownerType and year( c.claimPeriodEnd ) >= #_cutOffYear# inner join tbl_TPM_Requests r with (nolock) on r.requestId = cc.requestId and r.ownerId = cc.ownerId and r.ownerType = cc.ownerType and r.volumeGenerator = 'Y' inner join tbl_TPM_Contracts ct with (nolock) on ct.contractId = r.contractId and ct.ownerId = r.ownerId and ct.ownerType = r.ownerType and ct.partnerType ='OPR' and ct.flaggedForRecalc != 'Y' -- beneficiary inner join tbl_OPR_CLientOperators opr with (nolock) on opr.operatorId = ct.partnerId and opr.ownerId = ct.ownerId and opr.fsltablecode = ct.ownerType and opr.fsl_choid > 0 and exists ( select * from tbl_TPM_ProofOfDelivery pod with (nolock) inner join tbl_OPR_ClientOperators loc with (nolock) on loc.operatorId = pod.operatorId and loc.ownerId = pod.ownerId and loc.fsltablecode = pod.ownerType where pod.ownerId = cc.ownerId and pod.ownerType= cc.ownerType and pod.claimId = cc.claimId and pod.contractNbr = cc.contractNbr and pod.status in ( 'CLAIM','CONTRACT' ) and loc.fsl_choId > 0 and loc.oprCompanyType = '0' ) and not exists ( select * from #qmd_operatorAnalyzerTable.name# oa with (nolock) where oa.ownerId = opr.ownerId and oa.ownerType = opr.fsltablecode and oa.cho_id = opr.fsl_choId and oa.purchasingMonth = dateFromParts( year( c.claimPeriodEnd ), month( c.claimPeriodEnd ), 1 )) where cc.ownerId = and cc.ownerType = and cc.reconciled = 'Y' ) update ct set flaggedForRecalc = 'Y', flaggedForRecalcTime = getDate() from tbl_TPM_Contracts ct inner join outOfSync oos on oos.ownerId = ct.ownerId and oos.ownerType = ct.ownerType and oos.contractId = ct.contractId with contractsToFlag as ( select distinct r.contractId from tbl_TPM_Requests r with (nolock) where r.ownerId = and r.ownerType = and r.volumeGenerator = 'N' and exists ( select * from #qmd_operatorAnalyzerTable.name# oa with (nolock) where oa.requestId = r.requestId and oa.ownerId = r.ownerId and oa.ownerType = r.ownerType ) and not exists ( select * from tbl_TPM_Contracts ct with (nolock) where ct.contractId = r.contractId and ct.ownerId = r.ownerId and ct.ownerType = r.ownerType and ct.flaggedForRecalc = 'Y' ) ) update tbl_TPM_Contracts set flaggedForRecalc = 'Y', flaggedForRecalcTime = getDate() where ownerId = and ownerType = and contractId in ( select contractId from contractsToFlag ) select ct.partnerId, ct.partnerType, ct.assignedContractNbr, ct.contractId, count( distinct cc.claimContractId ) claims from tbl_TPM_Contracts ct with (nolock) left outer join tbl_TPM_Requests r with (nolock) on r.contractId = ct.contractId and r.ownerId = ct.ownerId and r.ownerType = ct.ownerType left outer join tbl_TPM_ClaimContracts cc with (nolock) on cc.requestId = r.requestId and cc.ownerId = r.ownerId and cc.ownerType = r.ownerType and cc.reconciled = 'Y' left outer join tbl_TPM_Claims c with (nolock) on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownerType = cc.ownerType where ct.ownerId = and ct.ownerType = and ct.flaggedForRecalc = 'Y' and coalesce( cc.firstDate, coalesce( cc.claimPeriodEnd, c.claimDate )) >= and ct.partnerId = and ct.partnerType = group by ct.partnerId, ct.partnerType, ct.assignedContractNbr, ct.contractId order by ct.partnerType, ct.partnerId, claims desc

#lsnumberformat( qmd_contractsToUpdate.recordCount )# Contracts To Recalculate

#htmleditformat( assignedContractNbr )# Queued