-
Notifications
You must be signed in to change notification settings - Fork 7
Expand file tree
/
Copy pathCreate_tbl_NPI.sql
More file actions
332 lines (332 loc) · 12 KB
/
Create_tbl_NPI.sql
File metadata and controls
332 lines (332 loc) · 12 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
CREATE TABLE tbl_NPI (
NPI VARCHAR(10) NOT NULL,
Entity_Type_Code VARCHAR(1),
Replacement_NPI VARCHAR(10),
Employer_ID_Num_EIN VARCHAR(9),
Prov_Org_Name_Legal_Bus_Name VARCHAR(70),
Prov_Last_Name_Legal_Name VARCHAR(35),
Prov_First_Name VARCHAR(20),
Prov_Middle_Name VARCHAR(20),
Prov_Name_Prefix_Text VARCHAR(5),
Prov_Name_Suffix_Text VARCHAR(5),
Prov_Credential_Text VARCHAR(20),
Prov_Oth_Org_Name VARCHAR(70),
Prov_Oth_Org_Name_Type_Code VARCHAR(1),
Prov_Oth_Last_Name VARCHAR(35),
Prov_Oth_First_Name VARCHAR(20),
Prov_Oth_Middle_Name VARCHAR(20),
Prov_Oth_Name_Prefix_Text VARCHAR(5),
Prov_Oth_Name_Suffix_Text VARCHAR(5),
Prov_Oth_Credential_Text VARCHAR(20),
Prov_Oth_Last_Name_Type_Code VARCHAR(1),
Prov_First_Line_Bus_Mailing_Addr VARCHAR(55),
Prov_Second_Line_Bus_Mailing_Addr VARCHAR(55),
Prov_Bus_Mailing_Addr_City VARCHAR(40),
Prov_Bus_Mailing_Addr_ST VARCHAR(40),
Prov_Bus_Mailing_Addr_Postal_Code VARCHAR(20),
Prov_Bus_Mailing_Addr_Country_Code VARCHAR(2),
Prov_Bus_Mailing_Addr_Telephone_Num VARCHAR(20),
Prov_Bus_Mailing_Addr_Fax_Num VARCHAR(20),
Prov_First_Line_Bus_Prac_Loc_Addr VARCHAR(55),
Prov_Second_Line_Bus_Prac_Loc_Addr VARCHAR(55),
Prov_Bus_Prac_Loc_Addr_City VARCHAR(40),
Prov_Bus_Prac_Loc_Addr_ST VARCHAR(40),
Prov_Bus_Prac_Loc_Addr_Postal_Code VARCHAR(20),
Prov_Bus_Prac_Loc_Addr_Country_Code VARCHAR(2),
Prov_Bus_Prac_Loc_Addr_Telephone_Num VARCHAR(20),
Prov_Bus_Prac_Loc_Addr_Fax_Num VARCHAR(20),
Prov_Enumeration_Date VARCHAR(10),
Last_Update_Date VARCHAR(10),
NPI_Deactivation_Reason_Code VARCHAR(2),
NPI_Deactivation_Date VARCHAR(10),
NPI_Reactivation_Date VARCHAR(10),
Prov_Gender_Code VARCHAR(1),
Auth_Official_Last_Name VARCHAR(35),
Auth_Official_First_Name VARCHAR(20),
Auth_Official_Middle_Name VARCHAR(20),
Auth_Official_Title_or_Position VARCHAR(35),
Auth_Official_Telephone_Num VARCHAR(20),
HC_Prov_Taxonomy_Code_1 VARCHAR(10),
Prov_Lic_Num_1 VARCHAR(20),
Prov_Lic_Num_ST_Code_1 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_1 VARCHAR(1),
HC_Prov_Taxonomy_Code_2 VARCHAR(10),
Prov_Lic_Num_2 VARCHAR(20),
Prov_Lic_Num_ST_Code_2 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_2 VARCHAR(1),
HC_Prov_Taxonomy_Code_3 VARCHAR(10),
Prov_Lic_Num_3 VARCHAR(20),
Prov_Lic_Num_ST_Code_3 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_3 VARCHAR(1),
HC_Prov_Taxonomy_Code_4 VARCHAR(10),
Prov_Lic_Num_4 VARCHAR(20),
Prov_Lic_Num_ST_Code_4 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_4 VARCHAR(1),
HC_Prov_Taxonomy_Code_5 VARCHAR(10),
Prov_Lic_Num_5 VARCHAR(20),
Prov_Lic_Num_ST_Code_5 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_5 VARCHAR(1),
HC_Prov_Taxonomy_Code_6 VARCHAR(10),
Prov_Lic_Num_6 VARCHAR(20),
Prov_Lic_Num_ST_Code_6 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_6 VARCHAR(1),
HC_Prov_Taxonomy_Code_7 VARCHAR(10),
Prov_Lic_Num_7 VARCHAR(20),
Prov_Lic_Num_ST_Code_7 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_7 VARCHAR(1),
HC_Prov_Taxonomy_Code_8 VARCHAR(10),
Prov_Lic_Num_8 VARCHAR(20),
Prov_Lic_Num_ST_Code_8 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_8 VARCHAR(1),
HC_Prov_Taxonomy_Code_9 VARCHAR(10),
Prov_Lic_Num_9 VARCHAR(20),
Prov_Lic_Num_ST_Code_9 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_9 VARCHAR(1),
HC_Prov_Taxonomy_Code_10 VARCHAR(10),
Prov_Lic_Num_10 VARCHAR(20),
Prov_Lic_Num_ST_Code_10 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_10 VARCHAR(1),
HC_Prov_Taxonomy_Code_11 VARCHAR(10),
Prov_Lic_Num_11 VARCHAR(20),
Prov_Lic_Num_ST_Code_11 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_11 VARCHAR(1),
HC_Prov_Taxonomy_Code_12 VARCHAR(10),
Prov_Lic_Num_12 VARCHAR(20),
Prov_Lic_Num_ST_Code_12 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_12 VARCHAR(1),
HC_Prov_Taxonomy_Code_13 VARCHAR(10),
Prov_Lic_Num_13 VARCHAR(20),
Prov_Lic_Num_ST_Code_13 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_13 VARCHAR(1),
HC_Prov_Taxonomy_Code_14 VARCHAR(10),
Prov_Lic_Num_14 VARCHAR(20),
Prov_Lic_Num_ST_Code_14 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_14 VARCHAR(1),
HC_Prov_Taxonomy_Code_15 VARCHAR(10),
Prov_Lic_Num_15 VARCHAR(20),
Prov_Lic_Num_ST_Code_15 VARCHAR(2),
HC_Prov_Prim_Taxonomy_Switch_15 VARCHAR(1),
Oth_Prov_ID_1 VARCHAR(20),
Oth_Prov_ID_Type_Code_1 VARCHAR(2),
Oth_Prov_ID_ST_1 VARCHAR(2),
Oth_Prov_ID_Issuer_1 VARCHAR(80),
Oth_Prov_ID_2 VARCHAR(20),
Oth_Prov_ID_Type_Code_2 VARCHAR(2),
Oth_Prov_ID_ST_2 VARCHAR(2),
Oth_Prov_ID_Issuer_2 VARCHAR(80),
Oth_Prov_ID_3 VARCHAR(20),
Oth_Prov_ID_Type_Code_3 VARCHAR(2),
Oth_Prov_ID_ST_3 VARCHAR(2),
Oth_Prov_ID_Issuer_3 VARCHAR(80),
Oth_Prov_ID_4 VARCHAR(20),
Oth_Prov_ID_Type_Code_4 VARCHAR(2),
Oth_Prov_ID_ST_4 VARCHAR(2),
Oth_Prov_ID_Issuer_4 VARCHAR(80),
Oth_Prov_ID_5 VARCHAR(20),
Oth_Prov_ID_Type_Code_5 VARCHAR(2),
Oth_Prov_ID_ST_5 VARCHAR(2),
Oth_Prov_ID_Issuer_5 VARCHAR(80),
Oth_Prov_ID_6 VARCHAR(20),
Oth_Prov_ID_Type_Code_6 VARCHAR(2),
Oth_Prov_ID_ST_6 VARCHAR(2),
Oth_Prov_ID_Issuer_6 VARCHAR(80),
Oth_Prov_ID_7 VARCHAR(20),
Oth_Prov_ID_Type_Code_7 VARCHAR(2),
Oth_Prov_ID_ST_7 VARCHAR(2),
Oth_Prov_ID_Issuer_7 VARCHAR(80),
Oth_Prov_ID_8 VARCHAR(20),
Oth_Prov_ID_Type_Code_8 VARCHAR(2),
Oth_Prov_ID_ST_8 VARCHAR(2),
Oth_Prov_ID_Issuer_8 VARCHAR(80),
Oth_Prov_ID_9 VARCHAR(20),
Oth_Prov_ID_Type_Code_9 VARCHAR(2),
Oth_Prov_ID_ST_9 VARCHAR(2),
Oth_Prov_ID_Issuer_9 VARCHAR(80),
Oth_Prov_ID_10 VARCHAR(20),
Oth_Prov_ID_Type_Code_10 VARCHAR(2),
Oth_Prov_ID_ST_10 VARCHAR(2),
Oth_Prov_ID_Issuer_10 VARCHAR(80),
Oth_Prov_ID_11 VARCHAR(20),
Oth_Prov_ID_Type_Code_11 VARCHAR(2),
Oth_Prov_ID_ST_11 VARCHAR(2),
Oth_Prov_ID_Issuer_11 VARCHAR(80),
Oth_Prov_ID_12 VARCHAR(20),
Oth_Prov_ID_Type_Code_12 VARCHAR(2),
Oth_Prov_ID_ST_12 VARCHAR(2),
Oth_Prov_ID_Issuer_12 VARCHAR(80),
Oth_Prov_ID_13 VARCHAR(20),
Oth_Prov_ID_Type_Code_13 VARCHAR(2),
Oth_Prov_ID_ST_13 VARCHAR(2),
Oth_Prov_ID_Issuer_13 VARCHAR(80),
Oth_Prov_ID_14 VARCHAR(20),
Oth_Prov_ID_Type_Code_14 VARCHAR(2),
Oth_Prov_ID_ST_14 VARCHAR(2),
Oth_Prov_ID_Issuer_14 VARCHAR(80),
Oth_Prov_ID_15 VARCHAR(20),
Oth_Prov_ID_Type_Code_15 VARCHAR(2),
Oth_Prov_ID_ST_15 VARCHAR(2),
Oth_Prov_ID_Issuer_15 VARCHAR(80),
Oth_Prov_ID_16 VARCHAR(20),
Oth_Prov_ID_Type_Code_16 VARCHAR(2),
Oth_Prov_ID_ST_16 VARCHAR(2),
Oth_Prov_ID_Issuer_16 VARCHAR(80),
Oth_Prov_ID_17 VARCHAR(20),
Oth_Prov_ID_Type_Code_17 VARCHAR(2),
Oth_Prov_ID_ST_17 VARCHAR(2),
Oth_Prov_ID_Issuer_17 VARCHAR(80),
Oth_Prov_ID_18 VARCHAR(20),
Oth_Prov_ID_Type_Code_18 VARCHAR(2),
Oth_Prov_ID_ST_18 VARCHAR(2),
Oth_Prov_ID_Issuer_18 VARCHAR(80),
Oth_Prov_ID_19 VARCHAR(20),
Oth_Prov_ID_Type_Code_19 VARCHAR(2),
Oth_Prov_ID_ST_19 VARCHAR(2),
Oth_Prov_ID_Issuer_19 VARCHAR(80),
Oth_Prov_ID_20 VARCHAR(20),
Oth_Prov_ID_Type_Code_20 VARCHAR(2),
Oth_Prov_ID_ST_20 VARCHAR(2),
Oth_Prov_ID_Issuer_20 VARCHAR(80),
Oth_Prov_ID_21 VARCHAR(20),
Oth_Prov_ID_Type_Code_21 VARCHAR(2),
Oth_Prov_ID_ST_21 VARCHAR(2),
Oth_Prov_ID_Issuer_21 VARCHAR(80),
Oth_Prov_ID_22 VARCHAR(20),
Oth_Prov_ID_Type_Code_22 VARCHAR(2),
Oth_Prov_ID_ST_22 VARCHAR(2),
Oth_Prov_ID_Issuer_22 VARCHAR(80),
Oth_Prov_ID_23 VARCHAR(20),
Oth_Prov_ID_Type_Code_23 VARCHAR(2),
Oth_Prov_ID_ST_23 VARCHAR(2),
Oth_Prov_ID_Issuer_23 VARCHAR(80),
Oth_Prov_ID_24 VARCHAR(20),
Oth_Prov_ID_Type_Code_24 VARCHAR(2),
Oth_Prov_ID_ST_24 VARCHAR(2),
Oth_Prov_ID_Issuer_24 VARCHAR(80),
Oth_Prov_ID_25 VARCHAR(20),
Oth_Prov_ID_Type_Code_25 VARCHAR(2),
Oth_Prov_ID_ST_25 VARCHAR(2),
Oth_Prov_ID_Issuer_25 VARCHAR(80),
Oth_Prov_ID_26 VARCHAR(20),
Oth_Prov_ID_Type_Code_26 VARCHAR(2),
Oth_Prov_ID_ST_26 VARCHAR(2),
Oth_Prov_ID_Issuer_26 VARCHAR(80),
Oth_Prov_ID_27 VARCHAR(20),
Oth_Prov_ID_Type_Code_27 VARCHAR(2),
Oth_Prov_ID_ST_27 VARCHAR(2),
Oth_Prov_ID_Issuer_27 VARCHAR(80),
Oth_Prov_ID_28 VARCHAR(20),
Oth_Prov_ID_Type_Code_28 VARCHAR(2),
Oth_Prov_ID_ST_28 VARCHAR(2),
Oth_Prov_ID_Issuer_28 VARCHAR(80),
Oth_Prov_ID_29 VARCHAR(20),
Oth_Prov_ID_Type_Code_29 VARCHAR(2),
Oth_Prov_ID_ST_29 VARCHAR(2),
Oth_Prov_ID_Issuer_29 VARCHAR(80),
Oth_Prov_ID_30 VARCHAR(20),
Oth_Prov_ID_Type_Code_30 VARCHAR(2),
Oth_Prov_ID_ST_30 VARCHAR(2),
Oth_Prov_ID_Issuer_30 VARCHAR(80),
Oth_Prov_ID_31 VARCHAR(20),
Oth_Prov_ID_Type_Code_31 VARCHAR(2),
Oth_Prov_ID_ST_31 VARCHAR(2),
Oth_Prov_ID_Issuer_31 VARCHAR(80),
Oth_Prov_ID_32 VARCHAR(20),
Oth_Prov_ID_Type_Code_32 VARCHAR(2),
Oth_Prov_ID_ST_32 VARCHAR(2),
Oth_Prov_ID_Issuer_32 VARCHAR(80),
Oth_Prov_ID_33 VARCHAR(20),
Oth_Prov_ID_Type_Code_33 VARCHAR(2),
Oth_Prov_ID_ST_33 VARCHAR(2),
Oth_Prov_ID_Issuer_33 VARCHAR(80),
Oth_Prov_ID_34 VARCHAR(20),
Oth_Prov_ID_Type_Code_34 VARCHAR(2),
Oth_Prov_ID_ST_34 VARCHAR(2),
Oth_Prov_ID_Issuer_34 VARCHAR(80),
Oth_Prov_ID_35 VARCHAR(20),
Oth_Prov_ID_Type_Code_35 VARCHAR(2),
Oth_Prov_ID_ST_35 VARCHAR(2),
Oth_Prov_ID_Issuer_35 VARCHAR(80),
Oth_Prov_ID_36 VARCHAR(20),
Oth_Prov_ID_Type_Code_36 VARCHAR(2),
Oth_Prov_ID_ST_36 VARCHAR(2),
Oth_Prov_ID_Issuer_36 VARCHAR(80),
Oth_Prov_ID_37 VARCHAR(20),
Oth_Prov_ID_Type_Code_37 VARCHAR(2),
Oth_Prov_ID_ST_37 VARCHAR(2),
Oth_Prov_ID_Issuer_37 VARCHAR(80),
Oth_Prov_ID_38 VARCHAR(20),
Oth_Prov_ID_Type_Code_38 VARCHAR(2),
Oth_Prov_ID_ST_38 VARCHAR(2),
Oth_Prov_ID_Issuer_38 VARCHAR(80),
Oth_Prov_ID_39 VARCHAR(20),
Oth_Prov_ID_Type_Code_39 VARCHAR(2),
Oth_Prov_ID_ST_39 VARCHAR(2),
Oth_Prov_ID_Issuer_39 VARCHAR(80),
Oth_Prov_ID_40 VARCHAR(20),
Oth_Prov_ID_Type_Code_40 VARCHAR(2),
Oth_Prov_ID_ST_40 VARCHAR(2),
Oth_Prov_ID_Issuer_40 VARCHAR(80),
Oth_Prov_ID_41 VARCHAR(20),
Oth_Prov_ID_Type_Code_41 VARCHAR(2),
Oth_Prov_ID_ST_41 VARCHAR(2),
Oth_Prov_ID_Issuer_41 VARCHAR(80),
Oth_Prov_ID_42 VARCHAR(20),
Oth_Prov_ID_Type_Code_42 VARCHAR(2),
Oth_Prov_ID_ST_42 VARCHAR(2),
Oth_Prov_ID_Issuer_42 VARCHAR(80),
Oth_Prov_ID_43 VARCHAR(20),
Oth_Prov_ID_Type_Code_43 VARCHAR(2),
Oth_Prov_ID_ST_43 VARCHAR(2),
Oth_Prov_ID_Issuer_43 VARCHAR(80),
Oth_Prov_ID_44 VARCHAR(20),
Oth_Prov_ID_Type_Code_44 VARCHAR(2),
Oth_Prov_ID_ST_44 VARCHAR(2),
Oth_Prov_ID_Issuer_44 VARCHAR(80),
Oth_Prov_ID_45 VARCHAR(20),
Oth_Prov_ID_Type_Code_45 VARCHAR(2),
Oth_Prov_ID_ST_45 VARCHAR(2),
Oth_Prov_ID_Issuer_45 VARCHAR(80),
Oth_Prov_ID_46 VARCHAR(20),
Oth_Prov_ID_Type_Code_46 VARCHAR(2),
Oth_Prov_ID_ST_46 VARCHAR(2),
Oth_Prov_ID_Issuer_46 VARCHAR(80),
Oth_Prov_ID_47 VARCHAR(20),
Oth_Prov_ID_Type_Code_47 VARCHAR(2),
Oth_Prov_ID_ST_47 VARCHAR(2),
Oth_Prov_ID_Issuer_47 VARCHAR(80),
Oth_Prov_ID_48 VARCHAR(20),
Oth_Prov_ID_Type_Code_48 VARCHAR(2),
Oth_Prov_ID_ST_48 VARCHAR(2),
Oth_Prov_ID_Issuer_48 VARCHAR(80),
Oth_Prov_ID_49 VARCHAR(20),
Oth_Prov_ID_Type_Code_49 VARCHAR(2),
Oth_Prov_ID_ST_49 VARCHAR(2),
Oth_Prov_ID_Issuer_49 VARCHAR(80),
Oth_Prov_ID_50 VARCHAR(20),
Oth_Prov_ID_Type_Code_50 VARCHAR(2),
Oth_Prov_ID_ST_50 VARCHAR(2),
Oth_Prov_ID_Issuer_50 VARCHAR(80),
Is_Sole_Prop VARCHAR(1),
Is_Org_SubPart VARCHAR(1),
Parent_Org_LBN VARCHAR(70),
Parent_Org_TIN VARCHAR(9),
Auth_Official_Name_Prefix VARCHAR(5),
Auth_Official_Name_Suffix VARCHAR(5),
Auth_Official_Cred_Text VARCHAR(20),
HC_Prov_Taxonomy_Grp_1 VARCHAR(70),
HC_Prov_Taxonomy_Grp_2 VARCHAR(70),
HC_Prov_Taxonomy_Grp_3 VARCHAR(70),
HC_Prov_Taxonomy_Grp_4 VARCHAR(70),
HC_Prov_Taxonomy_Grp_5 VARCHAR(70),
HC_Prov_Taxonomy_Grp_6 VARCHAR(70),
HC_Prov_Taxonomy_Grp_7 VARCHAR(70),
HC_Prov_Taxonomy_Grp_8 VARCHAR(70),
HC_Prov_Taxonomy_Grp_9 VARCHAR(70),
HC_Prov_Taxonomy_Grp_10 VARCHAR(70),
HC_Prov_Taxonomy_Grp_11 VARCHAR(70),
HC_Prov_Taxonomy_Grp_12 VARCHAR(70),
HC_Prov_Taxonomy_Grp_13 VARCHAR(70),
HC_Prov_Taxonomy_Grp_14 VARCHAR(70),
HC_Prov_Taxonomy_Grp_15 VARCHAR(70),
Certification_Date VARCHAR(12)
)