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