Dimensional Warehouse Model Data Model

Entity

Entity Payment Dimension

Description

Details about a payment and its individual pay items.

Attributes
Adjudication Type Cd
Adjudication Type Code Descr
Adjudication Type Code Sk
Advanced Beneficiary Notice Cd
Advanced Beneficiary Notice Code Descr
Advanced Beneficiary Notice Code Sk
Advance Payment Ind
Advance Payment Rt
AWM Load Info Sk
Batch Num
Check Num
Currency Cd
Currency Code Descr
Currency Code Sk
Current Ind
Debit Or Credit Ind
Denial Ts
DWM Load Info Sk
Effective From Dt
Effective To Dt
Exchange Rt
Extended Amt
Fee Schedule Cd
Fee Schedule Code Descr
Fee Schedule Code Sk
Filler Order Num
Financial Transaction Dt
Financial Transaction Posted Dt
Financial Transaction Type Cd
Financial Transaction Type Code Descr
Financial Transaction Type Code Sk
Financial Transaction Value Dt
Immediate Payment Ind
Item Qty
Medically Necessary Duplicate Procedure Reason Cd
Medically Necessary Duplicate Procedure Reason Code Descr
Medically Necessary Duplicate Procedure Reason Code Sk
NDC Cd
NDC Code Descr
NDC Code Sk
Originating Currency Amt
Patient Type Cd
Patient Type Code Descr
Patient Type Code Sk
Payee Type Cd
Payee Type Code Descr
Payee Type Code Sk
Payer Type Cd
Payer Type Code Descr
Payer Type Code Sk
Pay Item Seq
Pay Item Status Cd
Pay Item Status Code Descr
Pay Item Status Code Sk
Pay Item Status Descr
Payment Approach Cd
Payment Approach Code Descr
Payment Approach Code Sk
Payment Bk
Payment Clearance Dt
Payment Dk
Payment Due Dt
Payment Due Period End Dt
Payment Due Period Start Dt
Payment Num
Payment Receipt Dt
Payment Reference Num
Payment Rejection Dt
Payment Rejection Reason Cd
Payment Rejection Reason Code Descr
Payment Rejection Reason Code Sk
Payment Settlement Method Cd
Payment Settlement Method Code Descr
Payment Settlement Method Code Sk
Payment Sk
Payment Status Cd
Payment Status Code Descr
Payment Status Code Sk
Payment Status Descr
Plan Transaction Num
Procedure Cd
Procedure Code Descr
Procedure Code Sk
Processing Engine Cd
Processing Engine Code Descr
Processing Engine Code Sk
Schedule Ind Cd
Schedule Ind Code Descr
Schedule Ind Code Sk
Sender Transaction Num
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Third Party Transaction Num
Transaction Amt
Transaction Cd
Transaction Cnt
Transaction Code Descr
Transaction Code Sk
Transaction Currency Cd
Transaction Currency Code Descr
Transaction Currency Code Sk
Transaction Descr
Transaction Num
Transaction Posted Ts
Transaction Reason
Transaction Status Cd
Transaction Status Code Descr
Transaction Status Code Sk
Transaction Status Reason Cd
Transaction Status Reason Code Descr
Transaction Status Reason Code Sk
Transaction Submit Type Cd
Transaction Submit Type Code Descr
Transaction Submit Type Code Sk
Transaction Ts
Transaction Type Cd
Transaction Type Code Descr
Transaction Type Code Sk
Transaction Value Dt
Type Cd
Type Code Descr
Type Code Sk
Unit Amt
Unit Cost
Valid From Ts
Valid To Ts

Primary Key
Payment Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Adjudication Type Cd

Description	Indicates the nature of the adjudication of the payment request.
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

Adjudication Type Code Descr

Description	Indicates the nature of the adjudication of the payment request.
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

Adjudication Type Code Sk

Description	Indicates the nature of the adjudication of the payment request.
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

Advanced Beneficiary Notice Cd

Description	Status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures, (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed 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

Advanced Beneficiary Notice Code Descr

Description	Status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures, (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed 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

Advanced Beneficiary Notice Code Sk

Description	Status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures, (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed 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

Advance Payment Ind

Description	Indicates whether the payment is being made in advance of attaining some relevant information or the occurrence of some significant event.
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

Advance Payment Rt

Description	The rate used for an advance payment, based upon a percentage of estimated reimbursement.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
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

Batch Num

Description	The batch number for the financial transaction.
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

Check Num

Label	AP Check Number
Description	The check number for the payment.
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

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 Descr

Description	Indicates the currency used as the basis for all monetary amounts.
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

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

Debit Or Credit Ind

Description	Indicates whether the financial transaction was a debit or credit.
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

Denial Ts

Description	Date upon which the request for payment was denied.
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

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

Exchange Rt

Description	The exchange rate applied to the transaction amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Extended Amt

Description	The amount of a patient financial transaction. May be the total price for multiple items.
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

Fee Schedule Cd

Description	Standard charges for goods and services within an organization.
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

Fee Schedule Code Descr

Description	Standard charges for goods and services within an organization.
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

Fee Schedule Code Sk

Description	Standard charges for goods and services within an organization.
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

Filler Order Num

Description	The number used by a filler to uniquely identify a result. Used when the billing system is requesting observational reporting justification for a charge.
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

Financial Transaction Dt

Description	The date upon which the financial transaction occurred. For Example: The date a transaction is sent out to a recipient. The date the payment is made in case of payments.
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

Financial Transaction Posted Dt

Description	The date upon which the transaction was recorded.
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

Financial Transaction Type Cd

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
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

Financial Transaction Type Code Descr

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
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

Financial Transaction Type Code Sk

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
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

Financial Transaction Value Dt

Description	The date upon which the transaction is closed off as completed, from the perspective of the organization.
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

Immediate Payment Ind

Description	Indicates whether a payment should be executed immediately.
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

Item Qty

Description	Quantity of items associated with this Patient Financial Transaction.
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

Medically Necessary Duplicate Procedure Reason Cd

Description	Indicates the reason why a duplicate procedure for the same patient within the same date of service has been determined to be medically necessary.
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

Medically Necessary Duplicate Procedure Reason Code Descr

Description	Indicates the reason why a duplicate procedure for the same patient within the same date of service has been determined to be medically necessary.
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

Medically Necessary Duplicate Procedure Reason Code Sk

Description	Indicates the reason why a duplicate procedure for the same patient within the same date of service has been determined to be medically necessary.
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

NDC Cd

Description	Indicates a unique identification code used for any drug intended for human use.
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

NDC Code Descr

Description	Indicates a unique identification code used for any drug intended for human use.
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

NDC Code Sk

Description	Indicates a unique identification code used for any drug intended for human use.
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

Originating Currency Amt

Description	The amount paid in the originating currency.
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 Type Cd

Description	Indicates the type code assigned to the patient for an episode of care (visit or stay).
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

Patient Type Code Descr

Description	Indicates the type code assigned to the patient for an episode of care (visit or stay).
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

Patient Type Code Sk

Description	Indicates the type code assigned to the patient for an episode of care (visit or stay).
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

Payee Type Cd

Description	Indicates the type of payee in the financial transaction.
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

Payee Type Code Descr

Description	Indicates the type of payee in the financial transaction.
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

Payee Type Code Sk

Description	Indicates the type of payee in the financial transaction.
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

Payer Type Cd

Description	Indicates the type of payer in the financial transaction.
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

Payer Type Code Descr

Description	Indicates the type of payer in the financial transaction.
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

Payer Type Code Sk

Description	Indicates the type of payer in the financial transaction.
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

Pay Item Seq

Description	The sequential number of the pay item on the invoice.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pay Item Status Cd

Description	Indicates the general ledger activity type.
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

Pay Item Status Code Descr

Description	Indicates the general ledger activity type.
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

Pay Item Status Code Sk

Description	Indicates the general ledger activity type.
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

Pay Item Status Descr

Description	Describes the general ledger activity type.
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

Payment Approach Cd

Description	Indicates the plan or strategy of payment. For example: Partial Payment Payment in Advance Payment on Account
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

Payment Approach Code Descr

Description	Indicates the plan or strategy of payment. For example: Partial Payment Payment in Advance Payment on Account
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

Payment Approach Code Sk

Description	Indicates the plan or strategy of payment. For example: Partial Payment Payment in Advance Payment on Account
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

Payment 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

Payment Clearance Dt

Description	The date upon which the payment is confirmed to be cleared.
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

Payment 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

Payment Due Dt

Description	The date upon which the payment is due to be received by the payee.
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

Payment Due Period End Dt

Description	The date upon which the payment period (the period for which the payment due is created) ends for this payment due. For example: The period end date for the premium due related to the period 12/1/2001 to 12/1/2002 is the 12/1/2002.
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

Payment Due Period Start Dt

Description	The date upon which the payment period (the period for which the payment due is created) starts for this payment due. For example: The period start date for the premium due related to the period 12/1/2001 to 12/1/2002 is the 12/1/2001.
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

Payment Num

Description	A document reference number such as a payment reference or invoice reference as stored in the source ERP application.
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

Payment Receipt Dt

Description	The date upon which the money is available to the recipient of the payment.
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

Payment Reference Num

Description	The payment reference number of the payment medium reported.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Payment Rejection Dt

Description	The date upon which this payment has been rejected.
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

Payment Rejection Reason Cd

Description	Indicates the reason for which the payment has been rejected.
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

Payment Rejection Reason Code Descr

Description	Indicates the reason for which the payment has been rejected.
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

Payment Rejection Reason Code Sk

Description	Indicates the reason for which the payment has been rejected.
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

Payment Settlement Method Cd

Description	Indicates the method used for money transfer between financial organizations. For example: ACH Book Entry CHAPS CHIPS Concentrator Corporate Trade Exchange Draft Epay Fended RPS SWIFT
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

Payment Settlement Method Code Descr

Description	Indicates the method used for money transfer between financial organizations. For example: ACH Book Entry CHAPS CHIPS Concentrator Corporate Trade Exchange Draft Epay Fended RPS SWIFT
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

Payment Settlement Method Code Sk

Description	Indicates the method used for money transfer between financial organizations. For example: ACH Book Entry CHAPS CHIPS Concentrator Corporate Trade Exchange Draft Epay Fended RPS SWIFT
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

Payment 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

Payment Status Cd

Description	Indicates the general ledger activity type.
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

Payment Status Code Descr

Description	Indicates the general ledger activity type.
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

Payment Status Code Sk

Description	Indicates the general ledger activity type.
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

Payment Status Descr

Description	Describes the general ledger activity type.
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

Plan Transaction Num

Description	Transaction number recorded on the patient's Plan system.
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

Procedure Cd

Description	A unique code that identifies a procedure within a coding system. Standard procedure code sets include Current Procedural Terminology (CPT), SNOMED and Healthcare Common and Universal Billing (UB) Revenue codes.
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

Procedure Code Descr

Description	A unique code that identifies a procedure within a coding system. Standard procedure code sets include Current Procedural Terminology (CPT), SNOMED and Healthcare Common and Universal Billing (UB) Revenue codes.
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

Procedure Code Sk

Description	Indicates a procedure within a code set or code type. Standard procedure code sets include Current Procedural Terminology (CPT) and Universal Billing (UB) Revenue codes.
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

Processing Engine Cd

Description	The application and/or mainframe or server used to process the payment.
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

Processing Engine Code Descr

Description	The application and/or mainframe or server used to process the payment.
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

Processing Engine Code Sk

Description	The application and/or mainframe or server used to process the payment.
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

Schedule Ind Cd

Description	Indicates whether the transaction is a part of a schedule of payments.
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

Schedule Ind Code Descr

Description	Indicates whether the transaction is a part of a schedule of payments.
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

Schedule Ind Code Sk

Description	Indicates whether the transaction is a part of a schedule of payments.
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

Sender Transaction Num

Description	Transaction number assigned by the sending system. Eases communication regarding the transaction.
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

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

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

Third Party Transaction Num

Description	Transaction number recorded on the Third Party payor or processor's system.
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

Transaction Amt

Description	The monetary amount that is posted to the account.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Transaction Cd

Description	Indicates a unique transaction code per transaction type (a procedure, supply item, or test for charges) as defined by the institution.
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

Transaction Cnt

Description	Indicates the count of transactions.
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

Transaction Code Descr

Description	Indicates a unique transaction code per transaction type (a procedure, supply item, or test for charges) as defined by the institution.
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

Transaction Code Sk

Description	Indicates a unique transaction code per transaction type (a procedure, supply item, or test for charges) as defined by the institution.
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

Transaction 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

Transaction Currency Code Descr

Description	Indicates the currency used as the basis for all monetary amounts.
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

Transaction 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

Transaction Descr

Description	Description of the transaction.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transaction Num

Description	A number assigned by the sending system to the transaction for control purposes. The number can be returned by the receiving system to identify errors.
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

Transaction Posted Ts

Description	The date upon which the transaction was recorded.
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

Transaction Reason

Description	Indicates the reason why a transaction of a given type is being made.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transaction Status Cd

Description	Indicates the status of the transaction. For example: Replaced Stopped Unallocated Valued Written off
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

Transaction Status Code Descr

Description	Indicates the status of the transaction. For example: Replaced Stopped Unallocated Valued Written off
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

Transaction Status Code Sk

Description	Indicates the status of the transaction. For example: Replaced Stopped Unallocated Valued Written off
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

Transaction Status Reason Cd

Description	Payment Status Reason classifies financial transactions according to the motivation for changing the Status of the financial transaction.
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

Transaction Status Reason Code Descr

Description	Payment Status Reason classifies financial transactions according to the motivation for changing the Status of the financial transaction.
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

Transaction Status Reason Code Sk

Description	Payment Status Reason classifies financial transactions according to the motivation for changing the Status of the financial transaction.
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

Transaction Submit Type Cd

Description	Indicates the type of submitted transaction. For Example: Electronic Claim Paper Electronic Payment POS Payment
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

Transaction Submit Type Code Descr

Description	Indicates the type of submitted transaction. For Example: Electronic Claim Paper Electronic Payment POS Payment
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

Transaction Submit Type Code Sk

Description	Indicates the type of submitted transaction. For Example: Electronic Claim Paper Electronic Payment POS Payment
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

Transaction Ts

Description	The date upon which the financial transaction occurred. For Example: The date a transaction is sent out to a recipient. The date the payment is made in case of payments.
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

Transaction Type Cd

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
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

Transaction Type Code Descr

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
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

Transaction Type Code Sk

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
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

Transaction Value Dt

Description	The date upon which the transaction is closed off as completed, from the perspective of the organization.
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

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 Amt

Description	Unit price of one unit of the item referenced by the patient financial transaction.
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

Unit Cost

Description	The unit cost of a transaction.
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

Payment Dimension PK

Key Attribute

Payment Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model