Нова схема типів аккаунтів.
MNCAR:
    1. Designated Realtor
    2. Realtor
    3. Secondary Member
    4. Senior Member
    5. Paid Non Member
    6. Institute Affiliate
    7. Designated Affiliate
MNCAR-L:
    1. Broker
    2. Affiliate
    3. EDC Affiliate
    4. EDC EDAM Affiliate
MISC:
    1. Alternate Association Member
    2. Staff
    3. Non-Member
    
######################################################################
# Список змін по яких були питання але зумів з ними справитися
######################################################################
---------------------------------------------------------------------
# BroadcastEmail. Recipients List.
---------------------------------------------------------------------
Стара схема:
    {Broadcast Options - checkboxes etc .}
    AND Stauts != "Inactive"
    
Нова схема (Task 9408#c0p2d):
    (
        Broadcast Options - checkboxes etc .
    ) AND (
        ( 
            MNCAR Member = (
                Designated Realtor, 
                Realtor, 
                Secondary Member, 
                Senior Member
            )
            AND MNCAR Status != Inactive
        ) OR (
            MNCAR-L Member = (Broker, EDC Affiliate, EDC EDAM Affiliate)
            AND MNCAR-L Status != Inactive
        ) OR (
            MISC Member = (Alternate Association Member, Staff)
            AND MISC Status != Inactive
        )
    ) AND (
        Allow MCPE Access = Yes
    )

---------------------------------------------------------------------
# GIS Mapping System. 
---------------------------------------------------------------------
Allo MCPE Access = Yes 
і хоча б один зі статусів має бути Active або Pending.

---------------------------------------------------------------------    
# Purchasable Member List 
---------------------------------------------------------------------    
Стара схема:
    Account Type = "MNCAR Member"
    MNCAR Member Type = (Designated Realtor, Realtor)
    Status = "Active" or "Pending"
    MCPE Access = Yes
    Access Type = Billable
Нова схема: 
    MNCAR Member = (Designated Realtor, Realtor)
    MNCAR Status = "Active" or "Pending"
    MCPE Access = Yes
    Access Type = Billable

   
---------------------------------------------------------------------    
# Member Profile. BIO CATEGORIES. Show/Edit
---------------------------------------------------------------------
Стара схема:
    Account Type = MNCAR Member
    MNCR Member Type = (Affiliate, EDC Affiliate) 
Нова схема:
    MNCAR-L Member = (Affiliate, EDC Affiliate) 
    
---------------------------------------------------------------------    
# Member Profile. TYPE OF BUSINESS. Show/Edit
---------------------------------------------------------------------
Стара схема:
    Account Type = MNCAR Member
    MNCR Member Type = (Affiliate, EDC Affiliate) 
Нова схема:
    MNCAR-L Member = (Affiliate, EDC Affiliate) 

---------------------------------------------------------------------    
# Member Profile. MCPE INFORMATION. Show/Edit
---------------------------------------------------------------------
Стара схема:
    (Account Type = "Alternate Association Member (Not a MNCAR Member)")
    OR (
        Account Type = MNCAR Member
        MNCR Member Type = (
            Designated Realtor,
            Realtor,
            Secondary,
            Senior,
            Staff,
            EDC Affiliate,
            EDC EDAM Affiliate,
        )
    )
    
Нова схема (Task 9408):
    (
        MNCAR Member = (
            Designated Realtor, 
            Realtor, 
            Secondary Member, 
            Senior Member
        ) 
    ) OR (
        MNCAR-L Member = (Broker, EDC Affiliate, EDC EDAM Affiliate)
    ) OR (
        Misc. Member = (Alternate Association Member, Staff, Non-Member)
    )
        
---------------------------------------------------------------------    
# Member Profile. Autocheck "Receive Focus" checkbox
---------------------------------------------------------------------
Автоматичне встановлення галочки працює лише при створенні нового аккаунта за умов наведених в колонці "T" XLS-фалу.

Автоматичне зняття галочки працює при створенні нового і при редагуванні існуючого аккаунта при невиконанні умов наведених в колонці "T" XLS-фалу.

Автоматичне встановлення або зняття галочки працює до тих пір поки не значення чекбокса не було змінено вручну.

######################################################################
# Список змін/питань які потребують відповіді
######################################################################
---------------------------------------------------------------------    
# Event Registration. Register Another Member Also. 
---------------------------------------------------------------------
Хто може бути Another Member'ом?
Стара схема:
    Account Type = "MNCAR Member" 
Нова схема: ???

---------------------------------------------------------------------    
# Member Bio. Show/Edit
---------------------------------------------------------------------
Стара схема:
    Account Type = all except "Alternate Association Member (Not a MNCAR Member)"
Нова схема: ???

---------------------------------------------------------------------
# DuesReport. 
---------------------------------------------------------------------
Стара схема:
    Account Type = "MNCAR Member"
    Status = "Active" or "Pending"
Нова схема: ???

---------------------------------------------------------------------
# ExchangeDuesReport. 
---------------------------------------------------------------------
Під час формування репорта обчислюються значення "non_members" i "members" (кількість мемберів і немемберів). 
При цьому "non_members" це люди з:
Стара схема:
    Account Type = "Alternate Association Member (Not a MNCAR Member)"
    Status = "Active" or "Pending"
Нова схема: ???

А "members" це люди з:
Стара схема:
    Account Type = "MNCAR Member"
    MNCR Member Type = (Designated Realtor, Realtor, Secondary, EDC Affiliate) 
    Status = "Active" or "Pending"
Нова схема: ???