Sample Associate Reports

These are sample reports of a successful Zane Benefits Associate.

AMC Member: Theresa Trimble

Customer Information
Name	Theresa Trimble
AMC Signup Date	02/18/2007
Address	555 Main Street New York, NY 14325
Phone	555-555-5555
Email	demo@nowhere.com

Payments by theresa trimble (demo)
Date	Amount	Commission
04/11/2007	$9.99	$2.00
03/11/2007	$9.99	$2.00
02/11/2007	$34.99	$17.00


[7.0E-5s] select AffiliateId from affiliate where IsDemo=2

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[0.0001s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[4.0E-5s] select * from affiliatelicense where AffiliateId = 36651

[4.0E-5s] select AffiliateId from affiliate where IsDemo=2

[5.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[4.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[0.02565s] select * from amccustomer where CustomerId=46309

[0.00684s] select * from amcpolicy 
						where CustomerId=46309 and (EndDate is null or EndDate > '2010-09-09 06:08:04')

[0.02796s] select SQL_CALC_FOUND_ROWS sum(paymentledger.Amount) as Commission, amcledger.Amount, amcledger.Date from amcledger
								left outer join paymentledger on paymentledger.RecordId=amcledger.LedgerId and paymentledger.Type like 'AMC%'
							where amcledger.CustomerId=46309 and amcledger.Amount<0
							group by amcledger.LedgerId
						order by Date desc limit 0, 25

[7.0E-5s] select FOUND_ROWS()