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 created 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 created from 7/11/2019 to present.


What data is included?

Column Name

Type

Nullable

Default

Comment

INCENTIVE_CODE

VARCHAR(255)

TRUE

NULL

The unique incentive code that is sent to a consumer

INCENTIVE_POOL_NAME

VARCHAR(255)

TRUE

NULL

Name of the Incentive Pool

TENANT_KEY

VARCHAR(255)

TRUE

NULL

Tenant key associated with the pool/code

INCENTIVE_CODE_ID

NUMBER(38,0)

TRUE

NULL

Vibes ID of the code

CREATED_AT

TIMESTAMP_TZ(9)

TRUE

NULL

When the code was created

UPDATED_AT

TIMESTAMP_TZ(9)

TRUE

NULL

When it was last updated

ACTIVE

NUMBER(38,0)

TRUE

NULL

Whether or not it is active (1-active; 0-inactive)

ISSUED

NUMBER(38,0)

TRUE

NULL

Whether or not it is issued at least once (1-issued; 0-not issued)

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
, ISSUED
FROM INCENTIVE_CODES
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)