Resource: Property, Field : ListAgentMlsId

Description

ListAgentMlsId must be an active member. Office assistants cannot have their own listings under their MLS Id. ListAgentMlsId must be within the same board.

Error Messages

1) ERROR, action 'Add/Insert', This Member is either Inactive or belongs to a User Class not permitted to be a lister.
2) ERROR, action 'Add/Insert', Office Assistant's may not have listings using their own ID as the Listing Agent.
3) ERROR, action 'Add/Insert', Listing Agent must be in the same Board.
4) ERROR, action 'Add/Insert', Office Assistant's may not have listings using their own ID as the Listing Agent.
5) ERROR, action 'Add/Insert', For non-agent staff, the user must be in the same office or main office as the listing agent.
6) ERROR, action 'Add/Insert', Office Assistant's may not enter listings using their own ID as the Listing Agent.
7) ERROR, action 'Add/Insert', An agent related staff member must match the ‘listing agent MLS ID’.
8) ERROR, action 'Add/Insert', the office assistant must be in the same office as the listing agent.
9) ERROR, action 'Add/Insert', the office assistants cannot enter listings under their ID.
10) ERROR, action 'Add/Insert', user is a personal assistant but not to the listing agent.
11) ERROR, action 'Add/Insert', listings cannot be entered under a personal assistant’s ID.
12) ERROR, action 'Add/Insert', a personal assistant ID cannot match the listing agent ID or the co-listing agent ID.
13) ERROR, action 'Change/Update', This Member is either Inactive or belongs to a User Class not permitted to be a lister.
14) ERROR, action 'Change/Update', Office Assistant's may not have listings using their own ID as the Listing Agent.
15) ERROR, action 'Change/Update', Listing Agent must be in the same Board.
16) ERROR, action 'Change/Update', Office Assistant's may not have listings using their own ID as the Listing Agent.
17) ERROR, action 'Change/Update', For non-agent staff, the user must be in the same office or main office as the listing agent.
18) ERROR, action 'Change/Update', Office Assistant's may not enter listings using their own ID as the Listing Agent.
19) ERROR, action 'Change/Update', An agent related staff member must match the ‘listing agent MLS ID’.
20) ERROR, action 'Change/Update', the office assistant must be in the same office as the listing agent.
21) ERROR, action 'Change/Update', the office assistants cannot enter listings under their ID.
22) ERROR, action 'Change/Update', user is a personal assistant but not to the listing agent.
23) ERROR, action 'Change/Update', listings cannot be entered under a personal assistant’s ID.
24) ERROR, action 'Change/Update', a personal assistant ID cannot match the listing agent ID or the co-listing agent ID.
25) ERROR, action 'Change/Update', Listing must remain with the same Originating System ID. List Agent must be a member of the same MLS Association.

Fields referenced within this rule

CoListAgentKeyNumeric Go To Definition

CoListAgentMlsId Go To Definition

CoListOfficeKeyNumeric Go To Definition

ListAgentKeyNumeric Go To Definition

ListAgentMlsId Go To Definition

OriginatingSystemID Go To Definition

StandardStatus Go To Definition

Syntax with comments and error messages

//[ErrMsg1^ERROR, action 'Add/Insert', This Member is either Inactive or belongs to a User Class not permitted to be a lister.|LogicBlk1a^TRUE|LogicBlk2a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg2^ERROR, action 'Add/Insert', Office Assistant's may not have listings using their own ID as the Listing Agent.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk3a^TRUE|LogicBlk4a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg3^ERROR, action 'Add/Insert', Listing Agent must be in the same Board.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk5a^TRUE|LogicBlk6a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg4^ERROR, action 'Add/Insert', Office Assistant's may not have listings using their own ID as the Listing Agent.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk5a^TRUE|LogicBlk7a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg5^ERROR, action 'Add/Insert', For non-agent staff, the user must be in the same office or main office as the listing agent.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk8a^TRUE|LogicBlk9a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg6^ERROR, action 'Add/Insert', Office Assistant's may not enter listings using their own ID as the Listing Agent.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk8a^TRUE|LogicBlk23a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg7^ERROR, action 'Add/Insert', An agent related staff member must match the ‘listing agent MLS ID’.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk10a^TRUE|LogicBlk11a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg8^ERROR, action 'Add/Insert', the office assistant must be in the same office as the listing agent.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk12a^TRUE|LogicBlk13a^FALSE|LogicBlk15a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg9^ERROR, action 'Add/Insert', the office assistants cannot enter listings under their ID.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk12a^TRUE|LogicBlk14a^FALSE|LogicBlk15a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg10^ERROR, action 'Add/Insert', user is a personal assistant but not to the listing agent.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk16a^TRUE|LogicBlk17a^FALSE|LogicBlk18a^TRUE|LogicBlk22g^FALSE]
//[ErrMsg11^ERROR, action 'Add/Insert', listings cannot be entered under a personal assistant’s ID.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk16a^TRUE|LogicBlk19a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg12^ERROR, action 'Add/Insert', a personal assistant ID cannot match the listing agent ID or the co-listing agent ID.|LogicBlk1a^TRUE|LogicBlk2a^TRUE |LogicBlk16a^TRUE|LogicBlk20a^FALSE|LogicBlk22g^FALSE]
//[ErrMsg13^ERROR, action 'Change/Update', This Member is either Inactive or belongs to a User Class not permitted to be a lister.|LogicBlk1b^TRUE|LogicBlk2b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg14^ERROR, action 'Change/Update', Office Assistant's may not have listings using their own ID as the Listing Agent.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk3b^TRUE|LogicBlk4b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg15^ERROR, action 'Change/Update', Listing Agent must be in the same Board.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk5b^TRUE|LogicBlk6b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg16^ERROR, action 'Change/Update', Office Assistant's may not have listings using their own ID as the Listing Agent.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk5b^TRUE|LogicBlk7b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg17^ERROR, action 'Change/Update', For non-agent staff, the user must be in the same office or main office as the listing agent.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk8b^TRUE|LogicBlk9b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg18^ERROR, action 'Change/Update', Office Assistant's may not enter listings using their own ID as the Listing Agent.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk8b^TRUE|LogicBlk23b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg19^ERROR, action 'Change/Update', An agent related staff member must match the ‘listing agent MLS ID’.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk10b^TRUE|LogicBlk11b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg20^ERROR, action 'Change/Update', the office assistant must be in the same office as the listing agent.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk12b^TRUE|LogicBlk13b^FALSE|LogicBlk15b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg21^ERROR, action 'Change/Update', the office assistants cannot enter listings under their ID.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk12b^TRUE|LogicBlk14b^FALSE|LogicBlk15b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg22^ERROR, action 'Change/Update', user is a personal assistant but not to the listing agent.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk16b^TRUE|LogicBlk17b^FALSE|LogicBlk18b^TRUE|LogicBlk22g^FALSE]
//[ErrMsg23^ERROR, action 'Change/Update', listings cannot be entered under a personal assistant’s ID.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk16b^TRUE|LogicBlk19b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg24^ERROR, action 'Change/Update', a personal assistant ID cannot match the listing agent ID or the co-listing agent ID.|LogicBlk1b^TRUE|LogicBlk2b^TRUE |LogicBlk16b^TRUE|LogicBlk20b^FALSE|LogicBlk22g^FALSE]
//[ErrMsg25^ERROR, action 'Change/Update', Listing must remain with the same Originating System ID. List Agent must be a member of the same MLS Association.|LogicBlk1b^TRUE|LogicBlk2b^TRUE|LogicBlk21b^FALSE|LogicBlk22g^FALSE]((/*[LogicBlk1a]*/.UPDATEACTION..IN.('Add')).AND.
// The listing agent's member status is 'Active' and the listing agent has listing creation/edit permissions
((/*[LogicBlk2a]*/(ROSTER("LA","MemberStatus").IN.('A')).AND.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA','OG','OD','PH','TP','ON','AP'))).AND.
// Office Assistant's may not have listings using their own ID as the Listing Agent.
((/*[LogicBlk3a]*/.USERCLASS..IN.('BANGG','BANGP','BANGQ')).AND.(/*[LogicBlk4a]*/.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.
// Listing Agent must be in the same Board
((/*[LogicBlk5a]*/.USERCLASS..IN.('BANGM','BANGN')).AND.(/*[LogicBlk6a]*/IIF(CoListAgentMlsId = .EMPTY.,ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR"),ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR").OR.ROSTER("UserData","MemberAOR") = ROSTER("COLA","MemberAOR"))).AND.
// Office Assistant's may not have listings using their own ID as the Listing Agent.
(/*[LogicBlk7a]*/.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.
// Non-agent staff, check that user is in the same office as the listing agent or the same main office or...
((/*[LogicBlk8a]*/.USERCLASS..IN.('DB','OM','HM','HB','AS','OA','CB')).AND.(/*[LogicBlk9a]*/(ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).OR.IIF(ROSTER("LO","MainOfficeKeyNumeric") = .EMPTY.,TRIM(UPPER(CHAR(ROSTER("UserData","OfficeMlsId")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeMlsId")))),TRIM(UPPER(CHAR(ROSTER("UserData","OfficeKeyNumeric")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeKeyNumeric"))))).OR.
// check the the user office is the same as the co-listing agent office and...
(ROSTER("UserData","OfficeKeyNumeric") = ROSTER("COLA","OfficeKeyNumeric"))).AND.
// Office Assistant's may not enter listings using their own ID as the Listing Agent...
(/*[LogicBlk23a]*/.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.
// Agent or related staff type access permissions and the user is the listing agent, listing agent assistant, or co-listing agent
((/*[LogicBlk10a]*/.USERCLASS..IN.('AG','HA','AS','CA')).AND.(/*[LogicBlk11a]*/(UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(.ENTRY.))).OR.(UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo"))).AND..NOT.(ROSTER("UserData","MemberIsAssistantTo") = .EMPTY.)).OR.(UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(CoListAgentMlsId))))).OR.
// Office Assistant's may not enter listings using their own ID as the Listing Agent and ...
((/*[LogicBlk12a]*/.USERCLASS..IN.('OA')).AND.((/*[LogicBlk13a]*/ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).AND.
// member login does not match the listing agent MLS ID or…
(/*[LogicBlk14a]*/UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) != UPPER(.ENTRY.))).OR.
// the user is not the co-listing agent and the user is not the listing agent, but the user is in the same office or...
(/*[LogicBlk15a]*/IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))).AND.(ROSTER("UserData","OfficeKeyNumeric") = CoListOfficeKeyNumeric))).OR.
// the user permission access is of type personal assistant and…
((/*[LogicBlk16a]*/.USERCLASS..IN.('PA')).AND.
// the Listing Agent MLS ID matches the user’s assistant ID and…
(/*[LogicBlk17a]*/UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo")))).AND.(/*[LogicBlk18a]*/ROSTER("UserData","MemberIsAssistantTo") != .EMPTY.).AND.
// Personal Assistant's may not enter listings using their own ID as the Listing Agent...
(/*[LogicBlk19a]*/UPPER(ROSTER("UserData","MemberLoginId")) != UPPER(.ENTRY.)).AND.(/*[LogicBlk20a]*/IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))))))).OR.
// If action is change/update and …
((/*[LogicBlk1b]*/.UPDATEACTION..IN.('Change')).AND.
// The listing agent's member status is 'Active' and the listing agent has listing creation/edit permissions
((/*[LogicBlk2b]*/(ROSTER("LA","MemberStatus").IN.('A')).AND.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA','OG','OD','PH','TP','ON','AP'))).AND.
// Office Assistant's may not have listings using their own ID as the Listing Agent.
((/*[LogicBlk3b]*/.USERCLASS..IN.('BANGG','BANGP','BANGQ')).AND.(/*[LogicBlk4b]*/.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.
// Listing Agent must be in the same Board
((/*[LogicBlk5b]*/.USERCLASS..IN.('BANGM','BANGN')).AND.(/*[LogicBlk6b]*/IIF(CoListAgentMlsId = .EMPTY.,ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR"),ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR").OR.ROSTER("UserData","MemberAOR") = ROSTER("COLA","MemberAOR"))).AND.
// Error: Office Assistant's may not have listings using their own ID as the Listing Agent.
(/*[LogicBlk7b]*/.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.
// Non-agent staff, check that user is in the same office as the listing agent or the same main office
((/*[LogicBlk8b]*/.USERCLASS..IN.('DB','OM','HM','HB','AS','OA','CB')).AND.(/*[LogicBlk9b]*/(ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).OR.IIF(ROSTER("LO","MainOfficeKeyNumeric") = .EMPTY.,TRIM(UPPER(CHAR(ROSTER("UserData","OfficeMlsId")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeMlsId")))),TRIM(UPPER(CHAR(ROSTER("UserData","OfficeKeyNumeric")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeKeyNumeric"))))).OR.(ROSTER("UserData","OfficeKeyNumeric") = ROSTER("COLA","OfficeKeyNumeric"))).AND.
// Office Assistant's may not have listings using their own ID as the Listing Agent.
(/*[LogicBlk23b]*/.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.
// Agent or related staff type access permissions and the user is the listing agent, listing agent assistant, or co-listing agent
((/*[LogicBlk10b]*/.USERCLASS..IN.('AG','HA','AS','CA')).AND.(/*[LogicBlk11b]*/(UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(.ENTRY.))).OR.UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo"))).AND..NOT.(ROSTER("UserData","MemberIsAssistantTo") = .EMPTY.).OR.((UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(CoListAgentMlsId))).AND.(CoListOfficeKeyNumeric = ROSTER("COLA","OfficeKeyNumeric").AND.(LASTCoListOfficeKeyNumeric = CoListOfficeKeyNumeric))))).OR.
// Office Assistant's may not enter listings using their own ID as the Listing Agent...
((/*[LogicBlk12b]*/.USERCLASS..IN.('OA')).AND.((/*[LogicBlk13b]*/ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).AND.
// User is not the listing agent or...
(/*[LogicBlk14b]*/UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) != UPPER(.ENTRY.))).OR.
// User key is not same as co-list agent key and is not same as list agent key and user offfice is the same as co-list agent office or...
(/*[LogicBlk15b]*/IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))).AND.(ROSTER("UserData","OfficeKeyNumeric") = CoListOfficeKeyNumeric))).OR.((/*[LogicBlk16b]*/.USERCLASS..IN.('PA')).AND.
// the Listing Agent MLS ID matches the user’s assistant ID and…
(/*[LogicBlk17b]*/UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo")))).AND.
// If the user has an assistant defined...
(/*[LogicBlk18b]*/ROSTER("UserData","MemberIsAssistantTo") != .EMPTY.).AND.
// Then is the user not the list agent and...
(/*[LogicBlk19b]*/UPPER(ROSTER("UserData","MemberLoginId")) != UPPER(.ENTRY.)).AND.
// If the co-list agent key is empty, then return true, otherwise make sure the user key does not match that of the co-agent or agent and...
(/*[LogicBlk20b]*/IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))).AND.
//
((CoListOfficeKeyNumeric = ROSTER("COLA","OfficeKeyNumeric")).AND.(LASTCoListOfficeKeyNumeric = CoListOfficeKeyNumeric)))).AND.
// Listing must remain with the same Originating System ID. List Agent must be a member of the same MLS Association.
(/*[LogicBlk21b]*/(LASTOriginatingSystemID = ROSTER("LA","OriginatingSystemId")).OR.(.USERCLASS..IN.('BANGG','BANGP','BANGQ'))))).OR.
// Grandfather clause...
(/*[LogicBlk22g]*/(.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus = 'I').AND.StandardStatus.IN.('A','P')))

Syntax only

((.UPDATEACTION..IN.('Add')).AND.(((ROSTER("LA","MemberStatus").IN.('A')).AND.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA','OG','OD','PH','TP','ON','AP'))).AND.((.USERCLASS..IN.('BANGG','BANGP','BANGQ')).AND.(.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.((.USERCLASS..IN.('BANGM','BANGN')).AND.(IIF(CoListAgentMlsId = .EMPTY.,ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR"),ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR").OR.ROSTER("UserData","MemberAOR") = ROSTER("COLA","MemberAOR"))).AND.(.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.((.USERCLASS..IN.('DB','OM','HM','HB','AS','OA','CB')).AND.((ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).OR.IIF(ROSTER("LO","MainOfficeKeyNumeric") = .EMPTY.,TRIM(UPPER(CHAR(ROSTER("UserData","OfficeMlsId")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeMlsId")))),TRIM(UPPER(CHAR(ROSTER("UserData","OfficeKeyNumeric")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeKeyNumeric"))))).OR.(ROSTER("UserData","OfficeKeyNumeric") = ROSTER("COLA","OfficeKeyNumeric"))).AND.(.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.((.USERCLASS..IN.('AG','HA','AS','CA')).AND.((UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(.ENTRY.))).OR.(UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo"))).AND..NOT.(ROSTER("UserData","MemberIsAssistantTo") = .EMPTY.)).OR.(UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(CoListAgentMlsId))))).OR.((.USERCLASS..IN.('OA')).AND.((ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).AND.(UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) != UPPER(.ENTRY.))).OR.(IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))).AND.(ROSTER("UserData","OfficeKeyNumeric") = CoListOfficeKeyNumeric))).OR.((.USERCLASS..IN.('PA')).AND.(UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo")))).AND.(ROSTER("UserData","MemberIsAssistantTo") != .EMPTY.).AND.(UPPER(ROSTER("UserData","MemberLoginId")) != UPPER(.ENTRY.)).AND.(IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))))))).OR.((.UPDATEACTION..IN.('Change')).AND.(((ROSTER("LA","MemberStatus").IN.('A')).AND.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA','OG','OD','PH','TP','ON','AP'))).AND.((.USERCLASS..IN.('BANGG','BANGP','BANGQ')).AND.(.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.((.USERCLASS..IN.('BANGM','BANGN')).AND.(IIF(CoListAgentMlsId = .EMPTY.,ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR"),ROSTER("UserData","MemberAOR") = ROSTER("LA","MemberAOR").OR.ROSTER("UserData","MemberAOR") = ROSTER("COLA","MemberAOR"))).AND.(.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.((.USERCLASS..IN.('DB','OM','HM','HB','AS','OA','CB')).AND.((ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).OR.IIF(ROSTER("LO","MainOfficeKeyNumeric") = .EMPTY.,TRIM(UPPER(CHAR(ROSTER("UserData","OfficeMlsId")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeMlsId")))),TRIM(UPPER(CHAR(ROSTER("UserData","OfficeKeyNumeric")))) = TRIM(UPPER(CHAR(ROSTER("LO","MainOfficeKeyNumeric"))))).OR.(ROSTER("UserData","OfficeKeyNumeric") = ROSTER("COLA","OfficeKeyNumeric"))).AND.(.NOT.(ROSTER("LA","MemberMlsSecurityClass").IN.('PA','OA')))).OR.((.USERCLASS..IN.('AG','HA','AS','CA')).AND.((UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(.ENTRY.))).OR.UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo"))).AND..NOT.(ROSTER("UserData","MemberIsAssistantTo") = .EMPTY.).OR.((UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) = UPPER(CHAR(CoListAgentMlsId))).AND.(CoListOfficeKeyNumeric = ROSTER("COLA","OfficeKeyNumeric").AND.(LASTCoListOfficeKeyNumeric = CoListOfficeKeyNumeric))))).OR.((.USERCLASS..IN.('OA')).AND.((ROSTER("UserData","OfficeKeyNumeric") = ROSTER("LA","OfficeKeyNumeric")).AND.(UPPER(CHAR(ROSTER("UserData","MemberLoginId"))) != UPPER(.ENTRY.))).OR.(IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))).AND.(ROSTER("UserData","OfficeKeyNumeric") = CoListOfficeKeyNumeric))).OR.((.USERCLASS..IN.('PA')).AND.(UPPER(CHAR(.ENTRY.)) = UPPER(CHAR(ROSTER("UserData","MemberIsAssistantTo")))).AND.(ROSTER("UserData","MemberIsAssistantTo") != .EMPTY.).AND.(UPPER(ROSTER("UserData","MemberLoginId")) != UPPER(.ENTRY.)).AND.(IIF(CoListAgentKeyNumeric = .EMPTY.,.TRUE.,(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(CoListAgentKeyNumeric)).AND.(CHAR(ROSTER("UserData","MemberKeyNumeric")) != CHAR(ListAgentKeyNumeric))).AND.((CoListOfficeKeyNumeric = ROSTER("COLA","OfficeKeyNumeric")).AND.(LASTCoListOfficeKeyNumeric = CoListOfficeKeyNumeric)))).AND.((LASTOriginatingSystemID = ROSTER("LA","OriginatingSystemId")).OR.(.USERCLASS..IN.('BANGG','BANGP','BANGQ'))))).OR.((.ENTRY. = .OLDVALUE.).AND..NOT.((LASTStandardStatus = .EMPTY..OR.LASTStandardStatus = 'I').AND.StandardStatus.IN.('A','P')))

Rule Unique ID

c1e1be2c-940d-4f6a-aab1-ac18d4c01743

Rule Number

112