ACCEPT

Resource: Property, Field : EstimatedBuyerAgentStateLicense

Description

EstimatedBuyerAgentStateLicense must be valid.

Error Messages

1) ERROR, state license format is invalid for standard status values other than 'pending' or 'active under contract'.
2) ERROR, state license format is invalid, unexpected number of repeated digits.

Fields referenced within this rule

EstimatedBuyerAgentStateLicense 

StandardStatus 

Syntax with comments and error messages

//[ErrMsg1^ERROR, state license format is invalid for standard status values other than 'pending' or 'active under contract'.|LogicBlk1^TRUE|LogicBlk2^FALSE]
//[ErrMsg2^ERROR, state license format is invalid, unexpected number of repeated digits.|LogicBlk1^TRUE|LogicBlk2^TRUE|LogicBlk3^FALSE]
// If entry is not empty or has changed...
IIF((/*[LogicBlk1]*/(.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),
// Then check whether standard status is 'pending' or 'active under contract' and...
(/*[LogicBlk2]*/StandardStatus.IN.('P','U')).AND.
// verify entry does not contain digits repeated 7 to 20 times after removing any whitespace.
(/*[LogicBlk3]*/.NOT.MATCH('(^1{7,20}$)|(^2{7,20}$)|(^3{7,20}$)|(^4{7,20}$)|(^5{7,20}$)|(^6{7,20}$)|(^7{7,20}$)|(^8{7,20}$)|(^9{7,20}$)|(^0{7,20}$)',TRIM(.ENTRY.))),
// Else ACCEPT only if entry is empty.
.ENTRY. != .EMPTY.)

Syntax only

IIF(((.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),(StandardStatus.IN.('P','U')).AND.(.NOT.MATCH('(^1{7,20}$)|(^2{7,20}$)|(^3{7,20}$)|(^4{7,20}$)|(^5{7,20}$)|(^6{7,20}$)|(^7{7,20}$)|(^8{7,20}$)|(^9{7,20}$)|(^0{7,20}$)',TRIM(.ENTRY.))),.ENTRY. != .EMPTY.)

Rule Unique ID

ba5770a2-2fb2-4e51-9b49-e9719f7d8ba8

Rule Number

71