|
|
|
 |
 |
|
Field #
|
|
1
|
Field Description
|
Fill Rate
|
Percentage
|
|
2
|
Unique Physican@Location Identifier
|
741,064
|
100.00%
|
|
3
|
Unique Physician Identifier
|
741,064
|
100.00%
|
|
4
|
Primary Location Indicator
|
741,064
|
100.00%
|
|
5
|
Full Formatted Name of Physician
|
741,064
|
100.00%
|
|
6
|
Practice Name
|
741,064
|
100.00%
|
|
7
|
First Name of Physician
|
741,064
|
100.00%
|
|
8
|
Mid initial or name of Physician
|
463,640
|
62.56%
|
|
9
|
Surname of Physician
|
741,064
|
100.00%
|
|
10
|
Suffix
|
15,822
|
2.14%
|
|
11
|
Title Honorifics
|
741,064
|
100.00%
|
|
12
|
Gender
|
606,774
|
81.88%
|
|
13
|
unformatted Primary Phone
|
741,064
|
100.00%
|
|
14
|
unformatted Secondary Phone
|
17,171
|
2.32%
|
|
15
|
Unformatted Primary Fax Phone
|
600,141
|
80.98%
|
|
16
|
Unformatted Secondary Fax Phone
|
6,188
|
0.84%
|
|
17
|
Location Address
|
741,064
|
100.00%
|
|
18
|
Location City
|
741,064
|
100.00%
|
|
19
|
Location State
|
741,064
|
100.00%
|
|
20
|
Location Zip
|
741,064
|
100.00%
|
|
21
|
Location Zip4
|
737,533
|
99.52%
|
|
22
|
Fips Code (state, County code)
|
741,064
|
100.00%
|
|
23
|
SCF
|
741,064
|
100.00%
|
|
24
|
Carrier Route Code
|
737,536
|
99.52%
|
|
25
|
Line Of travel Code
|
737,647
|
99.54%
|
|
26
|
Delivery Point BarCode
|
736,760
|
99.42%
|
|
27
|
MSA Code
|
659,740
|
89.03%
|
|
28
|
DEA Number of Physician
|
696,653
|
94.01%
|
|
29
|
DEA Expiration date
|
696,653
|
94.01%
|
|
30
|
UPIN (Unique Physician ID #)
|
518,700
|
70.00%
|
|
31
|
Primary Specialty of Physician
|
741,064
|
100.00%
|
|
32
|
Specialty 1 description
|
741,064
|
100.00%
|
|
33
|
Secondary Specialty of Physician
|
156,800
|
21.16%
|
|
34
|
Specialty 2 description
|
156,800
|
21.16%
|
|
35
|
Estimated Sales
|
425,239
|
57.38%
|
|
36
|
Number Of site Employees
|
459,613
|
62.02%
|
|
37
|
Full Name of Office Manager
|
390,288
|
52.67%
|
|
38
|
Number of Physicians in the office
|
741,064
|
100.00%
|
|
39
|
Last Update Date
|
741,064
|
100.00%
|
|
40
|
Update type # 1
|
741,064
|
100.00%
|
|
41
|
Update type # 2
|
79,783
|
10.77%
|
|
42
|
County Name
|
741,064
|
100.00%
|
|
43
|
MSA description
|
659,740
|
89.03%
|
|
44
|
Time Zone
|
741,064
|
100.00%
|
|
45
|
Year of graduation
|
365,919
|
49.38%
|
|
46
|
Year Medical License Obtained
|
236,480
|
31.91%
|
|
47
|
Number of years in Practice
|
236,480
|
31.91%
|
|
48
|
Attending Medical School
|
234,260
|
31.61%
|
|
49
|
Medical school city
|
82,101
|
11.08%
|
|
50
|
Medical School State
|
74,356
|
10.03%
|
|
51
|
Medical School Zip
|
66,446
|
8.97%
|
|
52
|
Medical School Country
|
82,271
|
11.10%
|
|
53
|
Residency Location
|
172,725
|
23.31%
|
|
54
|
Last Phone verified Date
|
132,620
|
17.90%
|
|
56
|
Area Code
|
741,064
|
100.00%
|
|
57
|
Board Certification
|
141,429
|
19.08%
|
|
58
|
State of Licensure
|
579,115
|
78.15%
|
|
59
|
State License Number
|
579,115
|
78.15%
|
|
60
|
(State abbrev+State License)
|
579,115
|
78.15%
|
|
61
|
Mailing address
|
8,353
|
1.13%
|
|
62
|
Mail city
|
8,353
|
1.13%
|
|
63
|
Mail State
|
8,353
|
1.13%
|
|
64
|
Mail Zip
|
8,353
|
1.13%
|
|
65
|
Mail ZIP4
|
8,353
|
1.13%
|
|
66
|
Mail fips
|
8,353
|
1.13%
|
|
67
|
Mail SCF
|
8,353
|
1.13%
|
|
68
|
Mail Crrt
|
8,353
|
1.13%
|
|
69
|
Mail LOTCD
|
8,353
|
1.13%
|
|
70
|
Mail DLVPBC
|
8,353
|
1.13%
|
| |
|
|
|
|
|