Issuances Data

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 most recent data refresh. Data is refreshed once per day. For example, if you are looking at the data set on 7/18, it will contain data from 7/11 to present.

What data can be pulled?

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 mobile database)
REFERRING_APPLICATION_REF_ID	VARCHAR(16777216)	TRUE	NULL	Campaign ID of the campaign that assigned the code (usually a broadcast id or interactive campaign id)
EXTERNAL_ISSUEE_ID	VARCHAR(16777216)	TRUE	NULL	Usually the person id (for Campaign Manager and Mobiledb) or the person key (for Wallet)
CREATED_DATE_DIM_KEY	DATE	TRUE	NULL	Date 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

Sample Query

–- A query that will pull all sms messages from yesterday
SELECT
INCENTIVE_CODE
, INCENTIVE_POOL
,REFERRING_APPLICATION
,CREATED_AT
,UPDATED_AT

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)