Dimensional Warehouse Model Data Model

Entity

Entity Claim Line Fact

Description

A request for reimbursement that a healthcare provider issues in respect of an individual service or a single charge group of services. One or more claim lines make up a claim.

Attributes
Adjustment Amt
Admin Cost Amt
Allowed Amt
Annual Maximum Benefit Amt
Approved Amt
Attending Practitioner Dk
Attending Practitioner Sk
AWM Load Info Sk
Benefit Stage Amt
Claim Base Payment Rt
Claim Dk
Claimed Days Cnt
Claim Line Bk
Claim Line Cnt
Claim Line Detail Dk
Claim Line Dk
Claim Line Sk
Claim Post Discount Amt
Claim Pre Discount Amt
Claim Sk
Coinsurance Amt
Co-Insurance Pct
Contract Amt
Contract Pct
Copay Deductible Amt
Copayment Amt
Current Ind
Deductible Amt
Disallowed Amt
Dispensing Fee Paid Amt
Dispensing Fee Submitted Amt
DWM Load Info Sk
Effective From Dt
Effective To Dt
Employer Cost Amt
Encounter Dk
Encounter Sk
Facility Dk
Facility Sk
Fee For Service Equivalent Amt
Guarantor Dk
Guarantor Sk
Health Plan Product Dk
Health Plan Product Sk
Incentive Amt
Ingredient Cost Paid Amt
Ingredient Cost Submitted Amt
Initial Treatment Calendar Dk
Initial Treatment Dt
Interest Amt
Length Of Medical Necessity Cnt
Lifetime Maximum Benefit Amt
Line Item Charge Amt
Line Item Unit Charge Amt
Local Sales Tax Amt
Medication Administration Dk
Medication Administration Sk
Member Penalty Amt
Network Access Fee Amt
Noncovered Charge Amt
Non Covered Days Cnt
Nonpayable Professional Fees Amt
Number of Claimed Services
Number of Non Covered Services
Number of Services per Repetition Period
Ordering Practitioner Dk
Ordering Practitioner Sk
Out-of-Pocket Maximum Amt
Paid Amt
Paid Days Cnt
Patient Dk
Patient Paid Amt
Patient Payment Amt
Patient Responsibility Amt
Patient Sk
Payer Paid Amt
Payment Due Prior to COB
Pharmacy Fund Amt
Pharmacy Gross Amount Submitted
Plan Member Dk
Plan Member Sk
Postage Claimed Amt
Preference Incentive Co-Payment Amt
Pricing Rt
Procedure Code Dk
Procedure Code Sk
Procedure Sk
Professional Service Fee Paid
Professional Service Fee Submitted
Provider Dk
Provider Penalty Amt
Provider Sk
Purchased Service Charge Amt
Purchase Price Amt
Rendering Practitioner Dk
Rendering Practitioner Sk
Rental Price Amt
Repriced Allowed Amt
Repriced Approved Ambulatory Patient Group Amt
Repriced Approved Service Unit Cnt
Repriced Saving Amt
Repricing Flat Rate Amt
Sales Tax Amount Submitted
Sales Tax Amt
Service Delivery Calendar
Service Dk
Service Duration Cnt
Service Duration Period
Service Duration Period Cnt
Service Repetition Cnt
Service Repetition Period
Service Sk
Service Unit Cnt
Source Cd
Source Code Sk
Supervising Practitioner Dk
Supervising Practitioner Sk
Tenant Sk
Term Discount Pct
Type Cd
Type Code Sk
Unit Price Amt
Usual And Customary Charge UCC
Valid From Ts
Valid To Ts
Write Off Amt

Relationship
Claim Line Dimension_Claim Line_FK
Claim Line Detail_Claim_FK
Claim Line Detail_Provider_FK
Claim Line Rendering Practitioner_FK
Claim Line Supervising Practitioner_FK
Claim Line Ordering Practitioner_FK
Claim Line Attending Practitioner_FK
Claim Line Detail_Patient_FK
Claim Line Detail_Encounter_FK
Claim Line Fact_Calendar Dimension_FK
Claim Line Fact_Medication Administration Fact_FK
Claim Line Fact_Plan Member Dimension_FK
Claim Line Fact_Procedure Code Dimension_FK
Claim Line Fact_Service Dimension_FK
Claim Line Fact_Health Plan Product Dimension_FK
Claim Line Fact_Party Role Dimension_FK
Claim Line Fact_Point Of Care Location Dimension_FK

Primary Key
Claim Line Fact PK

Dependencies

Reverse Dependencies

Attribute Details

Adjustment Amt

Description	The amount of an adjustment that is made to an claim line when an adjustment is processed after the initial claim adjudication.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admin Cost Amt

Description	The monetary value of any administration charges.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount Large [DECIMAL(20,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Allowed Amt

Description	The maximum amount determined by the payer as being 'allowable' under the provisions of the contract prior to the determination of actual payment.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Annual Maximum Benefit Amt

Description	The member liability arising on the claim line from the claimant exceeding their annual maximum benefit amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Approved Amt

Description	The monetary value of the claim line approved by the payer.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Attending Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Attending Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Benefit Stage Amt

Description	The amount attributable to a particular benefit stage or coverage tier.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Claim Base Payment Rt

Description	The per diem or fixed amount used to price the claim line payment in line with the pricing method.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Claim Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Claimed Days Cnt

Description	the number of days billed on an institutional claim line item.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Claim Line Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Claim Line Cnt

Description	Counts the number of Claim Line Rows. Set to 1 by the ETL.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Default Value	1
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Claim Line Detail Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

Claim Line Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Claim Line Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Claim Post Discount Amt

Description	The cost of the service after applying discounts and excluding service cost.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Claim Pre Discount Amt

Description	The cost of the service before applying any discounts and excluding service cost.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Claim Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Coinsurance Amt

Description	The monetary value of co-insurance applying to the claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Co-Insurance Pct

Description	The percentage co-payment for which the member is liable that is applicable to a particular claim or medical service. The co-payment may depend on the type of service, the type of healthcare provider, the point of service where care was rendered, whether a healthcare provider is in the network, whether the care is an emergency, whether care was pre-certified or authorized by the health plan product, or other factors.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Contract Amt

Description	A fixed monetary amount that pertains to the contract. It is required if the service amounts are different than the claim level amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Contract Pct

Description	The percentage of charges that are payable under the contract.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Copay Deductible Amt

Description	The combined monetary value of the copayment and deductible as reported by the insurer.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Copayment Amt

Description	The out-of-pocket amount to be paid by the member for the medical service. The co-payment may depend on the type of service, the type of healthcare provider, the point of service where care was rendered, whether a healthcare provider is in the network, whether the care is an emergency, whether care was pre-certified or authorized by the health insurer, or other factors.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Deductible Amt

Description	The portion of the allowed amount on a healthcare claim line that is to be applied as a deductible based on the provisions of the health plan product.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Disallowed Amt

Description	The portion of a claim line item charge amount that is for a non-covered service or exceeds the maximum charge allowed in the provider agreement or the applicable usual and customary charge (UCC).
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensing Fee Paid Amt

Description	The monetary value of the dispensing fee included in the payment for a pharmacy claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensing Fee Submitted Amt

Description	The monetary value of a dispensing fee submitted by the pharmacy. This amount is included in the 'Pharmacy Gross Amount Submitted'.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Employer Cost Amt

Description	The portion of the claim line amount that the employer health plan will pay.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount Large [DECIMAL(20,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Encounter Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Facility Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Facility Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Fee For Service Equivalent Amt

Description	The amount which would have been paid to the provider for a specific medical service if the pricing methodology were Fee-for-Service. Generally applies to capitated services. May be used in analyzing provider payments, analyzing savings due to capitation, or calculating a reconciliation reimbursement to a capitated provider for total services rendered to members in excess of planned volumes.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Guarantor Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Guarantor Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Health Plan Product Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Health Plan Product Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Incentive Amt

Description	The contractually agreed upon incentive for specific services rendered.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ingredient Cost Paid Amt

Description	The amount of the cost of the medication ingredients that has been paid.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ingredient Cost Submitted Amt

Description	The monetary cost or estimated acquisition cost for the ingredients of the medication dispensed in the prescription. The method for determining ingredient cost amount may be the average wholesale price less a discount, as an estimate of the pharmacy's acquisition cost, or the maximum allowable cost per unit dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Initial Treatment Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Initial Treatment Dt

Description	The date upon which the patient initially sought treatment for this condition.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Interest Amt

Description	The amount of interest incurred by the insurer for late payment of a claim line item.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Length Of Medical Necessity Cnt

Description	The number of days the durable medical equipment will be required for medical treatment.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Lifetime Maximum Benefit Amt

Description	The member liability on the claim line arising from the claimant exceeding their lifetime maximum benefit amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Line Item Charge Amt

Description	The monetary value of charges related to this service.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Line Item Unit Charge Amt

Description	The per unit monetary charge for the procedure on the claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Local Sales Tax Amt

Description	The amount of local sales tax applicable to the claim line charge amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medication Administration Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medication Administration Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Member Penalty Amt

Description	The penalty incurred by the member on the claim line for failure to comply with health plan requirements regarding utilization management, prior authorization or other policy provisions.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Network Access Fee Amt

Description	The fee charged by another health plan, a provider network, preferred provider organization PPO, or other organization for granting access to its providers to the members of the health plan. This allows the members to have access to providers in locations or with specialties not covered in their own network and gives the health plan the benefit of discounted fees or other contracted pricing arrangements
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Noncovered Charge Amt

Description	The monetary amount of the charge on this claim line that is not covered by the payer.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Non Covered Days Cnt

Description	The number of claimed days not covered under coverage agreement specifications.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Nonpayable Professional Fees Amt

Description	The monetary value of professional fees billed but not payable by the healthcare insurer.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Claimed Services

Description	A count of the services rendered that are included in the claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Non Covered Services

Description	A count of services rendered that are not covered under coverage agreement specifications.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Services per Repetition Period

Description	The number of service units that are rendered in the period specified.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ordering Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Ordering Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Out-of-Pocket Maximum Amt

Description	The amount that the health plan is liable for on the claim line as a result of the claimant exceeding their annual out-of-pocket maximum amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Paid Amt

Description	The amount paid in total on this claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Paid Days Cnt

Description	The number of days paid by the health plan organization on an institutional claim. That is the claim days count less any days disallowed for reasons such as ineligibility, non-coverage, or excess of the maximum days allowed for the healthcare task rendered.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Patient Paid Amt

Description	The amount the provider has received from the patient (or insured) toward payment of a claim or claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Payment Amt

Description	The amount the patient already paid for the claimed services or products.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Responsibility Amt

Description	The patient's total cost share, including co-payments, amounts applied to deductible, over maximum amounts, penalties and so on.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Payer Paid Amt

Description	The amount paid by the payer on this claim or claim line.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Payment Due Prior to COB

Description	For a claim subject to coordination of benefits, the amount the healthcare insurer would have paid if the healthcare insurer were the primary payer. Where the healthcare insurer is not the primary payer, it is sometimes necessary to first adjudicate the claim as if it were the primary payer.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pharmacy Fund Amt

Description	The monetary amount that the health plan has paid for the cost of dispensing the medication specifically from the pharmacy fund excluding any portion from the members health benefit funds.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pharmacy Gross Amount Submitted

Description	The total monetary value claimed, including applicable ingredient cost, dispensing fees, incentive amounts, professional service fees and sales tax.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Plan Member Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Plan Member Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Postage Claimed Amt

Description	The monetary cost of postage used to provide a service or to process associated paper work.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preference Incentive Co-Payment Amt

Description	The monetary amount of a patient's co-payment / cost share incentive for preferred product.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pricing Rt

Description	The per diem or fixed amount used to price the claim in line with the claim pricing method type.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Code Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Procedure Code Sk

Description	The generated unique key for a Procedure.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Procedure Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Professional Service Fee Paid

Description	The monetary amount included in the payment for a pharmacy claim line, representing the contractually agreed upon fee for professional services rendered.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Professional Service Fee Submitted

Description	The monetary amount submitted by the provider for professional services rendered.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Provider Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Provider Penalty Amt

Description	A financial penalty incurred by the healthcare provider for failure to comply with health benefits plan requirements. The penalty incurred by the healthcare provider on the claim line for failure to comply with health benefits plan requirements regarding utilization management, prior authorization, referral, out-of-network or other policy or provider contract provisions applicable to a medical service charged on a claim.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Provider Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Purchased Service Charge Amt

Description	The monetary amount of the charge for a purchased service.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Purchase Price Amt

Description	The purchase price of the durable medical equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Rendering Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Rendering Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Rental Price Amt

Description	The monetary rental price of the durable medical equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Repriced Allowed Amt

Description	The maximum monetary amount determined by the repricer as being allowable under the provisions of the contract prior to the determination of the actual payment.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Repriced Approved Ambulatory Patient Group Amt

Description	The monetary amount of payment by the repricer for the referenced ambulatory patient group.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Repriced Approved Service Unit Cnt

Description	The number of service units approved by a pricing or repricing process.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Repriced Saving Amt

Description	The monetary value of savings related to third party organization repricing of claims.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Repricing Flat Rate Amt

Description	The amount used to determine the flat rate or per diem price by the repricing organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Sales Tax Amount Submitted

Description	The amount of sales tax included in the amount submitted.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Sales Tax Amt

Description	The amount of sales tax attributable to the referenced service.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Delivery Calendar

Description	The days of the week or month that services are rendered.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Service Duration Cnt

Description	The length of time a service takes or is in effect. For example: Length of time durable medical equipment (DME) is needed
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Duration Period

Description	The unit of measurement used to describe the period over which services are rendered.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Duration Period Cnt

Description	The total number of duration periods that services are rendered over. For example: 21 days
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Repetition Cnt

Description	The sampling frequency of the services. For example: 12 (every 12 hours) 3rd (every 3rd day)
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Repetition Period

Description	The period of measurement that the selective rendering of services is based on. For example: days (every 3rd) hours (every 12)
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Unit Cnt

Description	The quantity of units, times, days, visits, services, or treatments for the service described by the HCPCS codes, revenue code or procedure code.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Supervising Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Supervising Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Term Discount Pct

Description	The discount percentage available to the payer for payment within a specific time period.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Type Cd

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Type Code Sk

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Unit Price Amt

Description	The price for one unit of goods or services.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Usual And Customary Charge UCC

Description	The amount specified by the health plan product as the maximum amount payable for healthcare service rendered in a particular service geographic area and service setting, whether it be an inpatient, outpatient, or ambulatory facility. The type of healthcare provider rendering the service, whether it be a physician, midlevel practitioner or registered nurse, is also a factor.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Write Off Amt

Description	The total recoverable amount that has been written off. Claim recoveries may be written off in part or in total where the organization believes the cost of recovery will exceed the value to be recovered or where the amount is in dispute and the organization is not confident of a positive outcome.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Claim Line Dimension_Claim Line_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Claim Line Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Detail_Claim_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Claim Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Detail_Provider_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Rendering Practitioner_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Role Name	Rendering
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Supervising Practitioner_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Role Name	Supervising
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Ordering Practitioner_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Role Name	Ordering
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Attending Practitioner_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Role Name	Attending
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Detail_Patient_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Detail_Encounter_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Medication Administration Fact_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Medication Administration Fact
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Plan Member Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Procedure Code Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Procedure Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Service Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Service Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Health Plan Product Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Health Plan Product Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Party Role Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Party Role Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Claim Line Fact_Point Of Care Location Dimension_FK

Is Identifying Relationship	false
Child Table	Claim Line Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Claim Line Fact PK

Key Attribute

Claim Line Detail Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model