Source Data Catalog - gpcnetwork/grouse-cms GitHub Wiki
Main CDM Database
The main source GROUSE database may be presented to you in slightly different way depending on your final approved role, described as below:
Source Database Name
Dataset Type
Role Accessible
Notes
GROUSE_DEID_DB
full dataset
GROUSE_ROLE_C_ANALYTICS
NOT Allow Writing in the Same Database
GROUSE_DEID_ANALYTICS_DB_DROCxxx
study-specific dataset
GROUSE_ROLE_C_ANALYTICS_DROCxxx
Allow Writing in the Same Database
Schema - CMS_PCORNET_CDM
Secure views of PCORnet CDM derived from CMS RIF files and other relevant public files (e.g., ACS tables)
CDM View
Beneficiary#
Encounter#
Observation#
Other-Identifier#
V_DEID_ADDRESS_GEOCODE
NA
NA
5,461,243
5,460,901(addressid); 163,511(geocodeid)
V_DEID_ADDRESS_HISTORY
13,734,584
NA
52,616,257
5,453,172(addressid)
V_DEID_DEATH
2,653,304
NA
2,653,304
V_DEID_DEMOGRAPHIC
13,735,779
NA
13,735,779
V_DEID_DIAGNOSIS
11,720,102
766,434,347
4,172,206,936
1,131,501(providerid)
V_DEID_DISPENSING
9,786,772
NA
1,654,128,154
1,244,219(prescriberid)
V_DEID_ENCOUNTER
11,754,850
792,539,447
794,929,636
1,138,901(providerid)
V_DEID_ENROLLMENT
13,667,433
NA
38,435,909
V_DEID_PROCEDURES
11,646,026
796,462,370
4,975,926,639
1,166,530(providerid)
V_DEID_OBS_COMM
NA
NA
2,929,412
218,564(obscomm_geocodeid)
Schema - PCORNET_CDM_<XX>
Secure views of PCORnet CDM derived from GPC sites' electronic medical records. <XX> represents site's abbreviation (ALLINA, IHC, KUMC, MCRI, MCW, MU, UIOWA, UNMC, UTHSC (UTHOUSTON), UTHSCSA, UTSW, UU, WASHU) and following table provides an overview of CDM table availabilities for each site.
CDM View*
ALLINA
IHC
KUMC
MCRI
MCW
MU
UIOWA
UNMC
UTHSC
UTHSCSA
UTSW
UU
WASHU
V_DEID_CONDITION
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_DEATH
P
P
P
P
P
P
P
P
P
P
P
P
P
V_DEID_DEATH_CAUSE
N
N
N
N
N
N
N
N
N
N
N
N
N
V_DEID_DEMOGRAPHIC
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_DIAGNOSIS
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_DISPENSING
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_ENCOUNTER
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_ENROLLMENT
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_IMMUNIZATION
N
N
N
N
N
N
N
N
N
N
N
N
N
V_DEID_LAB_HISTORY
N
N
N
N
N
N
N
N
N
N
N
N
N
V_DEID_LAB_RESULT_CM
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_MED_ADMIN
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_OBS_CLIN
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_OBS_GEN
N
N
N
N
N
N
N
N
N
N
N
N
N
V_DEID_PCORNET_TRIAL
P
P
P
P
P
P
P
P
P
P
P
P
P
V_DEID_PRESCRIBING
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_PROCEDURES
C
C
C
C
C
C
C
C
C
C
C
C
C
V_DEID_PRO_CM
N
N
N
N
N
N
N
P
N
N
N
N
N
V_DEID_VITAL
C
C
C
C
C
C
C
C
C
C
C
C
C
C: consistently populated
P: partially populated
N: not populated/empty
Auxciliary Databases
Database
Schema
Object
Name
Description
NPPES_NPI_REGISTRY
NPPES_FEB
BASE TABLE
NPIDATA
Main NPPES database
NPPES_NPI_REGISTRY
NPPES_FEB
BASE TABLE
NPI_ENDPOINTS
NPPES_NPI_REGISTRY
NPPES_FEB
BASE TABLE
NPI_OTHER_NAMES
Other names for NPI
NPPES_NPI_REGISTRY
NPPES_FEB
BASE TABLE
NPI_PRACTICE_LOCATION
More Detailed information on Practive Location
NPPES_NPI_REGISTRY
NPPES_FEB
BASE TABLE
NPI_TAXONOMY
NPPES Taxonomy Descriptions
ONTOLOGY
ACT_ONTOLOGY
BASE TABLE
*
All ACT ontology tables
ONTOLOGY
GROUPER_VALUESETS
BASE TABLE
*
Multiple valuesets extracted from public resources