| CPAC (CarePrecise Access Complete) data is sourced and merged from the NPPES, PECOS and LEIE databases, keyed on the NPI. Every record has a unique NPI, and the NPI is used to link the relational tables together. The CPAC dataset is updated monthly. |
| CPAC |
tAddresses
(Provider addresses;
MDB and CSV formats) |
NPI |
National Provider Identifier (unique National Provider Identifier assigned to healthcare providers by the US Department of Health and Human Services) |
Relational Key
The NPI is a unique 10-digit numerical code assigned to every HIPAA-covered healthcare provider, including individuals and organizations, by the U.S. Department of Human Services, Centers for Medicare and Medicaid Services (CMS). |
| Mail1stAddr |
Provider First Line Business Mailing Address |
|
| Mail2ndAddr |
Provider Second Line Business Mailing Address |
|
| MailCity |
Provider Business Mailing Address City Name
|
|
| MailState |
Provider Business Mailing Address State Code |
|
| MailZip |
Provider Business Mailing Address Postal Code (most are 9-digit Zip Codes) |
|
| MailCountry |
Provider Business Mailing Address Country Code (If outside U.S.) |
|
| Prac1stAddr |
Provider First Line Business Practice Location Address |
|
| Prac2ndAddr |
Provider Second Line Business Practice Location Address |
|
| PracCity |
Provider Business Practice Location Address City Name |
|
| PracState |
Provider Business Practice Location Address State Code |
|
| PracZip |
Provider Business Practice Location Address Postal Code (most are 9-digit Zip Codes) |
|
| PracCountry |
Provider Business Practice Location Address Country Code (If outside U.S.) |
|
| CPAC |
tOtherPracticeLocations
Additional (secondary) practice locations for Type 2 providers;
MDB and CSV formats One-to-many table.
Table is not provided in custom data pulls (CarePrecise Select services). |
NPI |
National Provider Identifier |
Relational Key
(composite) |
| SecondaryPracAddr1 |
First line of street address |
Relational Key
(composite) |
| SecondaryPracAddr2 |
Second line of street address |
|
| SecondaryPracCity |
City Name
|
|
| SecondaryPracState |
State Code |
|
| SecondaryPracZip |
Postal Code (most are 9-digit Zip Codes) |
|
| SecondaryPracCountry |
Country Code (If outside U.S.) |
|
| SecondaryPracPhone |
Location Phone Number |
|
| SecondaryPracPhoneExt |
Location Phone Extension |
|
| SecondaryPracFax |
Location Fax Number |
|
| SecondaryLocationDate |
Location Date |
|
| CPAC |
tEntity |
NPI |
National Provider Identifier |
Relational Key |
| (Provider entity and record information; MDB and CSV formats) |
EntityType |
Entity Type Code |
Type 1 indicates an individual provider (i.e., physician, psychologist, etc.); Type 2 indicates an organizational provider (i.e., hospital, lab, pharmacy, etc.). Type1 entities (individuals) may have only one NPI number and so only one record, but Type 2 entities (organizations) may have multiple NPI numbers and thus multiple records. Click here to download the Exclusion Type Code description document... |
| ReplacementNPI |
Replacement NPI |
Not currently populated |
| EIN |
Employer Identification Number (EIN) |
Not currently populated. CMS is not yet providing tax numbers of this type. |
| EnumDate |
Provider Enumeration Date |
Date the record was first added to the NPI registry |
| UpdateDate |
Last Update Date |
Date this provider NPI record was last updated |
| DeactReason |
NPI Deactivation Reason Code |
Not populated because records in the current dataset are not deactivated. Not currently disclosed by CMS. |
| DeactDate |
NPI Deactivation Date |
Not populated because records in this table are not deactivated. This field IS populated in the separate delta table tEntity_DEACT, described below. |
| ReactDate |
NPI Reactivation Date |
Date record was reactivated following a deactivation. |
| Gender |
Provider Gender Code |
M or F for Type 1 providers |
| IsSoleProp |
Is Sole Proprietor |
Y = provider operates as a sole proprietor. No = not a sole proprietorship. X = question not answered by provider. |
| IsOrgSubpart |
Is Organization Subpart |
For Type 2 providers, may be one of several organizational units, each with its own NPI number. Y = provider is a subpart. No = not a subpart. X = question not answered. |
| ParentOrgTIN |
Parent Organization TIN |
Not currently populated. CMS is not currently providing tax numbers at this time.
|
| InPECOS |
From monthly CMS PECOS distributions of PECOS-enrolled providers. Source: PECOS Ordering and Referring Report file distribution. |
Y = Physicians and non-physician practitioners who are of a type/specialty that is legally eligible to order and refer in the Medicare program and who have current enrollment records in Medicare (i.e., they have enrollment records in PECOS)
|
| Warning |
From the Office of Inspector General's excluded providers database (LEIE), indicatying a sanction prevents the provider from billing Medicare. A warning in this field should not be taken as definitive; the user should check the tExcluded table and consider other sources of provider fraud and exclusion information.
Up until the May 2017 release, this field was algorithmically derived for some records.*
|
Y= elements in the providers record indicated a match with a listing in the federal excluded providers database (see the table tExcluded below)
|
| ExclType |
The exclusion type from the LEIE database, explaining the reason that a provider was barred from billing Medicare. Fields with a Y in the Warning field will display this code.
|
The code's definition can be found at this link. A CSV file listing these exclusion descriptions is included in the CarePrecise Access Complete CSV download file.
|
| ExclDate |
The date of the exclusion from the LEIE database, where reported.
|
Where available
|
| UPIN |
UPIN is a deprecated identifier, no longer used. CMS has stopped disseminating this data. The field remains here for purposes of backward-compatibility.
|
|
| Group |
From NPPES group taxonomy data. |
Y= this provider reported that it operates as either a multi-specialty group or single-specialty group.
|
| County |
|
Practice county |
| CountyFIPS |
|
Practice county FIPS code |
| StateFIPS |
|
Practice state FIPS code |
| TimeZone |
|
Practice time zone |
| DLSTime |
|
Daylight saving time; Y= Yes |
| MSA |
|
Metropolitan Statistical Area of practice |
| PMSA |
|
Primary Metropolitan Statistical Area of practice |
| Population |
|
Zip Code population |
| Zip5 |
|
First five digits of practice address Zip Code |
| CPAC |
tEntity-B |
NPI |
National Provider Identifier |
Relational Key |
| (Provider entity and record information; MDB and CSV formats) |
CertDate |
Date of certification of provider's NPI number |
New field added with December 9, 2019 data release, refers to the date the NPI record was officially certified. |
| EstPracYears |
Estimated years provider has been in practice |
Algorithmically derived* from EPGH tExtendedPhysician.GradYear and/or CPAC tEntity.EnumDate 2009 forward. |
| CPAC |
tHumanNames |
NPI |
National Provider Identifier |
Relational Key |
| (Provider person names or contact person names; MDB and CSV formats) |
LN |
Provider Last Name (Legal Name) |
The enumerated individual provider's name (for Entity Type 1 records) |
| FN |
Provider First Name |
| MN |
Provider Middle Name |
| PN |
Provider Name Prefix Text |
| SN |
Provider Name Suffix Text |
| Cred |
Provider Credential Text |
| OthLN |
Provider Other Last Name |
Other name Type Codes:
| Code |
Description |
EntityType |
| 1 |
Former Name |
1 |
| 2 |
Professional Name |
1 |
| 5 |
Other |
1, 2 |
|
| OthFN |
Provider Other First Name |
| OthMN |
Provider Other Middle Name |
| OthPN |
Provider Other Name Prefix Text |
| OthSN |
Provider Other Name Suffix Text |
| OthCred |
Provider Other Credential Text |
| OthLNType |
Provider Other Last Name Type Code |
| AuthLN |
Authorized Official Last Name (Contact person for a Type 2 organization record) |
Name of the provider's authorizing official, if other than the listed individual provider. For organizations (Entity Type 2 records), this is the contact name.
|
| AuthFN |
Authorized Official First Name |
| AuthMN |
Authorized Official Middle Name |
| AuthTitle |
Authorized Official Title or Position |
| AuthPN |
Authorized Official Name Prefix Text |
| AuthSN |
Authorized Official Name Suffix Text |
| AuthCred |
Authorized Official Credential Text
|
| CPAC |
tOID |
NPI |
National Provider Identifier |
Relational Key |
| (Other identifiers, such as UPIN, OSCAR, PIN, Medicaid, etc., excluding NPI and taxonomy codes; MDB and CSV formats) One-to-many table. |
OtherID |
Other Provider Identifier |
Identifier relevant to external data |
| OtherIDType |
Other Provider Identifier Type Code |
| Description |
OtherIDType |
| Other |
01 |
| Medicaid |
05 |
|
| OtherIDState |
Other Provider Identifier State |
In the case of a state license code, this is the licensing state |
| OtherIDIssuer |
Other Provider Identifier Issuer |
|
| OIDnum |
Source: Added by CarePrecise to indicate the original NPPES flat file Other Identifiers field number. |
The number of the NPPES Other Identifier field (1 through 50)
|
| CPAC |
tOrgNames |
NPI |
National Provider Identifier |
Relational Key |
(Provider organization names for Type 2 providers; MDB and CSV formats)
|
OrgName_LBN |
Provider Organization Name (Legal Business Name) |
LBN (for Entity Type 2 records) |
| OthOrgName |
Provider Other Organization Name |
Other |
| OthOrgNameType |
Provider Other Organization Name Type Code |
| Code |
Description |
EntityType |
| 3 |
DBA |
2 |
| 4 |
Former LBN |
2 |
| 5 |
Other |
1, 2 |
|
| ParentOrgLBN |
Parent Organization LBN |
|
| CPAC |
tOtherOrgNames |
NPI |
National Provider Identifier |
Relational Key (composite) |
Alternative org names beyond those lited in tOrgNames; MDB and CSV formats. One-to-many table.
Table is not provided in custom data pulls (CarePrecise Select services). |
OtherOrgName |
Other Organization Aame |
Relational Key (composite) |
| OtherOrgNameType |
Other Organization Name Type |
Relational Key (composite)
| Code |
Description |
EntityType |
| 3 |
DBA |
2 |
| 4 |
Former LBN |
2 |
| 5 |
Other |
1, 2 |
|
| CPAC |
tPhoneFax |
NPI |
National Provider Identifier |
Relational Key |
(Provider phone and fax numbers; fax numbers for approx. 65% of records; MDB and CSV formats)
|
MailPhone |
Provider Business Mailing Address Telephone Number |
|
| MailFax |
Provider Business Mailing Address Fax Number |
|
| PracPhone |
Provider Business Practice Location Address Telephone Number |
|
| PracFax |
Provider Business Practice Location Address Fax Number |
|
| AuthPhone |
Authorized Official Telephone Number
|
|
| CPAC |
tTaxo |
NPI |
National Provider Identifier |
Relational Key |
(Provider Taxonomy codes indicating specialties and subspecialties for Type 1/individual providers, and facility types for Type 2/organization providers; MDB and CSV formats). One-to-many table.
|
Taxo |
Healthcare Provider Taxonomy Code |
Providers may have multiple taxonomies reported here, and thus multiple records in this one-to-many table |
| Lic |
Provider License Number |
For Type 2 (organization) providers, License is no longer collected as of 9/10/2018. |
| LicState |
Provider License Number State Code |
For Type 2 (organization) providers, License is no longer collected as of 9/10/2018. |
| TaxoSwitch |
Healthcare Provider Primary Taxonomy Switch (Primary specialty indicator) |
"Y" means this is the provider's primary specialty or facility code. |
| Tnum |
|
The number of the NPPES taxonomy field (1 through 15). If a primary taxonomy is not indicated, it may be useful to assume that the first-listed code (1) is primary.
|
| TaxoDescr |
|
Taxonomy code description (the specialty/subspecialty in English)
|
| CPAC |
tTaxoGroups |
NPI |
National Provider Identifier |
Relational Key |
| (Provider Taxonomy codes indicating group practices; MDB and CSV formats). One-to-many table. |
Gnum |
The source data (NPPES) permits group codes to be reported in up to 15 fields in this section. CarePrecise creates a one-to-many table, listing each of a provider's reported taxonomy group codes in a separate record. The Gnum is the NPPES Group Taxonomy field number in which the code was reported, allowing the code be matched with the specific group specialty in the tTaxo table. For instance, a code in tTaxoGroup field Gnum 3 indicates a group practice of the specialty reported in Tnum 3 in the tTaxo table.
|
CMS does not report the group codes in the taxonomy section (which appear in our tTaxo table) because they represent an additional layer of information on any one or more of the tTaxo codes.
|
| TaxoGroup |
Healthcare Provider Taxonomy Group_[1 through 15] |
193200000X for a multi-specialty practice
193400000X for a single-specialty practice
|
| CPAC |
tCoLoCode |
NPI |
National Provider Identifier |
Relational Key (composite) |
| (MDB and CSV formats) |
CoLoCode™ |
Provider CoLoCode™ (co-location code, a CarePrecise algorithmically derived* exclusive). The NPI and CoLoCode comprise the dual relational key for this table. The NPI identifies the provider record, and the CoLoCode identifies the physical location. The CoLoCode is an up to 40-character string that stands in for detailed location data, and is not intended to be sensical to the human viewer.
|
Relational Key (composite)
This code is an algorithmically derived conformation of the provider's practice location, permitting identification of providers who practice at the same location, for instance, physician groups, dental groups, radiology groups, etc. By using this table in conjunction with the tTaxoGroups table, it is possible to visualize the group entity (generally an organization) and its provider members. CoLoCodes are created for Practice addresses in the United States (US) and US Minor Islands (UM).
|
| Count |
Count of providers matching this co-location (algorithmically derived* conformation of the provider's practice location; see tCoLoCodes above). Indicates the number of providers practicing at this location. |
|
| CPAC |
tAdded
(CPAC records only) |
NPI |
National Provider Identifier |
Relational Key (composite) |
(MDB and CSV formats)Table is not provided in custom data pulls (CarePrecise Select services)
|
DateDiscovered |
|
Relational Key (composite)
The CarePrecise processing date on which the added provider record was discovered. Corresponds to the most recent previous CMS update date on which the added provider data was included in the NPPES database. Unduplicative index key is dual; NPI and DateDiscovered.
|
| CPAC |
tDropped
(CPAC records only) Table is not provided in custom data pulls (CarePrecise Select services) |
NPI |
National Provider Identifier |
Relational Key (composite) |
(MDB and CSV formats)
|
DateDiscovered |
|
Relational Key (composite)
The CarePrecise processing date on which it was discovered that the provider record was dropped from the NPPES database. Corresponds to the most recent previous CMS update date on which the provider data was dropped from the NPPES database. Unduplicative index key is dual; NPI and DateDiscovered.
|
| EntityType |
Entity Type Code |
Type 1 is individual providers (i.e., physicians, psychologists, etc.); Type 2 is organizational providers (i.e., hospitals, labs, etc.)
|
| ProvName |
|
This is a generated field based on EntityType.
|
| Prac1stAddr |
Provider First Line Business Practice Location Address |
|
| Prac2ndAddr |
Provider Second Line Business Practice Location Address |
|
| PracCity |
Provider Business Practice Location Address City Name |
|
| PracState |
Provider Business Practice Location Address State Name |
The federal data contains variations on state codes, abbreviations and full state names; we conform this field to standard 2-character state codes. A small number of non-US postal addresses remain nonconforming.
|
| PracZip |
Provider Business Practice Location Address Postal Code |
|
| PracCountry |
Provider Business Practice Location Address Country Code (If outside U.S.) |
|
| PracPhone |
Provider Business Practice Location Address Telephone Number |
|
| EnumDate |
Provider Enumeration Date |
|
| UpdateDate |
Last Update Date |
Date this provider NPI record was last updated
|
| CPAC |
tExcluded
(MDB and CSV formats) Table is not provided in custom data pulls (CarePrecise Select services) |
LN |
Last name (Type 1 providers) |
This table, sourced from the LEIE, lists all provider records in the federal excluded providers database. A provider may be excluded (barred from billing Medicare) for reasons of a criminal nature, among other reasons. This table contains no relational key; however, it is used to produce the Warning field in the tEntity table, which does include the provider's NPI. This table should be referenced for backup information.
|
| FN |
First name (Type 1 providers) |
| MN |
Middle Name (Type 1 providers) |
| OrgName |
Organization name (Type 2 providers) |
| Addr |
Street address |
| City |
City |
| State |
State |
| Zip |
Zip Code |
| DOB |
Date of Birth. Not currently populated. CMS is not providing tax numbers at this time. |
| General |
Provider category |
| Specialty |
Provider specialty |
| UPIN |
Federal physician identifier code (legacy) |
| ExclType |
Exclusion type (why provider was excluded) |
| ExclDesc |
Exclusion Description |
| ExclDate |
Date provider was excluded (YYYYMMDD)
|
| CPAC |
tDeact
(MDB and CSV formats; CPAC records only) Table is not provided in custom data pulls (CarePrecise Select services) |
NPI |
National Provider Identifier |
Relational Key (composite)
This data is provided by CMS, listing all NPI records that have been deactivated and the deactivation date. Unduplicative index key is dual; NPI and DeactDate. Please note that a record may be added to the Deactivated tables, but then later be reactivated. Also note that Type 2 records (organizations) may have multiple rtecords; some may be deactivated while others are active. When a record is reactivated it will appear in the tAdded table.
|
| DeactDate |
Date CMS deactivated the provider's NPI record |
Relational Key (composite) |
| DeactFound |
Date deactivation was processed by CarePrecise |
|
| DeactReason |
Reason for deactivation. |
Not currently populated. Not disclosed by CMS. |
| CPAC |
Delta tables in NPPES_Delta.mdb
(MDB format; CPAC records only) Table is not provided in custom data pulls (CarePrecise Select services) |
tAddresses_DEACT
tEntity_DEACT
tHumanNames_DEACT
tOID_DEACT
tOrgNames_DEACT
tPhoneFax_DEACT
tTaxo_DEACT
tTaxoGroups_DEACT
tCoLoCode_DEACT
|
The Delta tables are contained in a separate database included in the CarePrecise Access Complete dataset, named NPPES_Delta. They contain near-complete data on those providers whose records have been deactivated by CMS for various reasons, including retirement, death, or for any of several infractions. These tables contain the same fields as the standard provider data tables as defined above for their namesakes, and are populated with the data from previous data releases, with the deactivation date populated in the tEntity_DEACT table's DeactDate field. Please note that a record may be added to the Deactivated tables, but then later be reactivated. Also note that Type 2 records (organizations) may have multiple rtecords; some may be deactivated while others are active. When a record is reactivated it will appear in the tAdded table. |
| Additional Data Included with Extended Professional, Group and Hospital (EPGH)/CPAC Master Bundle and CarePrecise Platinum. Data is sourced from PECOS, Physician Compare, Hospital Compare and other CMS data, and is updated monthly. Provider records are a subset of the CPAC records, with approximately 600,000 physician records and 500,000 other providers. The EPGH is not sold separately, and is available only as a bundle. No time stamp is provided for EPGH updates, and no historical data is included. |
| EPGH |
tExtended_Professional
(The EPGH is available optionally as a bundle with CarePrecise Access Complete (CPAC) that provides additional information on healthcare professionals (particularly physicians), practice groups and hospitals, and reveals the affiliation links between all three. MDB and CSV formats.)
Only active providers (have appeared on a Medicare claim in the past twelve months) are included in the EPGH dataset (unlike the CPAC dataset, which includes all US HIPAA-covered providers). EPGH data is available for approximately 560,000 physicians, and 300,000 other professionals, and is growing. The hospital data in EPGH provides an unduplicated listing of hospitals and their highest priority NPI number, and is linked to each hospital's affiliated professionals/physicians and practice groups. EPGH practice group data makes it possible to see the multiple locations at which an individual provider practices. |
NPI |
National Provider Identifier of Individual Professional |
Relational Key (composite and to CPAC)
Link to professional's data in the CPAC databases above. This ID is unique per professional (physician, PA, etc.).
|
| PACID |
Individual's unique PAC ID (Practice Access Code). Unique individual professional ID assigned by Medicare PECOS system
|
Relational Key (composite)
Link to practice group affiliations through the tExtended_GroupProfessional table, and is a link to upcoming practice group quality data.
|
| ProfEnrollID |
Professional Enrollment ID |
Relational Key (composite)
Unique ID for the individual professional enrollment that is the source for the data in the record. One professional may have multiple records in this table as a result of multiple PECOS enrollments, each of which may have its own hospital and practice group affiliations.
|
| LN |
Last Name |
In most cases the name fields here will be duplicative of the fields in tHumanNames, but these are sourced from the PECOS system rather than the NPPES. |
| FN |
First Name |
| MN |
Middle Name |
| Suffix |
Name Suffix (Jr, III, etc.) |
| Gender |
M (male) or F (female) |
|
| Cred |
Credential |
Medical credential such as MD, DO, DPM, etc. |
| School |
Professional's medical school |
|
| GradYear |
Professional's medical school graduation year |
|
| PriSpec |
Primary medical specialty reported by the individual professional in this PECOS enrollment record |
|
| AllSecSpec |
All four secondary specialties reported by the individual professional in this PECOS enrollment record, separated by commas |
|
| EPGH |
tExtended_Group
(Extended Practice Group information; MDB and CSV formats) |
GroupPracPACID |
Unique Group Practice PAC ID (Practice Access Code) assigned by PECOS to the Group Practice |
Relational Key
Links Group and Individual records within Extended tables. This ID is unique to each practice group.
This key will link to group practice quality data soon to be released. |
| NPI |
National Provider Identifier of the Practice Group |
Relational Key
(to CPAC)
Links practice groups in Extended tables to CPAC data above. Algorithmically derived*; not available for all group records.
Use the GroupPracPACID to link individuals with their groups through the tExtended_GroupProfessional table. |
| OrgLBN |
Legal name of the Group Practice |
|
| CountGroupPracMem |
Number of Individual Professionals affiliated with Group Practice |
This count is limited to individuals within the Extended domain; others may be found within the standard CPAC tables via CoLoCode. |
| StreetAddr1 |
Group Practice line 1 address |
|
| StreetAddr2 |
Group Practice line 2 address |
|
| Line2Suppress |
Marker that address as reported may be incomplete |
A peculiarity of the federal source data. |
| City |
Group Practice city |
|
| State |
Group Practice state |
|
| Zip |
Group Practice zip code (9 digits when available) |
|
| CoLoCode |
Derived algorithmically* based on location data |
May be used to identify additional affiliated individuals within the NPPES data above. See description of CoLoCode in the CPAC table tCoLoCode above.
|
| EPGH |
tExtended_
GroupProfessional
(Many-to-Many table linking group practices with individual professionals. One or more individuals per group, and may be one or more groups per individual. Extended information on group practices' individual providers, incl. whether accepts Medicare assignment, participates in various federal medical quality programs. MDB and CSV formats). Many-to-many table. |
NPI |
National Provider Identifier of the Individual Professional. |
Relational Key (composite and to CPAC)
Link to individual's data in CPAC tables above and in tExtended_Professional table. This ID is unique to the individual professional. |
| GroupPracPACID |
Unique Group Practice PAC ID (Practice Access Code) assigned by PECOS to the Group Practice that the individual professional works with. |
Relational Key (composite)
Link between practice groups and their members in the tExtended_Professional table. This ID is unique to the practice group. |
| AcceptsMedicareAsmt |
Y = Accepts Medicare approved amount as payment in full. M = May accept Medicare Assignment. |
All providers in this table are enrolled to bill Medicare, and have done so within the past 9 months, but may not still be accepting new Medicare patients, and may not accept Medicare amount as payment in full. |
| eRx |
Participates in the eRx Incentive Program, a pay-for-reporting program to encourage physicians, other providers to use electronic prescribing of medications.
|
|
| PQRS |
Participates in the Medicare Physician Quality Reporting System (PQRS) Incentive Program - a pay-for-reporting program that gives eligible professionals incentives and payment adjustments if they report quality measures satisfactorily. |
Quality data on individual professionals is not yet available in this product, but using the relational keys in this table, you will be able to access it when it is released. |
| EHR |
Participates in the Medicare Electronic Health Record (EHR) Incentive Program - provides incentives and payment adjustments to eligible professionals who use certified EHR technology in ways that may improve healthcare. |
Y in this field means provider is participating in federal EHR incentive program, though may use an EHR system even if not affirmative in this field. |
| EPGH |
tExtended_Hospital
(Extended information on all U.S. acute care, VA and children's hospitals. Data provides a single unique NPI number per hospital facilitating deduplication of hospital record. MDB and CSV formats) |
CCN |
Medicare Hospital Provider Number (CMS Certification Number assigned by CMS) |
Relational Key
Link between hospitals and their affiliated individual physicians, etc. This ID is unique to each hospital recognized in the CMS PECOS system. If a hospital is eligible to bill Medicare (whether or not sanctioned), and is a general hospital (Acute Care, VA, Critical Access or Children's hospital), it is in this table.
This key links to the exhaustive federal hospital quality data, optionally available for download at no cost to EPGH users. |
| NPI |
Priority National Provider Identifier. |
Relational Key
(to CPAC)
Link to one of the hospital's records in CPAC tables above. Hospitals may have as many NPI numbers as they believe they need for their particular business circumstances, and tend to have many. We have listed here the Priority NPI, based on the hierarchical Taxonomy coding system, selecting first the NPI of the record containing the top (parent) taxonomy code for the hospital type, and, if not present, the NPI from the first-listed record for the hospital. Algorithmically derived*; not available for all hospital records. |
| HospitalName |
Hospital name as reported by the hospital in its NPPES record |
From the PECOS database |
| HospitalLBN |
Hospital legal business name as listed in hospital quality data |
From the Hospital Compare database |
| Address1 |
Hospital line 1 address |
|
| Address2 |
Hospital line 2 address |
|
| City |
Hospital City |
|
| State |
Hospital State |
|
| Zip Code |
Hospital Zip Code |
|
| County |
Hospital County |
|
| Phone |
Phone |
|
| HospitalType |
Hospital Type, as recorded in hospital quality data |
|
| HospitalOwnership |
Hospital ownership structure |
|
| EmergencyService |
Y= Hospital has emergency service |
|
| CoLoCode |
Derived algorithmically* based on location data |
May be used to identify additional data within NPPES tables above. See description of CoLoCode in the CPAC table tCoLoCode above. |
| EPGH |
tExtended_HospAff
(1-to-Many table linking Hospitals with physicians and other providers; up to five hospitals per individual; MDB and CSV formats.) Many-to-many table. |
HospAffCCN |
Medicare CCN (CMS Certification Number assigned by CMS) of hospital where individual professional provides service |
Relational Key (composite)
Link to hospital details in tExtended_Hospital via CCN, and to the CarePrecise Authoritative Hospital Database (APD) |
| NPI |
Unique professional ID assigned by NPPES to Individual Professional affiliated with hospital |
Relational Key (composite)
Link to Individual Professionals affiliated with hospital |
HospAffLBN |
Legal business name of hospital where individual professional provides service |
From the Hospital Compare database |
| The ProCase™ module contains the Name and Address data in the CPAC package in properly-cased form. It is available as an add-on to the standard data package (CPAC), extended data package (Master Bundle), Gold or Platinum packages. ProCase is also available as a stand-alone product. |
| ProCase |
tProCase_Names
(Properly cased names from CPAC tHumanNames and tOrgNames tables.) |
NPI |
National Provider Identifier |
Relational Key
(to CPAC)
Link to data in the CPAC and EPGH databases above. |
| CompanyName |
Name of organization |
|
| PN |
Provider Name Prefix Text |
|
| FN |
Provider First Name Text |
|
| MN |
Provider Middle Name Text |
|
| LN |
Provider Last Name Text |
|
| SN |
Provider Suffix Name Text |
|
| Cred |
Provider Credential Text |
|
| AttnName |
Provider or Organization contact person's full name; i.e., "Dr. Robert J. Jones, Jr., MD, PhD" |
Useful for professional communications |
| Salutation |
AI-generated salutation (the greeting on a letter; i.e., Dear "Mrs. Smith" or "Ms. Doe" or "Dr. Jones" |
Useful for professional communications |
| Title |
Provider Title Text |
|
| EntityType |
1 = individual, 2 = organization |
|
| ProCase |
tProCase_Addresses_Mail
(Properly cased Mailing Addresses from CPAC tAddresses table.) |
NPI |
National Provider Identifier |
Relational Key
(to CPAC)
Link to data in the CPAC and EPGH databases above. |
| Addr1 |
Mailing address line 1 |
|
| Addr2 |
Mailing address line 2 |
|
| City |
Mailing address city |
|
| State |
Mailing address state |
|
| Zip |
Mailing address Zip Code |
|
| Country |
Mailing address country |
|
| ProCase |
tProCase_Addresses_Prac
(Properly cased Practice Addresses from CPAC tAddresses table.) |
NPI |
National Provider Identifier |
Relational Key
(to CPAC)
Link to data in the CPAC and EPGH databases above. |
| Addr1 |
Practice address line 1 |
|
| Addr2 |
Practice address line 2 |
|
| City |
Practice address city |
|
| State |
Practice address state |
|
| Zip |
Practice address Zip Code |
|
| Country |
Practice address country |
|
| The Authoritative Physician Database™ (APD) contains detailed data on all HIPAA-covered US physicians, including practice group and hospital affiliations, medical procedure volumes, etc. The Authoritative Physician Database is available separately, but can be linked to EPGH, CPAC, and Authoritative Hospital Database data keying on the NPI, PACID, and CCN fields. Note that neither CarePrecise Platinum, CarePrecise Gold, or the Master Bundle include the APD. |
| APD |
APD_Physician
All U.S. HIPAA-covered physicians. |
NPI |
National Provider Identifier assigned by the federal government to every HIPAA-covered healthcare provider. All physicians are required to have one, and only one, Type 1 NPI number. |
Relational Key |
| PhysPACID |
Unique Physician ID assigned by PECOS |
Relational Key (to EPGH) |
| LN |
Last name |
|
| FN |
First name |
|
| MN |
Middle name |
|
| PN |
Name Prefix (Dr, Ms, etc.) |
|
| SN |
Name Suffix (Jr, II, etc.) |
|
| Cred |
Credential(s) |
|
| Prac1stAddr |
Practice address line 1 |
|
| Prac2ndAddr |
Practice address line 2 |
|
| PracCity |
Practice address city |
|
| PracState |
Practice address state |
|
| PracZip |
Practice address Zip Code |
|
| County |
Practice address county |
|
| CoLoCode |
Practice co-location code; may be used to link providers practicing at the same location; derived algorithmically based on co-location data |
|
| Rural/Urban/Sub |
R = Rural, U = Urban, S = Suburban/other |
|
| PhysicianPracPhone |
Physician's Practice phone number |
|
| PhysicianFax |
Fax number |
|
| EnumDate |
Date provider registered with the federal NPI database |
|
| UpdateDate |
Date provider most recently updated their NPI record |
|
| Gender |
Provider's gender |
|
| IsSoleProp |
Y = sole proprietor business type |
|
| IndepProfile |
Y = physician's profile indicates independent practice or group of 3 or fewer |
|
| InPECOS |
Y = enrolled to bill Medicare (may order and refer) |
|
| Warning |
Y = physician is barred from billing Medicare due to an infraction |
|
| ExclType |
Code of the infraction (see the ExclCode table for definitions) |
|
| PriSpec |
Primary medical specialty from NPI Type 1 record (NOTE: All specialties are listed in APD_Specialty) |
|
| School |
Physician's medical school |
|
| GradYear |
Physician's medical school graduation year |
|
| EstPracYears |
Estimated number of years in practice; used to estimate physician's age |
Based on medical school graduation year or date of NPI enumeration. |
| APD |
APD_Physician_Type2
All U.S. HIPAA-covered physicians. |
NPI |
National Provider Identifier (Type 2) assigned by the federal government to a physician's business entity. Every physician is required to have one and anly one Type 1 (individual) NPI registration, but may have additional Type 2 (organization) NPI registrations. |
Relational Key |
| OrgName_LBN |
Legal Business Name of physician's business entity |
|
| LN |
Last name of authorized official for physician business entity |
|
| FN |
First name of authorized official for physician business entity |
|
| MN |
Middle name of authorized official for physician business entity |
|
| PN |
Name Prefix (Dr, Ms, etc.) of authorized official for physician business entity |
|
| SN |
Name Suffix (Jr, II, etc.) of authorized official for physician business entity |
|
| Cred |
Credential(s) of authorized official for physician business entity |
|
| Title |
Title of authorized official for physician business entity |
|
| Prac1stAddr |
Practice address line 1 |
|
| Prac2ndAddr |
Practice address line 2 |
|
| PracCity |
Practice address city |
|
| PracState |
Practice address state |
|
| PracZip |
Practice address Zip Code |
|
| County |
Practice address county |
|
| CoLoCode |
Business entity's co-location code, derived algorithmically based on co-location data |
|
| Rural/Urban/Sub |
R = Rural, U = Urban, S = Suburban/other |
|
| PhysicianPracPhone |
Business entity phone number |
|
| PhysicianFax |
Business entity fax number |
|
| EnumDate |
Date provider registered this Type 2 NPI enumeration with the federal NPI database |
|
| UpdateDate |
Date provider most recently updated this Type 2 NPI record |
|
| IsSoleProp |
Y = sole proprietor business type |
|
| InPECOS |
Y = enrolled to bill Medicare (may order and refer) |
|
| Warning |
Y = physician is barred from billing Medicare due to an infraction |
|
| ExclType |
Code of the infraction (see the ExclCode table for definitions) |
|
| PriSpec |
Primary medical specialty from business entity's NPI Type 1 record (NOTE: All specialties are listed in APD_Specialty) |
|
| APD |
APD_Specialty
All physicians' specialties. May be up to 15 per physician. |
NPI |
National Provider Identifier |
Relational Key |
| ReportedOrder |
Number of taxonomy field in which reported (1 - 15), same as Tnum field in CPAC.tTaxo |
|
| Taxonomy |
Taxonomy code |
|
| License |
License number |
|
| LicenseState |
Licensing state |
|
| IsPrimary |
Y = primary taxonomy code (primary specialty) |
|
| Specialty |
Taxonomy description, i.e., specialty |
|
| APD |
APD_Group
Physicians' affiliated practice groups. May be up to five per physician. Ongoing extraction from Medicare claims data.
NOTE: Medical procedure performed per group can be viewed as a summary of procedures performed by each group's affiliated physicians. See example query in AuthoritativeHospDB.mdb. |
PACID |
Unique Group Practice ID assigned by PECOS to the Group Practice that the individual professional works with |
Relational Key (composite) |
| NPI |
Group National Provider Identifier; derived algorithmically from NPI registry data; groups may have additional NPI numbers |
Relational Key |
| OrgLBN |
Legal name of the Group Practice |
|
| CountGroupPracMem |
Total number of individual professionals affiliated with the Group Practice based on Group Practice PAC ID |
|
| StreetAddr1 |
Group Practice line 1 address |
|
| StreetAddr2 |
Group Practice line 2 address |
|
| City |
Group Practice city |
|
| State |
Group Practice state |
|
| Zip |
Group Practice zip code (9 digits when available) |
|
| County |
Group Practice County |
|
| Rural/Urban/Sub |
R = Rural, U = Urban, S = Suburban/other |
|
| CoLoCode |
Group co-location code; may be used to link providers practicing at the same location; derived algorithmically based on co-location data |
|
| GroupPhone |
Phone Number |
|
| GroupFax |
Fax Number |
|
| AuthPN |
Contact name prefix |
|
| AuthFN |
Contact first name |
|
| AuthMN |
Contact middle name |
|
| AuthLN |
Contact last name |
|
| AuthSN |
Contact name suffix |
|
| AuthCred |
Contact credential |
|
| AuthTitle |
Contact title |
|
| APD |
APD_GroupAff
Linking table connects physicians with practice group affiliations. Collected from Medicare claims data during a moving window of twelve months prior to release date. |
NPI |
Unique physician ID assigned by NPPES |
Relational Key (composite) |
| PACID |
Unique Group Practice ID assigned by PECOS to the Group Practice that the individual professional works with |
Relational Key (composite) |
| AcceptsMedicareAsmt |
Y = Professional accepts Medicare approved amount as payment in full at this group location. M = Professional may accept Medicare Assignment. |
|
| APD |
APD_Hospital
Physician's affiliated hospitals. May be up to five per physician. Ongoing extraction from Medicare claims data. |
CCN |
CMS Certification Number |
Relational Key |
| NPI |
Priority National Provider Identifier of hospital; derived as best NPI based on taxonomy hierarchy; hospitals may have additional NPI numbers |
Relational Key (to CPAC) |
| HospitalName |
Hospital name as reported by the hospital in its NPPES record |
|
| HospitalLBN |
Hospital legal business name as listed in the hospital quality data |
|
| Address1 |
Hospital line 1 address |
|
| Address2 |
Hospital line 2 address |
|
| City |
Hospital City |
|
| State |
Hospital State |
|
| ZIP Code |
Hospital Zip Code |
|
| County |
Hospital County |
|
| Rural/Urban/Sub |
R = Rural, U = Urban, S = Suburban/other |
|
| HospitalPhone |
Hospital Phone |
|
| HospitalFax |
Hospital Fax Number |
|
| HospitalType |
Hospital Type, as recorded in hospital quality data |
|
| HospitalOwnership |
Hospital ownership structure |
|
| EmergencyService |
Y= Hospital has emergency service |
|
| CoLoCode |
Hospital co-location code; may be used to link providers practicing at the same location; derived algorithmically based on co-location data |
|
| AuthPN |
Contact name prefix |
|
| AuthFN |
Contact first name |
|
| AuthMN |
Contact middle name |
|
| AuthLN |
Contact last name |
|
| AuthSN |
Contact name suffix |
|
| AuthCred |
Contact credential |
|
| AuthTitle |
Contact Official title |
|
| APD |
APD_HospitalAff
Linking table connects physicians with their hospital affiliations. Collected from Medicare claims data during a moving window of twelve months prior to data release date. |
CCN |
CCN of hospital where individual professional provides service |
Relational Key (composite) |
| NPI |
Unique physician ID assigned by NPPES |
Relational Key (composite) |
| APD |
APD_PhysicianProcedure
Physician procedure volumes, listing top five procedures performed by physician, and counts of services and patients served, from CMS-collected HCPCS reporting. |
NPI |
National Provider Identifier of clinician |
Relational Key (composite) |
| HCPCS_Code |
Healthcare Common Procedure Coding System (HCPCS) procedural code billed by the clinician; "NR" indicares that no procedure data has been reported for this physician. Top five HCPCS procedures performed by physician are listed. |
Relational Key (composite) to Physician Procedure table |
| ServiceCount |
Frequency of individual clinician's performance of the associated HCPCS code within the calendar year |
|
| BeneficiaryCount |
The number of beneficiaries that received the service or procedure identified by the HCPCS code |
|
| MeasureYear |
The most recent year of procedure data reported by CMS |
|
| APD |
APD_ProcedureDescriptions
Physician procedure volumes. Ongoing extraction from CMS-collected HCPCS reporting. Abbreviated descriptions. |
HCPS_Code |
Healthcare Common Procedure Coding System (HCPCS) procedural code billed by the clinician |
Relational Key to Physician Procedure table |
| ProcedureDescription |
Lay-friendly description of procedure associated with HCPS code |
|
| APD |
Lookup_ExclusionDescriptions
Describes the exclusion code for sanctions indicated in the APD_Physician table. Exclusion from billing Medicare or other federal programs due to a sanction of other infraction. Sourced from Centers for Medicare and Medicaid Services Office of Inspector General. |
ExclType |
Exclusion type code |
Relational Key to ExclType in Physician table |
| ExclDescr |
Description of exclusions imposed by the OIG expanded from Medicare and State health care programs to all Federal health care programs, federal code 1128B(f)(1). |
|
| The Authoritative Hospital Database™ (AHD) contains detailed data on US hospitals, including bed counts, procedure volumes, medicare billings, patient satisfaction rankings, etc. The Authoritative Hospital Database is available separately, but can be linked to EPGH, CPAC, and Authoritative Physician Database data keying on the NPI, PACID and CCN fields. Note that neither CarePrecise Platinum, CarePrecise Gold, or the Master Bundle include the AHD. |
| AHD |
AuthoritativeHospital
DB.mdb
CSV files are provided for all database tables. |
CCN |
Unique federal hospital identifier |
Relational Key
(to EPGH)
Link to data in the EPGH databases above. |
| NPI |
National Provider Identifier |
Relational Key
(to CPAC)
Link to data in the CPAC and EPGH databases above. Algorithmically derived*; not available for all AHD records. The contact name fields in the AHD are then populated from the matched NPI record. |
| HospitalName |
Hospital’s name |
|
| Address1 |
Hospital’s address, line 1 |
|
| Address2 |
Hospital’s address, line 2 |
|
| City |
Hospital’s city |
|
| State |
Hospital’s state |
|
| ZipCode |
Hospital’s Zip Code |
|
| County |
Hospital’s county |
|
| Phone |
Hospital’s phone |
|
| Fax |
Hospital’s fax |
|
| Beds |
Number of beds |
|
| BedDaysAvail |
Number of bed days available |
|
| InternsAndResidents |
Number of interns and residents |
|
| PayrollEmployees |
Number of employees on payroll |
|
| NonPaidWorkers |
Number of non-paid workers |
|
| TotalDischarges |
Number of discharges/year |
|
| MedicareDischarges |
Number of Medicare discharges/year |
|
| MedicaidDischarges |
Number of Medicaid discharges/year |
|
| Vol_Gastrointestinal |
Procedure volume: Gastrointestinal |
|
| Vol_Eye |
Procedure volume: Eye |
|
| Vol_Nervous_system |
Procedure volume: Nervous system |
|
| Vol_Musculoskeletal |
Procedure volume: Musculoskeletal |
|
| Vol_Skin |
Procedure volume: Skin |
|
| Vol_Genitourinary |
Procedure volume: Genitourinary |
|
| Vol_Cardiovascular |
Procedure volume: Cardiovascular |
|
| PN |
Contact name prefix |
|
| FN |
Contact first name |
|
| MN |
Contact middle name |
|
| LN |
Contact last name |
|
| SN |
Contact name suffix |
|
| Title |
Contact title |
|
| Cred |
Contact credentials |
|
| HospitalType |
Type of hospital (general acute, children's, etc.) |
|
| HospitalOwnership |
Type of hospital ownership |
|
| ParentOrgLBN |
Name of parent system |
|
| EmergencyService |
Does have emergency service? |
|
| CoLoCode |
Algorithmically derived* from location data. Used to match records. |
|
| Bathroom cleanliness |
Patient satisfaction 1-5 stars |
|
| Communication from Nurses |
Patient satisfaction 1-5 stars |
|
| Communication from Doctors |
Patient satisfaction 1-5 stars |
|
| Patient received help quickly on request |
Patient satisfaction 1-5 stars |
|
| Quality of pain control |
Patient satisfaction 1-5 stars |
|
| Medications were explained before giving |
Patient satisfaction 1-5 stars |
|
| Patient received instruction on at-home recovery |
Patient satisfaction 1-5 stars |
|
| Patient understood care when leaving hospital |
Patient satisfaction 1-5 stars |
|
| Patient’s overall hospital rating |
Patient satisfaction 1-5 stars |
|
| Area around room was quiet at night |
Patient satisfaction 1-5 stars |
|
| Patient would recommend hospital |
Patient satisfaction 1-5 stars |
|
| Hospital summary star rating |
Patient satisfaction 1-5 stars |
|
| Additional data included in the CP ListMaker software component of CarePrecise Gold, and CarePrecise Platinum, sourced from USPS and U.S. Department of Commerce, and independent CarePrecise research. Data is periodically updated. These data are available only as part of the CP ListMaker and CarePrecise Gold/Platinum products, and are not sold separately. Note that only the tZips data, and not the the CP ListMaker application itself, is included in special licensing for Derivative Products or Redistribution; however, the CP ListMaker application is open source and may be used as a model for redistributed products. |
| CPLM |
tZips
Economic and social segmentation data for providers' service areas
|
ZipCode |
5-digit Zip Code |
Relational Key (to CPAC.tEntity.Zip5) |
| Wealth |
Numerical indicator of the relative wealth/poverty of the provider's immediate service area (5-digit zip). Wealth/poverty level is show as a percentage of the Federal Poverty Level (FPL) for the particular geographic area. Currently up to 12 levels are present in the data; additional levels will be included when data for those more extreme wealth levels are present. |
| Description |
Wealth Level |
| =<50% FPL |
1 |
| 50% to 100% FPL |
2 |
| 100% to 150% FPL |
3 |
| 150% to 200% FPL |
4 |
| 200% to 300% FPL |
5 |
| 300% to 500% FPL |
6 |
| 500% to 700% FPL |
7 |
| 700% to 1000% FPL |
8 |
| 1000% to 1500% FPL |
9 |
| 1500% to 2000% FPL |
10 |
| 2000% to 3000% FPL |
11 |
| Greater than 3000% FPL |
12 |
|
| RuralUrban |
Indicates Rural (R), Urban (U) or Other (O) status for the provider's immediate service area (zip). Other indicates suburban or small city status. |
|
| City |
City associated with Zip Code |
|
| County |
County primarily associated with Zip Code |
|
| State |
State associated with Zip Code |
|
| Latitude |
Geographic latitude to 5-digit zip accuracy (center of Zip) |
|
| Longitude |
Geographic longitude to 5-digit zip accuracy (center of Zip) |
|
| CPLM |
Additional Gold data tables:
- Names
- Names_Company
- Names_Cred
- Names_Genderize
- Names_Prefices
- Names_Suffices
- StateNameVariants
|
Additional data tables included in CarePrecise Gold are used by the included SharpMail™ tool to produce correctly-cased names and addresses and correctly-genderized and -prefixed salutations. |
|
* Marked above by an asterisk (*), algorithmically derived data in the datasets includes data that is extracted/mined from the source databases, but which has a margin of error and should not be relied upon as conclusive. Record linking algorithms are used to enrich our data when direct correlation (via a unique identifier field) is not available, using available information in name, address, phone, taxonomy, and other fields. In particular, some of the older data on providers excluded from billing Medicare (from the HHS Office of Inspector General's excluded providers database) can only be linked to NPI records by this means. Please note that when matches are found, there may be instances where an individual or firm has the same or similar name and location information as an excluded provider but is actually a different party. Therefore, it is important that you verify a potential match with the debarring agency identified in the record information. See the disclaimer appearing at the bottom of the documentation page.
Not all fields in all records are populated with data. Healthcare providers may update data in their record using the federal NPI registry website, and are required to do so within 30 days of a change in their information.
CarePrecise LLC reserves the right to make changes in the data and data structure as it deems necessary to preserve the quality of the product. Please read the Notice at the bottom of the page https://www.careprecise.com/help/ for additional information about the data.
|
Click for a printer-friendly version of the fields list. 