Skip to content

Query: QRY Restore Deleted leads

Type: Delete
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • Restore
  • Restore Deleted Leads

Columns Selected

  • [Restore Deleted Leads].[Entrepreneur ID]
  • [Restore Deleted Leads].[Reference Number]
  • [Restore Deleted Leads].[Date Record Created]
  • [Restore Deleted Leads].[Lead Type ID]
  • [Restore Deleted Leads].[Division ID]
  • [Restore Deleted Leads].[Date of Birth]
  • [Restore Deleted Leads].[First Name]
  • Surname
  • [Restore Deleted Leads].[EOI SA Identity Number]
  • [Restore Deleted Leads].[EOI Citizenship Type]
  • [Restore Deleted Leads].[EOI Date of Naturalisation]
  • [Restore Deleted Leads].[EOI Business Name]
  • [Restore Deleted Leads].[EOI Business Address 1]
  • [Restore Deleted Leads].[EOI Business Address 2]
  • [Restore Deleted Leads].[EOI Business Address 3]
  • [Restore Deleted Leads].[EOI Business Postal Code]
  • [Restore Deleted Leads].[EOI Industry ID]
  • [Restore Deleted Leads].[EOI Brief Description of Business]
  • [Restore Deleted Leads].[EOI Enterprise Type]
  • [Restore Deleted Leads].[EOI Percent of Ownership]
  • [Restore Deleted Leads].[EOI Average Monthly Turnover]
  • [Restore Deleted Leads].[EOI Years in Business]
  • [Restore Deleted Leads].[EOI Do you have a full time job]
  • [Restore Deleted Leads].[Entrepreneur Company ID]
  • [Restore Deleted Leads].[Shareholding Percentage]
  • [Restore Deleted Leads].[Telephone Number]
  • [Restore Deleted Leads].[Second Telephone Number]
  • [Restore Deleted Leads].[Email Address]
  • [Restore Deleted Leads].[Alternative Email Address]
  • Race
  • Gender
  • [Restore Deleted Leads].[SA Citizen]
  • [Restore Deleted Leads].[Identity Number]
  • SAID
  • [Restore Deleted Leads].[Profile Created]
  • [Restore Deleted Leads].[Full Time]
  • Province
  • Location
  • Country
  • [Restore Deleted Leads].[Access to PC]
  • [Restore Deleted Leads].[Access to Laptop]
  • [Restore Deleted Leads].[Access to Smartphone]
  • [Restore Deleted Leads].[Quality of Connectivity]
  • [Restore Deleted Leads].[Use Tech Resources For Sessions]
  • [Restore Deleted Leads].[Source Category]
  • [Restore Deleted Leads].[Source Detail]
  • [Restore Deleted Leads].[Process Date]
  • [Restore Deleted Leads].[Pipeline ID]
  • [Restore Deleted Leads].[Process Status ID]
  • [Restore Deleted Leads].[Process Status Notes]
  • [Restore Deleted Leads].[Date Status Changed]
  • [Restore Deleted Leads].[Status Modified By]
  • [Restore Deleted Leads].[Override Status Rules]
  • [Restore Deleted Leads].[Distribution Model ID]
  • [Restore Deleted Leads].[Delivery Location ID]
  • [Restore Deleted Leads].[Termination Reason ID]
  • [Restore Deleted Leads].[Unqualified Reason ID]
  • [Restore Deleted Leads].[Blue Eagle Recommendation Date]
  • [Restore Deleted Leads].[Blue Eagle Exported]
  • [Restore Deleted Leads].[Recommended Principal Project ID]
  • [Restore Deleted Leads].[Recommended Product ID]
  • [Restore Deleted Leads].[Recommended BBBEE Pillar]
  • [Restore Deleted Leads].[Primary Entrepreneur]
  • Notes
  • [Restore Deleted Leads].[Allocation ID]
  • [Restore Deleted Leads].[Student ID]
  • [Restore Deleted Leads].[Style Questionnaire Score]
  • [Restore Deleted Leads].[Style Questionnaire Results]
  • [Restore Deleted Leads].[Personal Audit Score]
  • [Restore Deleted Leads].[Personal Audit Results]
  • [Restore Deleted Leads].[Urgency Result]
  • [Restore Deleted Leads].[Financial Literacy Result]
  • [Restore Deleted Leads].[Entrepreneurial Assessment Results]
  • [Restore Deleted Leads].[EA Date]
  • [Restore Deleted Leads].[EA Marker]
  • [Restore Deleted Leads].[EA Retake Results]
  • [Restore Deleted Leads].[EA Retake Date]
  • [Restore Deleted Leads].[EA Retake Marker]
  • [Restore Deleted Leads].[Purple Panel Score]
  • [Restore Deleted Leads].[PP Results]
  • [Restore Deleted Leads].[Date Panel Held]
  • [Restore Deleted Leads].[Certified ID Copy]
  • [Restore Deleted Leads].[Date ID Certified]
  • [Restore Deleted Leads].[RSA Naturalisation Certificate]
  • [Restore Deleted Leads].[RSA Naturalisation Issue Date]
  • [Restore Deleted Leads].[Home Affairs Doc]
  • [Restore Deleted Leads].[Date Entered South Africa]
  • [Restore Deleted Leads].[Other Proof of Naturalisation]
  • [Restore Deleted Leads].[Other Proof Issue Date]
  • [Restore Deleted Leads].[Employee Payslips]
  • [Restore Deleted Leads].[Emplouee Number or Start Date]
  • [Restore Deleted Leads].[Employee Contracts]
  • [Restore Deleted Leads].[Employee Contract Start Date]
  • [Restore Deleted Leads].[EMP 201]
  • [Restore Deleted Leads].[EMP 201 Last Payment Date]
  • IRP5
  • [Restore Deleted Leads].[Tax Reference Number]
  • [Restore Deleted Leads].[CIPS Documents]
  • [Restore Deleted Leads].[Sworn Affidavit BEE]
  • [Restore Deleted Leads].[BBBEE Certificate Issued]
  • [Restore Deleted Leads].[Tax Clearance Certificate]
  • [Restore Deleted Leads].[VAT Registration Document]
  • [Restore Deleted Leads].[Proof of Turnover]
  • [Restore Deleted Leads].[Minimum Bank Statements]
  • [Restore Deleted Leads].[Audited Financials]
  • [Restore Deleted Leads].[Information 1]
  • [Restore Deleted Leads].[Information 2]
  • [Restore Deleted Leads].[Information 3]
  • [Restore Deleted Leads].[Information 4]
  • [Restore Deleted Leads].[Information 5]
  • OwnedBy
  • [Restore Deleted Leads].[Headhunted By]
  • Headhunted
  • [Restore Deleted Leads].[Modified By]
  • [Restore Deleted Leads].[Date Modified]
  • [Restore Deleted Leads].[Date Blue Heart Email Sent]
  • [Restore Deleted Leads].[Other Incubator]
  • [Restore Deleted Leads].[Other Incubator Text]
  • [Restore Deleted Leads].[Access to Tablet]
  • [Restore Deleted Leads].[Digital State of Business]
  • [Restore Deleted Leads].[Digital Fulltime in Business]
  • [Restore Deleted Leads].[Digital More Than One Partner]
  • [Restore Deleted Leads].[Digital More Than One Business]
  • [Restore Deleted Leads].[Digital Bank Account]
  • [Restore Deleted Leads].[Digital Fulltime Employees]
  • [Restore Deleted Leads].[Digital Signed Employee Contracts]
  • [Restore Deleted Leads].[Digital Currently Incubated]
  • [Restore Deleted Leads].[Digital Incubation Type]
  • [Restore Deleted Leads].[Digital Comodities]
  • [Restore Deleted Leads].[Digital Motivation]
  • [Restore Deleted Leads].[Blue Heart Score Calculated]
  • [Restore Deleted Leads].[Date Digital First Meeting Captured]
  • [Restore Deleted Leads].[SharePoint Link]

SQL

SELECT [Restore Deleted Leads].[Entrepreneur ID], [Restore Deleted Leads].[Reference Number], [Restore Deleted Leads].[Date Record Created], [Restore Deleted Leads].[Lead Type ID], [Restore Deleted Leads].[Division ID], [Restore Deleted Leads].[Date of Birth], [Restore Deleted Leads].[First Name], [Restore Deleted Leads].Surname, [Restore Deleted Leads].[EOI SA Identity Number], [Restore Deleted Leads].[EOI Citizenship Type], [Restore Deleted Leads].[EOI Date of Naturalisation], [Restore Deleted Leads].[EOI Business Name], [Restore Deleted Leads].[EOI Business Address 1], [Restore Deleted Leads].[EOI Business Address 2], [Restore Deleted Leads].[EOI Business Address 3], [Restore Deleted Leads].[EOI Business Postal Code], [Restore Deleted Leads].[EOI Industry ID], [Restore Deleted Leads].[EOI Brief Description of Business], [Restore Deleted Leads].[EOI Enterprise Type], [Restore Deleted Leads].[EOI Percent of Ownership], [Restore Deleted Leads].[EOI Average Monthly Turnover], [Restore Deleted Leads].[EOI Years in Business], [Restore Deleted Leads].[EOI Do you have a full time job], [Restore Deleted Leads].[Entrepreneur Company ID], [Restore Deleted Leads].[Shareholding Percentage], [Restore Deleted Leads].[Telephone Number], [Restore Deleted Leads].[Second Telephone Number], [Restore Deleted Leads].[Email Address], [Restore Deleted Leads].[Alternative Email Address], [Restore Deleted Leads].Race, [Restore Deleted Leads].Gender, [Restore Deleted Leads].[SA Citizen], [Restore Deleted Leads].[Identity Number], [Restore Deleted Leads].SAID, [Restore Deleted Leads].[Profile Created], [Restore Deleted Leads].[Full Time], [Restore Deleted Leads].Province, [Restore Deleted Leads].Location, [Restore Deleted Leads].Country, [Restore Deleted Leads].[Access to PC], [Restore Deleted Leads].[Access to Laptop], [Restore Deleted Leads].[Access to Smartphone], [Restore Deleted Leads].[Quality of Connectivity], [Restore Deleted Leads].[Use Tech Resources For Sessions], [Restore Deleted Leads].[Source Category], [Restore Deleted Leads].[Source Detail], [Restore Deleted Leads].[Process Date], [Restore Deleted Leads].[Pipeline ID], [Restore Deleted Leads].[Process Status ID], [Restore Deleted Leads].[Process Status Notes], [Restore Deleted Leads].[Date Status Changed], [Restore Deleted Leads].[Status Modified By], [Restore Deleted Leads].[Override Status Rules], [Restore Deleted Leads].[Distribution Model ID], [Restore Deleted Leads].[Delivery Location ID], [Restore Deleted Leads].[Termination Reason ID], [Restore Deleted Leads].[Unqualified Reason ID], [Restore Deleted Leads].[Blue Eagle Recommendation Date], [Restore Deleted Leads].[Blue Eagle Exported], [Restore Deleted Leads].[Recommended Principal Project ID], [Restore Deleted Leads].[Recommended Product ID], [Restore Deleted Leads].[Recommended BBBEE Pillar], [Restore Deleted Leads].[Primary Entrepreneur], [Restore Deleted Leads].Notes, [Restore Deleted Leads].[Allocation ID], [Restore Deleted Leads].[Student ID], [Restore Deleted Leads].[Style Questionnaire Score], [Restore Deleted Leads].[Style Questionnaire Results], [Restore Deleted Leads].[Personal Audit Score], [Restore Deleted Leads].[Personal Audit Results], [Restore Deleted Leads].[Urgency Result], [Restore Deleted Leads].[Financial Literacy Result], [Restore Deleted Leads].[Entrepreneurial Assessment Results], [Restore Deleted Leads].[EA Date], [Restore Deleted Leads].[EA Marker], [Restore Deleted Leads].[EA Retake Results], [Restore Deleted Leads].[EA Retake Date], [Restore Deleted Leads].[EA Retake Marker], [Restore Deleted Leads].[Purple Panel Score], [Restore Deleted Leads].[PP Results], [Restore Deleted Leads].[Date Panel Held], [Restore Deleted Leads].[Certified ID Copy], [Restore Deleted Leads].[Date ID Certified], [Restore Deleted Leads].[RSA Naturalisation Certificate], [Restore Deleted Leads].[RSA Naturalisation Issue Date], [Restore Deleted Leads].[Home Affairs Doc], [Restore Deleted Leads].[Date Entered South Africa], [Restore Deleted Leads].[Other Proof of Naturalisation], [Restore Deleted Leads].[Other Proof Issue Date], [Restore Deleted Leads].[Employee Payslips], [Restore Deleted Leads].[Emplouee Number or Start Date], [Restore Deleted Leads].[Employee Contracts], [Restore Deleted Leads].[Employee Contract Start Date], [Restore Deleted Leads].[EMP 201], [Restore Deleted Leads].[EMP 201 Last Payment Date], [Restore Deleted Leads].IRP5, [Restore Deleted Leads].[Tax Reference Number], [Restore Deleted Leads].[CIPS Documents], [Restore Deleted Leads].[Sworn Affidavit BEE], [Restore Deleted Leads].[BBBEE Certificate Issued], [Restore Deleted Leads].[Tax Clearance Certificate], [Restore Deleted Leads].[VAT Registration Document], [Restore Deleted Leads].[Proof of Turnover], [Restore Deleted Leads].[Minimum Bank Statements], [Restore Deleted Leads].[Audited Financials], [Restore Deleted Leads].[Information 1], [Restore Deleted Leads].[Information 2], [Restore Deleted Leads].[Information 3], [Restore Deleted Leads].[Information 4], [Restore Deleted Leads].[Information 5], [Restore Deleted Leads].OwnedBy, [Restore Deleted Leads].[Headhunted By], [Restore Deleted Leads].Headhunted, [Restore Deleted Leads].[Modified By], [Restore Deleted Leads].[Date Modified], [Restore Deleted Leads].[Date Blue Heart Email Sent], [Restore Deleted Leads].[Other Incubator], [Restore Deleted Leads].[Other Incubator Text], [Restore Deleted Leads].[Access to Tablet], [Restore Deleted Leads].[Digital State of Business], [Restore Deleted Leads].[Digital Fulltime in Business], [Restore Deleted Leads].[Digital More Than One Partner], [Restore Deleted Leads].[Digital More Than One Business], [Restore Deleted Leads].[Digital Bank Account], [Restore Deleted Leads].[Digital Fulltime Employees], [Restore Deleted Leads].[Digital Signed Employee Contracts], [Restore Deleted Leads].[Digital Currently Incubated], [Restore Deleted Leads].[Digital Incubation Type], [Restore Deleted Leads].[Digital Comodities], [Restore Deleted Leads].[Digital Motivation], [Restore Deleted Leads].[Blue Heart Score Calculated], [Restore Deleted Leads].[Date Digital First Meeting Captured], [Restore Deleted Leads].[SharePoint Link] FROM [Restore Deleted Leads]