Contents x
    [NO/URSA-CORE] MMR Member-Month Transactions
    • 28 Jun 2025
    • 33 Minutes to read
    • Print
    • Dark
      Light
    Contents

    [NO/URSA-CORE] MMR Member-Month Transactions

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

    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 the "final action" records in the MMR Member-Months natural object.

    Metadata

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

    Published Fields

    • Data Model Keys

      • Transaction ID -- The internal database identifier (used, e.g., for joins and primary keys) for the transaction. (See also [URSA-CORE] Claim or Billing Transaction)
      • 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 Transaction ID -- The internal database identifier for the transaction in the source data system this record originated from. (See also [URSA-CORE] Claim or Billing Transaction)
      • 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)
      • Source Local Payor ID -- The identifier for the payor organization in the original source data system.
      • Source Local Plan ID -- The identifier for the health plan in the original source data system.

    • Operations Support Fields

      • Original CMS MMR Payment or Adjustment Start Date -- The start date of the period in the patient's life covered by the contents of the original MMR record prior to being reshaped into records with member-month grain. This field contains the same values as the CMS MMR "Payment/Adjustment Start Date" field, which the CMS documentation defines as: "Earliest date covered by this payment or adjustment".
      • Original CMS MMR Payment or Adjustment End Date -- The end date of the period in the patient's life covered by the contents of the original MMR record prior to being reshaped into records with member-month grain. This field is based on the CMS MMR "Payment/Adjustment End Date" field, which the CMS documentation defines as: "Latest date covered by this payment or adjustment". (This field uses the standard Ursa Health exclusive convention for period end dates; i.e., this field will take the value one day after the original CMS value.)
      • Original CMS MMR Number of Payment or Adjustment Months Part A -- The count of Part A months in the patient's life covered by the contents of the original MMR record (prior to being reshaped into member-month grain). This field contains the same values as the CMS MMR "Number of Payment/Adjustment Months Part A" field, which the CMS documentation defines as: "Number of months included in this payment or adjustment for Part A".
      • Original CMS MMR Number of Payment or Adjustment Months Part B -- The count of Part B months in the patient's life covered by the contents of the original MMR record (prior to being reshaped into member-month grain). This field contains the same values as the CMS MMR "Number of Payment/Adjustment Months Part B" field, which the CMS documentation defines as: "Number of months included in this payment or adjustment for Part B".
      • Original CMS MMR Number of Payment or Adjustment Months Part D -- The count of Part D months in the patient's life covered by the contents of the original MMR record (prior to being reshaped into member-month grain). This field contains the same values as the CMS MMR "Number of Payment/Adjustment Months Part D" field, which the CMS documentation defines as: "Number of months included in this payment or adjustment for Part D".
      • CMS MMR Adjustment Reason Code -- The standard 2-digit Adjustment Reason Code (ARC) developed and maintained by CMS, and used to identify the reason for a revision to a patient's MMR information; e.g., 01 = Notification of Death of Beneficiary; 02 = Retroactive Enrollment; etc. This field contains the same values as the CMS MMR "Adjustment Reason Code (ARC)" field, which the CMS documentation defines as: "This is populated with a valid ARC for adjustments. For prospective payment components, it is populated with 00".
      • Is Disenrollment Transaction -- Indicates the transaction effects the disenrollment of the patient from the plan identified on the record.
      • CMS MMR Cleanup ID -- This field contains the same values as the CMS MMR "Cleanup ID" field, which the CMS documentation defines as: "The Cleanup ID field is used in the event of a cleanup or a RAS overpayment run. It is used to uniquely identify the cleanup with which the record is associated. It is usually the Ticket number for the cleanup or overpayment run. The field will be blank when the record reports: A prospective payment; A non-cleanup adjustment; Any payment or adjustment prior to August 2011".

    • Patient Fields

      • 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.
      • 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.

    • 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.
      • CMS MMR Payment Date -- The monthly period, expressed as text in YYYYMM format, in which any new or updated financial calculations in the current MMR record actually contributed to the amount paid by CMS to the Medicare Advantage organization. This field contains the same values as the CMS MMR "Payment Date" field, which the CMS documentation defines as: "Payment month for the report (YYYYMM)" (Note that we use the word "date" in the field name here -- even though the field does not, strictly speaking, contain a date -- for consistency with the official MMR field name.) (See also [URSA-CORE] Covered Month Start Date)
      • CMS MMR Run Date -- The date on which the contents of the current MMR record were generated from the original CMS source data. This field contains the same values as the CMS MMR "Run Date" field, which the CMS documentation defines as: "Date the file was produced"

    • 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)
      • Plan CMS PBP Number -- The standard 3-digit Plan Benefit Package (PBP) Number, maintained by CMS, identifying a particular insurance product offered by a given Medicare Advantage organization (identified by the CMS Contract Number). It is a standard Ursa data modeling convention to use a combination of the CMS Contract Number and the CMS PBP Number, when those two values are available, to generate the Plan ID. (See also [URSA-CORE] Plan ID, [URSA-CORE] Plan CMS Contract Number)
      • Plan CMS Segment Number -- The standard 3-digit numeric value, maintained by CMS, that identifies distinct groups of Medicare Advantage beneficiaries (with, potentially, distinct benefits from other segments) within a CMS Contract Number and CMS PBP Number. (For Medicare Advantage plans, it is a standard Ursa Health convention to define a plan as a distinct CMS Contract Number - CMS PBP Number - CMS Segment Number triples when those values are available.) (See also [URSA-CORE] Plan CMS Contract Number, [URSA-CORE] Plan CMS PBP Number)
      • Is CMS Part A Entitlement -- Indicates the patient is entitled to Medicare Part A as determined by CMS. This field reflects the values of the CMS MMR "Part A Entitlement" field, which the CMS documentation defines as: "Indicator that the beneficiary is entitled to Part A".
      • Is CMS Part B Entitlement -- Indicates the patient is entitled to Medicare Part B as determined by CMS. This field reflects the values of the CMS MMR "Part B Entitlement" field, which the CMS documentation defines as: "Indicator that the beneficiary is entitled to Part B".
      • Is CMS Hospice Status -- Indicates the patient is considered to be Hospice status.
      • CMS MMR Part A RAF Score -- This field contains the same values as the CMS MMR "Risk Adjustment Factor A" field, which the CMS documentation defines as: "Part A Risk Adjustment Factor used for the Payment Calculation".
      • CMS MMR Part B RAF Score -- This field contains the same values as the CMS MMR "Risk Adjustment Factor B" field, which the CMS documentation defines as: "Part B Risk Adjustment Factor used for the Payment Calculation".
      • CMS MMR Part D RAF Score -- This field contains the same values as the CMS MMR "Risk Adjustment Factor D" field, which the CMS documentation defines as: "Part D Risk Adjustment Factor used for the Payment Calculation".
      • CMS RAF Type Code -- The standard 1- or 2-character CMS Part C Risk Adjustment Factor Type Code; e.g., E = New Enrollee, I = Institutional, D = Dialysis (ESRD), CF = Community Full Dual, CP = Community Partial Dual, CN = Community Non-Dual, etc.
      • Is CMS ESRD Status -- Indicates the patient meets the Medicare ESRD eligibility criterion as of a particular date; can be derived from the CMS Medicare Beneficiary Status Code. (See also [URSA-CORE] CMS Medicare Beneficiary Status Code)
      • Is CMS LTI Status -- Indicates the patient meets the CMS criteria to be considered a Long-Term Institutional (LTI) patient. Among other potential uses, this status is used in the calculation of RAF scores.
      • CMS Original Reason for Entitlement Code -- The standard CMS 1-digit code, commonly abbreviated OREC, identifying the original reason the patient was entitled to Medicare; 0 = Old Age and Survivor's Insurance, 1 = Disability Insurance Benefit, 2 = ESRD, 3 = Both Disability and ESRD, 9 = None of the Above.
      • CMS Dual Status Code -- The standard 2-character CMS Dual Status Code, which identifies the patient's most recent entitlement status for Medicaid and other qualifying non-Medicare programs; e.g., 01 = QMB only, 02 = QMB + full Medicaid, etc.
      • CMS MMR State and County Code -- This field contains the same values as the CMS MMR "State & County Code" field, which the CMS documentation defines as: "Beneficiary State and County Code".
      • Is CMS MMR Out of Area Indicator -- Indicates the patient meets the CMS Out of Area definition for the given month. This field reflects the values of the CMS MMR "Out of Area Indicator" field, which the CMS documentation defines as: "Indicator that the beneficiary is Out of Area for the Plan".
      • Is CMS MMR Aged or Disabled MSP -- Indicates the patient meets the CMS definition of Medicare Secondary Payer (MSP). This field reflects the values of the CMS MMR "Aged/Disabled MSP" field, which the CMS documentation defines as: "Indicator that Medicare is Secondary Payer".
      • Is CMS MMR New Medicare Beneficiary Medicaid Status Flag -- Indicates whether the new Medicare beneficiary is also eligible for Medicaid. This field reflects the values of the CMS MMR "New Medicare Beneficiary Medicaid Status Flag" field, which the CMS documentation defines as: "Beneficiary Medicaid Status used for the month being paid or adjusted"; 1 = "Medicaid and a default risk factor was used"; 0 = "Not Medicaid and a default risk factor was used"; NULL = "No default risk factor or beneficiary is Part D only".
      • Is CMS MMR Medicaid Add-On Factor -- Indicates whether an additional adjustment factor has been used to calculate payments for Medicare beneficiaries that are also eligible for Medicaid. This field reflects the values of the CMS MMR "Medicaid Add-on Factor Indicator" field, which the CMS documentation defines as: "Indicator that the Medicaid Add-on factor was used for this payment or adjustment for a beneficiary: Before 2023, this field indicates when the Medicaid Add-on factor was used for: PACE; ESRD; or LTI risk scores. After 2023, this field indicates when the Medicaid Add-on factor was used for: PACE ESRD; or any beneficiary who is in LTI status, enrolled in any plan"; with 1 = "A RASS supplied Medicaid add-on factor is used in the payment"; and 0 = "No Medicaid Add-on was used".
      • CMS MMR Default Risk Factor Code -- This field contains the same values as the CMS MMR "Default Risk Factor Code" field, which the CMS documentation defines as: "Indicator that a Default Risk Adjustment Factor (RAF) was used for calculating this payment or adjustment. A Default Risk Adjustment Factor (score) is used only if the RASS system did not provide MARx risk scores for this beneficiary. In these cases MARx assigns a default score based upon 'demographics' of the beneficiary. 1 = Default Enrollee - Aged/Disabled; 2 = Default Enrollee - ESRD dialysis; 3 = Default Enrollee - ESRD Kidney Transplant - Month 1; 4 = Default Enrollee - ESRD Kidney Transplant - Months 2-3; 5 = Default Enrollee - ESRD Post Graft - Months 4-9; 6 = Default Enrollee - ESRD Post Graft - 10+ Months; 7 = Default Enrollee Chronic Care SNP".
      • CMS MMR ESRD MSP Code -- This field contains the same values as the CMS MMR "ESRD MSP Flag" field, which the CMS documentation defines as: "Indicator that Medicare is a Secondary Payer due to ESRD. As of January 2011: T = MSP due to Transplant/Dialysis; P = MSP due to Post Graft"; with NULL = "ESRD MSP not applicable".
      • Is CMS MMR Full or Partial Medicaid Status -- Indicates whether CMS considers the Medicare beneficiary to be a Medicaid patient (either full or partial). This field reflects the values of the CMS MMR "Medicaid Full/Partial/Nondual" field, which the CMS documentation defines as: "The Medicaid status that is in effect for the month used to determine the appropriate: Non-ESRD community (enrollees in MAOs or PACE organizations) or ESRD risk factor for a beneficiary (MAOs only; not applicable for beneficiaries enrolled in a PACE organization with ESRD status). (Medicaid status = Current Payment Month (CPM) minus 3 months). For all other risk factors, this field is informational. 1 = Beneficiary is determined to be full or partial Medicaid (F or P); 0 = Beneficiary is not Medicaid (N)"; with NULL = "This is a retroactive adjustment for a month prior to January 2017".
      • CMS MMR Risk Adjustment Age Group Code -- That standard 4-digit CMS Risk Adjustment Age Group (RAAG) Code, describing the age category of the patient as used to calculate RAF scores. This field contains the same values as the CMS MMR "Risk Adjustment Age Group (RAAG)" field, which the CMS documentation defines as: "The Risk Adjustment Age Group for the beneficiary (BBEE). In general it is based upon the age as of February 1 of payment year. BB = Beginning Age; EE = Ending Age".
      • Is CMS MMR Frailty Factor -- Indicates whether an additional adjustment factor related to the patient's frailty status has been used to calculate payments. This field reflects the values of the CMS MMR "Frailty Indicator (PACE/FIDE SNP only)" field, which the CMS documentation defines as: "Indicator that a Plan-level Frailty Factor was included in the calculation of the payment or adjustment. Y = Frailty Factor Included; N = No Frailty Factor".
      • Is Plan CMS Employer Group Health Plan -- Indicates that the beneficiary's plan meets the CMS definition of an Employer Group Health Plan (EGHP). This field reflects the values of the CMS MMR "EGHP Flag" field, which the CMS documentation defines as: "Indicator that the Plan is an Employer Group Health Plan"; with 1 = "Employer Group Health Plan"; 0 = "Not an Employer Group Health Plan".
      • CMS Part D RAF Type Code -- The standard 2-character CMS Part D Risk Adjustment Factor (RAF) Type code; e.g., D1 = Community Non-Low Income Continuing Enrollee, D2 = Community Low Income Continuing Enrollee, etc.
      • CMS Part D Default Risk Factor Code -- This field contains the same values as the CMS MMR "Part D Default Risk Factor Code" field, which the CMS documentation defines as: "The code that indicates the type of Part D Default Risk Factor for beneficiaries with less than 12 months of Medicare Part A entitlement: 1 = Not ESRD, Not Low Income, Not Originally Disabled; 2 = Not ESRD, Not Low Income, Originally Disabled; 3 = Not ESRD, Low Income, Not Originally Disabled; 4 = Not ESRD, Low Income, Originally Disabled; 5 = ESRD, Not Low Income, Not Originally Disabled; 6 = ESRD, Low Income, Not Originally Disabled; 7 = ESRD, Not Low Income, Originally Disabled; 8 = ESRD, Low Income, Originally Disabled Spaces = Not applicable"; with NULL = "Not applicable".
      • Is CMS MMR Part D Low-Income Status -- Indicates whether CMS considers the Medicare beneficiary to be low income status for the purpose of applying the Part D Low-Income Multiplier to the payment or adjustment amount. This field reflects the values of the CMS MMR "Part D Low-Income Indicator" field, which the CMS documentation defines as: "Indicator of beneficiary’s Low Income status for the Part D payment or adjustment. Calculations for a Low Income beneficiary include a Part D Low-Income multiplier. Y = beneficiary is Low Income; N = beneficiary is not Low Income"; with NULL = "Not applicable".
      • CMS MMR Part D Low-Income Multiplier -- This field contains the same values as the CMS MMR "Part D Low-Income Multiplier" field, which the CMS documentation defines as: "The Part D low-income multiplier used in the calculation of the payment or adjustment".
      • CMS MMR Part D LTI Indicator Code -- This field contains the same values as the CMS MMR "Part D Long Term Institutional Indicator" field, which the CMS documentation defines as: "Indicator of beneficiary Long Term Institutional (LTI) status for the Part D payment or adjustment. A = LTI (aged); D = LTI (disabled)"; with NULL = "No LTI".
      • CMS MMR Part D LTI Multiplier -- This field contains the same values as the CMS MMR "Part D Long Term Institutional Multiplier" field, which the CMS documentation defines as: "Part D LTI multiplier used in the calculation of the payment or adjustment".
      • CMS MMR Part C Frailty Factor -- This field contains the same values as the CMS MMR "Part C Frailty Factor" field, which the CMS documentation defines as: "Part C Frailty Factor used in this payment or adjustment calculation. Used for PACE, FIDE SNPs, and some MMPs"; with NULL = "Not applicable".
      • CMS MMR MSP Reduction Factor -- This field contains the same values as the CMS MMR "MSP Reduction Factor" field, which the CMS documentation defines as: "MSP secondary payer reduction factor used in this payment or adjustment calculation"; with NULL = "Not applicable".

    • Financial Fields

      • Increase to CMS MMR Total MA Payment Part A Amount -- The increase to the CMS MMR Total MA Payment Part A Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Total MA Payment Part A Amount)
      • Increase to CMS MMR Total MA Payment Part B Amount -- The increase to the CMS MMR Total MA Payment Part B Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Total MA Payment Part B Amount)
      • Increase to CMS MMR Total MA Payment Part C Amount -- The increase to the CMS MMR Total MA Payment Part C Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Total MA Payment Part C Amount)
      • Increase to CMS MMR Total Payment Part D Amount -- The increase to the CMS MMR Total Payment Part D Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Total Payment Part D Amount)
      • Increase to CMS MMR Monthly Risk-Adjusted Part A Amount -- The increase to the CMS MMR Monthly Risk-Adjusted Part A Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Monthly Risk-Adjusted Part A Amount)
      • Increase to CMS MMR Monthly Risk-Adjusted Part B Amount -- The increase to the CMS MMR Monthly Risk-Adjusted Part B Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Monthly Risk-Adjusted Part B Amount)
      • Increase to CMS MMR Part A Monthly Rate for Payment or Adjustment -- The increase to the CMS MMR Part A Monthly Rate for Payment or Adjustment from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part A Monthly Rate for Payment or Adjustment)
      • Increase to CMS MMR Part B Monthly Rate for Payment or Adjustment -- The increase to the CMS MMR Part B Monthly Rate for Payment or Adjustment from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part B Monthly Rate for Payment or Adjustment)
      • Increase to CMS MMR Part D Monthly Rate for Payment or Adjustment -- The increase to the CMS MMR Part D Monthly Rate for Payment or Adjustment from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part D Monthly Rate for Payment or Adjustment)
      • Increase to CMS MMR LIS Premium Subsidy Amount -- The increase to the CMS MMR LIS Premium Subsidy Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR LIS Premium Subsidy Amount)
      • Increase to CMS MMR Medication Therapy Management Add-On Amount -- The increase to the CMS MMR Medication Therapy Management Add-On Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Medication Therapy Management Add-On Amount)
      • Increase to CMS MMR Part C Basic Premium Part A Amount -- The increase to the CMS MMR Part C Basic Premium Part A Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part C Basic Premium Part A Amount)
      • Increase to CMS MMR Part C Basic Premium Part B Amount -- The increase to the CMS MMR Part C Basic Premium Part B Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part C Basic Premium Part B Amount)
      • Increase to CMS MMR Rebate for Part A Cost Sharing Reduction Amount -- The increase to the CMS MMR Rebate for Part A Cost Sharing Reduction Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part A Cost Sharing Reduction Amount)
      • Increase to CMS MMR Rebate for Part B Cost Sharing Reduction Amount -- The increase to the CMS MMR Rebate for Part B Cost Sharing Reduction Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part B Cost Sharing Reduction Amount)
      • Increase to CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount -- The increase to the CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount)
      • Increase to CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount -- The increase to the CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount)
      • Increase to CMS MMR Rebate for Part B Premium Reduction Part A Amount -- The increase to the CMS MMR Rebate for Part B Premium Reduction Part A Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part B Premium Reduction Part A Amount)
      • Increase to CMS MMR Rebate for Part B Premium Reduction Part B Amount -- The increase to the CMS MMR Rebate for Part B Premium Reduction Part B Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part B Premium Reduction Part B Amount)
      • Increase to CMS MMR Rebate for Part D Supplemental Benefits Part A Amount -- The increase to the CMS MMR Rebate for Part D Supplemental Benefits Part A Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part D Supplemental Benefits Part A Amount)
      • Increase to CMS MMR Rebate for Part D Supplemental Benefits Part B Amount -- The increase to the CMS MMR Rebate for Part D Supplemental Benefits Part B Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part D Supplemental Benefits Part B Amount)
      • Increase to CMS MMR Rebate for Part D Basic Premium Reduction Amount -- The increase to the CMS MMR Rebate for Part D Basic Premium Reduction Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Rebate for Part D Basic Premium Reduction Amount)
      • Increase to CMS MMR Part D Basic Premium Amount -- The increase to the CMS MMR Part D Basic Premium Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part D Basic Premium Amount)
      • Increase to CMS MMR Part D Direct Subsidy Amount -- The increase to the CMS MMR Part D Direct Subsidy Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part D Direct Subsidy Amount)
      • Increase to CMS MMR Reinsurance Subsidy Amount -- The increase to the CMS MMR Reinsurance Subsidy Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Reinsurance Subsidy Amount)
      • Increase to CMS MMR Low-Income Subsidy Cost-Sharing Amount -- The increase to the CMS MMR Low-Income Subsidy Cost-Sharing Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Low-Income Subsidy Cost-Sharing Amount)
      • Increase to CMS MMR PACE Premium Add-On Amount -- The increase to the CMS MMR PACE Premium Add-On Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR PACE Premium Add-On Amount)
      • Increase to CMS MMR PACE Cost Sharing Add-on Amount -- The increase to the CMS MMR PACE Cost Sharing Add-on Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR PACE Cost Sharing Add-on Amount)
      • Increase to CMS MMR Part A MSP Reduction Amount -- The increase to the CMS MMR Part A MSP Reduction Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part A MSP Reduction Amount)
      • Increase to CMS MMR Part B MSP Reduction Amount -- The increase to the CMS MMR Part B MSP Reduction Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part B MSP Reduction Amount)
      • Increase to CMS MMR Part D Coverage Gap Discount Amount -- The increase to the CMS MMR Part D Coverage Gap Discount Amount from an MMR transaction record; negative values indicate a decrease. (See also [URSA-CORE] CMS MMR Part D Coverage Gap Discount Amount)
      • Resulting CMS MMR Total MA Payment Part A Amount -- The resulting CMS MMR Total MA Payment Part A Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Total MA Payment Part A Amount)
      • Resulting CMS MMR Total MA Payment Part B Amount -- The resulting CMS MMR Total MA Payment Part B Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Total MA Payment Part B Amount)
      • Resulting CMS MMR Total MA Payment Part C Amount -- The resulting CMS MMR Total MA Payment Part C Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Total MA Payment Part C Amount)
      • Resulting CMS MMR Total Payment Part D Amount -- The resulting CMS MMR Total Payment Part D Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Total Payment Part D Amount)
      • Resulting CMS MMR Monthly Risk-Adjusted Part A Amount -- The resulting CMS MMR Monthly Risk-Adjusted Part A Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Monthly Risk-Adjusted Part A Amount)
      • Resulting CMS MMR Monthly Risk-Adjusted Part B Amount -- The resulting CMS MMR Monthly Risk-Adjusted Part B Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Monthly Risk-Adjusted Part B Amount)
      • Resulting CMS MMR Part A Monthly Rate for Payment or Adjustment -- The resulting CMS MMR Part A Monthly Rate for Payment or Adjustment obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part A Monthly Rate for Payment or Adjustment)
      • Resulting CMS MMR Part B Monthly Rate for Payment or Adjustment -- The resulting CMS MMR Part B Monthly Rate for Payment or Adjustment obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part B Monthly Rate for Payment or Adjustment)
      • Resulting CMS MMR Part D Monthly Rate for Payment or Adjustment -- The resulting CMS MMR Part D Monthly Rate for Payment or Adjustment obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part D Monthly Rate for Payment or Adjustment)
      • Resulting CMS MMR LIS Premium Subsidy Amount -- The resulting CMS MMR LIS Premium Subsidy Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR LIS Premium Subsidy Amount)
      • Resulting CMS MMR Medication Therapy Management Add-On Amount -- The resulting CMS MMR Medication Therapy Management Add-On Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Medication Therapy Management Add-On Amount)
      • Resulting CMS MMR Part C Basic Premium Part A Amount -- The resulting CMS MMR Part C Basic Premium Part A Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part C Basic Premium Part A Amount)
      • Resulting CMS MMR Part C Basic Premium Part B Amount -- The resulting CMS MMR Part C Basic Premium Part B Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part C Basic Premium Part B Amount)
      • Resulting CMS MMR Rebate for Part A Cost Sharing Reduction Amount -- The resulting CMS MMR Rebate for Part A Cost Sharing Reduction Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part A Cost Sharing Reduction Amount)
      • Resulting CMS MMR Rebate for Part B Cost Sharing Reduction Amount -- The resulting CMS MMR Rebate for Part B Cost Sharing Reduction Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part B Cost Sharing Reduction Amount)
      • Resulting CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount -- The resulting CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount)
      • Resulting CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount -- The resulting CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount)
      • Resulting CMS MMR Rebate for Part B Premium Reduction Part A Amount -- The resulting CMS MMR Rebate for Part B Premium Reduction Part A Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part B Premium Reduction Part A Amount)
      • Resulting CMS MMR Rebate for Part B Premium Reduction Part B Amount -- The resulting CMS MMR Rebate for Part B Premium Reduction Part B Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part B Premium Reduction Part B Amount)
      • Resulting CMS MMR Rebate for Part D Supplemental Benefits Part A Amount -- The resulting CMS MMR Rebate for Part D Supplemental Benefits Part A Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part D Supplemental Benefits Part A Amount)
      • Resulting CMS MMR Rebate for Part D Supplemental Benefits Part B Amount -- The resulting CMS MMR Rebate for Part D Supplemental Benefits Part B Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part D Supplemental Benefits Part B Amount)
      • Resulting CMS MMR Rebate for Part D Basic Premium Reduction Amount -- The resulting CMS MMR Rebate for Part D Basic Premium Reduction Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Rebate for Part D Basic Premium Reduction Amount)
      • Resulting CMS MMR Part D Basic Premium Amount -- The resulting CMS MMR Part D Basic Premium Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part D Basic Premium Amount)
      • Resulting CMS MMR Part D Direct Subsidy Amount -- The resulting CMS MMR Part D Direct Subsidy Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part D Direct Subsidy Amount)
      • Resulting CMS MMR Reinsurance Subsidy Amount -- The resulting CMS MMR Reinsurance Subsidy Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Reinsurance Subsidy Amount)
      • Resulting CMS MMR Low-Income Subsidy Cost-Sharing Amount -- The resulting CMS MMR Low-Income Subsidy Cost-Sharing Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Low-Income Subsidy Cost-Sharing Amount)
      • Resulting CMS MMR PACE Premium Add-On Amount -- The resulting CMS MMR PACE Premium Add-On Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR PACE Premium Add-On Amount)
      • Resulting CMS MMR PACE Cost Sharing Add-on Amount -- The resulting CMS MMR PACE Cost Sharing Add-on Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR PACE Cost Sharing Add-on Amount)
      • Resulting CMS MMR Part A MSP Reduction Amount -- The resulting CMS MMR Part A MSP Reduction Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part A MSP Reduction Amount)
      • Resulting CMS MMR Part B MSP Reduction Amount -- The resulting CMS MMR Part B MSP Reduction Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part B MSP Reduction Amount)
      • Resulting CMS MMR Part D Coverage Gap Discount Amount -- The resulting CMS MMR Part D Coverage Gap Discount Amount obtained after processing the MMR transaction; note that this may not represent the final action status of the MMR member-month. (See also [URSA-CORE] CMS MMR Part D Coverage Gap Discount Amount)

    • 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)
      • Is Ursa Unreliable Part C Field Values

    Foreign Keys

    • billing_prov_id → ursa.no_ursa_core_prov_001.prov_id
    • trx_payor_id → ursa.no_ursa_core_struct_004.payor_id
    • trx_plan_id → ursa.no_ursa_core_struct_005.plan_id
    • bill_id → ursa.no_ursa_core_fin_011.bill_id
    • bill_service_line_item_id → ursa.no_ursa_core_fin_012.bill_service_line_item_id
    • pat_id → ursa.no_ursa_core_pat_001.pat_id
    • payor_id → ursa.no_ursa_core_struct_004.payor_id
    • plan_id → ursa.no_ursa_core_struct_005.plan_id
    • plan_attributee_prov_id → ursa.no_ursa_core_prov_001.prov_id
    • plan_attributee_individual_prov_id → ursa.no_ursa_core_prov_001.prov_id
    • plan_attributee_prov_group_prov_id → ursa.no_ursa_core_prov_001.prov_id

    Dedicated Precursors

    • [NO/URSA-CORE] MMR Member-Month Transactions, Precursor 1 (All Source Records): 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 the "final action" records in the MMR Member-Months natural object.
    Was this article helpful?
    What's Next