SET_REQUIRED

Resource: Property, Field : BathroomsHalf

Description

BathroomsHalf is required if other bathroom fields are empty. BathroomsHalf is not required for Boat Slip or Deeded Parking.

Error Messages

1) ERROR, the property type and sub-type is valid and all other types of bathrooms are empty, indicate that the field is required.
2) ERROR, the property type and sub-type is valid and  update type is 'change' and all old bathroom values are empty, indicate that the field is required.

Fields referenced within this rule

BathroomsFull 

BathroomsHalf 

BathroomsOneQuarter 

BathroomsThreeQuarter 

PropertySubType 

PropertyType 

Syntax with comments and error messages

//[ErrMsg1^ERROR, the property type and sub-type is valid and all other types of bathrooms are empty, indicate that the field is required.|LogicBlk1^TRUE|LogicBlk2^TRUE|LogicBlk4^TRUE]
//[ErrMsg2^ERROR, the property type and sub-type is valid and update type is 'change' and all old bathroom values are empty, indicate that the field is required.|LogicBlk1^TRUE|LogicBlk3^TRUE|LogicBlk4^TRUE]
// Property type is 'residential' and...
(/*[LogicBlk1]*/PropertyType.IN.('Resi')).AND.
// all other types of bathrooms are empty or...
(/*[LogicBlk2]*/.NOT.((BathroomsFull != .EMPTY.).OR.(BathroomsOneQuarter != .EMPTY.).OR.(BathroomsThreeQuarter != .EMPTY.)).OR.
// the update action is 'change' and the last entry value is empty and other bathroom types are empty and...
(/*[LogicBlk3]*/(.UPDATEACTION..IN.('Change')).AND.((LASTBathroomsFull = .EMPTY.).AND.(LASTBathroomsThreeQuarter = .EMPTY.).AND.(.OLDVALUE. = .EMPTY.).AND.(LASTBathroomsOneQuarter = .EMPTY.)))).AND.
// the property sub-type is not of type 'boat slip' or 'deeded parking' and entry is empty.
(/*[LogicBlk4]*/(.NOT.(PropertySubType.IN.('BSLP','DDPK'))).AND.(.ENTRY. = .EMPTY.))

Syntax only

(PropertyType.IN.('Resi')).AND.(.NOT.((BathroomsFull != .EMPTY.).OR.(BathroomsOneQuarter != .EMPTY.).OR.(BathroomsThreeQuarter != .EMPTY.)).OR.((.UPDATEACTION..IN.('Change')).AND.((LASTBathroomsFull = .EMPTY.).AND.(LASTBathroomsThreeQuarter = .EMPTY.).AND.(.OLDVALUE. = .EMPTY.).AND.(LASTBathroomsOneQuarter = .EMPTY.)))).AND.((.NOT.(PropertySubType.IN.('BSLP','DDPK'))).AND.(.ENTRY. = .EMPTY.))

Rule Unique ID

a447460d-dbe1-4470-92ea-2b23a0a71a31

Rule Number

15