select ter.territoryId, ter.name territoryName, opr.oprType, opr.profileErrors, count( distinct opr.operatorId ) operatorCount from tbl_TER_Territories ter inner join tbl_OPR_ClientOperators opr on opr.territoryId = ter.territoryId and opr.ownerId = ter.ownerId and opr.fsltablecode = ter.fsl_tablecode where opr.profileComplete = 'N' and opr.ownerId = and opr.fsltablecode = group by ter.territoryId, ter.name, opr.oprType, opr.profileErrors select territoryId, territory, priority, errCode, sum( profileCount ) profileCount from qmd_incompleteSummary group by territoryId, territory, priority, errCode order by priority, territory select * from qmd_priorities where priorityCode =
Customer Managers of Priority "#priority#" Operators are required to maintain the following profile fields: , #htmleditformat( profileElementDisplay( prfReq ) )#
#_html#
select sum( case when opr.profileComplete = 'Y' then 1 else 0 end )completeOperators, sum( case when opr.profileComplete = 'N' then 1 else 0 end )incompleteOperators, count( * ) totalOperators from tbl_OPR_ClientOperators opr where ( opr.oprType = or opr.oprType = '0' or nullif( opr.oprType, '' ) is null ) and opr.ownerId = and opr.fsltablecode = and opr.territoryId = and opr.crmActive = 'Y'
Territory "#priority#" Profiles Complete % Incomplete %
#htmleditformat( territory )# #lsnumberformat( qmd_operatorBreakDown.totalOperators )# #lsnumberformat( qmd_operatorBreakdown.completeOperators )# #lsnumberformat( qmd_operatorBreakdown.completeOperators / qmd_operatorBreakdown.totalOperators * 100)# #lsnumberformat( qmd_operatorBreakdown.incompleteOperators )# #lsnumberformat( qmd_operatorBreakdown.incompleteOperators / qmd_operatorBreakdown.totalOperators * 100)#
#profileElementDisplay( errCode, "error")# #lsnumberformat( profileCount/qmd_operatorBreakdown.incompleteOperators * 100 )#
No Primary Contact Contact Phone Contact Email Contact Title Contact Last Name Contact First Name Contact Job Function Company Name Address State City Zip/Postal Code Primary Segment Primary Distributor Classification Main Phone Incomplete Purchasing Profile #arguments.prfError#