Merge Profiles

To keep the OPERA database trim and up-to-date, to ensure accurate profile statistics, and to reduce staff confusion, use the Merge Profiles feature to combine (merge) duplicate profiles. See Merge Rules, below, for information on how profile data is managed in the merge process.

There are two basic ways to go about merging profiles.

• Merging a Single Profile into the Original Profile. Start by opening the original profile (the profile you want to keep). It is important that you start from the profile that you want to keep. From the Profile screen, select the Options button. The Profile Options screen appears. Select the Merge button. Next, you are prompted to search for the profile you want to merge into the original profile. When you have chosen the profile to merge into the original profile, the Merge Profile screen appears, allowing you to review data from the two profiles, side by side. Select the Merge button on the Profile Merge screen to proceed with the merge. Once the merge process is completed, the second profile — the profile you are merging into the original profile — will no longer exist. See Merging a Single Profile into the Original Profile, below, for details.
• Merging One or Multiple Profiles into the Original Profile. (This option is available when the Profiles>Advanced Profile Merge application function is set to Y.) Select Miscellaneous>Profile Merge option from the menu bar options. The Profile Merge - Advanced screen appears. Search for a list of the profiles that are candidates for merging using the search criteria presented on the screen. Select the profile that is to be the original profile (the profile you want to keep), then select the one or more profiles you wish to merge into the original profile. Finally, select the Merge button on the Profile Merge - Advanced screen to proceed with the merge. Once the merge process is completed, the profiles you are merging into the original profile will no longer exist. See Merging One or Multiple Profiles into the Original Profile, below, for details.

In PMS and ORS, users can merge individual (guest profiles) with contacts when the parameter Global>Profiles>Parameters>MERGE CONTACT WITH DIRECT GUEST is set to Y. The system will display contacts and merge the contact with the direct guest profile. When set to N, contacts will not display and a contact and guest profile cannot be merged.

In S&C, when the Attendee Management module is active (available when the application function Catering>ATTENDEE MANAGEMENT is set to Y) individual profiles can be linked as "attendees" to business blocks. When merging two profiles that are both linked to the same business block as attendees, the profile that was removed through the merge will also be removed from the profile links in the attendees tables on both the block and event level.

Merging a Single Profile into the Original Profile

Using the Profile Search screen, search for the profile that is to remain in your system (the original profile).

Highlight the original profile in the search grid and select the Edit button to display the original profile. From the Profile screen, select the Options button. The Profile Options screen appears. Select the Merge button.

The Profile Search (Merge) screen appears. (For more information on the search criteria and field descriptions of this screen, refer to the Profile Search Screen topic.)

Note: If the Profiles>Restrict Profile Name Change After Folio Creation application parameter is set to Y and a folio or invoice has been generated for the Payee and/or Guest, the Merge button will not be active as a Profile name can't be modified.

Profile Search (Merge) Screen

The Profile Search (Merge) screen appears after the Merge button has been selected from the Profile Options menu. Use this specialized Profile Search screen to locate the profile that you want to merge into the original profile. (If there are multiple profiles that you wish to merge into the original profile, each one must be merged separately using this process. Alternatively, see Merging One or Multiple Profiles into the Original Profile, below, for details on how to merge multiple profiles into the original profile.) When the Profiles>Advanced Profile Merge application parameter is set to Y, users will be taken directly to the Profile Merge - Advanced screen.

Note: On the Profile Search (Merge) Screen, the indicator lamps that get displayed for the highlighted profile are view-only and cannot be opened. Clicking on them will result in no action.

Highlight the profile that you want to merge into the original profile and select the OK button. The merge process begins by displaying the Profile Merge screen.

This screen shows the information from the original profile in the right (Original Profile) column and the profile to be merged into the original in the left (Profile To Merge) column. Following the merge, the merged profile in the left column will be deleted. Compare the information in both columns to make sure that you have selected the correct profiles for the merge before proceeding. (The merge action cannot be undone.)  Following is a description of the Profile Merge screen fields. (See Merge Rules, below, for an explanation of how profile data is handled in the merge process.)

Profile to Merge. This profile will no longer exist after the merge process.

Original Profile. This profile will continue to exist and will absorb all the contacts, activities, business blocks, reservations, stay details, and statistical information from the profile to merge.

Profile Merge Fields

Following is a description of the Profile Merge screen fields. (See Merge Rules, below, for an explanation of how profile data is handled in the merge process.)

Note: When an Account or Contact profile is merged, the following fields will also be merged with duplicates being discarded:
•Owner
•Rooms Potential
•Scope
•Scope City
•Action Code
•Business Segment
•Source
•Industry Code
•Competition Code

Name. Profile name.

Note: When the application parameter Profiles>Extended Account Name Search is set to Y an additional field, Name 2, is also available for a merge and displays directly under the Name field.

Alt. Name. When the General>Alternate Name application function is set to Y, the alternate name field appears and displays the alternate name for the profile, if previously entered in the profile.

Title. Title attached to this profile if it is an individual profile type.

Note: When merging profiles, if the Original Profile has a title, the Merged Profile will take the title of the Original Profile. However, if the Original Profile does not have a title and the Profile to Merge does have a title, the Merged Profile will take the title of the Profile to Merge. If neither the Original Profile nor the Profile to Merge has a title, then the Merged Profile will not take a title. In addition, if an Envelope Greeting and/or a Salutation is configured for the title, the Merged Profile will inherit this from the title.

Language. Language attached to this profile if it is an individual profile type.

Address 1. First line of the address for this profile's primary address.

Address 2. Second line of the address for this profile's primary address.

City. City for this profile's primary address.

State. State for this profile's primary address.

Country. Country for this profile's primary address.

Postal Code. Postal code for this profile's primary address.

Phone Number. Primary phone number for this profile.

Fax Number. Primary fax number for this profile.

Notes. Most recent note entered for this profile.

Membership No. Loyalty program membership number for this profile.

Note: When the OPP_GCA Comp Accounting license code is active, profiles may have a player ID (PTS membership ID) assigned. The PTS membership type is designated by the Comp Accounting>PTS Membership Type application setting. The fact that one or both of the profiles being merged have a player ID will not prevent the profiles from being merged.

VIP. VIP status of this profile.

Last Stay. Arrival date of this profile's last stay.

Rate Code. Negotiated rate(s) attached to this profile.

Select the Merge button to complete the merge.

Note: You cannot stop the merge process once you select the Merge button. You cannot undo a merge.

(If you decide not to perform the merge, select the Close button.) A screen displays messages as profile information is merged.

Merging One or Multiple Profiles into the Original Profile

This option is available when the Profiles>Advanced Profile Merge application function is set to Y. Select the Miscellaneous>Profile Merge option from the menu bar options. The Profile Merge - Advanced screen appears.

Search for a list of the profiles that will be candidates for the merge by entering your search options and selecting the Search button. All profiles that meet your search criteria will be displayed in the search results grid. Possible duplicates are highlighted in gray/white.

(See Merge Rules, below, for an explanation of how profile data is handled in the merge process.)

Search Criteria

Filter

Profile Type. Select the down arrow to choose a profile type: Individual, Company, Travel Agent, Source (available when the Profiles>Source application function is set to Y), Group, Contact, or View All. View All displays all profile types grouped by profile type.

Name. Enter the name you wish to search for. (Enter the last name for Individual or Contact profile types.) If you access the Profile Merge - Advanced screen by selecting the Merge button from the Profile Options menu for a given profile, the name of the profile appears here by default. You may change the name if you wish. OPERA will search on partial names as well as complete names. A partial name consists of one or more of the beginning characters of the name. (E.g., S, SM, SMI, and SMIT are all partial names for Smith, Smithe, Smithers, and so on.)

Use the % wildcard to stand for any one or more characters or spaces. (E.g., SM%TH represents Smith, Smythe, Smithe, Smithers, Smathers, Smithson, Smoothey, and so on.) OPERA ignores case in this field so you may use upper case, lower case, or a mix.

Example:

Assume all the following profiles have the same address:

1. Smith-Peterson Wedding

2. Smith-Petersen Wedding

3. Smith Wedding

4. Smith-Peterson's Wedding

The following advanced searches with Postal Code as the match criteria would have the following results:

Smith-Peterson% would return profiles 1 and 4 as possible duplicates

Smith%wedding would return profiles 1, 2, 3, and 4 as possible duplicates

%wedding% would return profiles 1, 2, 3, and 4 as possible duplicates

Smith-Peters% would return profiles 1, 2, and 4 as possible duplicates

First Name. Enter the first name of the Individual or Contact profile you wish to search for. (This field is not available for View All, Company, Travel Agent, Source, and Group profile types.) If you access the Profile Merge - Advanced screen by selecting the Merge button from the Profile Options menu for a given Individual or Contact profile, the first name of the profile appears here by default. You may change the name if you wish. OPERA will search on partial names as well as complete names. A partial name consists of one or more of the beginning characters of the name. (E.g., J, JO, and JOH, are all partial names for John, Johnathan, Johan, etc.) Use the % wildcard to stand for any one or more characters or spaces. (E.g., J%N represents Jan, Jean, Joann, John, Jonathan, and so on.) OPERA ignores case in this field so you may use upper case, lower case, or a mix.

If you leave the Name and First Name fields blank (i.e., a null value), and select the Member Number/Corp ID/IATA Profile option, OPERA will display all profiles that have matching values entered in the profile for Membership Number, Corporate ID, and/or IATA Number regardless of the name. If you enter name information (Name and/or First Name, full or partial) and then select the Member Number/Corp ID/IATA Profile option, all profiles with a possible match on both name and Membership Number, Corporate ID, and/or IATA Number would be displayed; blanks (i.e., null values) in the profile for Membership Number, Corporate ID, and/or IATA Number constitute a match.

Profile. Select the down arrow to make a single choice from the listed profile feature options.

• Name. Select this option to search for profiles having the same name along with any one or more options in the Match Criteria section. (At least one Match Criteria option must be chosen.)
• Member Number/Corp ID/IATA. Select this option to search for profiles having duplicate membership numbers (or for company and travel agent profiles, duplicate corporate ID numbers or IATA numbers). When you select this option, the Membership Type field becomes available. The options in the Match Criteria section become unavailable.
• Passport No. Select this option to search for profiles having duplicate passport numbers. The options in the Match Criteria section become unavailable.
• Credit Card. Select this option to search for profiles having duplicate credit card numbers. The options in the Match Criteria section become unavailable.
• Tax ID. Select this option to search for profiles having duplicate tax IDs. The options in the Match Criteria section become unavailable.
• Email. Select this option to search for profiles having duplicate e-mail addresses. The options in the Match Criteria section become unavailable.
• Phone. Select this option to search for profiles having duplicate phone numbers. The options in the Match Criteria section become unavailable. This is based on the Rule ‘Phone’ (i.e., if one profile has the number set as the home phone and another as the business phone, then as long as the rule type for home phone and business phone is PHONE, this will be found as a match). Also, this will find matches if the same number is entered in different formats, for example, 217.555.1010 and (217) 555-1010 will still be found as a match.
• Fax. Select this option to search for profiles having duplicate fax numbers. The options in the Match Criteria section become unavailable.

  Note: When Email, Phone, or Fax is selected, the Match Criteria section of the Profile Merge screen will be disabled.

Membership Type. Available when the Member Number/Corp ID/IATA Profile option is selected. Select the down arrow to choose the membership type(s) you wish to use to control the search for duplicate membership numbers.

Match Criteria

These options work in conjunction with the Name selection in the Profile search criteria. One or more of these options may be chosen.

Address 1. Select this check box to search for profiles with duplicate Address 1 information (first line of the address) for the primary address.

Address 2. Select this check box to search for profiles with duplicate Address 2 information (second line of the address) for the primary address.

City. Select this check box to search for profiles with duplicate City information on their primary address.

Postal Code. Select this check box to search for profiles with duplicate Postal Codes on their primary address.

Nationality. Select this check box to search for profiles with duplicate Nationality information.

Search Results Grid

The following columns are included in the search results grid. You may click on a column header to sort the display by that information. The column header is shown in green when it has been chosen as a sort option.

You may double-click on any record or highlight the record and select the Profile button to display the complete Profile screen.

Note: If you edit a profile which has been displayed by double-clicking on a profile record in the search results grid or by selecting the Profile button, the search results grid refreshes to reflect the change. Such changes will be taken into consideration by the matching criteria and the record may no longer be visible.

X. Click in this column to mark an X next to the profiles you want to have merged into the profile you select as the original profile. You may mark as many profiles as you like to be merged into the original profile. The profile(s) you mark with an X will be absorbed into the original profile and will no longer exist following the merge. Profiles can only be marked once an original profile has been selected. Only profiles of the same profile type may be marked.

Name. Profile name.

Type. Profile type. I = Individual, C = Company, G = Group, T = Travel Agent, CT = Contact, S = Source.

Mem. Type. Membership types associated with the profile.

Membership Number. Membership number for profiles associated with a loyalty, frequent flyer, or gaming program.

Client ID/IATA/Corp. No. Client ID, IATA number (for travel agent or source profiles) or Corporate number (for company profiles) associated with the profile.

Address 1. Address 1 information (first line of the address) for the primary address.

Address 2. Address 2 information (second line of the address) for the primary address.

City. City information on this profile's primary address.

Postal Code. Postal code for this profile's primary address.

State. State for this profile's primary address.

Country. Country for this profile's primary address.

Last Stay. Arrival date of the profile's last stay. (This information can help you identify the most up-to-date profile information when there are duplicates.)

Passport. Passport number associated with the profile.

Created In. Resort the profile was created in.

Note: By default, Passport Number and ID Number information is masked with X's except for the last two characters. If you have Profiles>View Sensitive Information on Profile permission, you may double-click on the field to see this information in clear text. When updating ID and Passport numbers with masked values, the user is expected to replace the entire string rather than parts and pieces of the masked value. This is because these fields accommodate alphanumeric characters and therefore, if the string is not replaced in its entirety, the masked values will be saved as X's.

Credit Card Number. Credit card number associated with the profile.

Nationality. Nationality associated with the profile.

Total Profiles retrieved. Displays the total number of Profiles showing in the grid.

Total Matches. Displays the number of matches of the Profiles showing in the grid.

Button Functions

Note: When the profile results are displayed in the search results grid, another option to select the Original Profile and Merge Profiles is to highlight them and right-click. By right-clicking on the profile in the grid, you will have the Original Profile and Profile to Merge options active when they are applicable and can be used.

Original. This button is available when the search results grid has been populated. To designate the original profile for your merge, highlight the profile record and select this button. The profile you designate as the original profile will have a yellow background. (In addition, when the original profile is highlighted, the word "Original" appears in blue text in the lower left-hand corner of the screen, below the grid.) Only one profile may be selected as the original profile. If you change your mind and wish to choose a different original profile, highlight your new choice for the original profile and again select the Original button.

Note: When you change your choice of the original profile, the last-selected original profile is no longer selected to be merged.

Note: When the profile you have chosen as the original is highlighted, selecting the Original button again undoes your selection of that profile as the original. Because an original profile must be selected in order to mark other profiles to be merged into the original, in this scenario any profiles you may have chosen to be merged into the original will be automatically unselected.

Merge. When you have selected an original profile and one or more profiles to merge into the original profile, this button becomes available. Select the Merge button to complete the merge process.

Note: When the Profile>Allow Duplicate IDS application parameter is set to N and there are multiple profile matches with a duplicate NAME_CODE (Client ID), users will be prompted that a duplicate name code exists. If a user ignores this warning, the duplicate will still exist. This scenario is most likely when a MINI profile is created for a reservation or activity, and the MINI profile carries a duplicate name code. Therefore, OPERA will force MINI profiles to merge into existing OCIS profiles.

Report. Select this button to prepare a Duplicate Profiles Report (prduplicateprofile.rep). The search criteria specified on the Profile Merge - Advanced screen are carried over to the report options screen. If no search criteria have been defined, the report options screen opens with the default values selected. You may change these options before running the report.

Note: When selecting the Email, Phone, or Fax option in the Profile drop-down, the selected option will replace the Nationality column on the report.

Advanced Merge Process

To merge one or more profiles into the original profile, use the search criteria on the Profile Merge - Advanced screen to list the candidates for merging. You may click on the search results grid column headers sort the results.

Once the search results have populated the search results grid, the Original button becomes available. Highlight the profile that is to be the original profile (the profile that will remain after other profiles have been merged into it) and select the Original button. The profile record you have chosen as the original profile will be highlighted in yellow to set it apart from the other profiles in your search results.

Note: An original profile must be selected before you can select other profiles to be merged into the original.

Now mark an X in the X column next to the one or more other profiles that you wish to merge into the original profile. The original profile, which is highlighted in yellow, may not be marked. You may scroll left and right to see the details associated with each profile, or you may double click on a profile record to display the complete profile. (See Merge Rules, below, for an explanation of how profile data is handled in the merge process.)

When you are ready, select the Merge button to complete the merge process. The profiles marked with an X will be absorbed into the original profile and will no longer exist following the merge.

Note: You cannot stop the merge process once you select the Merge button. You cannot undo a merge.

Messages will display as the merge progresses.

Following the merge, the profile record designated as the original profile will remain highlighted in yellow, and the profiles you selected to merge into the original profile will be highlighted in cyan (light blue).

You may select additional profiles to be merged into the original profile if you like. However, the already-merged profiles (in cyan) cannot be selected for merging and, if these profiles are highlighted, the Original button and the Profile button are unavailable.

The Merge button will become available once you have selected one or more still-existing profiles to be merged into the original.

If no additional matches were found after the initial merge, the original profile will no longer be displayed.

To modify which columns display in the grid, the grid can be customized by right-clicking on one of the column headers and choosing Modify Grid. The Grid Definition screen displays to select the desired columns and column order:

Highlight a Column Name and click the Edit button to edit the column, or click Delete to delete the column.

Merge Rules

The following rules govern how data is merged in the profile merge process:

Note: When the Advanced Profile Merge feature is used in PMS or S&C (see Merging One or Multiple Profiles into the Original Profile, above), and if there are multiple duplicate profiles being merged into the original profile, the selected duplicate profiles will be merged into the original profile in the order in which they are displayed on the search results grid.

For Name, Title, Language, and VIP, if the original profile has data in a compared field, it is kept and the corresponding data in the merged profile is disregarded. If the original profile does not have data in the compared field, and the merged profile does have data, the merged profile data is copied to the original profile. (When the General>Alternate Name application function is set to Y, the alternate name field appears and displays the alternate name, if previously entered in the profile. The alternate name helps identify the profile and is also merged).

For Address, Phone, Notes, and Rate Codes, more than one entry of each type can be stored for the profile. Therefore, information in the merged profile will be carried over to the original profile where it will join the data belonging to the original profile.

For Memberships, a profile can have multiple membership types associated with it. Therefore, if the merged profile has information for a membership type that is different from any of the membership types on the original profile, information in the merged profile will be carried over to the original profile where it will join the data belonging to the original profile. This is also the case if the profile is merged while in the process of creating or after a reservation has been created.

For Example

-Created a profile for Watkins, Daniel.

-Profile exists for Watkins, Dan with US Membership Type and Number.

-Created a reservation for Watkins, Daniel 12/01/11 – 12/02/11.

-Reservations>Profiles>Edit the profile for Watkins, Dan>Options>Merge>select the profile for Watkins, Daniel. Profile merge is successful.

-Reservations>Update Reservation>the name on the reservation has been changed to Watkins, Dan and the Membership Type and Number have been auto populated.

However, the following rules take effect if the original profile and the merged profile have the same membership type attached.

• If both profiles have the same membership type and both memberships are active, the merge is not allowed. The message "Merge is not allowed because the same membership type exists on both profiles" appears.
• If both profiles have the same membership type, and the original profile's membership is active while the profile being merged into the original is inactive, the merge is allowed.
• If both profiles have the same membership type, and the original profile's membership is inactive while the profile being merged into the original is active, the merge is not allowed if the membership numbers are the same. The message "Merge is not allowed because the same membership card number exists on both profiles" appears.
• When the Profiles>Update Reservations for Merged Membership Profiles application is set to Y, then future reservations will be updated with the "Merged To" profiles' membership details. But if this application parameter is set to N, any future reservations for the profiles being merged will retain the original membership details.

For Last Stay, the most recent stay date is kept. Stay details from both profiles are merged.

Note: Profiles cannot be merged if one of the profiles has an outstanding AR balance. In addition, travel agent profiles and source profiles cannot be merged if the two profiles have different bank accounts or if one or both profiles have pending unreconciled commission payments.

Note: In PMS environments where the OPX_ORS license is active, OPERA allows the merging of two travel agent or source profiles that have identical IATA numbers (assuming all merge criteria are met) regardless of the Profiles>Allow Duplicate IDs application parameter.

Example: Profile 2 is being merged to Profile 1 so that the name_id of Profile 2 will be changed to the name_id of Profile 1.

Profiles will not be merged if the following conditions exist:

• Profiles have different profile types (travel agent, company, etc.)
• When the Profiles>Merge Contact With Direct Guests application parameter is set to N, then a Contact profile can't be merged with another type of profile.
• E-Certificates with a status of Available exist on the Merge From (Profile 2) profile.
• E-Certificates exist on a reservation that has a status of RESERVED, CHECKED IN, PROSPECT for the Merge From (Profile 2) profiles.
• Merging a individual global profile that has the Privacy Flag selected with a individual global profile that does not have the Privacy Flag selected.
• When the General>Check Trustee Permission application function is set to Y, but the Account Merge permission has not been granted.
• Corporate Agreements exist for the Merge From (Profile 2) profile.
• The Merge To (Profile 1) profile is configured as a 'MINI' Profile.
• The Merge From (Profile 2) is an Application User Profile.
• When the Profiles>Allow Profile Merge With AR Accounts application parameter is set to Y and both the profiles have AR accounts in the same resort and there are transactions on the account of the Merge From (Profile 2) profile.
• When the Profiles>Allow Profile Merge With AR Accounts application parameter is set to N and the Merge From (Profile 2) profile has financial transactions for AR accounts in any resort.
• If either the Merge From (Profile 2) or Merge To (Profile 1) profiles are a Travel Agent or Company profile type, the Profiles>Allow Profile Merge With Commissions application parameter is set to Y, and the commission code and bank account for both the profiles are not the same in any resort. When the OPP_COM Commission Handling add-on license is active and the commission code has not been defined, then the default commission code and default bank account are used to compare.
• If either the Merge From (Profile 2) or Merge To (Profile 1) profiles are a Travel Agent or Company profile type, the Profiles>Allow Profile Merge With Commissions application parameter is set to Y, and the Merge From (Profile 2) profile has any pending reconciled payments or outstanding commissions when the OPP_COM Commission Handling add-on license is active.
• If either the Merge From (Profile 2) or Merge To (Profile 1) profiles are a Travel Agent or Company profile type, the Profiles>Allow Profile Merge With Commissions application parameter is set to Y, Negotiated Rate Commission Codes are for the same rate code for the two profiles, and are not the same in the same resort when the OPP_COM Commission Handling add-on license is active. If no commission code is setup, then the default commission code is used to compare.
• If either the Merge From (Profile 2) or Merge To (Profile 1) profiles are a Travel Agent or Company profile type and the commission record was sent to the IRS with a Tax filed status of 'Y' or 'M'.
• Virtual Numbers exist for the Merge From (Profile 2) profile.
• Circular Relationships exist between the two profiles.
• OVOS accounts – When the OPV_<version number> OPERA Vacation Ownership license is active, either one of the profiles is a Reserve, Owner, Revenue Pool, or is an OVOS Contract Account.

Merging Profiles with Memberships

The following scenarios occur in ORS/OCIS when merging profiles with memberships.

In the tables, X = no membership data. The name on the original profile will transfer to the merged profile (resulting profile). Membership transactions will also transfer to the merged profile.

Scenario 1

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	ABC	ORS278ESO	Active	TRX 1 TRX 2
Original Profile	X	X	X	X

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	ABC	ORS278ESO	Active	TRX 1 TRX 2

Scenario 2

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	ABC	ORS693DBD	Inactive	TRX 1 TRX 2
Original Profile	X	X	X	X

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	ABC	ORS693DBD	Inactive	TRX 1 TRX 2

Scenario 3

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	X	X	X	X
Original Profile	ABC	ORS760V71	Active	TRX 1 TRX 2

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	ABC	ORS760V71	Active	TRX 1 TRX 2

Scenario 4

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	X	X	X	X
Original Profile	ABC	ORS080M91	Inactive	TRX 1 TRX 2

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	ABC	ORS080M91	Inactive	TRX 1 TRX 2

Scenario 5

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	ABC	ORS264017	Active	TRX 1 TRX 2
Original Profile	ABC	ORS920L6C	Active	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	ABC	ORS920L6C	Active	TRX 1 TRX 2 TRX 3 TRX 4
Profile to Merge	ABC	ORS264017	Inactive	X

Scenario 6

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	ABC	ORS342A2C	Inactive	TRX 1 TRX 2
Original Profile	ABC	ORS449M6E	Active	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	ABC	ORS449M6E	Active	TRX 3 TRX 4
Profile to Merge	ABC	ORS342A2C	Inactive	TRX 1 TRX 2

Scenario 7

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	ABC	GHAJTEAOY309	Active	TRX 1 TRX 2
Original Profile	ABC	GHAWZV3IS622	Inactive	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Original Profile	ABC	GHAWZV3IS622	Inactive	TRX 3 TRX 4
Merged Profile	ABC	GHAJTEAOY309	Active	TRX 1 TRX 2

Note: The final few scenarios will use a different membership type. This membership type allows memberships with duplicate card numbers to be attached to a profile. This feature is enabled by selecting the "Allow duplicate card numbers" option in Membership Types Setup.

Scenario 8

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	XYZ	121234	Active	TRX 1 TRX 2
Original Profile	XYZ	121234	Active	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	XYZ	121234	Active	TRX 1 TRX 2 TRX 3 TRX 4

Scenario 9

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	XYZ	345345	Inactive	TRX 1 TRX 2
Original Profile	XYZ	345345	Active	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	XYZ	345345	Active	TRX 3 TRX 4

Scenario 10

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	XYZ	456456	Active	TRX 1 TRX 2
Original Profile	XYZ	456456	Inactive	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	XYZ	456456	Active	TRX 1 TRX 2

Scenario 11

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Profile to Merge	XYZ	678678	Inactive	TRX 1 TRX 2
Original Profile	XYZ	678678	Inactive	TRX 3 TRX 4

Result

Profile	Membership Type	Membership Card #	Membership Status	Membership Transactions
Merged Profile	XYZ	678678	Inactive	TRX 1 TRX 2 TRX 3 TRX 4

Merging Profiles with AR Accounts or Commissions

When the Profiles>Allow Profile Merge with AR Accounts application parameter is set to Y, merging profiles that have AR accounts in a single property or in different properties in a multi-property environment is possible. In order for the merge to complete, one or both of the profiles must meet certain criteria.

Merging from Profile 2 to Profile 1 - The merging of Profile 2 to Profile 1 will execute if:

• Merge From (Profile 2) profile does not have financial transactions for AR Account in any resort.

When the Profiles>Allow Profile Merge with AR Accounts application parameter is set to Y, merging profiles that have AR accounts in a single property or in different properties in a multi-property environment is possible. In order for the merge to complete, one or both of the profiles must meet certain criteria.

Merging from Profile 2 to Profile 1 - The merging of Profile 2 to Profile 1 will execute if:

• The "merge to" profile (Profile 1) does not have an AR Account. The "merge to" profile (Profile 1) inherits the AR Account of the "merge from" profile (Profile 2).

When the Profiles>Allow Profile Merge with Commissions application parameter is set to Y, merging profiles that have commissions in a single property or in different properties in a multi-property environment is possible. In order for the merge to complete, one or both of the profiles must meet certain criteria.

Profiles that have Negotiated Rates with Commission Codes

Merging from Profile 2 to Profile 1 - The merging of Profile 2 to Profile 1 will execute if:

• Both profiles have the same rate code attached to the same commission code. If the commission code on a negotiated rate code has not been defined for one profile, then the default commission code set by the Commission>Default Commission application setting will be used.

Profiles with Commission Bank Accounts and Commission Codes

Merging from Profile 2 to Profile 1 - The merging of Profile 2 to Profile 1 will execute if:

• The profiles have the same commission bank account and commission code. If the "merge to" profile (Profile 1) does not have a commission bank account assigned, then the "merge to" profile (Profile 1) inherits the "merge from" profile (Profile 2) commission bank account.

Profile Merge Screen - ORS

In ORS (when the OPR<version number>ORS license code is active), if certain settings are enabled, the system will accept duplicate profile name codes across chains. The Chain Ownership and Chain Ownership Profiles Types application settings must be defined, as below:

• Global>Profile>Function>CHAIN OWNERSHIP is activated and set to Y. When this function has been activated, you must define the profile type that you will allow to have duplicate name codes. (If this application function is set to N, duplicate name codes are not allowed.) After activating this function you will need to run a utility to synchronize chain codes with the profiles in OPERA. Access Utilities>Profile>Synchronize Chains.

  Note: When the General>ORS CM (hidden) and CRO>General>Generic CRO application parameters are set to Y, only profiles that have the same Chain code attached can be merged together. If two exact profiles exist, but have two different Chain codes attached, then the merge will not be completed.

• Global>Profile>Setting>CHAIN OWNERSHIP PROFILE TYPES must be defined for the type of profile you want to allow duplicate name codes, such as Company, Individual, Group, Primary Member, Source, or Travel Agent. If the setting is null, this indicates ALL profile types with duplicate name codes will be allowed.

In PMS & ORS, users can merge individual (guest profiles) with contacts when the parameter Global>Profiles>Parameters>MERGE CONTACT WITH DIRECT GUEST is set to Y. The system will display contacts and merge the contact with the direct guest profile. When set to N, contacts will not display and a contact and guest profile cannot be merged.

Profiles created through OPERA or the web, which have a Web User account attached to the OPERA profile, may now be merged as well through this process.

This screen contains three panels and is similar to the ORSMERGE Suspended Profiles three panel screen.

The center panel shows the information from the original profile (Original Profile).  The column to the left of the Original Profile contains the profile that was merged (Profile To Merge) into the original. Compare the information in both columns to make sure that you have selected the correct profiles for the merge before proceeding. (The merge action cannot be undone.)  The column on the right displays the results of the merged profile. You may make changes to the Merged Profile for standardization or corrections (with the exception of fields that are LOV-based, as OPERA does not validate against those fields). When you are confident you have the correct information in the Merged Profile fields, select the Merge button to insert the final data into the ORS database. You are returned to the newly merged profile.

Enter the guest's address (mailing address, city, postal code and extension, country, and state. Please note that if postal codes for the city, state, and country have been configured in Configuration>Profiles>Geographic Data>Cities and Postal Codes, if you enter an existing postal code the city and state will automatically populate. If you enter an existing postal code that exists for more than one city or state, the first city or state configured automatically populates; you can then change to the other configured city or state, if necessary. If you enter an existing postal code, but it doesn't match the current state, a message displays such as "Postal Code is not in the valid range." If you enter a postal code that has not been configured, you may enter any state and city without an error message.

Following is a description of the Profile Merge screen fields. (See Merge Rules, above, for an explanation of how profile data is handled in the merge process.)

Profile Merge Fields

P Checkbox. Indicates Primary address or Primary phone, where appropriate. For example, if you want the primary address in the Merged Profile to be that of the Profile to Merge or Original Profile address, select the P check box on either the Profile to Merge or Original Profile, and then on the Merged Profile.

I Checkbox. Inactive. Select this checkbox if the profile (or phone, or credit card, or other)  is inactive.

G Checkbox. Indicates if the preferences are Global.

Profile to Merge. This profile will no longer exist after the merge process.

Original Profile. This profile will absorb all the contacts, activities, business blocks, reservations, stay details, commissions, and statistical information from the profile to merge. The results of the Profile to Merge and the Original Profile is the Merged Profile.

Merged Profile. This profile is the result of the merge process, and will appear in the database for the profile.

Profile Merge Buttons

Merge. Select the Merge button to complete the merge. (If you decide not to perform the merge, select the Close button.) When complete, you will be returned to the profile containing all the merged data. If there is an overlapping negotiated rate between the PMS and ORS profile records, the Overlapping Negotiated Rate screen will open after the Merge button is selected. See below for more information on this screen.

Reset. Select this button to reset the data in the fields that you may have changed in the Merged Profile. The fields are restored to their status of when the screen first displayed (after the Merge button had been selected from the Profile Options menu).

Close. Select this button to close the Profile Merge screen without saving the Merged Profile.

Overlapping Negotiated Rate

After the Merge button is selected, the Overlapping Negotiated Rate screen opens whenever the incoming PMS profile has a negotiated rate that overlaps with the existing profile record in ORS/OCIS. From this screen, users can choose to either delete the PMS profile's negotiated rate and keep the ORS profile's negotiated rate (accomplished by selecting the Del. check box, which is selected by default) or keep the PMS profile's negotiated rate (accomplished by selecting the IFC check box). The negotiated rate that is selected will be the one on the merged profile. Users can select OK to complete the action.

Note: When the IFC check box is selected and a database ID does not exist, the database ID subscribed to the ORS profile will auto populate on the merged profile.

Show Me

Advanced Profile Merge

See Also

• Managing Accounts
• Create a New Account
• Searching for an Account
• Searching for Contacts