crmd_leads

Database

prod_bank_wealth

Schema

sor_crmd

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 leads_hiid bigint 64
2 run_date timestamp without time zone
3 delta_type character varying 3
4 lead_id character varying 90
5 assoc_opportunity character varying 90
6 assoc_campaign character varying 90
7 assoc_contact character varying 90
8 contact_id character varying 90
9 last_name character varying 150
10 first_name character varying 150
11 title character varying 45
12 addr_type character varying 90
13 street_addr_1 character varying 600
14 street_addr_2 character varying 300
15 city character varying 150
16 state character varying 150
17 country character varying 150
18 post_code character varying 90
19 home_ph character varying 120
20 mobile_ph character varying 120
21 work_ph character varying 120
22 e_mail character varying 300
23 lead_status character varying 90
24 lead_type character varying 90
25 cust_segment character varying 90
26 lead_source character varying 90
27 potential_revenue character varying 60
28 reject_code character varying 90
29 reject_reason character varying 900
30 occupation_code character varying 90
31 company character varying 300
32 abn character varying 60
33 acn_arbn character varying 60
34 annual_revenue character varying 60
35 industry_level_1 character varying 90
36 industry_level_2 character varying 90
37 industry_level_3 character varying 90
38 industry_level_4 character varying 90
39 number_employees character varying 60
40 web_site character varying 300
41 description character varying 48000
42 estimated_close_date timestamp without time zone
43 expiry_date timestamp without time zone
44 lead_assigned_to_queue character varying 90
45 next_step character varying 12000
46 owner_full_name character varying 90
47 sales_person character varying 90
48 pref_contact_method character varying 90
49 product_interest character varying 300
50 referred_by_cust character varying 90
51 resolution_code character varying 120
52 job_title character varying 225
53 take_ownership character varying 15
54 import_identifier character varying 120
55 created_user character varying 60
56 created_ts timestamp without time zone
57 modified_ts timestamp without time zone
58 modified_user character varying 60
59 effective_strt_dt timestamp without time zone
60 effective_end_dt timestamp without time zone