Object Description
One record per patient-period during which the patient met the criteria for CKD and stage could be determined.
Metadata
- Table Name: ursa.so_ursa_ckd_pat_004
- Layer: SYNTHETIC_OBJECT
- Object Type: Attribution Timeline
- Temporal Class: Interval (Timeline)
- Case ID: Patient ID
- Interval Start Date: Period Start Date
- Interval End Date: Period End Date
- Primary Key: Patient ID, Period Start Date, Period End Date
Published Fields
-
Data Model Keys
- Patient ID
-
Date Fields
- Period Start Date
- Period End Date
-
Diagnosis Fields
- Is CKD Stage 1
- Is CKD Stage 2
- Is CKD Stage 3
- Is CKD Stage 4
- Is CKD Stage 5
- Is ESRD
-
Validation Only Fields
- Is 2+ Codes This Stage
- Is Chronic Dialysis Patient
- Is CMS ESRD Status Patient
- Stage Token
Foreign Keys
- pat_id → ursa.no_ursa_core_pat_001.pat_id