Atomic Warehouse Model Data Model

Entity

Entity Patient Financial Transaction Detail

Description

A financial transaction that pertains to a person who is being or has been treated by the healthcare organization.

For example:
Medication charge
Surgery Charge
Patient payment
Co-payment

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

Relationship
Patient Financial Transaction Detail_Patient Financial Transaction_FK

Primary Key
Patient Financial Transaction Detail PK

Dependencies

Reverse Dependencies

Attribute Details

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

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

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

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

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

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

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 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 Financial Transaction Sk

Description	Surrogate key for the Patient Financial Transaction data.
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	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 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 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

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

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 Code Sk

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/Surrogate Key [INTEGER]
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 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 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 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 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 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/Text Medium [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 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 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 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/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
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

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	true
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

Relationship Details

Patient Financial Transaction Detail_Patient Financial Transaction_FK

Is Identifying Relationship	true
Child Table	Patient Financial Transaction Detail
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Financial Transaction
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Patient Financial Transaction Detail PK

Key Attribute	Patient Financial Transaction Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model