Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec augue nunc, pretium at augue at, convallis pellentesque ipsum. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

John Smith

Founder of Something




Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec augue nunc, pretium at augue at, convallis pellentesque ipsum. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

John Smith

Founder of Something

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BASIC_Output_CSV](
  [TAXONOMY] [varchar](400) NOT NULL,
  [TAXONOMY_Group_Classification] [varchar](600) NOT NULL,
  [TAXONOMY_Specialization] [varchar](500) NULL,
  [TAXONOMY_CODE] [varchar](10) NULL,
  [TAXO_IS_PRIMARY] [varchar](1) NULL,
  [NPI] [bigint] NOT NULL,
  [EntityType] [int] NULL,
  [EntityDescription] [varchar](50) NULL,
  [EnumerationDate] [date] NULL,
  [UpdateDate] [date] NULL,
  [OrganizationName] [varchar](80) NULL,
  [OtherOrganizationName] [varchar](80) NULL,
  [LegalBusinessName] [varchar](80) NULL,
  [NamePrefix] [varchar](8) NULL,
  [FirstName] [varchar](32) NULL,
  [MiddleName] [varchar](32) NULL,
  [LastName] [varchar](64) NULL,
  [Suffix] [varchar](8) NULL,
  [CredentialText] [varchar](32) NULL,
  [Proper_Name] [varchar](200) NULL,
  [SoleOwner] [varchar](1) NULL,
  [SubPart] [varchar](1) NULL,
  [Office_Contact_Title] [varchar](64) NULL,
  [Office_Contact_NamePrefix] [varchar](50) NULL,
  [Office_Contact_FirstName] [varchar](50) NULL,
  [Office_Contact_MiddleName] [varchar](50) NULL,
  [Office_Contact_LastName] [varchar](64) NULL,
  [Office_Contact_NameSuffix] [varchar](50) NULL,
  [Office_Contact_Telephone] [varchar](50) NULL,
  [Office_Contact_Credential] [varchar](80) NULL,
  [GroupName] [varchar](50) NULL,
  [BUS_Address1] [varchar](64) NULL,
  [BUS_Address2] [varchar](64) NULL,
  [BUS_City] [varchar](64) NULL,
  [BUS_State] [varchar](64) NULL,
  [BUS_PostalCode] [varchar](24) NULL,
  [PRAC_Address1] [varchar](64) NULL,
  [PRAC_Address2] [varchar](64) NULL,
  [PRAC_City] [varchar](64) NULL,
  [PRAC_State] [varchar](64) NULL,
  [PRAC_PostalCode] [varchar](24) NULL,
  [BUS_Voice] [varchar](24) NULL,
  [BUS_Fax] [varchar](24) NULL,
  [PRAC_Voice] [varchar](24) NULL,
  [PRAC_Fax] [varchar](24) NULL,
  [Gender] [varchar](1) NULL,
  [PECOS_Registered] [bit] NULL,
  [PECOS_PART_B] [bit] NULL,
  [PECOS_HHA] [bit] NULL,
  [PECOS_DME] [bit] NULL,
  [PECOS_PMD] [bit] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BASIC_Output_CSV_LOCS](
  [NPI] [bigint] NOT NULL,
  [EntityType] [int] NULL,
  [PROPER_NAME] [varchar](200) NULL,
  [PRAC_Address1] [varchar](64) NULL,
  [PRAC_Address2] [varchar](64) NULL,
  [PRAC_City] [varchar](64) NULL,
  [PRAC_State] [varchar](64) NULL,
  [PRAC_PostalCode] [varchar](24) NULL,
  [PRAC_Voice] [varchar](24) NULL,
  [PRAC_Fax] [varchar](24) NULL
) ON [PRIMARY]
GO

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec augue nunc, pretium at augue at, convallis pellentesque ipsum. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

John Smith

Founder of Something