January 17, 2008 at 10:14 am
Jeremy (1/17/2008)
Shaun McGuile (1/16/2008)
Current petrol prices here are abou $7.73 per gallon(US)!!!!!:crying:$6.18 of that is tax!!!!!:crying:
--Shaun
I remember paying $0.80 per gallon in Texas in the mid '90s 🙂
Hah! Got you one better, I remember my dad taking me to hockey practice in the mid 70's, in his lime green Ford Pinto and complaining about gas at .25 a gallon.
January 18, 2008 at 4:57 am
Yes DTS can handle this and DTS will run in SQL 2005, although it would need to be converted to SSIS in order to be modified under 2005. Having said that - take a look at the indexes on the tables. In our data warehouse, we drop the indexes prior to loading and then recreate them. Helps to speed up the load.
January 18, 2008 at 6:47 am
Ture enough... and I've not tried the SSIS solution for this, but (just something to consider) the DTS solution was horribly slow compared to the BULK INSERT that used the format file.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 18, 2008 at 6:49 am
Whitt,
What I really want to know is that, although this was a great exercise for me personally, I did sort of bust a hump to give you a complete high-speed solution... how about a little feedback, please.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 23, 2008 at 9:04 am
Jeff Moden (1/18/2008)
Whitt,What I really want to know is that, although this was a great exercise for me personally, I did sort of bust a hump to give you a complete high-speed solution... how about a little feedback, please.
Jeff,
Really sorry for the delay. I'm being shifted from fire to fire here. I haven't had time to run this as I've been moved to helping with other release-related issues, but as soon as this stuff dies down I'll get back on this.
To everybody who posted -- I appreciate the help. I haven't had time to properly maintain my thread, but soon as I get this stuff running I'll post a concise summary of what I did in the end.
Re: Michiganders -- I just finished my degree from Oakland University in Rochester, MI.
January 23, 2008 at 3:35 pm
OTHER THOUGHTS:
You may want to try importing the whole file into SQL as 1 field VARCHAR(whateveryourmaxrecordlength).
Or Maybe parse out the first few fields if they can be used as a key, and the remaining rouge fields as one long textstring.
Then use T-SQL to parse into a target table.
WHY IS SERVER SLOWER THAN LAPTOP? Laptop is local, is the server import happening over a network? [slower/bottleneck-->Not only is network slower, but think about the permissions checking that goes on each time you connect to the server RBAR(TM)]. Try moving your raw data (and .NET app?) to the server before the import.
January 23, 2008 at 8:31 pm
Whitt (1/23/2008)
Jeff,Really sorry for the delay. I'm being shifted from fire to fire here. I haven't had time to run this as I've been moved to helping with other release-related issues, but as soon as this stuff dies down I'll get back on this.
To everybody who posted -- I appreciate the help. I haven't had time to properly maintain my thread, but soon as I get this stuff running I'll post a concise summary of what I did in the end.
Re: Michiganders -- I just finished my degree from Oakland University in Rochester, MI.
That's almost right up from the road from me. We should swing a beer or two sometime! Congrats on the degree!
Speaking of fires, Whitt, my company is moving to North Carolina... I've decided to not leave Michigan for a lot of reasons... you wouldn't happen to have room at work for a guy who thinks he knows a something about SQL Server, would ya?
--Jeff Moden
Change is inevitable... Change for the better is not.
January 24, 2008 at 11:59 am
Unfortunately, I'm no longer in Michigan. When I graduated, I didn't have a single interview in the state. I'm now based with a company out of Boston, MA. It's a lot like Michigan, except people drive much, much worse.
January 24, 2008 at 4:31 pm
Yeah- huh? I spent most of my school years in Rhode Island... I know what you mean.
Good luck and thanks for the feedback!
--Jeff Moden
Change is inevitable... Change for the better is not.
February 6, 2008 at 9:49 am
/thread-necromancy
The final solution I used for this one:
I used my C# .NET program to clean up the CSV provided by CMS and pull only the fields I needed into a new, cleaned up CSV. (5 -7 minutes to run)
I then used the BCP utility do a bulk insert into the database using a format file. I tweaked the file that provided by Jeff Moden to insert the fields from my new CSV. (~45 seconds)
I then ran a SQL script that used joins and some where clauses to transform the data from my temporary table into the target tables. (~3 minutes)
This is a serious improvement from the original 9 - 10 hour runtime that we were seeing. I didn't understand how inefficient RBAR was, and with the help ya'll provided, I was able to tame this program. Thanks again guys.
February 6, 2008 at 6:52 pm
Perfect... another "convert" to denounce the evils of RBAR 😛
Thanks, for the feedback, Whitt. Real glad we could collectively make such a difference for you.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 18, 2008 at 2:18 am
Jeff Moden (2/6/2008)
Perfect... another "convert" to denounce the evils of RBAR 😛Thanks, for the feedback, Whitt. Real glad we could collectively make such a difference for you.
RBAR is definitely not the way to do things in SQL, sometimes the trick is finding where they are hiding.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 14, 2016 at 7:48 am
Many years later and found your post very helpful. The file format has been updated, so I figured I'd share the updated files so if someone stumbles upon this thread, they'll be able to get up and go.
This process took about 15 minutes to import. The file is now up to 330 columns and is 5.5GB in size.
Table Create Script
CREATE TABLE dbo.NPIData
(
RowNum INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
[NPI] DECIMAL(10) NULL ,
[Entity Type Code] TINYINT NULL ,
[Replacement NPI] DECIMAL(10) NULL ,
[Employer Identification Number (EIN)] VARCHAR(9) NULL ,
[Provider Organization Name (Legal Business Name)] VARCHAR(80) NULL ,
[Provider Last Name (Legal Name)] VARCHAR(35) NULL ,
[Provider First Name] VARCHAR(20) NULL ,
[Provider Middle Name] VARCHAR(20) NULL ,
[Provider Name Prefix Text] VARCHAR(5) NULL ,
[Provider Name Suffix Text] VARCHAR(5) NULL ,
[Provider Credential Text] VARCHAR(20) NULL ,
[Provider Other Organization Name] VARCHAR(70) NULL ,
[Provider Other Organization Name Type Code] VARCHAR(1) NULL ,
[Provider Other Last Name] VARCHAR(35) NULL ,
[Provider Other First Name] VARCHAR(20) NULL ,
[Provider Other Middle Name] VARCHAR(20) NULL ,
[Provider Other Name Prefix Text] VARCHAR(5) NULL ,
[Provider Other Name Suffix Text] VARCHAR(5) NULL ,
[Provider Other Credential Text] VARCHAR(20) NULL ,
[Provider Other Last Name Type Code] CHAR(1) NULL ,
[Provider First Line Business Mailing Address] VARCHAR(60) NULL ,
[Provider Second Line Business Mailing Address] VARCHAR(60) NULL ,
[Provider Business Mailing Address City Name] VARCHAR(40) NULL ,
[Provider Business Mailing Address State Name] VARCHAR(40) NULL ,
[Provider Business Mailing Address Postal Code] VARCHAR(20) NULL ,
[Provider Business Mailing Address Country Code (If outside U.S.)] CHAR(2) NULL ,
[Provider Business Mailing Address Telephone Number] VARCHAR(20) NULL ,
[Provider Business Mailing Address Fax Number] VARCHAR(20) NULL ,
[Provider First Line Business Practice Location Address] VARCHAR(60) NULL ,
[Provider Second Line Business Practice Location Address] VARCHAR(60) NULL ,
[Provider Business Practice Location Address City Name] VARCHAR(40) NULL ,
[Provider Business Practice Location Address State Name] VARCHAR(40) NULL ,
[Provider Business Practice Location Address Postal Code] VARCHAR(20) NULL ,
[Provider Business Practice Location Address Country Code (If outside U.S.)] CHAR(2) NULL ,
[Provider Business Practice Location Address Telephone Number] VARCHAR(20) NULL ,
[Provider Business Practice Location Address Fax Number] VARCHAR(20) NULL ,
[Provider Enumeration Date] DATETIME NULL ,
[Last Update Date] DATETIME NULL ,
[NPI Deactivation Reason Code] VARCHAR(2) NULL ,
[NPI Deactivation Date] DATETIME NULL ,
[NPI Reactivation Date] DATETIME NULL ,
[Provider Gender Code] CHAR(1) NULL ,
[Authorized Official Last Name] VARCHAR(35) NULL ,
[Authorized Official First Name] VARCHAR(20) NULL ,
[Authorized Official Middle Name] VARCHAR(20) NULL ,
[Authorized Official Title or Position] VARCHAR(35) NULL ,
[Authorized Official Telephone Number] VARCHAR(20) NULL ,
[Healthcare Provider Taxonomy Code_1] VARCHAR(10) NULL ,
[Provider License Number_1] VARCHAR(20) NULL ,
[Provider License Number State Code_1] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_1] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_2] VARCHAR(10) NULL ,
[Provider License Number_2] VARCHAR(20) NULL ,
[Provider License Number State Code_2] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_2] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_3] VARCHAR(10) NULL ,
[Provider License Number_3] VARCHAR(20) NULL ,
[Provider License Number State Code_3] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_3] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_4] VARCHAR(10) NULL ,
[Provider License Number_4] VARCHAR(20) NULL ,
[Provider License Number State Code_4] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_4] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_5] VARCHAR(10) NULL ,
[Provider License Number_5] VARCHAR(20) NULL ,
[Provider License Number State Code_5] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_5] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_6] VARCHAR(10) NULL ,
[Provider License Number_6] VARCHAR(20) NULL ,
[Provider License Number State Code_6] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_6] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_7] VARCHAR(10) NULL ,
[Provider License Number_7] VARCHAR(20) NULL ,
[Provider License Number State Code_7] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_7] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_8] VARCHAR(10) NULL ,
[Provider License Number_8] VARCHAR(20) NULL ,
[Provider License Number State Code_8] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_8] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_9] VARCHAR(10) NULL ,
[Provider License Number_9] VARCHAR(20) NULL ,
[Provider License Number State Code_9] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_9] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_10] VARCHAR(10) NULL ,
[Provider License Number_10] VARCHAR(20) NULL ,
[Provider License Number State Code_10] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_10] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_11] VARCHAR(10) NULL ,
[Provider License Number_11] VARCHAR(20) NULL ,
[Provider License Number State Code_11] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_11] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_12] VARCHAR(10) NULL ,
[Provider License Number_12] VARCHAR(20) NULL ,
[Provider License Number State Code_12] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_12] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_13] VARCHAR(10) NULL ,
[Provider License Number_13] VARCHAR(20) NULL ,
[Provider License Number State Code_13] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_13] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_14] VARCHAR(10) NULL ,
[Provider License Number_14] VARCHAR(20) NULL ,
[Provider License Number State Code_14] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_14] VARCHAR(5) NULL ,
[Healthcare Provider Taxonomy Code_15] VARCHAR(10) NULL ,
[Provider License Number_15] VARCHAR(20) NULL ,
[Provider License Number State Code_15] CHAR(2) NULL ,
[Healthcare Provider Primary Taxonomy Switch_15] VARCHAR(5) NULL ,
[Other Provider Identifier_1] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_1] VARCHAR(2) NULL ,
[Other Provider Identifier State_1] CHAR(2) NULL ,
[Other Provider Identifier Issuer_1] VARCHAR(80) NULL ,
[Other Provider Identifier_2] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_2] VARCHAR(2) NULL ,
[Other Provider Identifier State_2] CHAR(2) NULL ,
[Other Provider Identifier Issuer_2] VARCHAR(80) NULL ,
[Other Provider Identifier_3] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_3] VARCHAR(2) NULL ,
[Other Provider Identifier State_3] CHAR(2) NULL ,
[Other Provider Identifier Issuer_3] VARCHAR(80) NULL ,
[Other Provider Identifier_4] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_4] VARCHAR(2) NULL ,
[Other Provider Identifier State_4] CHAR(2) NULL ,
[Other Provider Identifier Issuer_4] VARCHAR(80) NULL ,
[Other Provider Identifier_5] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_5] VARCHAR(2) NULL ,
[Other Provider Identifier State_5] CHAR(2) NULL ,
[Other Provider Identifier Issuer_5] VARCHAR(80) NULL ,
[Other Provider Identifier_6] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_6] VARCHAR(2) NULL ,
[Other Provider Identifier State_6] CHAR(2) NULL ,
[Other Provider Identifier Issuer_6] VARCHAR(80) NULL ,
[Other Provider Identifier_7] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_7] VARCHAR(2) NULL ,
[Other Provider Identifier State_7] CHAR(2) NULL ,
[Other Provider Identifier Issuer_7] VARCHAR(80) NULL ,
[Other Provider Identifier_8] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_8] VARCHAR(2) NULL ,
[Other Provider Identifier State_8] CHAR(2) NULL ,
[Other Provider Identifier Issuer_8] VARCHAR(80) NULL ,
[Other Provider Identifier_9] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_9] VARCHAR(2) NULL ,
[Other Provider Identifier State_9] CHAR(2) NULL ,
[Other Provider Identifier Issuer_9] VARCHAR(80) NULL ,
[Other Provider Identifier_10] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_10] VARCHAR(2) NULL ,
[Other Provider Identifier State_10] CHAR(2) NULL ,
[Other Provider Identifier Issuer_10] VARCHAR(80) NULL ,
[Other Provider Identifier_11] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_11] VARCHAR(2) NULL ,
[Other Provider Identifier State_11] CHAR(2) NULL ,
[Other Provider Identifier Issuer_11] VARCHAR(80) NULL ,
[Other Provider Identifier_12] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_12] VARCHAR(2) NULL ,
[Other Provider Identifier State_12] CHAR(2) NULL ,
[Other Provider Identifier Issuer_12] VARCHAR(80) NULL ,
[Other Provider Identifier_13] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_13] VARCHAR(2) NULL ,
[Other Provider Identifier State_13] CHAR(2) NULL ,
[Other Provider Identifier Issuer_13] VARCHAR(80) NULL ,
[Other Provider Identifier_14] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_14] VARCHAR(2) NULL ,
[Other Provider Identifier State_14] CHAR(2) NULL ,
[Other Provider Identifier Issuer_14] VARCHAR(80) NULL ,
[Other Provider Identifier_15] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_15] VARCHAR(2) NULL ,
[Other Provider Identifier State_15] CHAR(2) NULL ,
[Other Provider Identifier Issuer_15] VARCHAR(80) NULL ,
[Other Provider Identifier_16] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_16] VARCHAR(2) NULL ,
[Other Provider Identifier State_16] CHAR(2) NULL ,
[Other Provider Identifier Issuer_16] VARCHAR(80) NULL ,
[Other Provider Identifier_17] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_17] VARCHAR(2) NULL ,
[Other Provider Identifier State_17] CHAR(2) NULL ,
[Other Provider Identifier Issuer_17] VARCHAR(80) NULL ,
[Other Provider Identifier_18] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_18] VARCHAR(2) NULL ,
[Other Provider Identifier State_18] CHAR(2) NULL ,
[Other Provider Identifier Issuer_18] VARCHAR(80) NULL ,
[Other Provider Identifier_19] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_19] VARCHAR(2) NULL ,
[Other Provider Identifier State_19] CHAR(2) NULL ,
[Other Provider Identifier Issuer_19] VARCHAR(80) NULL ,
[Other Provider Identifier_20] VARCHAR(25) NULL ,
[Other Provider Identifier Type Code_20] VARCHAR(2) NULL ,
[Other Provider Identifier State_20] CHAR(2) NULL ,
[Other Provider Identifier Issuer_20] VARCHAR(80) NULL ,
[Other Provider Identifier_21] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_21] VARCHAR(80) NULL ,
[Other Provider Identifier State_21] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_21] VARCHAR(80) NULL ,
[Other Provider Identifier_22] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_22] VARCHAR(80) NULL ,
[Other Provider Identifier State_22] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_22] VARCHAR(80) NULL ,
[Other Provider Identifier_23] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_23] VARCHAR(80) NULL ,
[Other Provider Identifier State_23] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_23] VARCHAR(80) NULL ,
[Other Provider Identifier_24] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_24] VARCHAR(80) NULL ,
[Other Provider Identifier State_24] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_24] VARCHAR(80) NULL ,
[Other Provider Identifier_25] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_25] VARCHAR(80) NULL ,
[Other Provider Identifier State_25] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_25] VARCHAR(80) NULL ,
[Other Provider Identifier_26] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_26] VARCHAR(80) NULL ,
[Other Provider Identifier State_26] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_26] VARCHAR(80) NULL ,
[Other Provider Identifier_27] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_27] VARCHAR(80) NULL ,
[Other Provider Identifier State_27] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_27] VARCHAR(80) NULL ,
[Other Provider Identifier_28] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_28] VARCHAR(80) NULL ,
[Other Provider Identifier State_28] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_28] VARCHAR(80) NULL ,
[Other Provider Identifier_29] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_29] VARCHAR(80) NULL ,
[Other Provider Identifier State_29] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_29] VARCHAR(80) NULL ,
[Other Provider Identifier_30] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_30] VARCHAR(80) NULL ,
[Other Provider Identifier State_30] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_30] VARCHAR(80) NULL ,
[Other Provider Identifier_31] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_31] VARCHAR(80) NULL ,
[Other Provider Identifier State_31] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_31] VARCHAR(80) NULL ,
[Other Provider Identifier_32] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_32] VARCHAR(80) NULL ,
[Other Provider Identifier State_32] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_32] VARCHAR(80) NULL ,
[Other Provider Identifier_33] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_33] VARCHAR(80) NULL ,
[Other Provider Identifier State_33] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_33] VARCHAR(80) NULL ,
[Other Provider Identifier_34] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_34] VARCHAR(80) NULL ,
[Other Provider Identifier State_34] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_34] VARCHAR(80) NULL ,
[Other Provider Identifier_35] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_35] VARCHAR(80) NULL ,
[Other Provider Identifier State_35] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_35] VARCHAR(80) NULL ,
[Other Provider Identifier_36] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_36] VARCHAR(80) NULL ,
[Other Provider Identifier State_36] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_36] VARCHAR(80) NULL ,
[Other Provider Identifier_37] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_37] VARCHAR(80) NULL ,
[Other Provider Identifier State_37] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_37] VARCHAR(80) NULL ,
[Other Provider Identifier_38] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_38] VARCHAR(80) NULL ,
[Other Provider Identifier State_38] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_38] VARCHAR(80) NULL ,
[Other Provider Identifier_39] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_39] VARCHAR(80) NULL ,
[Other Provider Identifier State_39] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_39] VARCHAR(80) NULL ,
[Other Provider Identifier_40] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_40] VARCHAR(80) NULL ,
[Other Provider Identifier State_40] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_40] VARCHAR(80) NULL ,
[Other Provider Identifier_41] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_41] VARCHAR(80) NULL ,
[Other Provider Identifier State_41] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_41] VARCHAR(80) NULL ,
[Other Provider Identifier_42] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_42] VARCHAR(80) NULL ,
[Other Provider Identifier State_42] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_42] VARCHAR(80) NULL ,
[Other Provider Identifier_43] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_43] VARCHAR(80) NULL ,
[Other Provider Identifier State_43] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_43] VARCHAR(80) NULL ,
[Other Provider Identifier_44] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_44] VARCHAR(80) NULL ,
[Other Provider Identifier State_44] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_44] VARCHAR(80) NULL ,
[Other Provider Identifier_45] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_45] VARCHAR(80) NULL ,
[Other Provider Identifier State_45] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_45] VARCHAR(80) NULL ,
[Other Provider Identifier_46] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_46] VARCHAR(80) NULL ,
[Other Provider Identifier State_46] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_46] VARCHAR(80) NULL ,
[Other Provider Identifier_47] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_47] VARCHAR(80) NULL ,
[Other Provider Identifier State_47] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_47] VARCHAR(80) NULL ,
[Other Provider Identifier_48] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_48] VARCHAR(80) NULL ,
[Other Provider Identifier State_48] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_48] VARCHAR(80) NULL ,
[Other Provider Identifier_49] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_49] VARCHAR(80) NULL ,
[Other Provider Identifier State_49] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_49] VARCHAR(80) NULL ,
[Other Provider Identifier_50] VARCHAR(80) NULL ,
[Other Provider Identifier Type Code_50] VARCHAR(80) NULL ,
[Other Provider Identifier State_50] VARCHAR(80) NULL ,
[Other Provider Identifier Issuer_50] VARCHAR(80) NULL ,
[Is Sole Proprietor] VARCHAR(80) NULL ,
[Is Organization Subpart] VARCHAR(80) NULL ,
[Parent Organization LBN] VARCHAR(80) NULL ,
[Parent Organization TIN] VARCHAR(80) NULL ,
[Authorized Official Name Prefix Text] VARCHAR(80) NULL ,
[Authorized Official Name Suffix Text] VARCHAR(80) NULL ,
[Authorized Official Credential Text] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_1] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_2] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_3] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_4] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_5] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_6] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_7] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_8] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_9] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_10] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_11] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_12] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_13] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_14] VARCHAR(80) NULL ,
[Healthcare Provider Taxonomy Group_15] VARCHAR(80) NULL
)
GO
Format File (Same issue with the last row, 330, should be "\"<backslashN>")
9.0
330
1 SQLCHAR 0 999 "\"" 0 IgnoreMe ""
2 SQLCHAR 0 999 "\",\"" 2 NPI ""
3 SQLCHAR 0 999 "\",\"" 3 EntityTypeCode ""
4 SQLCHAR 0 999 "\",\"" 4 ReplacementNPI ""
5 SQLCHAR 0 999 "\",\"" 5 EmployerIdentificationNumber(EIN) ""
6 SQLCHAR 0 999 "\",\"" 6 ProviderOrganizationName(LegalBusinessName) ""
7 SQLCHAR 0 999 "\",\"" 7 ProviderLastName(LegalName) ""
8 SQLCHAR 0 999 "\",\"" 8 ProviderFirstName ""
9 SQLCHAR 0 999 "\",\"" 9 ProviderMiddleName ""
10 SQLCHAR 0 999 "\",\"" 10 ProviderNamePrefixText ""
11 SQLCHAR 0 999 "\",\"" 11 ProviderNameSuffixText ""
12 SQLCHAR 0 999 "\",\"" 12 ProviderCredentialText ""
13 SQLCHAR 0 999 "\",\"" 13 ProviderOtherOrganizationName ""
14 SQLCHAR 0 999 "\",\"" 14 ProviderOtherOrganizationNameTypeCode ""
15 SQLCHAR 0 999 "\",\"" 15 ProviderOtherLastName ""
16 SQLCHAR 0 999 "\",\"" 16 ProviderOtherFirstName ""
17 SQLCHAR 0 999 "\",\"" 17 ProviderOtherMiddleName ""
18 SQLCHAR 0 999 "\",\"" 18 ProviderOtherNamePrefixText ""
19 SQLCHAR 0 999 "\",\"" 19 ProviderOtherNameSuffixText ""
20 SQLCHAR 0 999 "\",\"" 20 ProviderOtherCredentialText ""
21 SQLCHAR 0 999 "\",\"" 21 ProviderOtherLastNameTypeCode ""
22 SQLCHAR 0 999 "\",\"" 22 ProviderFirstLineBusinessMailingAddress ""
23 SQLCHAR 0 999 "\",\"" 23 ProviderSecondLineBusinessMailingAddress ""
24 SQLCHAR 0 999 "\",\"" 24 ProviderBusinessMailingAddressCityName ""
25 SQLCHAR 0 999 "\",\"" 25 ProviderBusinessMailingAddressStateName ""
26 SQLCHAR 0 999 "\",\"" 26 ProviderBusinessMailingAddressPostalCode ""
27 SQLCHAR 0 999 "\",\"" 27 ProviderBusinessMailingAddressCountryCode(IfoutsideU.S.) ""
28 SQLCHAR 0 999 "\",\"" 28 ProviderBusinessMailingAddressTelephoneNumber ""
29 SQLCHAR 0 999 "\",\"" 29 ProviderBusinessMailingAddressFaxNumber ""
30 SQLCHAR 0 999 "\",\"" 30 ProviderFirstLineBusinessPracticeLocationAddress ""
31 SQLCHAR 0 999 "\",\"" 31 ProviderSecondLineBusinessPracticeLocationAddress ""
32 SQLCHAR 0 999 "\",\"" 32 ProviderBusinessPracticeLocationAddressCityName ""
33 SQLCHAR 0 999 "\",\"" 33 ProviderBusinessPracticeLocationAddressStateName ""
34 SQLCHAR 0 999 "\",\"" 34 ProviderBusinessPracticeLocationAddressPostalCode ""
35 SQLCHAR 0 999 "\",\"" 35 ProviderBusinessPracticeLocationAddressCountryCode(IfoutsideU.S.) ""
36 SQLCHAR 0 999 "\",\"" 36 ProviderBusinessPracticeLocationAddressTelephoneNumber ""
37 SQLCHAR 0 999 "\",\"" 37 ProviderBusinessPracticeLocationAddressFaxNumber ""
38 SQLCHAR 0 999 "\",\"" 38 ProviderEnumerationDate ""
39 SQLCHAR 0 999 "\",\"" 39 LastUpdateDate ""
40 SQLCHAR 0 999 "\",\"" 40 NPIDeactivationReasonCode ""
41 SQLCHAR 0 999 "\",\"" 41 NPIDeactivationDate ""
42 SQLCHAR 0 999 "\",\"" 42 NPIReactivationDate ""
43 SQLCHAR 0 999 "\",\"" 43 ProviderGenderCode ""
44 SQLCHAR 0 999 "\",\"" 44 AuthorizedOfficialLastName ""
45 SQLCHAR 0 999 "\",\"" 45 AuthorizedOfficialFirstName ""
46 SQLCHAR 0 999 "\",\"" 46 AuthorizedOfficialMiddleName ""
47 SQLCHAR 0 999 "\",\"" 47 AuthorizedOfficialTitleorPosition ""
48 SQLCHAR 0 999 "\",\"" 48 AuthorizedOfficialTelephoneNumber ""
49 SQLCHAR 0 999 "\",\"" 49 HealthcareProviderTaxonomyCode_1 ""
50 SQLCHAR 0 999 "\",\"" 50 ProviderLicenseNumber_1 ""
51 SQLCHAR 0 999 "\",\"" 51 ProviderLicenseNumberStateCode_1 ""
52 SQLCHAR 0 999 "\",\"" 52 HealthcareProviderPrimaryTaxonomySwitch_1 ""
53 SQLCHAR 0 999 "\",\"" 53 HealthcareProviderTaxonomyCode_2 ""
54 SQLCHAR 0 999 "\",\"" 54 ProviderLicenseNumber_2 ""
55 SQLCHAR 0 999 "\",\"" 55 ProviderLicenseNumberStateCode_2 ""
56 SQLCHAR 0 999 "\",\"" 56 HealthcareProviderPrimaryTaxonomySwitch_2 ""
57 SQLCHAR 0 999 "\",\"" 57 HealthcareProviderTaxonomyCode_3 ""
58 SQLCHAR 0 999 "\",\"" 58 ProviderLicenseNumber_3 ""
59 SQLCHAR 0 999 "\",\"" 59 ProviderLicenseNumberStateCode_3 ""
60 SQLCHAR 0 999 "\",\"" 60 HealthcareProviderPrimaryTaxonomySwitch_3 ""
61 SQLCHAR 0 999 "\",\"" 61 HealthcareProviderTaxonomyCode_4 ""
62 SQLCHAR 0 999 "\",\"" 62 ProviderLicenseNumber_4 ""
63 SQLCHAR 0 999 "\",\"" 63 ProviderLicenseNumberStateCode_4 ""
64 SQLCHAR 0 999 "\",\"" 64 HealthcareProviderPrimaryTaxonomySwitch_4 ""
65 SQLCHAR 0 999 "\",\"" 65 HealthcareProviderTaxonomyCode_5 ""
66 SQLCHAR 0 999 "\",\"" 66 ProviderLicenseNumber_5 ""
67 SQLCHAR 0 999 "\",\"" 67 ProviderLicenseNumberStateCode_5 ""
68 SQLCHAR 0 999 "\",\"" 68 HealthcareProviderPrimaryTaxonomySwitch_5 ""
69 SQLCHAR 0 999 "\",\"" 69 HealthcareProviderTaxonomyCode_6 ""
70 SQLCHAR 0 999 "\",\"" 70 ProviderLicenseNumber_6 ""
71 SQLCHAR 0 999 "\",\"" 71 ProviderLicenseNumberStateCode_6 ""
72 SQLCHAR 0 999 "\",\"" 72 HealthcareProviderPrimaryTaxonomySwitch_6 ""
73 SQLCHAR 0 999 "\",\"" 73 HealthcareProviderTaxonomyCode_7 ""
74 SQLCHAR 0 999 "\",\"" 74 ProviderLicenseNumber_7 ""
75 SQLCHAR 0 999 "\",\"" 75 ProviderLicenseNumberStateCode_7 ""
76 SQLCHAR 0 999 "\",\"" 76 HealthcareProviderPrimaryTaxonomySwitch_7 ""
77 SQLCHAR 0 999 "\",\"" 77 HealthcareProviderTaxonomyCode_8 ""
78 SQLCHAR 0 999 "\",\"" 78 ProviderLicenseNumber_8 ""
79 SQLCHAR 0 999 "\",\"" 79 ProviderLicenseNumberStateCode_8 ""
80 SQLCHAR 0 999 "\",\"" 80 HealthcareProviderPrimaryTaxonomySwitch_8 ""
81 SQLCHAR 0 999 "\",\"" 81 HealthcareProviderTaxonomyCode_9 ""
82 SQLCHAR 0 999 "\",\"" 82 ProviderLicenseNumber_9 ""
83 SQLCHAR 0 999 "\",\"" 83 ProviderLicenseNumberStateCode_9 ""
84 SQLCHAR 0 999 "\",\"" 84 HealthcareProviderPrimaryTaxonomySwitch_9 ""
85 SQLCHAR 0 999 "\",\"" 85 HealthcareProviderTaxonomyCode_10 ""
86 SQLCHAR 0 999 "\",\"" 86 ProviderLicenseNumber_10 ""
87 SQLCHAR 0 999 "\",\"" 87 ProviderLicenseNumberStateCode_10 ""
88 SQLCHAR 0 999 "\",\"" 88 HealthcareProviderPrimaryTaxonomySwitch_10 ""
89 SQLCHAR 0 999 "\",\"" 89 HealthcareProviderTaxonomyCode_11 ""
90 SQLCHAR 0 999 "\",\"" 90 ProviderLicenseNumber_11 ""
91 SQLCHAR 0 999 "\",\"" 91 ProviderLicenseNumberStateCode_11 ""
92 SQLCHAR 0 999 "\",\"" 92 HealthcareProviderPrimaryTaxonomySwitch_11 ""
93 SQLCHAR 0 999 "\",\"" 93 HealthcareProviderTaxonomyCode_12 ""
94 SQLCHAR 0 999 "\",\"" 94 ProviderLicenseNumber_12 ""
95 SQLCHAR 0 999 "\",\"" 95 ProviderLicenseNumberStateCode_12 ""
96 SQLCHAR 0 999 "\",\"" 96 HealthcareProviderPrimaryTaxonomySwitch_12 ""
97 SQLCHAR 0 999 "\",\"" 97 HealthcareProviderTaxonomyCode_13 ""
98 SQLCHAR 0 999 "\",\"" 98 ProviderLicenseNumber_13 ""
99 SQLCHAR 0 999 "\",\"" 99 ProviderLicenseNumberStateCode_13 ""
100 SQLCHAR 0 999 "\",\"" 100 HealthcareProviderPrimaryTaxonomySwitch_13 ""
101 SQLCHAR 0 999 "\",\"" 101 HealthcareProviderTaxonomyCode_14 ""
102 SQLCHAR 0 999 "\",\"" 102 ProviderLicenseNumber_14 ""
103 SQLCHAR 0 999 "\",\"" 103 ProviderLicenseNumberStateCode_14 ""
104 SQLCHAR 0 999 "\",\"" 104 HealthcareProviderPrimaryTaxonomySwitch_14 ""
105 SQLCHAR 0 999 "\",\"" 105 HealthcareProviderTaxonomyCode_15 ""
106 SQLCHAR 0 999 "\",\"" 106 ProviderLicenseNumber_15 ""
107 SQLCHAR 0 999 "\",\"" 107 ProviderLicenseNumberStateCode_15 ""
108 SQLCHAR 0 999 "\",\"" 108 HealthcareProviderPrimaryTaxonomySwitch_15 ""
109 SQLCHAR 0 999 "\",\"" 109 OtherProviderIdentifier_1 ""
110 SQLCHAR 0 999 "\",\"" 110 OtherProviderIdentifierTypeCode_1 ""
111 SQLCHAR 0 999 "\",\"" 111 OtherProviderIdentifierState_1 ""
112 SQLCHAR 0 999 "\",\"" 112 OtherProviderIdentifierIssuer_1 ""
113 SQLCHAR 0 999 "\",\"" 113 OtherProviderIdentifier_2 ""
114 SQLCHAR 0 999 "\",\"" 114 OtherProviderIdentifierTypeCode_2 ""
115 SQLCHAR 0 999 "\",\"" 115 OtherProviderIdentifierState_2 ""
116 SQLCHAR 0 999 "\",\"" 116 OtherProviderIdentifierIssuer_2 ""
117 SQLCHAR 0 999 "\",\"" 117 OtherProviderIdentifier_3 ""
118 SQLCHAR 0 999 "\",\"" 118 OtherProviderIdentifierTypeCode_3 ""
119 SQLCHAR 0 999 "\",\"" 119 OtherProviderIdentifierState_3 ""
120 SQLCHAR 0 999 "\",\"" 120 OtherProviderIdentifierIssuer_3 ""
121 SQLCHAR 0 999 "\",\"" 121 OtherProviderIdentifier_4 ""
122 SQLCHAR 0 999 "\",\"" 122 OtherProviderIdentifierTypeCode_4 ""
123 SQLCHAR 0 999 "\",\"" 123 OtherProviderIdentifierState_4 ""
124 SQLCHAR 0 999 "\",\"" 124 OtherProviderIdentifierIssuer_4 ""
125 SQLCHAR 0 999 "\",\"" 125 OtherProviderIdentifier_5 ""
126 SQLCHAR 0 999 "\",\"" 126 OtherProviderIdentifierTypeCode_5 ""
127 SQLCHAR 0 999 "\",\"" 127 OtherProviderIdentifierState_5 ""
128 SQLCHAR 0 999 "\",\"" 128 OtherProviderIdentifierIssuer_5 ""
129 SQLCHAR 0 999 "\",\"" 129 OtherProviderIdentifier_6 ""
130 SQLCHAR 0 999 "\",\"" 130 OtherProviderIdentifierTypeCode_6 ""
131 SQLCHAR 0 999 "\",\"" 131 OtherProviderIdentifierState_6 ""
132 SQLCHAR 0 999 "\",\"" 132 OtherProviderIdentifierIssuer_6 ""
133 SQLCHAR 0 999 "\",\"" 133 OtherProviderIdentifier_7 ""
134 SQLCHAR 0 999 "\",\"" 134 OtherProviderIdentifierTypeCode_7 ""
135 SQLCHAR 0 999 "\",\"" 135 OtherProviderIdentifierState_7 ""
136 SQLCHAR 0 999 "\",\"" 136 OtherProviderIdentifierIssuer_7 ""
137 SQLCHAR 0 999 "\",\"" 137 OtherProviderIdentifier_8 ""
138 SQLCHAR 0 999 "\",\"" 138 OtherProviderIdentifierTypeCode_8 ""
139 SQLCHAR 0 999 "\",\"" 139 OtherProviderIdentifierState_8 ""
140 SQLCHAR 0 999 "\",\"" 140 OtherProviderIdentifierIssuer_8 ""
141 SQLCHAR 0 999 "\",\"" 141 OtherProviderIdentifier_9 ""
142 SQLCHAR 0 999 "\",\"" 142 OtherProviderIdentifierTypeCode_9 ""
143 SQLCHAR 0 999 "\",\"" 143 OtherProviderIdentifierState_9 ""
144 SQLCHAR 0 999 "\",\"" 144 OtherProviderIdentifierIssuer_9 ""
145 SQLCHAR 0 999 "\",\"" 145 OtherProviderIdentifier_10 ""
146 SQLCHAR 0 999 "\",\"" 146 OtherProviderIdentifierTypeCode_10 ""
147 SQLCHAR 0 999 "\",\"" 147 OtherProviderIdentifierState_10 ""
148 SQLCHAR 0 999 "\",\"" 148 OtherProviderIdentifierIssuer_10 ""
149 SQLCHAR 0 999 "\",\"" 149 OtherProviderIdentifier_11 ""
150 SQLCHAR 0 999 "\",\"" 150 OtherProviderIdentifierTypeCode_11 ""
151 SQLCHAR 0 999 "\",\"" 151 OtherProviderIdentifierState_11 ""
152 SQLCHAR 0 999 "\",\"" 152 OtherProviderIdentifierIssuer_11 ""
153 SQLCHAR 0 999 "\",\"" 153 OtherProviderIdentifier_12 ""
154 SQLCHAR 0 999 "\",\"" 154 OtherProviderIdentifierTypeCode_12 ""
155 SQLCHAR 0 999 "\",\"" 155 OtherProviderIdentifierState_12 ""
156 SQLCHAR 0 999 "\",\"" 156 OtherProviderIdentifierIssuer_12 ""
157 SQLCHAR 0 999 "\",\"" 157 OtherProviderIdentifier_13 ""
158 SQLCHAR 0 999 "\",\"" 158 OtherProviderIdentifierTypeCode_13 ""
159 SQLCHAR 0 999 "\",\"" 159 OtherProviderIdentifierState_13 ""
160 SQLCHAR 0 999 "\",\"" 160 OtherProviderIdentifierIssuer_13 ""
161 SQLCHAR 0 999 "\",\"" 161 OtherProviderIdentifier_14 ""
162 SQLCHAR 0 999 "\",\"" 162 OtherProviderIdentifierTypeCode_14 ""
163 SQLCHAR 0 999 "\",\"" 163 OtherProviderIdentifierState_14 ""
164 SQLCHAR 0 999 "\",\"" 164 OtherProviderIdentifierIssuer_14 ""
165 SQLCHAR 0 999 "\",\"" 165 OtherProviderIdentifier_15 ""
166 SQLCHAR 0 999 "\",\"" 166 OtherProviderIdentifierTypeCode_15 ""
167 SQLCHAR 0 999 "\",\"" 167 OtherProviderIdentifierState_15 ""
168 SQLCHAR 0 999 "\",\"" 168 OtherProviderIdentifierIssuer_15 ""
169 SQLCHAR 0 999 "\",\"" 169 OtherProviderIdentifier_16 ""
170 SQLCHAR 0 999 "\",\"" 170 OtherProviderIdentifierTypeCode_16 ""
171 SQLCHAR 0 999 "\",\"" 171 OtherProviderIdentifierState_16 ""
172 SQLCHAR 0 999 "\",\"" 172 OtherProviderIdentifierIssuer_16 ""
173 SQLCHAR 0 999 "\",\"" 173 OtherProviderIdentifier_17 ""
174 SQLCHAR 0 999 "\",\"" 174 OtherProviderIdentifierTypeCode_17 ""
175 SQLCHAR 0 999 "\",\"" 175 OtherProviderIdentifierState_17 ""
176 SQLCHAR 0 999 "\",\"" 176 OtherProviderIdentifierIssuer_17 ""
177 SQLCHAR 0 999 "\",\"" 177 OtherProviderIdentifier_18 ""
178 SQLCHAR 0 999 "\",\"" 178 OtherProviderIdentifierTypeCode_18 ""
179 SQLCHAR 0 999 "\",\"" 179 OtherProviderIdentifierState_18 ""
180 SQLCHAR 0 999 "\",\"" 180 OtherProviderIdentifierIssuer_18 ""
181 SQLCHAR 0 999 "\",\"" 181 OtherProviderIdentifier_19 ""
182 SQLCHAR 0 999 "\",\"" 182 OtherProviderIdentifierTypeCode_19 ""
183 SQLCHAR 0 999 "\",\"" 183 OtherProviderIdentifierState_19 ""
184 SQLCHAR 0 999 "\",\"" 184 OtherProviderIdentifierIssuer_19 ""
185 SQLCHAR 0 999 "\",\"" 185 OtherProviderIdentifier_20 ""
186 SQLCHAR 0 999 "\",\"" 186 OtherProviderIdentifierTypeCode_20 ""
187 SQLCHAR 0 999 "\",\"" 187 OtherProviderIdentifierState_20 ""
188 SQLCHAR 0 999 "\",\"" 188 OtherProviderIdentifierIssuer_20 ""
189 SQLCHAR 0 999 "\",\"" 189 OtherProviderIdentifier_21 ""
190 SQLCHAR 0 999 "\",\"" 190 OtherProviderIdentifierTypeCode_21 ""
191 SQLCHAR 0 999 "\",\"" 191 OtherProviderIdentifierState_21 ""
192 SQLCHAR 0 999 "\",\"" 192 OtherProviderIdentifierIssuer_21 ""
193 SQLCHAR 0 999 "\",\"" 193 OtherProviderIdentifier_22 ""
194 SQLCHAR 0 999 "\",\"" 194 OtherProviderIdentifierTypeCode_22 ""
195 SQLCHAR 0 999 "\",\"" 195 OtherProviderIdentifierState_22 ""
196 SQLCHAR 0 999 "\",\"" 196 OtherProviderIdentifierIssuer_22 ""
197 SQLCHAR 0 999 "\",\"" 197 OtherProviderIdentifier_23 ""
198 SQLCHAR 0 999 "\",\"" 198 OtherProviderIdentifierTypeCode_23 ""
199 SQLCHAR 0 999 "\",\"" 199 OtherProviderIdentifierState_23 ""
200 SQLCHAR 0 999 "\",\"" 200 OtherProviderIdentifierIssuer_23 ""
201 SQLCHAR 0 999 "\",\"" 201 OtherProviderIdentifier_24 ""
202 SQLCHAR 0 999 "\",\"" 202 OtherProviderIdentifierTypeCode_24 ""
203 SQLCHAR 0 999 "\",\"" 203 OtherProviderIdentifierState_24 ""
204 SQLCHAR 0 999 "\",\"" 204 OtherProviderIdentifierIssuer_24 ""
205 SQLCHAR 0 999 "\",\"" 205 OtherProviderIdentifier_25 ""
206 SQLCHAR 0 999 "\",\"" 206 OtherProviderIdentifierTypeCode_25 ""
207 SQLCHAR 0 999 "\",\"" 207 OtherProviderIdentifierState_25 ""
208 SQLCHAR 0 999 "\",\"" 208 OtherProviderIdentifierIssuer_25 ""
209 SQLCHAR 0 999 "\",\"" 209 OtherProviderIdentifier_26 ""
210 SQLCHAR 0 999 "\",\"" 210 OtherProviderIdentifierTypeCode_26 ""
211 SQLCHAR 0 999 "\",\"" 211 OtherProviderIdentifierState_26 ""
212 SQLCHAR 0 999 "\",\"" 212 OtherProviderIdentifierIssuer_26 ""
213 SQLCHAR 0 999 "\",\"" 213 OtherProviderIdentifier_27 ""
214 SQLCHAR 0 999 "\",\"" 214 OtherProviderIdentifierTypeCode_27 ""
215 SQLCHAR 0 999 "\",\"" 215 OtherProviderIdentifierState_27 ""
216 SQLCHAR 0 999 "\",\"" 216 OtherProviderIdentifierIssuer_27 ""
217 SQLCHAR 0 999 "\",\"" 217 OtherProviderIdentifier_28 ""
218 SQLCHAR 0 999 "\",\"" 218 OtherProviderIdentifierTypeCode_28 ""
219 SQLCHAR 0 999 "\",\"" 219 OtherProviderIdentifierState_28 ""
220 SQLCHAR 0 999 "\",\"" 220 OtherProviderIdentifierIssuer_28 ""
221 SQLCHAR 0 999 "\",\"" 221 OtherProviderIdentifier_29 ""
222 SQLCHAR 0 999 "\",\"" 222 OtherProviderIdentifierTypeCode_29 ""
223 SQLCHAR 0 999 "\",\"" 223 OtherProviderIdentifierState_29 ""
224 SQLCHAR 0 999 "\",\"" 224 OtherProviderIdentifierIssuer_29 ""
225 SQLCHAR 0 999 "\",\"" 225 OtherProviderIdentifier_30 ""
226 SQLCHAR 0 999 "\",\"" 226 OtherProviderIdentifierTypeCode_30 ""
227 SQLCHAR 0 999 "\",\"" 227 OtherProviderIdentifierState_30 ""
228 SQLCHAR 0 999 "\",\"" 228 OtherProviderIdentifierIssuer_30 ""
229 SQLCHAR 0 999 "\",\"" 229 OtherProviderIdentifier_31 ""
230 SQLCHAR 0 999 "\",\"" 230 OtherProviderIdentifierTypeCode_31 ""
231 SQLCHAR 0 999 "\",\"" 231 OtherProviderIdentifierState_31 ""
232 SQLCHAR 0 999 "\",\"" 232 OtherProviderIdentifierIssuer_31 ""
233 SQLCHAR 0 999 "\",\"" 233 OtherProviderIdentifier_32 ""
234 SQLCHAR 0 999 "\",\"" 234 OtherProviderIdentifierTypeCode_32 ""
235 SQLCHAR 0 999 "\",\"" 235 OtherProviderIdentifierState_32 ""
236 SQLCHAR 0 999 "\",\"" 236 OtherProviderIdentifierIssuer_32 ""
237 SQLCHAR 0 999 "\",\"" 237 OtherProviderIdentifier_33 ""
238 SQLCHAR 0 999 "\",\"" 238 OtherProviderIdentifierTypeCode_33 ""
239 SQLCHAR 0 999 "\",\"" 239 OtherProviderIdentifierState_33 ""
240 SQLCHAR 0 999 "\",\"" 240 OtherProviderIdentifierIssuer_33 ""
241 SQLCHAR 0 999 "\",\"" 241 OtherProviderIdentifier_34 ""
242 SQLCHAR 0 999 "\",\"" 242 OtherProviderIdentifierTypeCode_34 ""
243 SQLCHAR 0 999 "\",\"" 243 OtherProviderIdentifierState_34 ""
244 SQLCHAR 0 999 "\",\"" 244 OtherProviderIdentifierIssuer_34 ""
245 SQLCHAR 0 999 "\",\"" 245 OtherProviderIdentifier_35 ""
246 SQLCHAR 0 999 "\",\"" 246 OtherProviderIdentifierTypeCode_35 ""
247 SQLCHAR 0 999 "\",\"" 247 OtherProviderIdentifierState_35 ""
248 SQLCHAR 0 999 "\",\"" 248 OtherProviderIdentifierIssuer_35 ""
249 SQLCHAR 0 999 "\",\"" 249 OtherProviderIdentifier_36 ""
250 SQLCHAR 0 999 "\",\"" 250 OtherProviderIdentifierTypeCode_36 ""
251 SQLCHAR 0 999 "\",\"" 251 OtherProviderIdentifierState_36 ""
252 SQLCHAR 0 999 "\",\"" 252 OtherProviderIdentifierIssuer_36 ""
253 SQLCHAR 0 999 "\",\"" 253 OtherProviderIdentifier_37 ""
254 SQLCHAR 0 999 "\",\"" 254 OtherProviderIdentifierTypeCode_37 ""
255 SQLCHAR 0 999 "\",\"" 255 OtherProviderIdentifierState_37 ""
256 SQLCHAR 0 999 "\",\"" 256 OtherProviderIdentifierIssuer_37 ""
257 SQLCHAR 0 999 "\",\"" 257 OtherProviderIdentifier_38 ""
258 SQLCHAR 0 999 "\",\"" 258 OtherProviderIdentifierTypeCode_38 ""
259 SQLCHAR 0 999 "\",\"" 259 OtherProviderIdentifierState_38 ""
260 SQLCHAR 0 999 "\",\"" 260 OtherProviderIdentifierIssuer_38 ""
261 SQLCHAR 0 999 "\",\"" 261 OtherProviderIdentifier_39 ""
262 SQLCHAR 0 999 "\",\"" 262 OtherProviderIdentifierTypeCode_39 ""
263 SQLCHAR 0 999 "\",\"" 263 OtherProviderIdentifierState_39 ""
264 SQLCHAR 0 999 "\",\"" 264 OtherProviderIdentifierIssuer_39 ""
265 SQLCHAR 0 999 "\",\"" 265 OtherProviderIdentifier_40 ""
266 SQLCHAR 0 999 "\",\"" 266 OtherProviderIdentifierTypeCode_40 ""
267 SQLCHAR 0 999 "\",\"" 267 OtherProviderIdentifierState_40 ""
268 SQLCHAR 0 999 "\",\"" 268 OtherProviderIdentifierIssuer_40 ""
269 SQLCHAR 0 999 "\",\"" 269 OtherProviderIdentifier_41 ""
270 SQLCHAR 0 999 "\",\"" 270 OtherProviderIdentifierTypeCode_41 ""
271 SQLCHAR 0 999 "\",\"" 271 OtherProviderIdentifierState_41 ""
272 SQLCHAR 0 999 "\",\"" 272 OtherProviderIdentifierIssuer_41 ""
273 SQLCHAR 0 999 "\",\"" 273 OtherProviderIdentifier_42 ""
274 SQLCHAR 0 999 "\",\"" 274 OtherProviderIdentifierTypeCode_42 ""
275 SQLCHAR 0 999 "\",\"" 275 OtherProviderIdentifierState_42 ""
276 SQLCHAR 0 999 "\",\"" 276 OtherProviderIdentifierIssuer_42 ""
277 SQLCHAR 0 999 "\",\"" 277 OtherProviderIdentifier_43 ""
278 SQLCHAR 0 999 "\",\"" 278 OtherProviderIdentifierTypeCode_43 ""
279 SQLCHAR 0 999 "\",\"" 279 OtherProviderIdentifierState_43 ""
280 SQLCHAR 0 999 "\",\"" 280 OtherProviderIdentifierIssuer_43 ""
281 SQLCHAR 0 999 "\",\"" 281 OtherProviderIdentifier_44 ""
282 SQLCHAR 0 999 "\",\"" 282 OtherProviderIdentifierTypeCode_44 ""
283 SQLCHAR 0 999 "\",\"" 283 OtherProviderIdentifierState_44 ""
284 SQLCHAR 0 999 "\",\"" 284 OtherProviderIdentifierIssuer_44 ""
285 SQLCHAR 0 999 "\",\"" 285 OtherProviderIdentifier_45 ""
286 SQLCHAR 0 999 "\",\"" 286 OtherProviderIdentifierTypeCode_45 ""
287 SQLCHAR 0 999 "\",\"" 287 OtherProviderIdentifierState_45 ""
288 SQLCHAR 0 999 "\",\"" 288 OtherProviderIdentifierIssuer_45 ""
289 SQLCHAR 0 999 "\",\"" 289 OtherProviderIdentifier_46 ""
290 SQLCHAR 0 999 "\",\"" 290 OtherProviderIdentifierTypeCode_46 ""
291 SQLCHAR 0 999 "\",\"" 291 OtherProviderIdentifierState_46 ""
292 SQLCHAR 0 999 "\",\"" 292 OtherProviderIdentifierIssuer_46 ""
293 SQLCHAR 0 999 "\",\"" 293 OtherProviderIdentifier_47 ""
294 SQLCHAR 0 999 "\",\"" 294 OtherProviderIdentifierTypeCode_47 ""
295 SQLCHAR 0 999 "\",\"" 295 OtherProviderIdentifierState_47 ""
296 SQLCHAR 0 999 "\",\"" 296 OtherProviderIdentifierIssuer_47 ""
297 SQLCHAR 0 999 "\",\"" 297 OtherProviderIdentifier_48 ""
298 SQLCHAR 0 999 "\",\"" 298 OtherProviderIdentifierTypeCode_48 ""
299 SQLCHAR 0 999 "\",\"" 299 OtherProviderIdentifierState_48 ""
300 SQLCHAR 0 999 "\",\"" 300 OtherProviderIdentifierIssuer_48 ""
301 SQLCHAR 0 999 "\",\"" 301 OtherProviderIdentifier_49 ""
302 SQLCHAR 0 999 "\",\"" 302 OtherProviderIdentifierTypeCode_49 ""
303 SQLCHAR 0 999 "\",\"" 303 OtherProviderIdentifierState_49 ""
304 SQLCHAR 0 999 "\",\"" 304 OtherProviderIdentifierIssuer_49 ""
305 SQLCHAR 0 999 "\",\"" 305 OtherProviderIdentifier_50 ""
306 SQLCHAR 0 999 "\",\"" 306 OtherProviderIdentifierTypeCode_50 ""
307 SQLCHAR 0 999 "\",\"" 307 OtherProviderIdentifierState_50 ""
308 SQLCHAR 0 999 "\",\"" 308 OtherProviderIdentifierIssuer_50 ""
309 SQLCHAR 0 999 "\",\"" 309 IsSoleProprietor ""
310 SQLCHAR 0 999 "\",\"" 310 IsOrganizationSubpart ""
311 SQLCHAR 0 999 "\",\"" 311 ParentOrganizationLBN ""
312 SQLCHAR 0 999 "\",\"" 312 ParentOrganizationTIN ""
313 SQLCHAR 0 999 "\",\"" 313 AuthorizedOfficialNamePrefixText ""
314 SQLCHAR 0 999 "\",\"" 314 AuthorizedOfficialNameSuffixText ""
315 SQLCHAR 0 999 "\",\"" 315 AuthorizedOfficialCredentialText ""
316 SQLCHAR 0 999 "\",\"" 316 HealthcareProviderTaxonomyGroup_1 ""
317 SQLCHAR 0 999 "\",\"" 317 HealthcareProviderTaxonomyGroup_2 ""
318 SQLCHAR 0 999 "\",\"" 318 HealthcareProviderTaxonomyGroup_3 ""
319 SQLCHAR 0 999 "\",\"" 319 HealthcareProviderTaxonomyGroup_4 ""
320 SQLCHAR 0 999 "\",\"" 320 HealthcareProviderTaxonomyGroup_5 ""
321 SQLCHAR 0 999 "\",\"" 321 HealthcareProviderTaxonomyGroup_6 ""
322 SQLCHAR 0 999 "\",\"" 322 HealthcareProviderTaxonomyGroup_7 ""
323 SQLCHAR 0 999 "\",\"" 323 HealthcareProviderTaxonomyGroup_8 ""
324 SQLCHAR 0 999 "\",\"" 324 HealthcareProviderTaxonomyGroup_9 ""
325 SQLCHAR 0 999 "\",\"" 325 HealthcareProviderTaxonomyGroup_10 ""
326 SQLCHAR 0 999 "\",\"" 326 HealthcareProviderTaxonomyGroup_11 ""
327 SQLCHAR 0 999 "\",\"" 327 HealthcareProviderTaxonomyGroup_12 ""
328 SQLCHAR 0 999 "\",\"" 328 HealthcareProviderTaxonomyGroup_13 ""
329 SQLCHAR 0 999 "\",\"" 329 HealthcareProviderTaxonomyGroup_14 ""
330 SQLCHAR 0 999 "\"" 330 HealthcareProviderTaxonomyGroup_15 ""
Import Command
BULK INSERT WCHD_Scratch.dbo.NPIData
FROM 'D:\NPIpidata_20050523-20151213.csv'
WITH (
CODEPAGE = 'RAW',
DATAFILETYPE = 'CHAR',
FORMATFILE = 'D:\NPI\NPIData.fmt',
FIRSTROW = 2,
BATCHSIZE = 50000,
TABLOCK
)
Viewing 13 posts - 31 through 42 (of 42 total)
You must be logged in to reply to this topic. Login to reply