Blueshift List

List Code

list_cde

list_code

Customer Number

ctm_nbr

customer_id

Last Update Time Stamp

upd_dte

timestamp

Last Update By

upd_usr

last_updated_by

Update Flag

upd_flg

update_flag

if 'Y' then true else 'false'

Demographic Data 

dmo_dat

weekly_delivery_flag

Email Status

eml_sta

email_status

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

Created Time Stamp

dte_add

date_joined

Profile Identifier

prof_id

profile_identifier

List Source

lst_src

source_code

Outlet Code

outlet_code

Confirmation Timestamp

cnfm_dte

confirmation_date

Double OptIn

dbl_opt

double_opt_in

if 'Y' then 'true' else 'false'

Email Reference Number

eml_ref

email_reference_number

Oiginal Source Code

org_src

original_source_code

Last Enrollment Timestamp

lst_enrl

last_enrollment_date

Email Id

emal_id

email_id

List Rejoin Days

lst_rejd

list_rejoin_days

Owning Org

own_org

owning_org

Email Valid

emal_vld

email_valid

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

Email Device

eml_dvce

email_device

Email Address

adr_eml

email_address