User Tools

Site Tools


record_filter_winpers

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'

Back to Assessor Wiki Home || WinPers Home

Cloud Words

record_filter_winpers.txt · Last modified: 2017/04/21 13:58 (external edit)