WinPers Record Filters
Here are some record filter examples.
PPAN greater than 4800
PPANKey>4800
PPAN greater than 00014104
*You must use ( ) because PPAN is text due to leading zeroes.
PPAN>(00014104)
School District equals CLF30
SchoolDist='CLF30'
School District equals CLF30 or CLF20
SchoolDist in ('CLF30', 'CLF20')
Specific PPAN Comment
*Must use % as wild card.
Upper(PPAN.PublicComments) like '%2012 NO TAXPAYER RESPONSE - ESTIMATED%'
Specific Assess Year, Assess Date, and Changed By User.
AssessYear=2008 AND AssessDate='08/14/2008' AND ChangedBy='JAS'
Specific Assess Year, Assess Date Range, Changed Date Range, and Changed By User.
PPAN.AssessYear=2008 AND PPAN.AssessDate>='8/2/2008' AND PPAN.ChangedDate ⇐ '8/15/2008 23:59:59' AND PPAN.ChangedBy='JAS'
Specific Business Type
PPAN.BusinessType like '%LEASE VEHICLE%'
Specific Assess Year, Status, and Total Assessed Value Greater than or Equal to 150000
PPAN.AssessYear=2009 AND PPAN.Status='ACTIVE' AND PPAN.TotalAssessedValue>=150000
Specific Assess Year and Business Type Equal to New Business
PPAN.AssessYear=2008 AND Left(PPAN.BusinessType,14) = 'NEW BUSINESS'
Specific Assess Year, Status, Property Type, Business Type, Assess Name that contains Wheels
AssessYear=2009 AND Status='ACTIVE' AND PropType='C' AND BusinessType like '%LEASE%' AND AssessName like '%WHEELS%'
PPAN ASMT 2010, NO PROPERTY FO
(RPTvwAssessments.AssessYear=2010and not PRTvwAssessments.PPANKey in (select Property.PPANKey from Property where RPTvwAssessments.PPANKey=Property.PPANKey and year(Property.AssessDate)=2010))
BLANK TAXPAYER ID BY YEAR
PPAN.TaxpayerID is null AND PPAN.AssessYear=2008
BUSINESS ASMT REPORT
PPAN.AssessYear=2009 AND PPAN.AssessDate>='03/13/2009' AND PPAN.ChangedDate >= '03/01/2009 00:00:00' AND PPAN.ChangedDate ⇐ '03/19/2009 23:59:59' AND PPAN.ChangedBy='JKP'
BUSINESS FORMS MASS PRINT
PPAN.AssessYear=2009 AND PPAN.ChangedDate ⇐ '12-31-2009 23:59:59' AND not Upper(PPAN.OfficeComments) like '%BUSINESS FORM TO CUSTOMER%' AND not PPAN.BusinessType like '%LEASE%'
SPECIFIC ASSESS YEAR, BUSINESS TYPE, ASSESS DATE RANGE, STATUS
AssessYear=2006 AND BusinessType='UTILITY' AND AssessDate>='01/01/2006' AND AssessDate⇐'12/31/2006' AND Status='ACTIVE'
Check Asmts Record by date
PPAN.AssessYear=2008 AND PPAN.AssessDate>='1/12/2008' AND PPAN.ChangedDate ⇐ '1/25/2008 23:59:59' AND PPAN.ChangedBy='RHE'
ASMTS BY SPECIFIED RANGE 2009
PPAN.AssessYear=2008 AND PPAN.AssessDate>='11/12/2008' AND PPAN.ChangedDate >= '11/12/2008 00:00:00' AND Left(PPAN.AssessName,1) = 'O' AND PPAN.ChangedBy='JKP'
BUSINESSES LEASES
PPAN.BusinessType like '%LEASE%'
BUSINESSES NOT LEASES
not PPAN.BusinessType like '%LEASE%'
BLANK TAXPAYER ID IN A SPECIFIC YEAR
PPAN.TaxpayerID is null AND PPAN.AssessYear=2006
SPECIFIC ASSESS YEAR AND PPAN TYPE
PPAN.AssessYear=2011 AND PPAN.PPANType='U'
SPECIFIC ASSESS YEAR AND WHERE THE ASSESS NAME AND CHANGED DATE IS NOT BLANK
AssessYear>=2008 AND AssessName is not null AND ChangedDate is not null
SPECIFIC ASSESS YEAR, SCHOOL DISTRICT, AND TOTAL ASSESSED VALUE GREATER THAN 50000
PPAN.AssessYear=2008 AND PPAN.SchoolDist='082' AND PPAN.TotalAssessedValue>50000
BUSINESS ASSESSMENT 1 MILLION
999999 < (select sum(Property.AssessedValue) from Property where PPAN.PPANKey = Property.PPANKey) and PPAN.PPANType <> 'P'
SPECIFIC ASSESS YEAR AND PROPERTY TYPE
AssessYear=2007 AND PropType='2001 TOYOTA TUNDRA'
WHERE TAXPAYER ID IS BLANK AND ASSESS YEAR 2007
PPAN.TaxpayerID is null AND PPAN.AssessYear=2007
SPECIFIC ASSESS NAME AND STATUS
PPAN.AssessName like '%D L PETERSON%' AND PPAN.Status='ACTIVE'
Cloud Words
