Available Data & Definitions
CKDRegistry_Production
Table
dbo.version
A table to store version, author, validator and release date of each registry.
| registry | CURE-CKD |
| version | Major.Minor |
| author | Creator |
| validator | Quality Control |
| release_date | Date of Release |
registry2017.ckd
Patients are identified as having chronic kidney disease (CKD) by one of three algorithms. 1) At least two eGFR (CKD-EPI) measurements =30 mg/g or urine protein >=150 mg/g, OR 3) At least one encounter (inpatient or outpatient) with an ICD-9 or ICD-10 diagnosis code indicating CKD. This table includes 618,655 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| ckd_entry_age | The age of the patient at first indication of CKD |
| ckd_entry_period_scr_count | The count of serum creatinine laboratory measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_egfr_mean | The mean of eGFR (CKD-EPI) measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_egfr_mean_staging | Stage of CKD based on mean eGFR measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_bp_count | The count of blood pressure measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_sbp_mean | The mean of systolic blood pressure measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_dbp_mean | The mean of diastolic blood pressure measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_hba1c_count | The count of HbA1c measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_hba1c_mean | The mean of HbA1c measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_uacr_stage | The highest albuminuria stage based on all UACR measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
| ckd_entry_period_upcr_stage | The highest proteinuria stage based on all UPCR measurements from the date of earliest identification of CKD until 90 days following the earliest date of identification of CKD |
registry2017.disease
Patients at-risk or having chronic kidney disease (CKD) are stored in this table. Patients with CKD, diabetes mellitus (DM), pre-diabetes mellitus (PDM) and hypertension (HTN) are flagged. This table includes 2,625,963 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| ckd_flag | Indicated if ckd_egfr_flag, ckd_dx_flag or ckd_albuminuria_flag is set |
| ckd_egfr_flag | A minimum of two serum creatinine measurements at least 90 days apart in which the CKD-EPI calculation of eGFR falls below 60 mL/min/1.73 m² |
| ckd_egfr_year | The year of the earliest date of identification |
| ckd_dx_flag | A minimum of one encounter of any type in which an ICD9 or ICD10 diagnosis code indicating CKD is present |
| ckd_dx_year | The year of the earliest date of identification |
| ckd_albpro_flag | A minimum of two laboratory measurements at least 90 days apart in which albuminuria was indicated; albumin to creatinine ratio greater than or equal to 30 mg/g, or urine protein greater than 150 mg/g |
| ckd_albpro_year | The year of the earliest date of identification |
| dm_flag | Indicated if dm_a1c_flag, dm_fbg_flag, dm_rbg_flag, dm_dxip_flag, dm_dxop_flag, or dm_medication_flag is set. If the patient has a diagnosis for polycystic ovarian syndrome, taking metformin with no HbA1c or diagnosis indication of DM, the dm_flag is set to 0 |
| dm_a1c_flag | A minimum of one laboratory measurement in which HbA1c reached at least 6.5% |
| dm_a1c_year | The year of the earliest date of identification |
| dm_fbg_flag | A minimum of two laboratory measurements at least one day but no more than 2 years apart in which fasting blood glucose reached at least 126 mg/dL |
| dm_fbg_year | The year of the earliest date of identification |
| dm_rbg_flag | A minimum of two laboratory measurements at least one day but no more than 2 years apart in which fasting was not indicated and the blood glucose reached at least 200 mg/dL |
| dm_rbg_year | The year of the earliest date of identification |
| dm_dxip_flag | A minimum of one inpatient encounter in which an ICD9 or ICD10 diagnosis code indicating DM is present |
| dm_dxip_year | The year of the earliest date of identification |
| dm_dxop_flag | A minimum of two outpatient encounters at least one day apart in which an ICD9 or ICD10 diagnosis code indicating DM is present |
| dm_dxop_year | The year of the earliest date of identification |
| dm_medication_flag | A minimum of one medication record with a pharmaceutical class for treating DM (DPP-4, GLP-1 receptor agonists, insulin, biguanide, SGLT2, dopamine receptor agonists, sulfonylurea, SGLT2) |
| dm_medication_year | The year of the earliest date of identification |
| pdm_flag | Indicated if pdm_a1c_flag, pdm_fbg_flag, pdm_rbg_flag or pdm_dx_flag is set. |
| pdm_a1c_flag | A minimum of one laboratory measurement in which HbA1c was at least 5.7% but less than 6.5% |
| pdm_a1c_year | The year of the earliest date of identification |
| pdm_fbg_flag | A minimum of two laboratory measurements at least one day but no more than 2 years apart in which fasting blood glucose was between 100 and 125 mg/dL |
| pdm_fbg_year | The year of the earliest date of identification |
| pdm_rbg_flag | A minimum of two laboratory measurements at least one day but no more than 2 years apart in which random blood glucose was between 140 and 199 mg/dL |
| pdm_rbg_year | The year of the earliest date of identification |
| pdm_dx_flag | A minimum of one encounter of any type in which an ICD9 or ICD10 diagnosis code indicating PDM is present |
| pdm_dx_year | The year of the earliest date of identification |
| htn_flag | Indicated if htn_vit_flag or htn_dx_flag is set |
| htn_vit_flag | A minimum of two blood pressure measurements at least 14 days apart in which either/both sbp reaches at least 140 mmHg or dbp reaches at least 90 mmHg |
| htn_vit_year | The year of the earliest date of identification |
| htn_dx_flag | A minimum of one encounter of any type in which an ICD9 or ICD10 diagnosis code indicating HTN is present |
| htn_dx_year | The year of the earliest date of identification |
registry2017.dm
Patients are identified as having diabetes mellitus (DM) by one of six algorithms. 1) A laboratory result for HbA1c >= 6.5%, OR 2) Two random blood glucose measurements >=200 mg/dL at least one day, but no more than two years apart, OR 3) Two fasting blood glucose measurements >= 126 mg/dL at least one day, but no more than two years apart, OR 4) At least one inpatient encounter with an ICD-9 or ICD-10 diagnosis code indicating DM present, OR 5) At least two outpatient encounters with an ICD-9 or ICD-10 diagnosis code indicating DM present, OR 6) At least one medical record with a pharmaceutical class for treating DM. This table includes 914,310 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| dm_entry_age | The age of the patient at first indication of DM |
| dm_entry_period_hba1c_count | The count of HbA1c measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_hba1c_mean | The mean of HbA1c measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_scr_count | The count of serum creatinine laboratory measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_egfr_mean | The mean of eGFR (CKD-EPI) measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_bp_count | The count of blood pressure measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_sbp_mean | The mean of systolic blood pressure measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_dbp_mean | The mean of diastolic blood pressure measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_uacr_stage | The highest albuminuria stage based on all UACR measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
| dm_entry_period_upcr_stage | The highest proteinuria stage based on all UPCR measurements from the date of earliest identification of DM until 90 days following the earliest date of identification of DM |
registry2017.egfr
All registry patients (identified CKD, DM, PDM or HTN) with least one serum creatinine measurement are included in this table. This table includes 2,185,007 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| egfr_entry_period_scr_count | The number of serum creatinine (SCr) measurements from the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_year1_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year2_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year3_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year4_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year5_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year6_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year7_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year8_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year9_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year10_scr_count | The number of serum creatinine measurements in each of the follow-up years from the eGFR entry period |
| egfr_year_scr_count | The total number of follow-up years in which serum creatinine was measured. Follow-up years are not required to be continuously sequential |
| egfr_entry_period_mean | The mean of eGFR measurements (CKD-EPI) from the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_year1_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year2_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year3_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year4_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year5_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year6_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year7_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year8_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year9_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year10_mean | The mean of eGFR measurements (CKD-EPI) in each of the follow-up years |
| egfr_year1_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year2_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year3_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year4_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year5_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year6_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year7_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year8_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year9_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_year10_reduction | The percent reduction of mean eGFR measurements for each follow-up year’s mean compared to the eGFR entry period mean |
| egfr_reduction30_flag | An indication if a 30% decline in eGFR was recorded |
| egfr_reduction30_time | The number of years for the 30% decline in eGFR to occur |
| egfr_reduction40_flag | An indication if a 40% decline in eGFR was recorded |
| egfr_reduction40_time | The number of years for the 40% decline in eGFR to occur |
| egfr_reduction50_flag | An indication if a 50% decline in eGFR was recorded |
| egfr_reduction50_time | The number of years for the 50% decline in eGFR to occur |
| egfr_reduction57_flag | An indication if a 57% decline in eGFR was recorded |
| egfr_reduction57_time | The number of years for the 57% decline in eGFR to occur |
registry2017.egfr_entry
All registry patients (identified CKD, DM, PDM or HTN) with least one serum creatinine measurement are included in this table. This table includes 2,185,007 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| egfr_entry_age | The age of the patient at the first serum creatinine (SCr) measurement |
| egfr_entry_smoking_status | The smoking status on or before the first SCr measurement. If no encounter exists in the time a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the period, the value logged on the latest encounter date is recorded |
| egfr_entry_period_smoking_status | The smoking status from the date of the SCr measurement until 90 days following the first measurement of SCr. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the period the value logged on the latest encounter date is recorded |
| egfr_entry_period_egfrckd_flag | An indication of low eGFR (CKD-EPI) below 60 ml/min/1.73m2 from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_dxckd_flag | An indication of a diagnosis for CKD occurred from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_albprockd_flag | An indication if an elevated UACR (>30 g/g) or UPCR (>150 mg/g) measurement was recorded from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_dm_flag | An indication if DM was identified on or before the date of the first serum creatinine measurement |
| egfr_entry_pdm_flag | An indication if PDM was identified on or before the date of the first serum creatinine measurement |
| egfr_entry_htn_flag | An indication if HTN was identified on or before the date of the first serum creatinine measurement |
| egfr_entry_period_hba1c_count | The count of HbA1c measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_hba1c_mean | The mean of HbA1c measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_uacr_count | The count of UACR measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_uacr_mean | The mean of UACR measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_upcr_count | The count of UPCR measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_upcr_mean | The mean of UPCR measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_bp_count | The count of blood pressure measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_sbp_mean | The mean of systolic blood pressure measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_dbp_mean | The mean of diastolic blood pressure measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_pp_mean | The mean of pulse pressure measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_map_mean | The mean of mean arterial pressure measurements from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_av_count | The count of ambulatory visits (pcornet visit types of ‘AV’ and ‘ED’) from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_ipv_count | The count of inpatient visits (pcornet visit types of ‘IP' and ‘EI’) from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_aceiarb_flag | An indication of ACEi/ARB use on or before the date of the first serum creatinine measurement |
| egfr_entry_sglt2_flag | An indication of SGLT2 use on or before the date of the first serum creatinine measurement |
| egfr_entry_nsaid_flag | An indication of NSAID use on or before the date of the first serum creatinine measurement |
| egfr_entry_ppi_flag | An indication of PPI use on or before the date of the first serum creatinine measurement |
| egfr_entry_period_aceiarb_coverage | The number of days of ACEi/ARB coverage from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_sglt2_coverage | The number of days of SGLT2 coverage from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_nsaid_coverage | The number of days of NSAID coverage from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_period_ppi_coverage | The number of days of PPI coverage from the date of the first measurement of SCr until 90 days following the first measurement of SCr |
| egfr_entry_contrast_flag | An indication if any procedures were billed using iodinated contrast dye, with a procedure date before the first date of measurement of SCr |
| egfr_entry_period_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date on or after the first date of measurement of SCr until 90 days following the first measurement of SCR |
registry2017.egfr_follow
All registry patients (identified CKD, DM, PDM or HTN) with at least one serum creatinine measurement are included in this table. This table includes 2,185,007 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| egfr_year1_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year2_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year3_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year4_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year5_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year6_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year7_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year8_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year9_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year10_smoking_status | The smoking status in each of the follow-up years. If no encounter exists in the period a value of ‘NM’ is recorded. If one encounter exists in the period, the value logged is recorded. If multiple encounters exist in the time period the value logged on the latest encounter date is recorded |
| egfr_year1_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year2_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year3_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year4_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year5_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year6_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year7_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year8_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year9_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year10_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year1_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year2_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year3_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year4_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year5_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year6_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year7_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year8_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year9_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year10_hba1c_count | The count of HbA1c measurements in each of the follow-up years |
| egfr_year1_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year2_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year3_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year4_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year5_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year6_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year7_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year8_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year9_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year10_hba1c_mean | The mean of HbA1c measurements in each of the follow-up years |
| egfr_year1_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year2_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year3_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year4_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year5_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year6_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year7_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year8_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year9_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year10_uacr_count | The count of UACR measurements in each of the follow-up years |
| egfr_year1_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year2_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year3_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year4_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year5_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year6_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year7_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year8_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year9_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year10_uacr_mean | The mean of UACR measurements in each of the follow-up years |
| egfr_year1_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year2_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year3_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year4_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year5_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year6_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year7_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year8_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year9_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year10_upcr_count | The count of UPCR measurements in each of the follow-up years |
| egfr_year1_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year2_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year3_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year4_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year5_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year6_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year7_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year8_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year9_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year10_upcr_mean | The mean of UPCR measurements in each of the follow-up years |
| egfr_year1_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year2_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year3_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year4_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year5_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year6_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year7_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year8_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year9_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year10_bp_count | The count of blood pressure measurements in each of the follow-up years |
| egfr_year1_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year2_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year3_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year4_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year5_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year6_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year7_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year8_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year9_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year10_sbp_mean | The mean of systolic blood pressure measurements in each of the follow-up years |
| egfr_year1_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year2_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year3_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year4_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year5_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year6_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year7_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year8_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year9_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year10_dbp_mean | The mean of diastolic blood pressure measurements in each of the follow-up years |
| egfr_year1_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year2_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year3_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year4_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year5_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year6_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year7_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year8_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year9_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year10_pp_mean | The mean of pulse pressure measurements in each of the follow-up years |
| egfr_year1_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year2_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year3_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year4_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year5_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year6_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year7_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year8_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year9_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year10_map_mean | The mean of mean arterial pressure measurements in each of the follow-up years |
| egfr_year1_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year2_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year3_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year4_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year5_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year6_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year7_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year8_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year9_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year10_av_count | The count of ambulatory visits in each of the follow-up years |
| egfr_year1_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year2_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year3_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year4_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year5_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year6_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year7_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year8_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year9_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year10_ipv_count | The count of inpatient visits in each of the follow-up years |
| egfr_year1_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year2_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year3_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year4_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year5_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year6_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year7_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year8_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year9_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year10_aceiarb_coverage | The number of days of ACEi/ARB coverage in each of the follow-up years |
| egfr_year1_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year2_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year3_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year4_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year5_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year6_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year7_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year8_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year9_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year10_sglt2_coverage | The number of days of SGLT2 coverage in each of the follow-up years |
| egfr_year1_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year2_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year3_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year4_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year5_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year6_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year7_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year8_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year9_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year10_nsaid_coverage | The number of days of NSAID coverage in each of the follow-up years |
| egfr_year1_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year2_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year3_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year4_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year5_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year6_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year7_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year8_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year9_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year10_ppi_coverage | The number of days of PPI coverage in each of the follow-up years |
| egfr_year1_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year2_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year3_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year4_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year5_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year6_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year7_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year8_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year9_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
| egfr_year10_contrast_count | The count of unique procedure dates billed using iodinated contrast dye, with a procedure date in each of the follow-up years |
registry2017.htn
Patients are identified as having hypertension (HTN) by one of two algorithms. 1) At least two vital sign measurements at least 14 days apart with a systolic blood pressure >= 140 mmHg or a diastolic blood pressure >= 90 mmHg, OR 2) At least one encounter (inpatient or outpatient) with an ICD-9 or ICD-10 diagnosis code indicating hypertension is present. This table includes 1,915,245 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| htn_entry_age | The age of the patient at first indication of HTN |
| htn_entry_period_bp_count | The count of blood pressure measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_sbp_mean | The mean of systolic blood pressure measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_dbp_mean | The mean of diastolic blood pressure measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_scr_count | The count of serum creatinine laboratory measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_egfr_mean | The mean of eGFR (CKD-EPI) measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_hba1c_count | The count of HbA1c measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_hba1c_mean | The mean of HbA1c measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_uacr_stage | The highest albuminuria stage based on all UACR measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
| htn_entry_period_upcr_stage | The highest proteinuria stage based on all UPCR measurements from the date of earliest identification of HTN until 90 days following the earliest date of identification of HTN |
registry2017.incident_ckd
All adult patients with an encounter in each time period of 2006-2007, 2008-2009, 2010-2011, 2012-2013, 2014-2015 and 2016-2017 were included. A surviving patient is represented in multiple time periods. This table includes 49,709,971 patients identified at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| age | The age of the patient at the start of the time period |
| gender | The sex of the patient with 1=male and 2=female |
| race_ethnicity | A coded value for race and ethnicity where race='White' and ethnicity='Not Latino' equals 1, otherwise 0 |
| historical_ckd_cureckd_flag | Once flagged as CKD by CURE-CKD definition all subsequent period historical flags are set |
| historical_ckd_kdigo_flag | Once flagged as CKD by KDIGO definition all subsequent period historical flags are set |
| dm_flag | Flagged if DM is identified in the time period |
| pdm_flag | Flagged if PDM is identified in the time period |
| htn_flag | Flagged if HTN is identified in the time period |
| time_period | The time period 2006-2007, 2008-2009, 2010-2011, 2012-2013, 2014-2015 and 2016-2017 |
| time_period_scr_count | The number of serum creatinine measurements in the time period |
| time_period_ckd_cureckd_flag | Identification of CKD in the time period by any two measurements at least 90 days apart (eGFR, UACR or UPCR) or a diagnosis for CKD |
| time_period_ckd_kdigo_flag | Identification of CKD in the time period by at least two impaired eGFR measurements 90 days apart, or two elevated UACR/UPCR measurements at least 90 days apart |
| time_period_followed | The number of years in the time period followed, either one or two years |
| year_start_followed | The first year of an encounter for the patient |
| year_end_followed | The last year of an encounter for the patient |
| year_death | The year of death if recorded |
registry2017.patient
This table includes 2,625,963 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| site_source | The EPIC instance from which the data was sourced with 1=UCLA, 2=PHS, 3=KHS and 4=SHS |
| site_source_cat | The categorization of the EPIC instance from which the data was sourced with 1=UCLA and 2=Providence |
| gender | Patient gender |
| gender_cat | Categorization of the patient gender with 1=male and 2=female |
| mapped_race | Patient race |
| mapped_ethnicity_view | Patient ethnicity |
| race_ethnicity_cat | The categorization of the patient race and ethnicity with 1A=White Non-Latino, 1B=White Latino, 2=Black, 3=Asian, 4=American Indian, 5=Hawaiian, 8=Other, 9=Multiple Races and -9=Not Categorized |
| rural_flag | Categorization of the patient zip code using RUCA Categorization C with 0=urban and 1=rural |
| state | The state of residence of the patient |
| country | The country of residence of the patient |
| vital_status_code | Vital status of the patient as of the extract of data from the EPIC source with 0=alive and 1=deceased |
registry2017.pdm
Patients are identified as having Pre-Diabetes Mellitus (PDM) by one of four algorithms. 1) At least one laboratory measurement of HbA1c greater than or equal to 5.7% and less than or equal to 6.4%, OR 2) At least two random blood glucose measurements between 140-199 mg/dL at least one day, but not more than two years apart, OR 3) At least two fasting blood glucose measurements between 100-125 mg/dL at least one day, but not more than two years apart, OR 4) At least one encounter (inpatient or outpatient) with an ICD-9 or ICD-10 diagnosis code indicating PDM. This table includes 1,026,629 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| pdm_incident_ckd_flag | An indication of CKD identified after the earliest date of PDM identification |
| pdm_incident_ckd_days | The number of days from earliest identification of PDM until the date of identification of CKD |
| pdm_incident_dm_flag | An indication of DM identified after the earliest date of PDM identification |
| pdm_incident_dm_days | The number of days from earliest identification of PDM until the date of identification of DM |
| pdm_incident_htn_flag | An indication of HTN identified after the earliest date of PDM identification |
| pdm_incident_htn_days | The number of days from earliest identification of PDM until the date of identification of HTN |
registry2017.pdm_entry
This table includes 1,026,629 patients identified Pre-Diabetes Mellitus (PDM) from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| pdm_entry_age | The age of the patient at the earliest identification of PDM |
| pdm_entry_ckd_flag | An indication if CKD was identified on or before the date of the earliest identification of PDM |
| pdm_entry_dm_flag | An indication if DM was identified on or before the date of the earliest identification of PDM |
| pdm_entry_htn_flag | An indication if HTN was identified on or before the date of the earliest identification of PDM |
| pdm_entry_hba1c_count | The count of HbA1c measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_hba1c_mean | The mean of HbA1c measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_scr_count | The count of serum creatinine (SCr) measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_egfr_mean | The mean of eGFR (CKD-EPI) measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_bp_count | The count of blood pressure measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_sbp_mean | The mean of systolic blood pressure measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_dbp_mean | The mean of diastolic blood pressure measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_pp_mean | The mean of pulse pressure measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_map_mean | The mean of mean arterial pressure measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_uacr_count | The count of UACR measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_uacr_stage | The highest albuminuria stage based on all UACR measurements from the date of earliest identification of PDM until 90 days following the earliest date of identification of PDM |
| pdm_entry_upcr_count | The count of UPCR measurements from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_upcr_stage | The highest proteinuria stage based on all UPCR measurements from the date of earliest identification of PDM until 90 days following the earliest date of identification of PDM |
| pdm_entry_av_count | The count of ambulatory visits (pcornet visit types of ‘AV’ and ‘ED’) from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_ipv_count | The count of inpatient visits (pcornet visit types of ‘IP' and ‘EI’) from the earliest date of PDM identification until 90 days following the earliest date of PDM identification |
| pdm_entry_aceiarb_flag | An indication of ACEi/ARB use on or before the date of the earliest date of PDM identification |
| pdm_entry_sglt2_flag | An indication of SGLT2 use on or before the date of the earliest date of PDM identification |
| pdm_entry_nsaid_flag | An indication of NSAID use on or before the date of the earliest date of PDM identification |
| pdm_entry_ppi_flag | An indication of PPI use on or before the date of the earliest date of PDM identification |
registry2017.registry_entry
All registry patients, identified by CKD, DM, PDM and/or HTN are included. This table includes 2,625,963 patients identified from 2006-2017 at both PSJH and UCLA.
| patient_id | A unique identifier for a patient, with no real-world meaning |
| registry_entry_age | The age of the patient at the earliest identification of CKD, DM, PDM or HTN (registry entry) |
| registry_entry_period_egfr_mean | The mean of all eGFR (CKD-EPI) measurements from registry entry until 90 days following registry entry |
| registry_entry_period_hba1c_mean | The mean of all HbA1c measurements from registry entry until 90 days following registry entry |
| registry_entry_period_sbp_mean | The mean of all systolic blood pressure measurements from registry entry until 90 days following registry entry |
| registry_entry_period_dbp_mean | The mean of all diastolic blood pressure measurements from registry entry until 90 days following registry entry |
| registry_entry_period_uacr_stage | The highest albuminuria stage based on all UACR measurements from registry entry until 90 days following registry entry |
| registry_entry_period_upcr_stage | The highest proteinuria stage based on all UPCR measurements from registry entry until 90 days following registry entry |
| registry_entry_acei_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_arb_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_dri_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_mra_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_diuretic_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_betablocker_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_ccb_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_alphablocker_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_centralsympatholytic_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_othervasodilator_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_insulin_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_sulfonylurea_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_metformin_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_tzd_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_dpp4_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_glp1_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_sglt2_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_statin_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_asa_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_otherantiplatelet_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_ppi_flag | A flag to indicate if medication information was present on or before the registry entry date |
| registry_entry_nsaid_flag | A flag to indicate if medication information was present on or before the registry entry date |
Schema
registry2017
V1.4 Release: 11/30/2019 populated with data from UCLA and Providence from 2006-2017