Skip to end of metadata
Go to start of metadata

Last Updated: Tuesday, December 7, 2021



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

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)
  • No labels