Blueshift Subscription

Subscription Reference

sub_ref

subscription_reference

Publication Code

pub_cde

publication_code

Key Code

key_cde

key_code

Circulation Status Detail

crc_sts

circulation_status_detail

Circulation Status

crc_sts

circulation_status

If ('R','P','Q','W','G') Then 'Active',
if ('C','N','X') Then 'Cancel',
if 'E' Then 'Expire',
if ('B','L','S','T','U','K') Then 'Suspended',
if Null Then 'UNKNOWN'
else 'UNKNOWN'

Billing Status Detail

bil_sts

billing_status_detail

Billing Status 

bil_sts

billing_status

If ('P','R') Then 'Paid',
if ('M') Then 'Cancel',
if 'B' Then 'Unpaid',
if 'C' the 'Comp',
if 'A' On Approval',
else 'UNKNOWN'

Delivery Code Detail

dlv_cde

delivery_code_detail

Delivery Code 

dlv_cde

delivery_code

If 'ML' then 'Mail', else 'Email'

Customer Number

ctm_nbr

customer_id

First Date

frst_dte

first_date

Final Expire

fin_exp

final_expire

Final Issues / Issues to go

fin_itg

issues_to_go

Promotion Choice

pmo_chc

promotion_choice

Subscription Demographic

sub_dmo

subscription_demographic

Subscription Demographic2

sub_dm2

subscription_demographic2

Special Handling

spl_hand

special_handling

Rate

rate

rate

Remaining Subscription Liability

rem_liab

remaining_subscription_liability

Renewal Type Detail

rn_flg

renewal_type_detail

Renewal Notice / Renewal Type

rn_flg

renewal_type

If 'A' then 'Lifetime or Comp',
if 'C' then 'Auto Charge',
if D then 'Auto Discontinued',
if 'E' then 'Promote Done',
if 'N' then 'Do Not Renew',
if 'S' then 'Special Renewal',
if 'U' then 'Auto Charge Bad Card',
if 'X' then 'Do not Promote for Renewal',
if 'Y' then 'Promote for Renewal',
if 'Z' then 'Promote Limited Offers'
else 'UNKNOWN'

Last Renewal Date

lrnw_dte

last_renewal_date

Last Renewal Effort

lst_reft

last_renewal_effort

Latest Start Date

lst_dte

latest_start_date

Organization Code

mbr_org

member_org

Original Control Group Date

org_ctgd

date_joined

Original Key / Promotion Code

org_key

promotion_code

Original Key / Outlet Code

outlet_code

Original Order

org_ord

original_order

Order Number

ord_nbr

order_number

Term Number

trm_nbr

term_number

Subject Type / Subscription Type

sub_typ

subscription_type

Term

term

term

Last Renewal Key Code

lrnw_key

last_renewal_key_code

Last Billing Key Code

lbil_key

last_billing_key_code

Owning Org

own_org

owning_org

Email Id

emal_id

email_id

Email Status

eml_sta

email_status

If  ('A','') then 'Active',
if 'I' then 'OptOut',
if 'B' then 'Bounce',
if ('X','S') then 'Spam'
else 'UNKNOWN'

Email Valid

emal_vld

email_valid

if 'N' then 'false' else 'true'

Email Device

eml_dvce

email_device

Email Address

adr_eml

email_address

Customer Number

ctm_nbr

customer_id

Subscription Reference

sub_ref

subscription_reference

Sequence Number

seq_nbr

sequence_number

Customer Number

ctm_nbr

customer_number

Member Category

mbr_cat

member_category

Member Org

mbr_org

member_org

Acquisition Method

pmo_acq

acquisition_method

Campaign Code

cpn_cde

campaign_code

Creative Code

ctv_cde

creative_code

Offer Code

ofr_cde

offer_code

Promotion Code / Source Code

pmo_cde

promotion_code