> For the complete documentation index, see [llms.txt](https://docs.bcbi.brown.edu/codiac-for-health/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bcbi.brown.edu/codiac-for-health/ursa-ri/datasets/national-plan-and-provider-enumeration-system-nppes/data-dictionary.md).

# Data Dictionary

## 1. Main Provider File · npidata\_pfile\_\*.csv

One row per NPI. Repeating groups use a \_N suffix; positions reflect the CSV column order (330 columns total).

| Position | Field Name                                                                 | Description                                                                                                                             | Code Set                |
| -------- | -------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------- | ----------------------- |
| 1        | NPI                                                                        | Unique 10-digit National Provider Identifier assigned by CMS. Primary key of the file.                                                  | —                       |
| 2        | Entity Type Code                                                           | 1 = Individual, 2 = Organization. Blank only for deactivated records.                                                                   | Entity Type             |
| 3        | Replacement NPI                                                            | If this NPI was deactivated and replaced, the replacement NPI. Blank otherwise.                                                         | —                       |
| 4        | Employer Identification Number (EIN)                                       | IRS EIN of the provider. SUPPRESSED in the public file for privacy.                                                                     | —                       |
| 5        | Provider Organization Name (Legal Business Name)                           | Official legal business name of the organization. V.2 expanded this field's length.                                                     | —                       |
| 6        | Provider Last Name (Legal Name)                                            | Legal last (family) name of the individual provider.                                                                                    | —                       |
| 7        | Provider First Name                                                        | Legal first (given) name. V.2 expanded this field's length.                                                                             | —                       |
| 8        | Provider Middle Name                                                       | Middle name or initial of the individual provider.                                                                                      | —                       |
| 9        | Provider Name Prefix Text                                                  | Name prefix (e.g., Dr., Mr., Ms.).                                                                                                      | Name Prefix             |
| 10       | Provider Name Suffix Text                                                  | Name suffix (e.g., Jr., Sr., III).                                                                                                      | Name Suffix             |
| 11       | Provider Credential Text                                                   | Professional credential(s), e.g., MD, DO, NP, PA.                                                                                       | —                       |
| 12       | Provider Other Organization Name                                           | Single alternate organization name (DBA, former name, etc.).                                                                            | —                       |
| 13       | Provider Other Organization Name Type Code                                 | Type of the alternate organization name (3, 4, 5).                                                                                      | Other Name Type         |
| 14       | Provider Other Last Name (Legal Name)                                      | Alternate last name of an individual provider.                                                                                          | —                       |
| 15       | Provider Other First Name                                                  | Alternate first name of an individual provider.                                                                                         | —                       |
| 16       | Provider Other Middle Name                                                 | Alternate middle name of an individual provider.                                                                                        | —                       |
| 17       | Provider Other Name Prefix Text                                            | Name prefix for the alternate individual name.                                                                                          | Name Prefix             |
| 18       | Provider Other Name Suffix Text                                            | Name suffix for the alternate individual name.                                                                                          | Name Suffix             |
| 19       | Provider Other Credential Text                                             | Professional credential for the alternate individual name.                                                                              | —                       |
| 20       | Provider Other Last Name Type Code                                         | Type of the alternate individual name (1, 2, 5).                                                                                        | Other Name Type         |
| 21       | Provider First Line Business Mailing Address                               | Street address line 1 of the mailing address.                                                                                           | —                       |
| 22       | Provider Second Line Business Mailing Address                              | Street address line 2 (suite, floor, PO box) of the mailing address.                                                                    | —                       |
| 23       | Provider Business Mailing Address City Name                                | City of the mailing address.                                                                                                            | —                       |
| 24       | Provider Business Mailing Address State Name                               | State/territory code of the mailing address.                                                                                            | State Codes             |
| 25       | Provider Business Mailing Address Postal Code                              | ZIP/postal code (USPS 9-digit; may include ZIP+4).                                                                                      | —                       |
| 26       | Provider Business Mailing Address Country Code (If outside U.S.)           | ISO country code; populated only when outside the U.S.                                                                                  | Country Codes           |
| 27       | Provider Business Mailing Address Telephone Number                         | Phone number for the mailing address.                                                                                                   | —                       |
| 28       | Provider Business Mailing Address Fax Number                               | Fax number for the mailing address.                                                                                                     | —                       |
| 29       | Provider First Line Business Practice Location Address                     | Street address line 1 of the primary practice location.                                                                                 | —                       |
| 30       | Provider Second Line Business Practice Location Address                    | Street address line 2 of the primary practice location.                                                                                 | —                       |
| 31       | Provider Business Practice Location Address City Name                      | City of the primary practice location.                                                                                                  | —                       |
| 32       | Provider Business Practice Location Address State Name                     | State/territory code of the primary practice location.                                                                                  | State Codes             |
| 33       | Provider Business Practice Location Address Postal Code                    | ZIP/postal code of the primary practice location.                                                                                       | —                       |
| 34       | Provider Business Practice Location Address Country Code (If outside U.S.) | ISO country code; populated only when outside the U.S.                                                                                  | Country Codes           |
| 35       | Provider Business Practice Location Address Telephone Number               | Phone number at the primary practice location.                                                                                          | —                       |
| 36       | Provider Business Practice Location Address Fax Number                     | Fax number at the primary practice location.                                                                                            | —                       |
| 37       | Provider Enumeration Date                                                  | Date the NPI was first assigned (MM/DD/YYYY).                                                                                           | —                       |
| 38       | Last Update Date                                                           | Most recent date any field on the record changed (MM/DD/YYYY).                                                                          | —                       |
| 39       | NPI Deactivation Reason Code                                               | Reason the NPI was deactivated, if applicable.                                                                                          | Deactivation Reason     |
| 40       | NPI Deactivation Date                                                      | Date the NPI was deactivated. Blank for active providers.                                                                               | —                       |
| 41       | NPI Reactivation Date                                                      | Date the NPI was reactivated after a prior deactivation.                                                                                | —                       |
| 42       | Provider Sex Code                                                          | Sex of an individual provider (formerly 'Provider Gender Code'). Not used for organizations.                                            | Sex                     |
| 43       | Authorized Official Last Name                                              | Last name of the official authorized to act for the organization.                                                                       | —                       |
| 44       | Authorized Official First Name                                             | First name of the authorized official.                                                                                                  | —                       |
| 45       | Authorized Official Middle Name                                            | Middle name or initial of the authorized official.                                                                                      | —                       |
| 46       | Authorized Official Title or Position                                      | Job title/position of the authorized official (e.g., CEO, CFO).                                                                         | —                       |
| 47       | Authorized Official Telephone Number                                       | Phone number of the authorized official.                                                                                                | —                       |
| 48–107   | Healthcare Provider Taxonomy Code\_N                                       | NUCC taxonomy code classifying provider type/specialization (e.g., 207Q00000X). Interleaved per occurrence with the three fields below. | Taxonomy (NUCC)         |
| 48–107   | Provider License Number\_N                                                 | State-issued license number for the taxonomy at the same position.                                                                      | —                       |
| 48–107   | Provider License Number State Code\_N                                      | State that issued the license at the same position.                                                                                     | State Codes             |
| 48–107   | Healthcare Provider Primary Taxonomy Switch\_N                             | Y if this is the provider's primary taxonomy (only one Y per NPI).                                                                      | Primary Taxonomy Switch |
| 108–307  | Other Provider Identifier\_N                                               | Legacy/plan-specific identifier (e.g., Medicaid ID). Masked: SSN=$$$$$$$$$, ITIN=\*\*\*\*\*\*\*\*\*, EIN=========.                      | —                       |
| 108–307  | Other Provider Identifier Type Code\_N                                     | Type/issuer system of the identifier at the same position.                                                                              | Other Provider ID Type  |
| 108–307  | Other Provider Identifier State\_N                                         | State code for the identifier (used when issued by a state Medicaid plan).                                                              | State Codes             |
| 108–307  | Other Provider Identifier Issuer\_N                                        | Name of the plan/organization that issued the identifier.                                                                               | —                       |
| 308      | Is Sole Proprietor                                                         | Whether the individual operates as a sole proprietor (Y/N/X).                                                                           | Sole Proprietor         |
| 309      | Is Organization Subpart                                                    | Whether the organization is a subpart of a larger parent (Y/N/X).                                                                       | Subpart                 |
| 310      | Parent Organization LBN                                                    | Legal Business Name of the parent organization. SUPPRESSED in the public file.                                                          | —                       |
| 311      | Parent Organization TIN                                                    | Tax ID of the parent organization. SUPPRESSED in the public file.                                                                       | —                       |
| 312      | Authorized Official Name Prefix Text                                       | Name prefix of the authorized official.                                                                                                 | Name Prefix             |
| 313      | Authorized Official Name Suffix Text                                       | Name suffix of the authorized official.                                                                                                 | Name Suffix             |
| 314      | Authorized Official Credential Text                                        | Professional credential of the authorized official.                                                                                     | —                       |
| 315–329  | Healthcare Provider Taxonomy Group\_N                                      | Grouping code for the taxonomy at the same position (e.g., 193200000X).                                                                 | Group Taxonomy          |
| 330      | Certification Date                                                         | Date the provider certified the application information is accurate.                                                                    | —                       |

## 2. Practice Location Reference File · pl\_pfile\_\*.csv

Non-primary practice locations for Type 1 & Type 2 NPIs. Join back to the main file on NPI.

| Position | Field Name                                                                    | Description                                                                 |
| -------- | ----------------------------------------------------------------------------- | --------------------------------------------------------------------------- |
| 1        | NPI                                                                           | NPI of the provider for this secondary location. Join key to the main file. |
| 2        | Provider Secondary Practice Location Address – Address Line 1                 | Street address line 1 of the secondary location.                            |
| 3        | Provider Secondary Practice Location Address – Address Line 2                 | Street address line 2 (suite, floor, etc.).                                 |
| 4        | Provider Secondary Practice Location Address – City Name                      | City of the secondary location.                                             |
| 5        | Provider Secondary Practice Location Address – State Name                     | State/territory code of the secondary location.                             |
| 6        | Provider Secondary Practice Location Address – Postal Code                    | ZIP/postal code (may include ZIP+4).                                        |
| 7        | Provider Secondary Practice Location Address – Country Code (If outside U.S.) | ISO country code; populated only when outside the U.S.                      |
| 8        | Provider Secondary Practice Location Address – Telephone Number               | Phone number at the secondary location.                                     |
| 9        | Provider Secondary Practice Location Address – Telephone Extension            | Phone extension at the secondary location.                                  |
| 10       | Provider Practice Location Address – Fax Number                               | Fax number at the secondary location.                                       |

## 3. Other Names Reference File · othername\_pfile\_\*.csv

Additional 'other names' for Type 2 (organization) NPIs beyond the one stored in the main file.

| Position | Field Name                                 | Description                                                                           |
| -------- | ------------------------------------------ | ------------------------------------------------------------------------------------- |
| 1        | NPI                                        | NPI of the organizational provider this name belongs to. Join key to the main file.   |
| 2        | Provider Other Organization Name           | The alternate organization name (DBA, former name, etc.).                             |
| 3        | Provider Other Organization Name Type Code | Type of the alternate name (3 = DBA, 4 = Former Legal Business Name, 5 = Other Name). |

## 4. Endpoint Reference File · endpoint\_pfile\_\*.csv

Health IT endpoints (Direct messaging, FHIR servers, HIE, etc.) associated with NPIs.

| Position | Field Name                      | Description                                                                |
| -------- | ------------------------------- | -------------------------------------------------------------------------- |
| 1        | NPI                             | NPI of the provider this endpoint belongs to. Join key to the main file.   |
| 2        | Endpoint Type                   | Short code/label for the endpoint type (e.g., DIRECT, FHIR).               |
| 3        | Endpoint Type Description       | Full descriptive name of the endpoint type.                                |
| 4        | Endpoint                        | The actual endpoint address (Direct email, FHIR/web-services URL, etc.).   |
| 5        | Affiliation                     | Whether the endpoint is affiliated with another organization (Y/N).        |
| 6        | Endpoint Description            | Free-text description of the endpoint and its purpose.                     |
| 7        | Affiliation Legal Business Name | Legal Business Name of the affiliated organization (when Affiliation = Y). |
| 8        | Use Code                        | Short code for the endpoint's use (e.g., DIRECTMESSAGING).                 |
| 9        | Use Description                 | Full description of the endpoint's use.                                    |
| 10       | Other Use Description           | Free-text description when Use Code is 'Other'.                            |
| 11       | Content Type                    | Short code for content exchanged (e.g., CCD).                              |
| 12       | Content Description             | Full description of the content type.                                      |
| 13       | Other Content Description       | Free-text description when Content Type is 'Other'.                        |
| 14       | Affiliation Address Line One    | Street address line 1 of the affiliated organization.                      |
| 15       | Affiliation Address Line Two    | Street address line 2 of the affiliated organization.                      |
| 16       | Affiliation Address City        | City of the affiliated organization.                                       |
| 17       | Affiliation Address State       | State of the affiliated organization.                                      |
| 18       | Affiliation Address Country     | ISO country code of the affiliated organization.                           |
| 19       | Affiliation Address Postal Code | Postal code of the affiliated organization.                                |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.bcbi.brown.edu/codiac-for-health/ursa-ri/datasets/national-plan-and-provider-enumeration-system-nppes/data-dictionary.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.