DVMs for Aristocrat Oasis
The following Data Value Mappings (DVMs) must be set up for the Aristocrat Oasis system. For details on how to create DVMs within OPERA Cloud, see Data Value Mappings in the OPERA Cloud Services documentation.
The below DVM values are for reference only and can vary by property.
Table 3-5 Address Type
| Address Name | Address Type |
|---|---|
|
Home |
1 |
|
Business |
2 |
|
Legal |
3 |
|
Mailing |
4 |
|
Physical |
5 |
|
Shipping |
6 |
|
Marketing |
7 |
Note:
Aristocrat requires "AddressType" column values.
Table 3-6 Phone Type
| Direction | Contact Type ID | |||
|---|---|---|---|---|
| Home | Business | Mobile | ||
|
OPERA > External |
1 |
1 |
2 |
3 |
|
External > OPERA |
P_1 |
E_1 |
P_2 |
P_3 |
Note:
Aristocrat requires "ContactTypeID" column values mapped for the OPERA > External row.
Note:
You are unable to configure the OPERA Data Value Mappings to translate both Home Email and Home Phone contact types to the same external code (this is 1) in both directions. Therefore, the Home Email must be configured to translate to '1' on the OPERA > External direction and must be configured to translate to 'E_1' on the External > OPERA directions. OIC will do the translation from '1' to 'E_1' from the Aristocrat response to do this workaround on the OPERA DVM. This same logic applies on the Home Phone as well.
Table 3-7 Document Type
| Identity Name | Ident ID |
|---|---|
|
Alien Registration |
A |
|
Drivers License |
D |
|
Military ID |
M |
|
SSN Card |
N |
|
Other |
O |
|
Passport |
P |
|
State ID |
S |
|
Voter ID |
V |
Note:
Aristocrat requires "IdentID" column values.
Table 3-8 Membership Level
| Code | Membership Level | Membership Level Description |
|---|---|---|
|
ARIS0 |
0 |
Evergreen |
Note:
Aristocrat requires "Membership Level" column values.
Table 3-9 Membership Type
| Membership Type |
|---|
|
PTS |
Note:
Aristocrat requires "Membership Type" column values.
Table 3-10 Title
| Title |
|---|
|
Dr. |
|
Miss |
|
Mr. |
|
Mrs. |
|
Ms. |
Note:
Aristocrat requires "Title" column values.
Table 3-11 States / Provinces
| State / Province Code | Country Code | State / Province Name |
|---|---|---|
|
CAN |
||
|
AB |
CAN |
Alberta |
|
BC |
CAN |
British Columbia |
|
MB |
CAN |
Manitoba |
|
NB |
CAN |
New Brunswick |
|
NL |
CAN |
Newfoundland and Labrador |
|
NS |
CAN |
Nova Scotia |
|
NT |
CAN |
Northwest Territories |
|
NU |
CAN |
Nunavut |
|
ON |
CAN |
Ontario |
|
PE |
CAN |
Prince Edward Island |
|
QC |
CAN |
Quebec |
|
SK |
CAN |
Saskatchewan |
|
YT |
CAN |
Yukon |
|
USA |
||
|
AK |
USA |
Alaska |
|
AL |
USA |
Alabama |
|
AR |
USA |
Arkansas |
|
AZ |
USA |
Arizona |
|
CA |
USA |
California |
|
CO |
USA |
Colorado |
|
CT |
USA |
Connecticut |
|
DC |
USA |
District of Columbia |
|
DE |
USA |
Delaware |
|
FL |
USA |
Florida |
|
GA |
USA |
Georgia |
|
HI |
USA |
Hawaii |
|
IA |
USA |
Iowa |
|
ID |
USA |
Idaho |
|
IL |
USA |
Illinois |
|
IN |
USA |
Indiana |
|
KS |
USA |
Kansas |
|
KY |
USA |
Kentucky |
|
LA |
USA |
Louisiana |
|
MA |
USA |
Massachusetts |
|
MD |
USA |
Maryland |
|
ME |
USA |
Maine |
|
MI |
USA |
Michigan |
|
MN |
USA |
Minnesota |
|
MO |
USA |
Missouri |
|
MS |
USA |
Mississippi |
|
MT |
USA |
Montana |
|
NC |
USA |
North Carolina |
|
ND |
USA |
North Dakota |
|
NE |
USA |
Nebraska |
|
NH |
USA |
New Hampshire |
|
NJ |
USA |
New Jersey |
|
NM |
USA |
New Mexico |
|
NV |
USA |
Nevada |
|
NY |
USA |
New York |
|
OH |
USA |
Ohio |
|
OK |
USA |
Oklahoma |
|
OR |
USA |
Oregon |
|
PA |
USA |
Pennsylvania |
|
RI |
USA |
Rhode Island |
|
SC |
USA |
South Carolina |
|
SD |
USA |
South Dakota |
|
TN |
USA |
Tennessee |
|
TX |
USA |
Texas |
|
UT |
USA |
Utah |
|
VA |
USA |
Virginia |
|
VT |
USA |
Vermont |
|
WA |
USA |
Washington |
|
WI |
USA |
Wisconsin |
|
WV |
USA |
West Virginia |
|
WY |
USA |
Wyoming |
Note:
Aristocrat requires "StateProvCode" column values. These values can change based on the geographical location of the property.
Parent topic: Aristocrat Oasis