Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Last Updated:

Lastupdatedate

Livesearch
placeholderSearch the Vibes Developer Wiki
typepage



This data set contains recently issued incentive codes associated with the company's account.


How much data is retained?

This data set will contain 7 days worth of data starting from the previous day. For example, if you are looking at the data set today, 7/18/2019, it will contain data for codes issued from 7/11/2019 to present.


What data is included?

Column Name

Type

Nullable

Default

Comment

ISSUANCE_IDNUMBER(38,0)TRUENULLThe unique ID of the issuance

INCENTIVE_CODE

VARCHAR(255)

TRUE

NULL

The unique incentive code that is sent to a consumer

INCENTIVE_POOL

VARCHAR(255)

TRUE

NULL

Name of the Incentive Pool

TENANT_KEY

VARCHAR(255)

TRUE

NULL

Tenant key associated with the pool/code

REFERRING_APPLICATION

VARCHAR(16777216)

TRUE

NULL

The application that assigned the code (usually Campaign Manager, Wallet or Mobiledb)

REFERRING_APPLICATION_REF_IDVARCHAR(16777216)TRUENULLCampaign ID of the campaign that assigned the code (usually a broadcast id or interactive campaign id)
EXTERNAL_ISSUEE_IDVARCHAR(16777216)TRUENULLUsually the person id (for Campaign Manager and Mobiledb) or the person key (for Wallet)
CREATED_DATE_DIM_KEYDATETRUENULLDate it was issued

CREATED_AT

TIMESTAMP_TZ(9)

TRUE

NULL

When the code was created

UPDATED_AT

TIMESTAMP_TZ(9)

TRUE

NULL

When it was last updated

DW_CREATED_AT

TIMESTAMP_TZ(9)

TRUE

NULL

When it was added to the warehouse

DW_UPDATED_AT

TIMESTAMP_TZ(9)

TRUE

NULL

When it was updated last in the warehouse


What are some sample queries to pull this data?

–- A query that will pull all sms messages from yesterday
SELECT
INCENTIVE_CODE
, INCENTIVE_POOL_NAME
FROM ISSUANCES
WHERE CAST(DW_CREATED_AT AS DATE) >= CAST(DATEADD(day,-1,CURRENT_DATE())AS DATE)
AND CAST(DW_CREATED_AT AS DATE) < CAST(CURRENT_DATE() AS DATE)