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.
-
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.
Table 8-8 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
-
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.
-
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.
Parent topic: Exports