1. Tables and Views for Loyalty
  2. Loyalty Tables and Views

Loyalty Tables and Views

This guide contains the information about tables within Oracle Loyalty Cloud and their columns, primary keys, and indexes. It also includes the information about views within Oracle Loyalty Cloud along with the columns and queries associated with each view.

Note: While using this document, you will also want to refer to the following chapters in Tables and Views for CX Sales and B2B Service for additional tables and views that will be useful in your applications:

  • Catalog, Price Books, Products, and Promotions

  • Common CRM

  • ConfigurationCRM Application Composer

  • Customer Data Model

  • Partner Management

For your reference:

  • Tables are the basic unit of data storage in Oracle Loyalty Cloud, where data is stored in rows and columns. For example, the LOY_PROGRAM table stores information about the Loyalty programs. This table stores attributes such as the program name, program owner, program description, and whether an enrollment bonus is enabled, and so on.

  • A view is a logical representation of a table or combination of tables. It is a stored query that derives its data from the tables on which it is based. For example, the LOY_ATTRDEFN_VL view is based on the LOY_ATTRDEFN_B and the LOY_ATTRDEFN_TL tables, and shows the attributes queried from these two tables.

Note: Don't use the information in this guide to build data extracts or analytics and reports. For your business intelligence needs, see the resources for subject areas and data lineage mapping.