NPPES Provider Addresses
Snowflake table name : CYBERSYN.NPPES_PROVIDER_ADDRESSES
| Name | Description | Type | Example |
|---|---|---|---|
| National Provider Identifier, which is a unique id assigned to a provider by the CMS National Plan and Provider Enumeration System | NUMBER |
|
| Type of address: mailing, primary practice, secondary practice | VARCHAR |
|
| First line of address | VARCHAR |
|
| Second line of address | VARCHAR |
|
| City or town of address | VARCHAR |
|
| State or US territory the address is located in | VARCHAR |
|
| Zip code of the address | VARCHAR |
|
| Two letter country code of the address | VARCHAR |
|
| Telephone number associated with the address | ARRAY |
|
| Fax number | ARRAY |
|
| Email address | ARRAY |
|
| Unique zip code geographic identifier joinable to the geography_index | VARCHAR |
|
| Unique city geographic identifier joinable to the geography_index | VARCHAR |
|
| Unique US state or territory geographic identifier joinable to the geography_index | VARCHAR |
|
| Unique country geographic identifier joinable to the geography_index | VARCHAR |
|
Last updated