National Data Warehouse (NDW)

Data Content

During the initial load of the data warehouse, NPIRS asked the sites to send all registration and encounter data dating back to October 1, 2000. Most sites were able to do so, but not all. Some also sent encounter data prior to that date, but this data is sparse.

Data includes (but is not limited to):

Registration	Encounter
Patient identification Chart numbers and locations Address Social Security Number Tribal membership and benefit class Insurance eligibility Alias (AKA names)	Admission and discharge dates Patient data Location (Facility/clinic) of the service Provider discipline Procedure, diagnosis, injury and dental codes Lab tests and clinical measurements Health factors Patient Education Medication Contract Health Service data such as authorization number, authorizing facility and cost

Please refer to the Meta Data and Standard Code Book tabs under this section for further information on those subjects.
Below are some commonly asked questions concerning data content within the NDW:

What standards do we adhere to/strive toward?
Is there a Thesaurus or other names for our fields?
Do we have registration/encounters with Temporary charts? How are they treated?

Yes; RPMS chart numbers are 6 characters in a 10 character field (i.e.: 0000007330, 0000T07330). A ‘T’ in the 5th position of an RPMS chart number indicates it is a temporary chart number. Non-RPMS systems may use other ways to indicate temporary charts.

RPMS will, and non-RPMS systems may, send registrations and visits with temporary charts to the NDW. They are not treated any differently than records containing permanent charts.

Do we have social security disability insurance (SSI) info?
Do we have demo patient encounter records?
Do we have the state in which a facility is located?
Do we have a variable that contains something like a “chart abstract?”
How to add Data Elements: