| Dimensional Warehouse Model Data Model |
| 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. |
| Primary Key | |
Claim Line Dimension PK |
|
| Dependencies | |
|
|
|
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Acute Manifestation Dt
| Description | Date of acute manifestation of patient's 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 |
Adjusted Repriced Line Item Reference Num
| Description | Identification number of an adjusted repriced line item adjusted from an original amount. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
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 |
Ambulatory Patient Group Cd
| Description | The ambulatory patient group (APG) of the patient. Relevant where the contractual reimbursement arrangement between provider and payer is based on APG. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ambulatory Patient Group Code Descr
| Description | The ambulatory patient group (APG) of the patient. Relevant where the contractual reimbursement arrangement between provider and payer is based on APG. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ambulatory Patient Group Code Sk
| Description | The ambulatory patient group (APG) of the patient. Relevant where the contractual reimbursement arrangement between provider and payer is based on APG. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
Attachment Report Type Cd
| Description | Indicates the inherent nature of the claim line attachment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Attachment Report Type Code Sk
| Description | Indicates the inherent nature of the claim line attachment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Attachment Report Type Descr
| Description | Indicates the inherent nature of the claim line attachment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Attachment Transmission Cd
| Description | Indicates the timing, transmission method or format by which an attachment is to be sent or has been sent. For example: Previously Submitted to Payer Certification Included in this Claim Narrative Segment Included in this Claim No Documentation is Required Not Specified |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Attachment Transmission Code Sk
| Description | Indicates the timing, transmission method or format by which an attachment is to be sent or has been sent. For example: Previously Submitted to Payer Certification Included in this Claim Narrative Segment Included in this Claim No Documentation is Required Not Specified |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Attachment Transmission Descr
| Description | Indicates the timing, transmission method or format by which an attachment is to be sent or has been sent. For example: Previously Submitted to Payer Certification Included in this Claim Narrative Segment Included in this Claim No Documentation is Required Not Specified |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 |
Benefit Stage Qualifier Cd
| Description | Qualifies the benefit stage amount by identifying the coverage tier under which a benefit is being paid. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Benefit Stage Qualifier Code Descr
| Description | Qualifies the benefit stage amount by identifying the coverage tier under which a benefit is being paid. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Benefit Stage Qualifier Code Sk
| Description | Qualifies the benefit stage amount by identifying the coverage tier under which a benefit is being paid. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Certification Type Cd
| Description | Indicates the type of certification established for the service performed. For example: Initial Renewal Revised |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Certification Type Code Sk
| Description | Indicates the type of certification established for the service performed. For example: Initial Renewal Revised |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Certification Type Descr
| Description | Indicates the type of certification established for the service performed. For example: Initial Renewal Revised |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 |
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 Item Num
| Description | A sequence number to uniquely identify this claim line within the context of the claim to which it belongs. |
| 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 |
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 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 Item Cd
| Description | A code identifying a procedure, medication, test, product or service specified on the claim line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Claim Line Item Code Descr
| Description | A code identifying a procedure, medication, test, product or service specified on the claim line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Claim Line Item Code Sk
| Description | A code identifying a procedure, medication, test, product or service specified on the claim line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Claim Line Item Code Type Cd
| Description | Indicates the type of the item code such as procedure, medication, test, product or service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Claim Line Item Code Type Code Descr
| Description | Indicates the type of the item code such as procedure, medication, test, product or service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Claim Line Item Code Type Code Sk
| Description | Indicates the type of the item code such as procedure, medication, test, product or service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
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 |
Compound Drug Cd
| Description | Indicates the compound nature of a drug. For example: 0 = Not specified 1 = Not a compound 2 = Compound |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Compound Drug Code Descr
| Description | Indicates the compound nature of a drug. For example: 0 = Not specified 1 = Not a compound 2 = Compound |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Compound Drug Code Sk
| Description | Indicates the compound nature of a drug. For example: 0 = Not specified 1 = Not a compound 2 = Compound |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Compound Drug Ind
| Description | Indicates whether this drug is a compound or not. 1 Compound 0 Not a compound |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Compound Ingredient Modifier Cd
| Description | A code that identifies special circumstances related to the dispensing/payment of the compound drug product. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Compound Ingredient Modifier Code Descr
| Description | A code that identifies special circumstances related to the dispensing/payment of the compound drug product. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Compound Ingredient Modifier Code Sk
| Description | A code that identifies special circumstances related to the dispensing/payment of the compound drug product. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 Id
| Description | Identifies the specific contract, established by the payer. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| 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 |
Contract Type Cd
| Description | Indicates the contract type that is being claimed against. It is recommended that a contract type is always provided for capitated encounters. For example: Per Diem Variable Per Diem Flat Capitated Percent Other |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Contract Type Code Sk
| Description | Indicates the contract type that is being claimed against. It is recommended that a contract type is always provided for capitated encounters. For example: Per Diem Variable Per Diem Flat Capitated Percent Other |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Contract Type Descr
| Description | Indicates the contract type that is being claimed against. It is recommended that a contract type is always provided for capitated encounters. For example: Per Diem Variable Per Diem Flat Capitated Percent Other |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Contract Version Id
| Description | The version or generation of an insurance coverage in force at the time of the claimed for service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| 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 |
Copay Status Cd
| Description | Indicates the status of the co-payment requirements for this service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Copay Status Code Sk
| Description | Indicates the status of the co-payment requirements for this service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Copay Status Descr
| Description | Indicates the status of the co-payment requirements for this service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Cost Sharing Ind
| Description | Indicates whether co-payment or co-insurance requirements are applicable for this claim line. 0 No 1 Yes |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Currency Cd
| Description | Indicates the currency used as the basis for all monetary amounts. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Currency Code Sk
| Description | Indicates the currency used as the basis for all monetary amounts. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
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 |
Dosage Form Cd
| Description | Indicates the dosage form of the complete compound mixture. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Dosage Form Code Descr
| Description | Indicates the dosage form of the complete compound mixture. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Dosage Form Code Sk
| Description | Indicates the dosage form of the complete compound mixture. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
EPSDT Ind
| Description | An indicator of whether or not early and periodic screening for diagnosis and treatment (EPSDT) of children services are involved with this claim line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Family Planning Ind
| Description | An indicator of whether or not family planning services are involved with this claim Line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
Form Id
| Description | A reference code or number identifying a specific claim form. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 Basis Cd
| Description | Indicates the method of calculation used for the cost of ingredients in the relevant medication. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ingredient Cost Basis Code Descr
| Description | Indicates the method of calculation used for the cost of ingredients in the relevant medication. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ingredient Cost Basis Code Sk
| Description | Indicates the method of calculation used for the cost of ingredients in the relevant medication. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
Ingredient Ind
| Description | Indicates whether this drug is used as an ingredient in another drug. 1 Ingredient 0 Not an ingredient |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
Last X-Ray Dt
| Description | The date upon which the patient most recently had an X-Ray. |
| 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 |
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 |
Level Of Effort Cd
| Description | Classifies a pharmacy claim line item identified as a compound according to the amount of work involved.The code indicates the level of effort as determined by the complexity of decision making or resources utilized by a pharmacist to perform a professional service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Level Of Effort Code Descr
| Description | Classifies a pharmacy claim line item identified as a compound according to the amount of work involved.The code indicates the level of effort as determined by the complexity of decision making or resources utilized by a pharmacist to perform a professional service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Level Of Effort Code Sk
| Description | Classifies a pharmacy claim line item identified as a compound according to the amount of work involved.The code indicates the level of effort as determined by the complexity of decision making or resources utilized by a pharmacist to perform a professional service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [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 80_100 Cd
| Description | A code indicating that the amount shown in the payment field on the non-institutional line item represents either 80% or 100% of the allowed charges less any deductible, or 100% limitation of liability only. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item 80_100 Code Sk
| Description | A code indicating that the amount shown in the payment field on the non-institutional line item represents either 80% or 100% of the allowed charges less any deductible, or 100% limitation of liability only. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item 80_100 Descr
| Description | A code indicating that the amount shown in the payment field on the non-institutional line item represents either 80% or 100% of the allowed charges less any deductible, or 100% limitation of liability only. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 Control Num
| Description | An identifying reference number assigned by the submitter/provider to this line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| 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 |
Line Note Txt
| Description | Free form narrative text providing additional information related to the claim line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Low Income Cost Sharing Level Cd
| Description | Identifies and describes the low income cost sharing (LICS) level |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Low Income Cost Sharing Level Code Descr
| Description | Identifies and describes the low income cost sharing (LICS) level |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Low Income Cost Sharing Level Code Sk
| Description | Identifies and describes the low income cost sharing (LICS) level |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
National Drug Code Num
| Description | Identifies prescription and non-prescription drugs. NDC codes reflect the manufacturer or distributor, the product code, drug formulation, strength, dosage form (tablet or capsule), and package size. The National Drug Code Directory is managed by the US Food and Drug Administration (FDA). For example: 10-digit 3-segment number: 12345-678-90 |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| 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 |
Non-Covered Reason Cd
| Description | Indicates why submitted charges were not covered. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Non-Covered Reason Code Descr
| Description | Indicates why submitted charges were not covered. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Non-Covered Reason Code Sk
| Description | Indicates why submitted charges were not covered. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [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 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 |
Onset Dt
| Description | The date of the onset of the condition being treated. |
| 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 |
Other Coverage Exists Ind
| Description | Indicator that coverage exists under another coverage agreement or policy for this claim line. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Out Of Area Claim Ind
| Description | Indicates whether or not the claimed procedure was rendered outside of the healthcare insurer's normal service area or geography in which they normally do business. 0 = In Area Treatment 1 = Out Of Area Treatment |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| 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 Group Num
| Description | An identifier for the patient group assigned to the patient on this claim. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
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 |
Pharmacy Claim Line Item Status Reason Cd
| Description | Indicates why a change was made to the status of a pharmacy claim line item. For example: Drug not covered for patient age Non-matched cardholder ID Non-matched prescriber ID Prior authorization required Refill too soon |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Claim Line Item Status Reason Code Descr
| Description | Indicates why a change was made to the status of a pharmacy claim line item. For example: Drug not covered for patient age Non-matched cardholder ID Non-matched prescriber ID Prior authorization required Refill too soon |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Claim Line Item Status Reason Code Sk
| Description | Indicates why a change was made to the status of a pharmacy claim line item. For example: Drug not covered for patient age Non-matched cardholder ID Non-matched prescriber ID Prior authorization required Refill too soon |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Co-Payment Basis Cd
| Description | Indicates how co-payment amounts were calculated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Co-Payment Basis Code Descr
| Description | Indicates how co-payment amounts were calculated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Co-Payment Basis Code Sk
| Description | Indicates how co-payment amounts were calculated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Dispensing Fee Basis Cd
| Description | Indicates how dispensing fee amounts were calculated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Dispensing Fee Basis Code Descr
| Description | Indicates how dispensing fee amounts were calculated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Dispensing Fee Basis Code Sk
| Description | Indicates how dispensing fee amounts were calculated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
Pharmacy Level Of Service Cd
| Description | Indicates the level of service the provider rendered on a pharmacy claim line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Level Of Service Code Descr
| Description | Indicates the level of service the provider rendered on a pharmacy claim line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Level Of Service Code Sk
| Description | Indicates the level of service the provider rendered on a pharmacy claim line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Reimbursement Basis Cd
| Description | Indicates how the reimbursement amount was calculated for a pharmacy claim line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Reimbursement Basis Code Descr
| Description | Indicates how the reimbursement amount was calculated for a pharmacy claim line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Reimbursement Basis Code Sk
| Description | Indicates how the reimbursement amount was calculated for a pharmacy claim line item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Service Reason Cd
| Description | A code identifying the type of utilization conflict detected or the reason for the pharmacist's professional service. For example: Additional drug needed Additive toxicity Adverse drug reaction Chronic disease management Drug-allergy Drug-drug interaction Excessive quantity Non-formulary drug Prescriber consultation Preventive health care Sub optimal compliance |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Service Reason Code Descr
| Description | A code identifying the type of utilization conflict detected or the reason for the pharmacist's professional service. For example: Additional drug needed Additive toxicity Adverse drug reaction Chronic disease management Drug-allergy Drug-drug interaction Excessive quantity Non-formulary drug Prescriber consultation Preventive health care Sub optimal compliance |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Service Reason Code Sk
| Description | A code identifying the type of utilization conflict detected or the reason for the pharmacist's professional service. For example: Additional drug needed Additive toxicity Adverse drug reaction Chronic disease management Drug-allergy Drug-drug interaction Excessive quantity Non-formulary drug Prescriber consultation Preventive health care Sub optimal compliance |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Service Result Cd
| Description | Indicates action taken by a pharmacist in response to a conflict or the result of a pharmacists professional service. For example: 0=Not Specified, 1A=Filled As Is False Positive, 1B=Filled Prescription As Is, 1C=Filled With Different Dose, 1D=Filled With Different Directions, 1E=Filled With Different Drug, 1F=Filled With Different Quantity, 1G=Filled With Prescriber Approval |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Service Result Code Descr
| Description | Indicates action taken by a pharmacist in response to a conflict or the result of a pharmacists professional service. For example: 0=Not Specified, 1A=Filled As Is False Positive, 1B=Filled Prescription As Is, 1C=Filled With Different Dose, 1D=Filled With Different Directions, 1E=Filled With Different Drug, 1F=Filled With Different Quantity, 1G=Filled With Prescriber Approval |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Service Result Code Sk
| Description | Indicates action taken by a pharmacist in response to a conflict or the result of a pharmacists professional service. For example: 0=Not Specified, 1A=Filled As Is False Positive, 1B=Filled Prescription As Is, 1C=Filled With Different Dose, 1D=Filled With Different Directions, 1E=Filled With Different Drug, 1F=Filled With Different Quantity, 1G=Filled With Prescriber Approval |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Physician Assistant Discount Cd
| Description | Indicates the discount given based on the fact that the service was provided by a medical assistant. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Physician Assistant Discount Code Sk
| Description | Indicates the discount given based on the fact that the service was provided by a medical assistant. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Physician Assistant Discount Descr
| Description | Indicates the discount given based on the fact that the service was provided by a medical assistant. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Place Of Service Cd
| Description | Indicates the type of facility where services were performed or may be performed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Place Of Service Code Sk
| Description | Indicates the type of facility where services were performed or may be performed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Place Of Service Descr
| Description | Indicates the type of facility where services were performed or may be performed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Policy Compliance Cd
| Description | Indicates policy compliance. For example: Procedure Followed (Compliance) Not Followed - Call Not Made (Non-Compliance Call Not Made) Not Medically Necessary (Non-Compliance Non-Medically Necessary) Not Followed Other (Non-Compliance Other) Emergency Admit to Non-Network Hospital |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Policy Compliance Code Sk
| Description | Indicates policy compliance. For example: Procedure Followed (Compliance) Not Followed - Call Not Made (Non-Compliance Call Not Made) Not Medically Necessary (Non-Compliance Non-Medically Necessary) Not Followed Other (Non-Compliance Other) Emergency Admit to Non-Network Hospital |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Policy Compliance Descr
| Description | Indicates policy compliance. For example: Procedure Followed (Compliance) Not Followed - Call Not Made (Non-Compliance Call Not Made) Not Medically Necessary (Non-Compliance Non-Medically Necessary) Not Followed Other (Non-Compliance Other) Emergency Admit to Non-Network Hospital |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 Methodology Cd
| Description | Indicates the pricing method by which the claim or line item has been priced or repriced. For example: Zero Pricing (Not Covered Under Contract) Priced as Billed at 100% Priced at the Standard Fee Schedule Priced at a Contractual Percentage Bundled Pricing Peer Review Pricing Per Diem Pricing Flat Rate Pricing Combination Pricing Maternity Pricing Other Pricing Lower of Cost Ratio of Cost Cost Reimbursed Adjustment Pricing |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pricing Methodology Code Sk
| Description | Indicates the pricing method by which the claim or line item has been priced or repriced. For example: Zero Pricing (Not Covered Under Contract) Priced as Billed at 100% Priced at the Standard Fee Schedule Priced at a Contractual Percentage Bundled Pricing Peer Review Pricing Per Diem Pricing Flat Rate Pricing Combination Pricing Maternity Pricing Other Pricing Lower of Cost Ratio of Cost Cost Reimbursed Adjustment Pricing |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pricing Methodology Descr
| Description | Indicates the pricing method by which the claim or line item has been priced or repriced. For example: Zero Pricing (Not Covered Under Contract) Priced as Billed at 100% Priced at the Standard Fee Schedule Priced at a Contractual Percentage Bundled Pricing Peer Review Pricing Per Diem Pricing Flat Rate Pricing Combination Pricing Maternity Pricing Other Pricing Lower of Cost Ratio of Cost Cost Reimbursed Adjustment Pricing |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 |
Principal Procedure Ind
| Description | An indicator to show whether this claim line represents the most significant service in the treatment covered by this claim. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prior Authorization Num
| Description | A number, code or other value that indicates the services provided on this claim have been authorized by the payee or other service organization, or that a referral for services has been approved. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Professional Pharmacy Service PPS Cd
| Description | Professional pharmacy services (PPS) codes defined by NCPDP are used to document requests for and delivery of professional services by pharmacists to their patients who are enrolled in pharmacy service benefit plans. PPS codes define the reason for service (conflict), the professional service rendered (intervention) and the result of service (outcome). For example: AS=Patient assessment CC=Coordination of care, DE=Dosing evaluation/determination, FE=Formulary enforcement, GP=Generic product selection, M=Prescriber consulted MA=Medication administration, MR=Medication review, No intervention PA=Patient consulted PE=Patient education/instruction, PH=Patient medication history, PM=Patient monitoring, PT=Perform laboratory test, RA=Pharmacist consulted other source RT=Recommend laboratory test, SC=Self-care consultation, SW=Literature search/review, TC=Payer/processor consulted, TH=Therapeutic product interchange |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Professional Pharmacy Service PPS Code Descr
| Description | Professional pharmacy services (PPS) codes defined by NCPDP are used to document requests for and delivery of professional services by pharmacists to their patients who are enrolled in pharmacy service benefit plans. PPS codes define the reason for service (conflict), the professional service rendered (intervention) and the result of service (outcome). For example: AS=Patient assessment CC=Coordination of care, DE=Dosing evaluation/determination, FE=Formulary enforcement, GP=Generic product selection, M=Prescriber consulted MA=Medication administration, MR=Medication review, No intervention PA=Patient consulted PE=Patient education/instruction, PH=Patient medication history, PM=Patient monitoring, PT=Perform laboratory test, RA=Pharmacist consulted other source RT=Recommend laboratory test, SC=Self-care consultation, SW=Literature search/review, TC=Payer/processor consulted, TH=Therapeutic product interchange |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Professional Pharmacy Service PPS Code Sk
| Description | Professional pharmacy services (PPS) codes defined by NCPDP are used to document requests for and delivery of professional services by pharmacists to their patients who are enrolled in pharmacy service benefit plans. PPS codes define the reason for service (conflict), the professional service rendered (intervention) and the result of service (outcome). For example: AS=Patient assessment CC=Coordination of care, DE=Dosing evaluation/determination, FE=Formulary enforcement, GP=Generic product selection, M=Prescriber consulted MA=Medication administration, MR=Medication review, No intervention PA=Patient consulted PE=Patient education/instruction, PH=Patient medication history, PM=Patient monitoring, PT=Perform laboratory test, RA=Pharmacist consulted other source RT=Recommend laboratory test, SC=Self-care consultation, SW=Literature search/review, TC=Payer/processor consulted, TH=Therapeutic product interchange |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
Prognosis Cd
| Description | Indicates the outlook attributed to the patient for this service line based on condition and the diagnosis. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prognosis Code Sk
| Description | Indicates the outlook attributed to the patient for this service line based on condition and the diagnosis. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prognosis Descr
| Description | Indicates the outlook attributed to the patient for this service line based on condition and the diagnosis. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
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 |
Received Dt
| Description | The date upon which the claim line was received by an administrator. |
| 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 |
Reimbursement Dt
| Description | The date upon which the provider was reimbursed for the product or service. |
| 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 |
Reject Reason Cd
| Description | Indicates the reason for rejection of the claim line. For example: Cannot Identify Provider as TPO (Third Party Organization) Participant Cannot Identify Payer as TPO (Third Party Organization) Participant Cannot Identify Insured as TPO (Third Party Organization) Participant Payer Name or Identifier Missing Certification Information Missing Claim does not contain enough information for re-pricing |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Reject Reason Code Sk
| Description | Indicates the reason for rejection of the claim line. For example: Cannot Identify Provider as TPO (Third Party Organization) Participant Cannot Identify Payer as TPO (Third Party Organization) Participant Cannot Identify Insured as TPO (Third Party Organization) Participant Payer Name or Identifier Missing Certification Information Missing Claim does not contain enough information for re-pricing |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Reject Reason Descr
| Description | Indicates the reason for rejection of the claim line. For example: Cannot Identify Provider as TPO (Third Party Organization) Participant Cannot Identify Payer as TPO (Third Party Organization) Participant Cannot Identify Insured as TPO (Third Party Organization) Participant Payer Name or Identifier Missing Certification Information Missing Claim does not contain enough information for re-pricing |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 Ambulatory Patient Group Cd
| Description | Identifies the ambulatory patient group (APG) assigned to the claim by the repricer. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Repriced Approved Ambulatory Patient Group Code Sk
| Description | Identifies the ambulatory patient group (APG) assigned to the claim by the repricer. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Repriced Approved Ambulatory Patient Group Descr
| Description | Identifies the ambulatory patient group (APG) assigned to the claim by the repricer. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 Line Item Reference Num
| Description | An identification number of a line item repriced by a third party or prior payer. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| 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 |
Resident in CMS Qualified Facility Ind
| Description | Indicates that the patient resides in a facility that qualifies for CMS benefits. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Revenue Cd
| Description | The field indicates the surrogate key for revenue codes that are 3-digit numbers that are used on hospital bills to tell the insurance companies either where the patient was when they received treatment, or what type of item a patient might have received as a patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Revenue Code Num
| Description | Revenue codes are 3-digit numbers that are used on hospital bills to tell the insurance companies either where the patient was when they received treatment, or what type of item a patient might have received as a patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Revenue Code Sk
| Description | The field indicates the surrogate key for revenue codes that are 3-digit numbers that are used on hospital bills to tell the insurance companies either where the patient was when they received treatment, or what type of item a patient might have received as a patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Revenue Descr
| Description | The field indicates the surrogate key for revenue codes that are 3-digit numbers that are used on hospital bills to tell the insurance companies either where the patient was when they received treatment, or what type of item a patient might have received as a patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 |
Secondary Payment Ind
| Description | Secondary Payment Indicator. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| 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 Delivery Times
| Description | The times of the day that services are rendered. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Time [TIME] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 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 |
Service Unit Type Cd
| Description | Describes one unit of the service provided. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Service Unit Type Code Sk
| Description | Describes one unit of the service provided. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Similar Illness Dt
| Description | The date upon which a similar illness or symptom began. |
| 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 |
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 Descr
| Description | The description that corresponds to the Source Type Cd. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 |
Source Descr
| Description | Source of the data for this row. For Claims and related data the source could be a Patient Administration feed, Lab System Feed, Claims System feed, or some other related feed. This code can be used to indicate the relative data quality of the row represented. eg: For a claim: this should identify pre adjudicated [provider] or post adjudicated [payor]. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| 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 |
Test Performed Dt
| Description | The date upon which a specific test is completed for a patient. |
| 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 |
Therapeutic Class Code Num
| Description | The therapeutic class that indicates the accepted purpose of the drug. This may be based on an external classification scheme or a regulatory body definition (e.g. CMS), or for internal use (e.g. diabetes care). For example: Antibiotic Antipsychotic COX2 inhibitor |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Type Cd
| Description | The code that corresponds to the Type 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 |
Type Code Descr
| Description | The description that corresponds to the Type Cd. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Type Code Sk
| Description | The code identifying the actual type of the entity as per the type hierarchy defined in the analysis 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 |
Universal Product Num
| Description | An industry standard code identifying supplies and materials. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| 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 |
| Primary Key Details |
Claim Line Dimension PK
| Key Attribute | Claim Line Dk |
| Dimensional Warehouse Model Data Model |