Membership, groups and price levels
Group
Season
Membership Type Code
Membership Type Description
Membership Category
Membership Category Description
Member Group Id
Member Group Description
Price Level Code
Price Level Description
Tier ID
MRC Members
Current
MRC
MRC Membership
<> MRC
1
MRC Members
2
100 Members
-2
Current
MMC
Mornington Membership
<> MRC
9
MMC Members
2
100 Members
-6
Current
SOC
Racing and Events Membership
<> MRC
10
Social Members
2
100 Members
-7
Current
LIF
Life Membership
<> MRC
11
Life Members
2
100 Members
-8
Current
VIP
VIP Honorary Membership
<> MRC
12
VIP Members
2
100 Members
-9
Current
PCM
Pegasus Club Membership
<> MRC
13
Pegasus Members
2
100 Members
-10
Current
CCM
Chairman's Club Membership
<> MRC
14
Chariman's Club Members
2
100 Members
-11
Current
CAS
Casual Membership
<> MRC
15
Casual Members
2
100 Members
-12
LIFE Members
All Seasons
LIF
Life Membership
<> MRC
11
Life Members
2
-8
Committee Members
Current
MRC
MRC Membership
==MRC
MRC Committee Member
1
MRC Members
2
-2
MRC Internal Accounts
ALL
EV870_ALPHA_SEARCH_KEY LIKE 'MRC%'
2
MRC Internal Accounts
18
100 Internal Staff Cost
-3
MRC Staff Accounts
ALL
Account Link = "POS" and Current Staff Card
Also include Committee department hold staff card
3
MRC Staff Account
18
100 Internal Staff Cost
-4
MRC Event Sales Accounts
ALL
NOT(A.EV870_ALPHA_SEARCH_KEY LIKE 'MRC%') AND NOT(A.EV870_ALPHA_SEARCH_KEY LIKE 'PAC-%')
4
MRC Event Sales Account
1
100 Public
5
POS Account Charge Cards
Current
Opportunity Type in ('1P', '1I' )
16
POS Account Charge Cards
1
100 Public
-13