Natural Objects

Object Description One record per institutional claim ICD-9-CM or ICD-10-CM discharge diagnosis code. Metadata Table Name : ursa.no_ursa_core_cond_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case...

Object Description One record per non-reversed institutional claim service line item; includes denied line items. Metadata Table Name : ursa.no_ursa_core_fin_002 Layer : Natural Object Object Type : Single Stack Temporal Class : Ev...

Object Description One record per diagnosis (expressed as ICD-9-CM and/or ICD-10-CM code) associated with a professional claim service line item. Metadata Table Name : ursa.no_ursa_core_cond_002 Layer : Natural Object Object Type : Si...

Object Description One record per institutional bill ICD-9-CM or ICD-10-CM discharge diagnosis code. Metadata Table Name : ursa.no_ursa_core_cond_003 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ...

Object Description One record per diagnosis (expressed as ICD-9-CM and/or ICD-10-CM code) associated with a professional bill service line item. Metadata Table Name : ursa.no_ursa_core_cond_004 Layer : Natural Object Object Type : Sin...

Object Description One record per diagnosis associated with an EMR encounter; includes reason for visit; does not include problem list entries added or edited during an encounter. Metadata Table Name : ursa.no_ursa_core_cond_005 Layer : ...

Object Description One record per problem list entry. Metadata Table Name : ursa.no_ursa_core_cond_006 Layer : Natural Object Object Type : Single Stack Temporal Class : Interval Case ID : Problem List Entry ID Interval Start...

Object Description One record per allergy / intolerance list entry. Metadata Table Name : ursa.no_ursa_core_cond_007 Layer : Natural Object Object Type : Single Stack Temporal Class : Interval Case ID : Allergy / Intolerance Lis...

Object Description One record per EMR encounter from a clinical (non-claims) data source; includes lookups. Metadata Table Name : ursa.no_ursa_core_enc_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Event ...

Object Description One record per instance of a service rendered to a patient during an EMR encounter. Metadata Table Name : ursa.no_ursa_core_enc_002 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case...

Object Description One record per non-deleted appointment record. Metadata Table Name : ursa.no_ursa_core_enc_003 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Appointment ID Event Date : ...

Object Description One record per period of time that is, was, or has some future potential to be available for booking an appointment for an encounter. Multiple appointment slots can be assigned to a single appointment; but the converse is not tr...

Object Description One record per non-reversed institutional claim header; includes denied claims. Metadata Table Name : ursa.no_ursa_core_fin_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID ...

Object Description One record per non-reversed professional claim service line item; includes denied line items; includes header-level fields. Metadata Table Name : ursa.no_ursa_core_fin_003 Layer : Natural Object Object Type : Single...

Object Description One row per non-reversed pharmacy claim; includes denied claims. Metadata Table Name : ursa.no_ursa_core_fin_004 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Claim ID E...

Object Description One record per patient-plan timeline period in which the patient had an active membership in the plan; overlapping periods are reconciled to eliminate overlapping periods, with precedence given to the period with the more recent...

Object Description One record per institutional bill header. Metadata Table Name : ursa.no_ursa_core_fin_011 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Bill ID Event Date : Bill Covered...

Object Description One record per institutional bill service line item. Metadata Table Name : ursa.no_ursa_core_fin_012 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Bill Service Line Item ID...

Object Description One record per non-reversed professional bill service line item; includes denied line items; includes header-level fields. Metadata Table Name : ursa.no_ursa_core_fin_013 Layer : Natural Object Object Type : Single ...

Object Description One record per billing transaction detail item; typically used to capture claim adjustment reason codes (CARCs) and remittance advice remark codes (RARCs). Metadata Table Name : ursa.no_ursa_core_fin_017 Layer : Natura...

Object Description One record per billing transaction; includes both billing header- and line-item-level transactions, for both professional and institutional billing. Metadata Table Name : ursa.no_ursa_core_fin_016 Layer : Natural Objec...

Object Description One record per patient timeline period of continuous CMS LISHIST Low Income status. Metadata Table Name : ursa.no_ursa_core_fin_025 Layer : NATURAL_OBJECT Object Type : Single Stack Temporal Class : Interval (Tim...

Object Description One record per capitation financial transaction record; includes records representing increases or decreases to account balances related to revenue, expenses, or other financial considerations associated with a capitation contra...

Object Description One record per member-month in a capitation member summary report from any data source. Values represent the final action status of the member-month net of all report updates received over time. Metadata Table Name : ursa...

Object Description One record per claim transaction detail item; typically used to capture claim adjustment reason codes (CARCs) and remittance advice remark codes (RARCs). Metadata Table Name : ursa.no_ursa_core_fin_007 Layer : NATURAL_...

Object Description One record per claim transaction; includes both claim header- and line-item-level transactions, for professional, institutional, and pharmacy claims. Metadata Table Name : ursa.no_ursa_core_fin_006 Layer : NATURAL_OBJE...

Object Description One record per medication. Metadata Table Name : ursa.no_ursa_core_meds_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Medication ID Primary Key : Medication ID ...

Object Description One record per medication order. Metadata Table Name : ursa.no_ursa_core_meds_002 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Medication Order ID Event Date : Ordered ...

Object Description One record per medication dispense; includes information about medication administrations that occur contemporaneous to when the medication is dispensed. Metadata Table Name : ursa.no_ursa_core_meds_004 Layer : NATURAL...

Object Description One record per medication list entry. Metadata Table Name : ursa.no_ursa_core_meds_003 Layer : Natural Object Object Type : Single Stack Temporal Class : Interval Case ID : Medication List Entry ID Interval...

Object Description One record per clinical note; excludes deleted notes. Metadata Table Name : ursa.no_ursa_core_note_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Clinical Note ID Eve...

Object Description One record per task. Metadata Table Name : ursa.no_ursa_core_ops_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Task ID Event Date : Task Completed Date Primary Ke...

Object Description One record per patient. Metadata Table Name : ursa.no_ursa_core_pat_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Patient ID Primary Key : Patient ID Relational...

Object Description One record per patient-source timeline period during which at least one of the flagged data types for that patient would be included in the imported files from that data source if such records existed. NB: Input data to this obj...

Object Description One record per patient observation, including lab results, patient questionnaires, imaging studies, etc. Metadata Table Name : ursa.no_ursa_core_pat_003 Layer : Natural Object Object Type : Single Stack Temporal ...

Object Description One record per observation report. Metadata Table Name : ursa.no_ursa_core_pat_004 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Observation Report ID Event Date : Repor...

Object Description One record per instance of a communication between a provider and a patient; communication instances can also have children instances, representing discrete messages or parts of the parent communication. Excludes deleted records...

Object Description One record per patient timeline period in which a targeted time-varying patient feature is known. Metadata Table Name : ursa.no_ursa_core_pat_010 Layer : Natural Object Object Type : Complex Timeline Temporal Cla...

Object Description One record per timeline period of affiliation between a patient and a program entity. Metadata Table Name : ursa.no_ursa_core_pat_011 Layer : Natural Object Object Type : Simple Timeline Temporal Class : Interval...

Object Description One record per institutional claim ICD-9-CM or ICD-10-PCS procedure code. Metadata Table Name : ursa.no_ursa_core_proc_001 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Cla...

Object Description One record per institutional bill ICD-9-CM or ICD-10-PCS procedure code. Metadata Table Name : ursa.no_ursa_core_proc_002 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Bill...

Object Description One record per service. Metadata Table Name : ursa.no_ursa_core_proc_003 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Service ID Primary Key : Service ID Relationa...

Object Description One record per service order. Metadata Table Name : ursa.no_ursa_core_proc_004 Layer : Natural Object Object Type : Single Stack Temporal Class : Event Case ID : Service Order ID Event Date : Ordered Date ...

Object Description One record per individual or organization provider; includes provider organization staff that are only indirectly involved in the provision of care to patients, such as receptionists, back office staff, and technology profession...

Object Description One record per specialty associated with a provider as defined and documented by the source organization; i.e., does not include specialty data tracked solely at the national level via NPPES. Metadata Table Name : ursa.no...

Object Description One record per license, certification, educational, or other credential associated with a provider earned by a provider. Metadata Table Name : ursa.no_ursa_core_prov_004 Layer : Natural Object Object Type : Single S...

Object Description One record per provider contract record. Metadata Table Name : ursa.no_ursa_core_fin_008 Layer : NATURAL_OBJECT Object Type : Single Stack Temporal Class : Interval Case ID : Provider Contract ID Interval S...

Object Description One record per provider - provider group affiliation timeline period during which the provider was an active provider in the provider group. Providers may have multiple concurrent affiliations with different provider groups. M...

Object Description One record per provider - health system affiliation timeline period during which the provider was affiliated with the health system. Providers may have multiple concurrent affiliations with different health systems. Metadata ...

Object Description One record per provider - program entity affiliation timeline period during which the provider was affiliated with the program entity. Providers may have multiple concurrent affiliations with different program entities. Metada...

Object Description One record per health system. Metadata Table Name : ursa.no_ursa_core_struct_002 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Health System ID Primary Key : Health Sys...

Object Description One record per program entity. Metadata Table Name : ursa.no_ursa_core_struct_003 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Program Entity ID Primary Key : Program ...

Object Description One record per payor organization. Metadata Table Name : ursa.no_ursa_core_struct_004 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Payor ID Primary Key : Payor ID ...

Object Description One record per health plan. Metadata Table Name : ursa.no_ursa_core_struct_005 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Plan ID Primary Key : Plan ID Relationa...

Object Description One record per location. Metadata Table Name : ursa.no_ursa_core_struct_010 Layer : Natural Object Object Type : Single Stack Temporal Class : Entity Case ID : Location ID Primary Key : Location ID Rela...

Object Description One record per final action MAO-004 diagnosis code obtained from the reconciliation of MAO-004 (or commercial MA plan equivalent) data to final action status. Metadata Table Name : ursa.no_ursa_core_cond_008 Layer : NA...

Object Description One record per MAO-004 diagnosis transaction record (equivalent to a distinct MAO-004 encounter-diagnosis pair) obtained from MAO-004 (or commercial MA plan equivalent) data. Metadata Table Name : ursa.no_ursa_core_cond_0...

Object Description One record per member-month transaction obtained from assigning payments or adjustments from MMR (or commercial plan equivalent) data to discrete months. Records in this object represent the transactional data used to produce th...

Object Description One record per distinct member-month obtained from the reconciliation of MMR (or commercial MA plan equivalent) data to final action status. Excludes disenrolled member-months. Metadata Table Name : ursa.no_ursa_core_fin_...

Object Description One record per record containing pre-calculated measure results received from an upstream data source. Metadata Table Name : ursa.no_ursa_core_ops_011 Layer : Natural Object Object Type : Single Stack Case ID : M...