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

    [NO/URSA-CORE] MMR Member-Months

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

    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_020
    • Layer: NATURAL_OBJECT
    • Object Type: Single Stack
    • Case ID: Patient ID, Plan ID, Covered Month Start Date
    • Primary Key: Patient ID, Plan ID, Covered Month 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)
      • 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)
      • 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.

    • 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.
      • Last CMS MMR Payment Date -- The most recent CMS MMR Payment Date from among the MMR Member-Month Transaction records contributing to the current (final action) MMR Member-Month record. (See also [URSA-CORE] CMS MMR Payment Date)
      • Last CMS MMR Run Date -- The most recent CMS MMR Run Date from among the MMR Member-Month Transaction records contributing to the current (final action) MMR Member-Month record. (See also [URSA-CORE] CMS MMR 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)
      • 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

      • CMS MMR Total MA Payment Part A Amount -- This field contains the same values as the CMS MMR "Total MA Payment or Adjustment Part A" field, which the CMS documentation defines as: "The total Part A portion of the MA payment".
      • CMS MMR Total MA Payment Part B Amount -- This field contains the same values as the CMS MMR "Total MA Payment or Adjustment Part B" field, which the CMS documentation defines as: "The total Part B portion of the MA payment".
      • CMS MMR Total MA Payment Part C Amount -- This field contains the same values as the CMS MMR "Total MA Part C Payment or Adjustment" field, which the CMS documentation defines as: "The total MA Part C A/B payment".
      • CMS MMR Total Payment Part D Amount -- This field contains the same values as the CMS MMR "Total Part D Payment or Adjustment" field, which the CMS documentation defines as: "The total Part D payment or adjustment for the beneficiary".
      • CMS MMR Monthly Risk-Adjusted Part A Amount -- This field contains the same values as the CMS MMR "Monthly Risk Adjusted Amount Part A" field, which the CMS documentation defines as: "Monthly Part A portion of the payment or adjustment dollars".
      • CMS MMR Monthly Risk-Adjusted Part B Amount -- This field contains the same values as the CMS MMR "Monthly Risk Adjusted Amount Part B" field, which the CMS documentation defines as: "Monthly Part B portion of the payment or adjustment dollars".
      • CMS MMR Part A Monthly Rate for Payment or Adjustment -- This field contains the same values as the CMS MMR "Part A Monthly Rate for Payment or Adjustment" field, which the CMS documentation defines as: "The Part A State and County Rate used in the payment or adjustment calculation. Payments = Rate in effect for payment period; Adjustments = Rate in effect for adjustment period i.e. the updated rate in effect for the adjustment period".
      • CMS MMR Part B Monthly Rate for Payment or Adjustment -- This field contains the same values as the CMS MMR "Part B Monthly Rate for Payment or Adjustment" field, which the CMS documentation defines as: "The Part B State and County Rate used in the payment or adjustment calculation. Payments = Rate in effect for payment period; Adjustments = Rate in effect for adjustment period i.e. the updated rate in effect for the adjustment period".
      • CMS MMR Part D Monthly Rate for Payment or Adjustment -- This field contains the same values as the CMS MMR "Part D Monthly Rate for Payment or Adjustment" field, which the CMS documentation defines as: "The Part D rate used in the payment or adjustment calculation. Payments = Rate amount in effect for payment period; Adjustments = Rate amount in effect for adjustment period".
      • CMS MMR LIS Premium Subsidy Amount -- This field contains the same values as the CMS MMR "LIS Premium Subsidy" field, which the CMS documentation defines as: "Low Income Premium Subsidy Amount for the beneficiary".
      • CMS MMR Medication Therapy Management Add-On Amount -- This field contains the same values as the CMS MMR "Medication Therapy Management (MTM) Add On" field, which the CMS documentation defines as: "The total Medication Therapy Management (MTM) Add-On for the beneficiary".
      • CMS MMR Part C Basic Premium Part A Amount -- This field contains the same values as the CMS MMR "Part C Basic Premium – Part A Amount" field, which the CMS documentation defines as: "The premium amount for determining the MA payment attributable to Part A".
      • CMS MMR Part C Basic Premium Part B Amount -- This field contains the same values as the CMS MMR "Part C Basic Premium – Part B Amount" field, which the CMS documentation defines as: "The premium amount for determining the MA payment attributable to Part B".
      • CMS MMR Rebate for Part A Cost Sharing Reduction Amount -- This field contains the same values as the CMS MMR "Rebate for Part A Cost Sharing Reduction" field, which the CMS documentation defines as: "The amount of the rebate allocated to reducing the beneficiary Part A cost-sharing".
      • CMS MMR Rebate for Part B Cost Sharing Reduction Amount -- This field contains the same values as the CMS MMR "Rebate for Part B Cost Sharing Reduction" field, which the CMS documentation defines as: "The amount of the rebate allocated to reducing the beneficiary Part B cost-sharing".
      • CMS MMR Rebate for Other Part A Mandatory Supplemental Benefits Amount -- This field contains the same values as the CMS MMR "Rebate for Other Part A Mandatory Supplemental Benefits" field, which the CMS documentation defines as: "The amount of the rebate allocated to providing Part A Supplemental benefits".
      • CMS MMR Rebate for Other Part B Mandatory Supplemental Benefits Amount -- This field contains the same values as the CMS MMR "Rebate for Other Part B Mandatory Supplemental Benefits" field, which the CMS documentation defines as: "The amount of the rebate allocated to providing Part B Supplemental benefits".
      • CMS MMR Rebate for Part B Premium Reduction Part A Amount -- This field contains the same values as the CMS MMR "Rebate for Part B Premium Reduction – Part A Amount" field, which the CMS documentation defines as: "The Part A amount of the rebate that is allocated to reducing the beneficiary Part B premium. This amount is subtracted from payments for one of two reasons: 1. The beneficiary has ESRD status. 2. The beneficiary is enrolled in an Employer Group Plan and is neither Hospice nor ESRD (Effective 01/01/2020). For all other beneficiaries, this field is informational".
      • CMS MMR Rebate for Part B Premium Reduction Part B Amount -- This field contains the same values as the CMS MMR "Rebate for Part B Premium Reduction – Part B Amount" field, which the CMS documentation defines as: "The Part B amount of the rebate that is allocated to reducing the beneficiary Part B premium. This amount is subtracted from payments for one of two reasons: 1. The beneficiary has ESRD status. 2. The beneficiary is enrolled in an Employer Group Plan and is neither Hospice nor ESRD (Effective 01/01/2020). For all other beneficiaries, this field is informational".
      • CMS MMR Rebate for Part D Supplemental Benefits Part A Amount -- This field contains the same values as the CMS MMR "Rebate for Part D Supplemental Benefits – Part A Amount" field, which the CMS documentation defines as: "Part A Amount of the rebate allocated to providing Part D supplemental benefits".
      • CMS MMR Rebate for Part D Supplemental Benefits Part B Amount -- This field contains the same values as the CMS MMR "Rebate for Part D Supplemental Benefits – Part B Amount" field, which the CMS documentation defines as: "Part B Amount of the rebate allocated to providing Part D supplemental benefits".
      • CMS MMR Rebate for Part D Basic Premium Reduction Amount -- This field contains the same values as the CMS MMR "Rebate for Part D Basic Premium Reduction" field, which the CMS documentation defines as: "Amount of the rebate allocated to reducing the beneficiary basic Part D premium".
      • CMS MMR Part D Basic Premium Amount -- This field contains the same values as the CMS MMR "Part D Basic Premium Amount" field, which the CMS documentation defines as: "Plan’s Part D premium amount".
      • CMS MMR Part D Direct Subsidy Amount -- This field contains the same values as the CMS MMR "Part D Direct Subsidy Amount" field, which the CMS documentation defines as: "Total Part D Direct subsidy amount for the beneficiary".
      • CMS MMR Reinsurance Subsidy Amount -- This field contains the same values as the CMS MMR "Reinsurance Subsidy Amount" field, which the CMS documentation defines as: "The amount of reinsurance subsidy included in the payment".
      • CMS MMR Low-Income Subsidy Cost-Sharing Amount -- This field contains the same values as the CMS MMR "Low-Income Subsidy Cost-Sharing Amount" field, which the CMS documentation defines as: "The low-income subsidy cost-sharing amount included in the payment".
      • CMS MMR PACE Premium Add-On Amount -- This field contains the same values as the CMS MMR "PACE Premium Add On" field, which the CMS documentation defines as: "Total Part D PACE Premium Add-on amount".
      • CMS MMR PACE Cost Sharing Add-on Amount -- This field contains the same values as the CMS MMR "PACE Cost Sharing Add-on" field, which the CMS documentation defines as: "Total Part D PACE Cost Sharing Add-on amount".
      • CMS MMR Part A MSP Reduction Amount -- This field contains the same values as the CMS MMR "MSP Reduction Amount Part A" field, which the CMS documentation defines as: "MSP reduction amount Part A; Reported as a POSITIVE AMT, is actually a NEGATIVE AMT".
      • CMS MMR Part B MSP Reduction Amount -- This field contains the same values as the CMS MMR "MSP Reduction Amount Part B" field, which the CMS documentation defines as: "MSP reduction amount Part B; Reported as a POSITIVE AMT, is actually a NEGATIVE AMT".
      • CMS MMR Part D Coverage Gap Discount Amount -- This field contains the same values as the CMS MMR "Part D Coverage Gap Discount Amount" field, which the CMS documentation defines as: "Amount of the Coverage Gap Discount Amount included in the payment".

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

    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-Months, Precursor 1 (All Source Records): One record per distinct member-month obtained from the reconciliation of MMR (or commercial MA plan equivalent) data to final action status; collected from all sources.
    Was this article helpful?
    What's Next