| master_id | int(11) | NO | 0 | | | |
| master_guid | varchar(36) | NO | | | | |
| master_opid | varchar(36) | NO | | | | |
| master_enabled | tinyint(1) | YES | 1 | | | |
| master_status | varchar(1) | YES | | | | |
| master_created | datetime | YES | CURRENT_TIMESTAMP | | | |
| master_modified | datetime | NO | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| master_expires | datetime | YES | | | | |
| Id | varchar(18) | NO | | | | |
| IsDeleted | tinyint(1) | YES | | | | |
| MasterRecordId | varchar(0) | YES | | | | |
| LastName | varchar(73) | YES | | | | |
| FirstName | varchar(40) | YES | | | | |
| Salutation | varchar(7) | YES | | | | |
| Name | varchar(79) | YES | | | | |
| RecordTypeId | varchar(18) | YES | | | | |
| Title | varchar(110) | YES | | | | |
| Company | varchar(131) | YES | | | | |
| Street | text | YES | | | | |
| City | varchar(32) | YES | | | | |
| State | varchar(35) | YES | | | | |
| PostalCode | varchar(16) | YES | | | | |
| Country | varchar(28) | YES | | | | |
| Latitude | double | YES | | | | |
| Longitude | double | YES | | | | |
| GeocodeAccuracy | varchar(0) | YES | | | | |
| Address | text | YES | | | | |
| Phone | varchar(40) | YES | | | | |
| MobilePhone | varchar(33) | YES | | | | |
| Fax | varchar(32) | YES | | | | |
| Email | varchar(55) | YES | | | | |
| Website | varchar(251) | YES | | | | |
| PhotoUrl | varchar(41) | YES | | | | |
| Description | text | YES | | | | |
| LeadSource | varchar(28) | YES | | | | |
| Status | varchar(30) | YES | | | | |
| Industry | varchar(32) | YES | | | | |
| Rating | varchar(9) | YES | | | | |
| AnnualRevenue | double | YES | | | | |
| NumberOfEmployees | int(11) | YES | | | | |
| OwnerId | varchar(18) | YES | | | | |
| HasOptedOutOfEmail | tinyint(1) | YES | | | | |
| IsConverted | tinyint(1) | YES | | | | |
| ConvertedDate | datetime(6) | YES | | | | |
| ConvertedAccountId | varchar(18) | YES | | | | |
| ConvertedContactId | varchar(18) | YES | | | | |
| ConvertedOpportunityId | varchar(18) | YES | | | | |
| IsUnreadByOwner | tinyint(1) | YES | | | | |
| CreatedDate | datetime(6) | YES | | | | |
| CreatedById | varchar(18) | YES | | | | |
| LastModifiedDate | datetime(6) | YES | | | | |
| LastModifiedById | varchar(18) | YES | | | | |
| SystemModstamp | datetime(6) | YES | | | | |
| LastActivityDate | datetime(6) | YES | | | | |
| LastViewedDate | datetime(6) | YES | | | | |
| LastReferencedDate | datetime(6) | YES | | | | |
| JigsawContactId | varchar(0) | YES | | | | |
| ConnectionReceivedId | varchar(0) | YES | | | | |
| ConnectionSentId | varchar(0) | YES | | | | |
| EmailBouncedReason | varchar(254) | YES | | | | |
| EmailBouncedDate | datetime(6) | YES | | | | |
| Client_ID__c | double | YES | | | | |
| of_offices__c | double | YES | | | | |
| of_physicians__c | double | YES | | | | |
| Parent_Account__c | varchar(18) | YES | | | | |
| LMD_Lead_Source__c | varchar(38) | YES | | | | |
| Physician_Name__c | varchar(48) | YES | | | | |
| Systems_being_evaulated__c | varchar(88) | YES | | | | |
| Interested_In__c | varchar(184) | YES | | | | |
| Office_Hours__c | varchar(87) | YES | | | | |
| Lead_Quality__c | varchar(41) | YES | | | | |
| Recent_Campaign_Upload__c | varchar(21) | YES | | | | |
| Extension__c | double | YES | | | | |
| Lead_Source_Other_Details__c | varchar(94) | YES | | | | |
| Last_Modified_by_Role__c | varchar(32) | YES | | | | |
| SFSSDupeCatcher__Override_DupeCatcher__c | tinyint(1) | YES | | | | |
| Created_by_Role__c | varchar(32) | YES | | | | |
| ofDemoAttendees__c | varchar(1) | YES | | | | |
| ofLocations__c | double | YES | | | | |
| Owner_Role__c | varchar(32) | YES | | | | |
| ofPhys__c | double | YES | | | | |
| ofPhysOld__c | varchar(12) | YES | | | | |
| ofStaff__c | double | YES | | | | |
| pi__campaign__c | varchar(52) | YES | | | | |
| pi__comments__c | text | YES | | | | |
| pi__conversion_date__c | datetime(6) | YES | | | | |
| pi__conversion_object_name__c | varchar(56) | YES | | | | |
| pi__conversion_object_type__c | varchar(12) | YES | | | | |
| pi__created_date__c | datetime(6) | YES | | | | |
| pi__first_activity__c | datetime(6) | YES | | | | |
| pi__first_search_term__c | varchar(198) | YES | | | | |
| pi__first_search_type__c | varchar(22) | YES | | | | |
| pi__first_touch_url__c | text | YES | | | | |
| pi__grade__c | varchar(0) | YES | | | | |
| pi__last_activity__c | datetime(6) | YES | | | | |
| pi__notes__c | text | YES | | | | |
| pi__score__c | double | YES | | | | |
| pi__url__c | varchar(47) | YES | | | | |
| pi__utm_campaign__c | varchar(0) | YES | | | | |
| pi__utm_content__c | varchar(0) | YES | | | | |
| pi__utm_medium__c | varchar(19) | YES | | | | |
| pi__utm_source__c | varchar(7) | YES | | | | |
| pi__utm_term__c | varchar(0) | YES | | | | |
| Lead_Qualification_Owner__c | varchar(18) | YES | | | | |
| Lead_Qualification_Owner_TEXT__c | varchar(24) | YES | | | | |
| of_mid_levels__c | double | YES | | | | |
| Medicare__c | tinyint(1) | YES | | | | |
| Medicaid__c | tinyint(1) | YES | | | | |
| Sites_In_Group__c | double | YES | | | | |
| Total_Doctors_In_Group__c | double | YES | | | | |
| Group_Name__c | varchar(63) | YES | | | | |
| Count__c | double | YES | | | | |
| Current_PM__c | varchar(253) | YES | | | | |
| Outpatient_EHR__c | varchar(107) | YES | | | | |
| Lead_Type__c | varchar(21) | YES | | | | |
| Office_Manager__c | varchar(255) | YES | | | | |
| Create_Task__c | varchar(112) | YES | | | | |
| Import2_Id__c | varchar(15) | YES | | | | |
| Still_on_Paper__c | tinyint(1) | YES | | | | |
| Associated_Azalea_Customer_Account__c | varchar(117) | YES | | | | |
| Associated_Azalea_Customer_Client_Name__c | varchar(40) | YES | | | | |
| Associated_Azalea_Customer_Phone__c | varchar(17) | YES | | | | |
| PACS__c | varchar(99) | YES | | | | |
| CPOE__c | varchar(96) | YES | | | | |
| Hospital_Type__c | varchar(30) | YES | | | | |
| NPI__c | double | YES | | | | |
| Managed_Leased_Owned__c | varchar(13) | YES | | | | |
| Care_Coordination_Management_Software__c | varchar(126) | YES | | | | |
| Surgery_Operating_Room_Management_System__c | varchar(128) | YES | | | | |
| RIS__c | varchar(74) | YES | | | | |
| Transcription__c | varchar(163) | YES | | | | |
| Coding__c | varchar(67) | YES | | | | |
| Patient_Portal__c | varchar(83) | YES | | | | |
| HIE_Affiliations__c | varchar(179) | YES | | | | |
| Ownership__c | varchar(32) | YES | | | | |
| HIS__c | varchar(169) | YES | | | | |
| Inpatient_EHR__c | varchar(131) | YES | | | | |
| RCM__c | varchar(165) | YES | | | | |
| HIE__c | varchar(156) | YES | | | | |
| Provider_Number__c | varchar(7) | YES | | | | |
| IDN__c | varchar(84) | YES | | | | |
| IDN_Parent__c | varchar(139) | YES | | | | |
| Uncompensated_Care__c | double | YES | | | | |
| Payor_Mix_Medicare__c | double | YES | | | | |
| Payor_Mix_Medicaid__c | double | YES | | | | |
| Payor_Mix_Private_Self_Pay_Other__c | double | YES | | | | |
| of_Affiliated_Physicians__c | double | YES | | | | |
| Outpatient_Revenue__c | double | YES | | | | |
| of_Outpatient_Visits__c | double | YES | | | | |
| of_ER_Visits__c | double | YES | | | | |
| of_Beds__c | double | YES | | | | |
| Address2__c | varchar(59) | YES | | | | |
| Actively_Looking__c | tinyint(1) | YES | | | | |
| Purchasing_Contact__c | varchar(100) | YES | | | | |
| Rural_Zip__c | tinyint(1) | YES | | | | |
| Days_to_Conversion__c | double | YES | | | | |
| Last_Activity_Date__c | datetime(6) | YES | | | | |
| Days_Since_Last_Activity__c | double | YES | | | | |
| Owner_Active__c | varchar(3) | YES | | | | |
| Buying_Timeline__c | varchar(17) | YES | | | | |
| MRR_Target__c | varchar(8) | YES | | | | |
| Existing_Contract_Terminated__c | varchar(3) | YES | | | | |
| TMP__c | varchar(8) | YES | | | | |
| TMP_Other_Details__c | varchar(42) | YES | | | | |
| Specific_Lead_Source__c | varchar(103) | YES | | | | |
| dupcheck__dc3DisableDuplicateCheck__c | tinyint(1) | YES | | | | |
| Estimated_MRR__c | double | YES | | | | |
| ofStaffOld__c | varchar(10) | YES | | | | |
| AccountCategory__c | varchar(25) | YES | | | | |
| AccountType__c | varchar(17) | YES | | | | |
| Age_hours__c | double | YES | | | | |
| Email_Bounced__c | tinyint(1) | YES | | | | |
| BillingCompanySolution__c | varchar(11) | YES | | | | |
| BillingService__c | varchar(0) | YES | | | | |
| Demo_Date__c | varchar(31) | YES | | | | |
| Demo_Time__c | varchar(30) | YES | | | | |
| Demo_Time_Lead_Time_Zone__c | datetime(6) | YES | | | | |
| Entry_URL__c | varchar(255) | YES | | | | |
| ExistingPMS__c | varchar(0) | YES | | | | |
| Howdidyoulearnaboutus__c | varchar(15) | YES | | | | |
| Iflearnedofusotherhow__c | varchar(83) | YES | | | | |
| Ifspecialtyotherwhat__c | varchar(20) | YES | | | | |
| Interested_in_Billing__c | tinyint(1) | YES | | | | |
| Interested_in_Charting__c | tinyint(1) | YES | | | | |
| InterestedinClinicalEdition__c | varchar(0) | YES | | | | |
| InterestedinEnterpriseEdition__c | varchar(0) | YES | | | | |
| Interested_in_Messaging__c | tinyint(1) | YES | | | | |
| InterestedinMobileEdition__c | varchar(0) | YES | | | | |
| Interested_in_Other__c | varchar(50) | YES | | | | |
| InterestedinPortalEdition__c | varchar(0) | YES | | | | |
| InterestedinProfessionalEdition__c | varchar(3) | YES | | | | |
| Interested_in_Scheduling__c | tinyint(1) | YES | | | | |
| InterestedinStandardEdition__c | varchar(3) | YES | | | | |
| InternetAccess__c | varchar(0) | YES | | | | |
| Next_Step__c | varchar(255) | YES | | | | |
| Request_Credit__c | tinyint(1) | YES | | | | |
| Lead_ID2__c | double | YES | | | | |
| Lead_Quality_1_5_Old__c | double | YES | | | | |
| LeadRep__c | varchar(0) | YES | | | | |
| Lead_Status_Date__c | datetime(6) | YES | | | | |
| LeadStatusDetail__c | varchar(50) | YES | | | | |
| Link_Campaign__c | varchar(25) | YES | | | | |
| Link_Description__c | text | YES | | | | |
| Lost_Billing_EDI__c | tinyint(1) | YES | | | | |
| PatientVolume__c | varchar(10) | YES | | | | |
| Planning_to_Purchase__c | varchar(252) | YES | | | | |
| PMSCompanySolution__c | varchar(100) | YES | | | | |
| PotentialofPhysicians__c | double | YES | | | | |
| Price__c | double | YES | | | | |
| Product__c | varchar(22) | YES | | | | |
| Referring_URL__c | varchar(255) | YES | | | | |
| Time_Zone__c | varchar(8) | YES | | | | |
| TranscriptionCompanySolution__c | varchar(17) | YES | | | | |
| TranscriptionService__c | varchar(14) | YES | | | | |
| Unedited__c | tinyint(1) | YES | | | | |
| Owner_on_PTO__c | tinyint(1) | YES | | | | |
| LeadStatusDate__c | datetime(6) | YES | | | | |
| Lead_Action__c | varchar(0) | YES | | | | |
| Lead_Cost__c | double | YES | | | | |
| Lead_Quality_1_5__c | double | YES | | | | |
| Reason_Lost__c | varchar(0) | YES | | | | |
| Mail_Returned_From_Address__c | tinyint(1) | YES | | | | |
| Other_Specialties__c | varchar(94) | YES | | | | |
| LID__LinkedIn_Company_Id__c | varchar(0) | YES | | | | |
| LID__LinkedIn_Member_Token__c | varchar(0) | YES | | | | |
| LMD_Specialty__c | varchar(151) | YES | | | | |
| DQL_Reason__c | varchar(26) | YES | | | | |
| Active_Lead__c | double | YES | | | | |
| Current_Monthly_Spend__c | double | YES | | | | |
| Product_Type_Interested_In__c | varchar(41) | YES | | | | |
| PreviousLeadOwner__c | varchar(24) | YES | | | | |
| Current_Lead_Owner__c | varchar(24) | YES | | | | |
| DQL_Reason_Other_Details__c | varchar(255) | YES | | | | |
| Date_of_SQL__c | datetime(6) | YES | | | | |
| Current_List_Import__c | varchar(16) | YES | | | | |
| Full_Name__c | varchar(79) | YES | | | | |
| Current_Vendor_Status__c | varchar(17) | YES | | | | |
| Date_of_SAL__c | datetime(6) | YES | | | | |
| texcellency__DefHC_ExecutiveID__c | double | YES | | | | |
| texcellency__DefHC_HospitalID__c | double | YES | | | | |
| texcellency__DefHC_Is_Active__c | tinyint(1) | YES | | | | |
| texcellency__DefHC_Record_Changed_Date__c | datetime(6) | YES | | | | |
| texcellency__DefHC_SyncTime__c | datetime(6) | YES | | | | |
| Date_of_MQL__c | datetime(6) | YES | | | | |
| Converted__c | varchar(3) | YES | | | | |
| dupcheck__dc3Index__c | varchar(0) | YES | | | | |
| dupcheck__dc3Web2Lead__c | tinyint(1) | YES | | | | |
| Date_of_DQL__c | datetime(6) | YES | | | | |
| Next_Step_Date__c | datetime(6) | YES | | | | |
| Assigned_Sales_Rep__c | varchar(18) | YES | | | | |
| Last_Status_Update__c | datetime(6) | YES | | | | |
| Days_in_Current_Status__c | double | YES | | | | |
| If_PreCert_Only_Monthly_Volume__c | double | YES | | | | |
| Current_System2__c | varchar(24) | YES | | | | |
| Hospital_owned_or_Independent__c | varchar(14) | YES | | | | |
| GCLID__c | varchar(0) | YES | | | | |
| Primary_Specialty__c | varchar(36) | YES | | | | |
| Referred_By__c | varchar(29) | YES | | | | |
| engagio__Department__c | varchar(14) | YES | | | | |
| engagio__EngagementMinutesLast3Months__c | double | YES | | | | |
| engagio__EngagementMinutesLast7Days__c | double | YES | | | | |
| engagio__FirstEngagementDate__c | datetime(6) | YES | | | | |
| engagio__InPlay__c | tinyint(1) | YES | | | | |
| engagio__LastPlay__c | varchar(0) | YES | | | | |
| engagio__LeftCompany__c | tinyint(1) | YES | | | | |
| engagio__Match_Time__c | datetime(6) | YES | | | | |
| engagio__Matched_Account_Annual_Revenue__c | double | YES | | | | |
| engagio__Matched_Account_Employees__c | double | YES | | | | |
| engagio__Matched_Account_EngageMinsLast3Months__c | double | YES | | | | |
| engagio__Matched_Account_EngageMinsLast7Days__c | double | YES | | | | |
| engagio__Matched_Account_Engagio_Status__c | varchar(16) | YES | | | | |
| engagio__Matched_Account_HQ_State__c | varchar(9) | YES | | | | |
| engagio__Matched_Account_Industry__c | varchar(15) | YES | | | | |
| engagio__Matched_Account_Name__c | varchar(126) | YES | | | | |
| engagio__Matched_Account_Owner_Name__c | varchar(24) | YES | | | | |
| engagio__Matched_Account_Type__c | varchar(20) | YES | | | | |
| engagio__Matched_Account__c | varchar(18) | YES | | | | |
| engagio__Role__c | varchar(8) | YES | | | | |