Resource: Property, Field : ParcelNumber

Description

ParcelNumber must be in a valid county format.

Error Messages

1) ERROR, Los Angeles county 'parcel number' formatting requires exactly 10 digits.
2) ERROR, Riverside county 'parcel number' formatting requires exactly 9 or 13 digits.
3) ERROR, San Bernardino county 'parcel number' formatting requires exactly 9 digits, a lowercase letter or digit, and 3 digits.
4) ERROR, Orange county 'parcel number' formatting requires exactly 8 digits.
5) ERROR, Ventura county 'parcel number' formatting requires exactly 10 digits.
6) ERROR, San Diego county 'parcel number' formatting requires exactly 10 digits.
7) ERROR, Dashes are invalid within the 'parcel number' for the associated county.
8) ERROR, Amador county 'parcel number' formatting requires exactly 12 digits.
9) ERROR, Butte county 'parcel number' formatting requires exactly 12 digits.
10) ERROR, Invalid 'property type'.
11) ERROR, 'parcel number' cannot be all zeros or all nines.
12) ERROR, 'parcel number' cannot be all spaces.

Fields referenced within this rule

CountyOrParish Go To Definition

ParcelNumber Go To Definition

PropertyType Go To Definition

StandardStatus Go To Definition

Syntax with comments and error messages

//[ErrMsg1^ERROR, Los Angeles county 'parcel number' formatting requires exactly 10 digits.|LogicBlk1^TRUE|LogicBlk2^TRUE|LogicBlk3^FALSE]
//[ErrMsg2^ERROR, Riverside county 'parcel number' formatting requires exactly 9 or 13 digits.|LogicBlk1^TRUE|LogicBlk4^TRUE|LogicBlk5^FALSE]
//[ErrMsg3^ERROR, San Bernardino county 'parcel number' formatting requires exactly 9 digits, a lowercase letter or digit, and 3 digits.|LogicBlk1^TRUE|LogicBlk6^TRUE|LogicBlk7^FALSE]
//[ErrMsg4^ERROR, Orange county 'parcel number' formatting requires exactly 8 digits.|LogicBlk1^TRUE|LogicBlk8^TRUE|LogicBlk9^FALSE]
//[ErrMsg5^ERROR, Ventura county 'parcel number' formatting requires exactly 10 digits.|LogicBlk1^TRUE|LogicBlk10^TRUE|LogicBlk11^FALSE]
//[ErrMsg6^ERROR, San Diego county 'parcel number' formatting requires exactly 10 digits.|LogicBlk1^TRUE|LogicBlk12^TRUE|LogicBlk13^FALSE]
//[ErrMsg7^ERROR, Dashes are invalid within the 'parcel number' for the associated county.|LogicBlk1^TRUE|LogicBlk14^TRUE|LogicBlk15^FALSE]
//[ErrMsg8^ERROR, Amador county 'parcel number' formatting requires exactly 12 digits.|LogicBlk1^TRUE|LogicBlk16^TRUE|LogicBlk17^FALSE|LogicBlk18^FALSE]
//[ErrMsg9^ERROR, Butte county 'parcel number' formatting requires exactly 12 digits.|LogicBlk1^TRUE|LogicBlk19^TRUE|LogicBlk20^FALSE|LogicBlk21^FALSE]
//[ErrMsg10^ERROR, Invalid 'property type'.|LogicBlk22^FALSE|LogicBlk23^FALSE|LogicBlk24^FALSE]
//[ErrMsg11^ERROR, 'parcel number' cannot be all zeros or all nines.|LogicBlk25^FALSE|LogicBlk26^FALSE]
//[ErrMsg12^ERROR, 'parcel number' cannot be all spaces.|LogicBlk27^FALSE|LogicBlk28^FALSE]
// If entry is not empty validate the 'parcel number' format based upon county formatting requirements and ...
IIF((/*[LogicBlk1]*/.ENTRY. != .EMPTY.),((/*[LogicBlk2]*/CountyOrParish.IN.('LA')).AND.(/*[LogicBlk3]*/MATCH('^\d{10}$',.ENTRY.))).OR.((/*[LogicBlk4]*/CountyOrParish.IN.('RI')).AND.(/*[LogicBlk5]*/MATCH('^\d{9}$',.ENTRY.).OR.MATCH('^\d{13}$',.ENTRY.))).OR.((/*[LogicBlk6]*/CountyOrParish.IN.('SB')).AND.(/*[LogicBlk7]*/MATCH('^\d{9}[a-z0-9]\d{3}$',.ENTRY.))).OR.((/*[LogicBlk8]*/CountyOrParish.IN.('OR')).AND.(/*[LogicBlk9]*/MATCH('^\d{8}$',.ENTRY.))).OR.((/*[LogicBlk10]*/CountyOrParish.IN.('VE')).AND.(/*[LogicBlk11]*/MATCH('^\d{10}$',.ENTRY.))).OR.((/*[LogicBlk12]*/CountyOrParish.IN.('SD')).AND.(/*[LogicBlk13]*/MATCH('^\d{10}$',.ENTRY.))).OR.((/*[LogicBlk14]*/.NOT.(CountyOrParish.IN.('LA','OR','RI','SB','SD','VE','AMA','BUT'))).AND.(/*[LogicBlk15]*/.NOT.(.ENTRY..CONTAINS.('-')))).OR.((/*[LogicBlk16]*/CountyOrParish.IN.('AMA')).AND.((/*[LogicBlk17]*/MATCH('^\d{12}$',.ENTRY.)).OR.(/*[LogicBlk18]*/(.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P'))))).OR.((/*[LogicBlk19]*/CountyOrParish.IN.('BUT')).AND.((/*[LogicBlk20]*/MATCH('^\d{12}$',.ENTRY.)).OR.(/*[LogicBlk21]*/(.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P'))))),.TRUE.).AND.
// Administrator bypass or...
(/*[LogicBlk22]*/.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ').OR.
// 'property type' is valid or...
(/*[LogicBlk23]*/(PropertyType.IN.('Resi').AND.(/* No Duplicate Active */.TRUE.)).OR.(PropertyType.IN.('Rlse').AND.(/* No Duplicate Active */.TRUE.)).OR.(PropertyType.IN.('Rinc').AND.(/* No Duplicate Active */.TRUE.)).OR.(PropertyType.IN.('Land').AND.(/* No Duplicate Active */.TRUE.)).OR.(PropertyType.IN.('Manu').AND.(/* No Duplicate Active */.TRUE.)).OR.PropertyType.IN.('Comm','Clse','Busop')).OR.
// grandfather clause and...
(/*[LogicBlk24]*/(.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P')))).AND.
// 'parcel number' is not all zeros or all nines or grandfather clause and...
((/*[LogicBlk25]*/.NOT.(MATCH('^9{8,13}$',.ENTRY.).OR.MATCH('^0{8,13}$',.ENTRY.))).OR.(/*[LogicBlk26]*/(.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P')))).AND.
// 'parcel number' is not all spaces or grandfather clause.
((/*[LogicBlk27]*/TRIM(.ENTRY.) != .EMPTY.).OR.(/*[LogicBlk28]*/(.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P'))))

Syntax only

IIF((.ENTRY. != .EMPTY.),((CountyOrParish.IN.('LA')).AND.(MATCH('^\d{10}$',.ENTRY.))).OR.((CountyOrParish.IN.('RI')).AND.(MATCH('^\d{9}$',.ENTRY.).OR.MATCH('^\d{13}$',.ENTRY.))).OR.((CountyOrParish.IN.('SB')).AND.(MATCH('^\d{9}[a-z0-9]\d{3}$',.ENTRY.))).OR.((CountyOrParish.IN.('OR')).AND.(MATCH('^\d{8}$',.ENTRY.))).OR.((CountyOrParish.IN.('VE')).AND.(MATCH('^\d{10}$',.ENTRY.))).OR.((CountyOrParish.IN.('SD')).AND.(MATCH('^\d{10}$',.ENTRY.))).OR.((.NOT.(CountyOrParish.IN.('LA','OR','RI','SB','SD','VE','AMA','BUT'))).AND.(.NOT.(.ENTRY..CONTAINS.('-')))).OR.((CountyOrParish.IN.('AMA')).AND.((MATCH('^\d{12}$',.ENTRY.)).OR.((.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P'))))).OR.((CountyOrParish.IN.('BUT')).AND.((MATCH('^\d{12}$',.ENTRY.)).OR.((.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P'))))),.TRUE.).AND.(.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ').OR.((PropertyType.IN.('Resi').AND.(.TRUE.)).OR.(PropertyType.IN.('Rlse').AND.(.TRUE.)).OR.(PropertyType.IN.('Rinc').AND.(.TRUE.)).OR.(PropertyType.IN.('Land').AND.(.TRUE.)).OR.(PropertyType.IN.('Manu').AND.(.TRUE.)).OR.PropertyType.IN.('Comm','Clse','Busop')).OR.((.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P')))).AND.((.NOT.(MATCH('^9{8,13}$',.ENTRY.).OR.MATCH('^0{8,13}$',.ENTRY.))).OR.((.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P')))).AND.((TRIM(.ENTRY.) != .EMPTY.).OR.((.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus.IN.('I')).AND.StandardStatus.IN.('A','P'))))

Rule Unique ID

d154794a-dc74-494e-b306-5c222ca6ace3

Rule Number

161