Contents x
    [NO/URSA-CORE] Part C MOR Records
    • 28 Jun 2025
    • 12 Minutes to read
    • Print
    • Dark
      Light
    Contents

    [NO/URSA-CORE] Part C MOR Records

    • Updated on 28 Jun 2025
    • 12 Minutes to read
    • Print
    • Dark
      Light
    Article summary

    Object Description

    One record per MOR record for any Part C HCC/RAF model, including ESRD and PACE variants, covering model versions 21, 22, 24, and 28. Records represent the original grain size of the CMS Model Output Report file, i.e.: each covered month's results represent a snapshot of the model outputs from the latest RAS model run for that covered month, but without retroactive updates to prior covered months when the midyear run results are available, and with a single repetition of the December covered month record with the final run results when those become available.

    Metadata

    • Table Name: ursa.no_ursa_core_cond_010
    • Layer: NATURAL_OBJECT
    • Object Type: Single Stack
    • Case ID: Record ID
    • Primary Key: Record ID

    Published Fields

    • Data Model Keys

      • Record ID
      • 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)
      • Payor ID -- The identifier for the health insurance organization associated with the current record.
      • Plan ID -- The identifier for a particular health insurance plan product offered by a payor.
      • Source ID -- The identifier for the original source data system from which the current record originated.

    • Source Local Keys

      • Source Local Record ID -- The internal database identifier for the record in the source data system this record originated from.
      • Source Local Patient ID -- The internal database identifier for the patient in the source data system this record originated from. (See also [URSA-CORE] Patient)

    • Date Fields

      • Covered Month Start Date -- The start date (e.g., January 1, February 1, etc.) of the month in the patient's life described by the current record.
      • Covered Year Start Date
      • CMS MOR Run Date

    • Insurance Fields

      • Plan CMS Contract Number -- This variable is the unique identification for a managed care organization (MCO) enabling the entity to provide coverage to eligible Medicare beneficiaries. The first character of the contract ID is a letter that indicates the type of plan. For local managed care contracts, it begins with 'H' or '9'; for regional managed care contracts, it begins with 'R'; for prescription drug plans (PDPs), it begins with 'S'; for fallback contracts, it begins with 'F', for Employer-Direct PDP and Employer-Direct PFFS it begins with 'E'. The remaining 4 digits are numeric. It is a standard Ursa data modeling convention to use a combination of the CMS Contract Number and the CMS PBP (Plan Benefit Package) Number, when those two values are available, to generate the Plan ID. (See also [URSA-CORE] Plan ID)

    • Metadata Fields

      • Record Last Updated Datetime -- The date and time the current record was last updated in the original data source.
      • Source Data Effective Datetime -- The "as of" date and time of the original source data system at the moment the current record was extracted. For example, if a snapshot of the data in a production system is taken at 12:05 AM on the first of each month and used to generate a package of flat files that are eventually loaded into the Ursa Studio client database later that month, the Source Data Effective Datetime of all records in that month's package will be 12:05 AM on the first. Not to be confused with Record Last Updated Datetime. (See also [URSA-CORE] Record Last Updated Datetime)

    • Patient Fields

      • Patient MBI -- The patient's Medicare Beneficiary Identifier (MBI). On the Patients Natural Object, this reflects the most recent MBI known for the patient; on the Patient-Plan Timelines of Plan Membership Natural Object, this reflects the contemporaneous MBI during the respective timeline period.
      • Is Patient Sex Female -- Indicates the patient's sex is female. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the patient sex documented on that particular type of record in the source data.
      • Is Patient Sex Male -- Indicates the patient's sex is male. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the patient sex documented on that particular type of record in the source data.
      • Patient Date of Birth -- The patient's date of birth. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the date of birth found on that particular type of record in the source data.

    • HCC/RAF Fields

      • CMS MOR Record Type Code
      • CMS MOR Record Type Description
      • Is CMS MOR ESRD Record
      • Is CMS MOR PACE Record
      • Is CMS MOR Model Version 21
      • Is CMS MOR Model Version 22
      • Is CMS MOR Model Version 24
      • Is CMS MOR Model Version 28
      • Is CMS MOR Age Group Female 0 to 34
      • Is CMS MOR Age Group Female 35 to 44
      • Is CMS MOR Age Group Female 45 to 54
      • Is CMS MOR Age Group Female 55 to 59
      • Is CMS MOR Age Group Female 60 to 64
      • Is CMS MOR Age Group Female 65 to 69
      • Is CMS MOR Age Group Female 70 to 74
      • Is CMS MOR Age Group Female 75 to 79
      • Is CMS MOR Age Group Female 80 to 84
      • Is CMS MOR Age Group Female 85 to 89
      • Is CMS MOR Age Group Female 90 to 94
      • Is CMS MOR Age Group Female 95 and Greater
      • Is CMS MOR Age Group Male 0 to 34
      • Is CMS MOR Age Group Male 35 to 44
      • Is CMS MOR Age Group Male 45 to 54
      • Is CMS MOR Age Group Male 55 to 59
      • Is CMS MOR Age Group Male 60 to 64
      • Is CMS MOR Age Group Male 65 to 69
      • Is CMS MOR Age Group Male 70 to 74
      • Is CMS MOR Age Group Male 75 to 79
      • Is CMS MOR Age Group Male 80 to 84
      • Is CMS MOR Age Group Male 85 to 89
      • Is CMS MOR Age Group Male 90 to 94
      • Is CMS MOR Age Group Male 95 and Greater
      • Is CMS MOR Medicaid
      • Is CMS MOR Medicaid Female Disabled
      • Is CMS MOR Medicaid Female Aged
      • Is CMS MOR Medicaid Male Disabled
      • Is CMS MOR Medicaid Male Aged
      • Is CMS MOR Originally ESRD Female
      • Is CMS MOR Originally ESRD Male
      • Is CMS MOR Originally Disabled
      • Is CMS MOR Originally Disabled Female
      • Is CMS MOR Originally Disabled Male
      • CMS MOR Payment HCC Count
      • Is CMS MOR HCC 001
      • Is CMS MOR HCC 002
      • Is CMS MOR HCC 006
      • Is CMS MOR HCC 008
      • Is CMS MOR HCC 009
      • Is CMS MOR HCC 010
      • Is CMS MOR HCC 011
      • Is CMS MOR HCC 012
      • Is CMS MOR HCC 017
      • Is CMS MOR HCC 018
      • Is CMS MOR HCC 019
      • Is CMS MOR HCC 020
      • Is CMS MOR HCC 021
      • Is CMS MOR HCC 022
      • Is CMS MOR HCC 023
      • Is CMS MOR HCC 027
      • Is CMS MOR HCC 028
      • Is CMS MOR HCC 029
      • Is CMS MOR HCC 033
      • Is CMS MOR HCC 034
      • Is CMS MOR HCC 035
      • Is CMS MOR HCC 036
      • Is CMS MOR HCC 037
      • Is CMS MOR HCC 038
      • Is CMS MOR HCC 039
      • Is CMS MOR HCC 040
      • Is CMS MOR HCC 046
      • Is CMS MOR HCC 047
      • Is CMS MOR HCC 048
      • Is CMS MOR HCC 049
      • Is CMS MOR HCC 050
      • Is CMS MOR HCC 051
      • Is CMS MOR HCC 052
      • Is CMS MOR HCC 054
      • Is CMS MOR HCC 055
      • Is CMS MOR HCC 056
      • Is CMS MOR HCC 057
      • Is CMS MOR HCC 058
      • Is CMS MOR HCC 059
      • Is CMS MOR HCC 060
      • Is CMS MOR HCC 062
      • Is CMS MOR HCC 063
      • Is CMS MOR HCC 064
      • Is CMS MOR HCC 065
      • Is CMS MOR HCC 068
      • Is CMS MOR HCC 070
      • Is CMS MOR HCC 071
      • Is CMS MOR HCC 072
      • Is CMS MOR HCC 073
      • Is CMS MOR HCC 074
      • Is CMS MOR HCC 075
      • Is CMS MOR HCC 076
      • Is CMS MOR HCC 077
      • Is CMS MOR HCC 078
      • Is CMS MOR HCC 079
      • Is CMS MOR HCC 080
      • Is CMS MOR HCC 081
      • Is CMS MOR HCC 082
      • Is CMS MOR HCC 083
      • Is CMS MOR HCC 084
      • Is CMS MOR HCC 085
      • Is CMS MOR HCC 086
      • Is CMS MOR HCC 087
      • Is CMS MOR HCC 088
      • Is CMS MOR HCC 092
      • Is CMS MOR HCC 093
      • Is CMS MOR HCC 094
      • Is CMS MOR HCC 096
      • Is CMS MOR HCC 099
      • Is CMS MOR HCC 100
      • Is CMS MOR HCC 103
      • Is CMS MOR HCC 104
      • Is CMS MOR HCC 106
      • Is CMS MOR HCC 107
      • Is CMS MOR HCC 108
      • Is CMS MOR HCC 109
      • Is CMS MOR HCC 110
      • Is CMS MOR HCC 111
      • Is CMS MOR HCC 112
      • Is CMS MOR HCC 114
      • Is CMS MOR HCC 115
      • Is CMS MOR HCC 122
      • Is CMS MOR HCC 124
      • Is CMS MOR HCC 125
      • Is CMS MOR HCC 126
      • Is CMS MOR HCC 127
      • Is CMS MOR HCC 134
      • Is CMS MOR HCC 135
      • Is CMS MOR HCC 136
      • Is CMS MOR HCC 137
      • Is CMS MOR HCC 138
      • Is CMS MOR HCC 139
      • Is CMS MOR HCC 140
      • Is CMS MOR HCC 141
      • Is CMS MOR HCC 151
      • Is CMS MOR HCC 152
      • Is CMS MOR HCC 153
      • Is CMS MOR HCC 154
      • Is CMS MOR HCC 155
      • Is CMS MOR HCC 157
      • Is CMS MOR HCC 158
      • Is CMS MOR HCC 159
      • Is CMS MOR HCC 160
      • Is CMS MOR HCC 161
      • Is CMS MOR HCC 162
      • Is CMS MOR HCC 166
      • Is CMS MOR HCC 167
      • Is CMS MOR HCC 169
      • Is CMS MOR HCC 170
      • Is CMS MOR HCC 173
      • Is CMS MOR HCC 176
      • Is CMS MOR HCC 180
      • Is CMS MOR HCC 181
      • Is CMS MOR HCC 182
      • Is CMS MOR HCC 186
      • Is CMS MOR HCC 188
      • Is CMS MOR HCC 189
      • Is CMS MOR HCC 190
      • Is CMS MOR HCC 191
      • Is CMS MOR HCC 192
      • Is CMS MOR HCC 193
      • Is CMS MOR HCC 195
      • Is CMS MOR HCC 196
      • Is CMS MOR HCC 197
      • Is CMS MOR HCC 198
      • Is CMS MOR HCC 199
      • Is CMS MOR HCC 200
      • Is CMS MOR HCC 201
      • Is CMS MOR HCC 202
      • Is CMS MOR HCC 211
      • Is CMS MOR HCC 212
      • Is CMS MOR HCC 213
      • Is CMS MOR HCC 221
      • Is CMS MOR HCC 222
      • Is CMS MOR HCC 223
      • Is CMS MOR HCC 224
      • Is CMS MOR HCC 225
      • Is CMS MOR HCC 226
      • Is CMS MOR HCC 227
      • Is CMS MOR HCC 228
      • Is CMS MOR HCC 229
      • Is CMS MOR HCC 238
      • Is CMS MOR HCC 248
      • Is CMS MOR HCC 249
      • Is CMS MOR HCC 253
      • Is CMS MOR HCC 254
      • Is CMS MOR HCC 263
      • Is CMS MOR HCC 264
      • Is CMS MOR HCC 267
      • Is CMS MOR HCC 276
      • Is CMS MOR HCC 277
      • Is CMS MOR HCC 278
      • Is CMS MOR HCC 279
      • Is CMS MOR HCC 280
      • Is CMS MOR HCC 282
      • Is CMS MOR HCC 283
      • Is CMS MOR HCC 298
      • Is CMS MOR HCC 300
      • Is CMS MOR HCC 326
      • Is CMS MOR HCC 327
      • Is CMS MOR HCC 328
      • Is CMS MOR HCC 329
      • Is CMS MOR HCC 379
      • Is CMS MOR HCC 380
      • Is CMS MOR HCC 381
      • Is CMS MOR HCC 382
      • Is CMS MOR HCC 383
      • Is CMS MOR HCC 385
      • Is CMS MOR HCC 387
      • Is CMS MOR HCC 397
      • Is CMS MOR HCC 398
      • Is CMS MOR HCC 399
      • Is CMS MOR HCC 401
      • Is CMS MOR HCC 402
      • Is CMS MOR HCC 405
      • Is CMS MOR HCC 409
      • Is CMS MOR HCC 454
      • Is CMS MOR HCC 463
      • Is CMS MOR Cancer and Immune Disorders
      • Is CMS MOR CHF and COPD
      • Is CMS MOR Heart Failure and Chronic Lung Disorder
      • Is CMS MOR CHF and Renal
      • Is CMS MOR Heart Failure and Kidney
      • Is CMS MOR COPD and Cardiorespiratory Failure
      • Is CMS MOR Chronic Lung Disorder and Cardiorespiratory Failure
      • Is CMS MOR Diabetes and CHF
      • Is CMS MOR Diabetes and Heart Failure
      • Is CMS MOR CHF and Specified Heart Arrhythmias
      • Is CMS MOR Heart Failure and Specified Heart Arrhythmias
      • Is CMS MOR Sepsis and Cardiorespiratory Failure
      • Is CMS MOR Artificial Openings and Pressure Ulcer
      • Is CMS MOR Aspiration and Specified Bacterial Pneumonias and Pressure Ulcer
      • Is CMS MOR COPD and Aspiration and Specified Bacterial Pneumonias
      • Is CMS MOR Schizophrenia and CHF
      • Is CMS MOR Schizophrenia and COPD
      • Is CMS MOR Schizophrenia and Seizures
      • Is CMS MOR Sepsis and Artificial Openings
      • Is CMS MOR Sepsis and Aspiration and Specified Bacterial Pneumonias
      • Is CMS MOR Sepsis and Pressure Ulcer
      • Is CMS MOR Substance Use Disorder and Psychiatric
      • Is CMS MOR Disabled and HCC 006
      • Is CMS MOR Disabled and HCC 034
      • Is CMS MOR Disabled and HCC 039
      • Is CMS MOR Disabled and HCC 046
      • Is CMS MOR Disabled and HCC 054
      • Is CMS MOR Disabled and HCC 055
      • Is CMS MOR Disabled and HCC 077
      • Is CMS MOR Disabled and HCC 085
      • Is CMS MOR Disabled and HCC 110
      • Is CMS MOR Disabled and HCC 161
      • Is CMS MOR Disabled and HCC 176
      • Is CMS MOR Disabled and Pressure Ulcer
      • Is CMS MOR Disabled and Substance Use Disorder and Psychiatric
      • Is CMS MOR Disabled and Heart Failure
      • Is CMS MOR Disabled and Skin Ulcer
      • Is CMS MOR Disabled and Cancer
      • Is CMS MOR Disabled and Neurological
      • Is CMS MOR Disabled and Chronic Lung Disorder

    Foreign Keys

    • pat_id → ursa.no_ursa_core_pat_001.pat_id

    Dedicated Precursors

    • [NO/URSA-CORE] Part C MOR Records, Precursor 1 (All Source Records): One record per MOR record for any Part C HCC/RAF model, including ESRD and PACE variants, covering model versions 21, 22, 24, and 28. Records represent the original grain size of the CMS Model Output Report file, i.e.: each covered month's results represent a snapshot of the model outputs from the latest RAS model run for that covered month, but without retroactive updates to prior covered months when the midyear run results are available, and with a single repetition of the December covered month record with the final run results when those become available.
    Was this article helpful?
    What's Next