crmd_campaign_details

Database

prod_bank_wealth

Schema

sor_crmd

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 crmd_camp_hiid bigint 64
2 run_date timestamp without time zone
3 delta_type character varying 3
4 campaign_code character varying 90
5 campaign_type character varying 90
6 campaign_name character varying 300
7 tracking_id character varying 90
8 brand character varying 90
9 channel character varying 90
10 line_of_business character varying 90
11 objective character varying 12000
12 offer_code character varying 120
13 offer_desc character varying 48000
14 originated_by character varying 90
15 campaign_owner_id character varying 90
16 campaign_owner character varying 300
17 product_portfolio character varying 90
18 status character varying 90
19 budgeted_cost character varying 60
20 actual_cost character varying 60
21 leads_targetted character varying 60
22 revenue_target character varying 60
23 start_date timestamp without time zone
24 end_date timestamp without time zone
25 created_user character varying 60
26 created_ts timestamp without time zone
27 modified_user character varying 60
28 modified_ts timestamp without time zone
29 effective_strt_dt timestamp without time zone
30 effective_end_dt timestamp without time zone