Object Description
None
Metadata
- Table Name: ursa.so_ursa_ckd_meds_008
- Layer: SYNTHETIC_OBJECT
- Object Type: Single Stack
- Case ID: Patient ID, Period Start Date
- Primary Key: Patient ID, Period Start Date
Published Fields
-
Data Model Keys
- Patient ID -- The internal database identifier (used, e.g., for joins and primary keys) for the patient. This value is typically mastered, i.e., all records for the same patient, regardless of the source data system from which that record originated, should have the same Patient ID value. (Note that while the mastered Patient ID value might resemble a local identifier used in one of the upstream data sources, this does not indicate any special priority of that source system in determining the characteristics of the patient.) (See also [URSA-CORE] Patient)
- Period Start Date -- The date identifying the start of a period of time. Period Start Date values are inclusive; e.g., a period with Period Start Date = January 1 would begin be considered to begin at 00:00 on January 1.
- Period End Date -- The date identifying the end of an period of time. Period End Date values are exclusive; e.g., a period with Period End Date = January 1 would begin be considered to end at precisely 00:00 on January 1 (meaning that the period did not include any time on January 1).
-
Date Fields
- Current Continuous Primary Payor Membership Episode Start Date -- The start date of the Continuous Primary Payor Membership Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Primary Payor Membership Episode)
- Current Continuous Primary Payor Membership Episode End Date -- The end date of the Continuous Primary Payor Membership Episode in effect as of the (potentially historical) period covered by the record. Values follow the standard exclusive convention for Period End Dates. (See also [URSA-CORE] Continuous Primary Payor Membership Episode, [URSA-CORE] Period End Date)
-
Encounter Fields
- Is Candidate PDC Denominator Period
- Is Ursa Encounter Type SNF Encounter
- Is Ursa Encounter Type Hospital Inpatient Admission
-
Medication Fields
- Is CKD ACE/ARB In-Supply Period
- Is CKD Ace Inhibitors In-Supply Period
- Is CKD ARB In-Supply Period
- Is CKD SGLT2 In-Supply Period
- Is CKD nsMRA In-Supply Period
- Is CKD Statin In-Supply Period