lead_audit_db
Tables (4)
Call Result (call_result)
- call_result_id — number(5) — Primary key — NOT NULL
- call_result_desc — varchar2(400)
Record Status (record_status)
- record_status_id — number(5) — Primary key — NOT NULL
- record_status_desc — varchar2(400)
Record Type (record_type)
- record_type_id — number(5) — Primary key — NOT NULL
- record_type_desc — varchar2(400)
lead_summary
- event_id — number(40) — Primary key — NOT NULL
- contact_info — varchar2(128) — NOT NULL
- attempt — number(38)
- call_time — number(38)
- campaign_id — number(38)
- chain_id — number(38) — NOT NULL
- chain_n — number(38) — NOT NULL
- dail_sched_time — number(38)
- dc_clientfirstname — varchar2(255)
- dc_clientsurname — varchar2(255)
- dc_cleintname — varchar2(255)
- dc_clientidnumber — varchar2(255)
- dc_clientlegalrefno — varchar2(255)
- dc_comment — varchar2(255)
- dc_clientcomment — varchar2(255)
- dc_productcode — varchar2(255)
- dc_leadsource — varchar2(255)
- dc_leadrefnumber — varchar2(255)
- dc_agentdetails — varchar2(255)
- chainingwrapupcode — varchar2(50)
- completioncode — varchar2(50)
- datecreatedts — date — NOT NULL
- dc_subleadtype — varchar2(255)
- dc_leadtype — varchar2(255)
- dc_loadid — varchar2(255)
- iud_status — varchar2(50) — NOT NULL
- iud_date — date — NOT NULL
- lms_attempt — number(10)
- call_result_id — number(5) — Foreign key → Call Result.call_result_id
- record_status_id — number(5) — Foreign key → Record Status.record_status_id — NOT NULL
- record_type_id — number(5) — Foreign key → Record Type.record_type_id — NOT NULL