Sample Associate Reports

These are sample reports of a successful Zane Benefits Associate.

AMC Member: Monica Warden

Customer Information
Name	Monica Warden
AMC Signup Date	11/21/2006
Address	555 Main Street New York, NY 14325
Phone	555-555-5555
Email	demo@nowhere.com

Payments by monica warden (demo)
Date	Amount	Commission
04/14/2007	$19.99	$4.00
03/14/2007	$19.99	$4.00
02/14/2007	$19.99	$4.00
01/14/2007	$19.99	$4.00
12/14/2006	$19.99	$4.00
11/14/2006	$44.99	$19.00


[5.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

[5.0E-5s] 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

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

[6.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.02736s] select * from amccustomer where CustomerId=43119

[0.00483s] select * from amcpolicy 
						where CustomerId=43119 and (EndDate is null or EndDate > '2010-09-09 06:03:03')

[0.02934s] 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=43119 and amcledger.Amount<0
							group by amcledger.LedgerId
						order by Date desc limit 0, 25

[7.0E-5s] select FOUND_ROWS()