| 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 | |
![]() |
Dependencies | |
![]() |
|
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Key Attribute | Claim Line Dk |
| Dimensional Warehouse Model Data Model |