SELECT rowId FROM tbl_EAI_InboundFileProcessors WITH (nolock) WHERE ownerId = AND ownerType = AND fileFormat = '$BatchReviews' AND fileProcessor = '/mstrcfmod/EAI/batch/reviewBatches.cfm' INSERT INTO tbl_EAI_InboundFileProcessors ( ownerId ,ownerType ,fileName ,fileFormat ,fileProcessor ,processingWindowStartHr24 ,processingWindowLengthHr ,autoProcess ,allowUpload ,allowFTP ,allowEmail ,notifications ,clientProcessEmail ,fseProcessEmail ,defaultBatchClass ,repeating ,repeatTime ) VALUES ( , ,'^nothing\.txt$' ,'$BatchReviews' ,'/mstrcfmod/EAI/batch/reviewBatches.cfm' ,0 ,24 ,'Y' ,'N' ,'N' ,'N' ,'N' ,'data-czar@system-message.com' ,'joe.fuchs@system-message.com' ,'A' ,'Y' ,'09:00AM' ) SELECT eai.ownerId ,eai.ownerType ,'ownerTypeAndId' = CAST(eai.ownerType AS VARCHAR(3)) + CAST(eai.ownerId AS VARCHAR(6)) ,'ownerName' = COALESCE(mfr.mfr_name, cho.cho_name, 'UNKNOWN ACCOUNT') ,eai.batchId ,eai.fileFormat ,eai.fileName ,eai.clientProcessEmail ,'batchTime' = CONVERT(VARCHAR, eai.batchTime, 100) ,eai.resultsText ,eai.comment FROM tbl_EAI_InboundBatches AS eai WITH (nolock) LEFT JOIN tblManufacturers AS mfr WITH (nolock) ON eai.ownerType = 'MFR' AND eai.ownerId = mfr.mfr_id LEFT JOIN tbl_CHO_Operators AS cho WITH (nolock) ON eai.ownerType = 'CHO' AND eai.ownerId = cho.cho_id WHERE eai.status = 'REVIEW' AND eai.ownerType = 'MFR' AND eai.ownerType = 'CHO' AND eai.ownerType = AND eai.ownerId = ORDER BY ownerName ASC, eai.fileFormat ASC, eai.batchId ASC No Batches with "REVIEW" status were found. SELECT FILEFORMAT, BATCHID, BATCHTIME, CLIENTPROCESSEMAIL, FILENAME, RESULTSTEXT, COMMENT FROM qmd_getReviewBatches WHERE ownerTypeAndId = '#qmd_getReviewBatches.ownerTypeAndId#'

Emailed To: none

Emailed To: #_emailList#

#emailHTMLBody#