NPPES Organization Attributes

Snowflake table name : CYBERSYN.NPPES_ORGANIZATION_ATTRIBUTES

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

NPI

National Provider Identifier, which is a unique ID assigned to a provider by the CMS National Plan and Provider Enumeration System (NPPES)

NUMBER

1699527127

ORGANIZATION_NAME

Name of the provider organization or name of the individual in cases when a practitioner is a sole proprietor

VARCHAR

MENTOR SMILES, VLADIMIR KHRAMOY, DDS, LLC

OTHER_ORGANIZATION_NAME

Alternate name of the organization

VARCHAR

DREAM BIGGER ABA LLC

IS_ORGANIZATION_SUBPART

Boolean field indicating if organization is subpart of another organization

BOOLEAN

False

PARENT_ORGANIZATION_NAME

Legal name of the parent organization

VARCHAR

SHAY MARKOVITCH DENTISTRY, PLLC

IS_SOLE_PROPRIETOR

Boolean field indicating whether organization is an individual operating as a sole proprietorship

BOOLEAN

True

NPI_CREATION_DATE

Date NPPES assigned the NPI to the individual practitioner

DATE

2024-04-04

NPI_DEACTIVATION_DATE

Date of last NPI deactivation, if applicable

DATE

2017-02-28

NPI_REACTIVATION_DATE

Date of last NPI reactivation, if applicable

DATE

2023-11-21

CERTIFICATION_DATE

Date when provider last confirmed NPPES data is correct

DATE

2024-04-08

LAST_UPDATE_DATE

Last date the entry was updated

DATE

2024-04-04

Last updated

Copyright © 2024 Cybersyn