Membership Exports

You can export membership data from the OPERA database into files and use these files for various purposes depending upon your needs. For example, if you have a loyalty program, you can export membership statements to a data file that can be sent to a fulfillment house for the processing of membership points.

The following export types can be used for Membership exports:
  • General ‒ This option enables you to export commonly used data from existing templates. These export files are pre-configured and can be modified.

  • Membership Export ‒ This option enables you to export data related to memberships, membership points, and membership statements.

The following Membership Export file types can be selected for the membership export. These are available in OPERA as system integrated data (SID).

Table 7-3 File Types

File Type Description

BA EXPORT

British Airways Export

CI EXPORT

China Airlines Export

CX EXPORT

Cathay Pacific Airlines Export

FF EXPORT

Frequent Flyer Export

FF EXPORT PC

Frequent Flyer Export

GL1 EXPORT

Airline Guests Reservations Export

GV1 EXPORT

Gold Passport Reservations Export

MEM EXPORT

Membership Fulfillment Production Export

OCIS AMERICAN

OCIS American Airline Export

OCIS ALASKA

OCIS Alaska Airline Export

OCIS DL EXP

OCIS DL Export

PA EXPORT

Passages Export

QF EXPORT

Qantas Airways Export

SCC EXPORT

SCC Export

SR EXPORT

Swiss Air Export

UA EXPORT

United Airlines Export

VS EXPORT

Virgin Atlantic Airways Export

Export File Sources

When creating a membership export, you must select the source of your export file. These sources are the views for the export procedure. You can select from the following sources for exporting membership statements:
  • MEMBER_STATEMENT_EXP_MEM_VW ‒ Select this option if you want the statements to contain detailed membership information for each member.

  • MEMBER_STATEMENT_EXP_TRX_VW ‒ Select this option if you want the statements to contain membership statement transactions information.

Centrally Managed Memberships

You can export membership award points and membership transactions for centrally managed membership programs to a statement. Membership award points for centrally managed membership programs enables you to export frequent flyer membership types to airlines.

Three templates are included for the central membership award points and transactions export. You can use the templates in their existing form or modify and rename them according to your needs. These templates export positive award points, unless you delete the filter command, which would enable negative points to be included in the export.
  • OCIS_ALASKA (OCIS Alaska Airline) ‒ This template is for the transaction level. It identifies bonus points (column contains FORMULA of H5B). One transaction appears per line. Provides the view of MEMBER_STATEMENT_EXP_TRX_VW.

  • OCIS_AMERICAN (OCIS American Airline) ‒ This template is for the transaction level. One transaction appears per line. It provides the view of MEMBER_STATEMENT_EXP_TRX_VW.

  • OCIS_DL_EXP (OCIS DL Export) ‒ This template is for the membership level. It combines the total accumulated points on one line (for all transactions for one member). Provides the view of MEMBER_STATEMENT_EXP_MEM_VW.