Atomic Warehouse Model Data Model

Entity

Entity Supplier Transaction Detail

Description

A financial transaction that the healthcare organization conducts with a vendor of goods or services.

Attributes
Adjudication Type Code Sk
Advance Payment Ind
Advance Payment Rt
Batch Num
Channel Code Sk
Check Num
Currency Code Sk
Debit Or Credit Ind
Denial Ts
Effective From Dt
Effective To Dt
Exchange Rt
Financial Transaction Dt
Financial Transaction Posted Dt
Financial Transaction Type Code Sk
Financial Transaction Value Dt
Immediate Payment Ind
Load Info Sk
Originating Currency Amt
Payee Type Code Sk
Payer Type Code Sk
Payment Approach Code Sk
Payment Channel Code Sk
Payment Clearance Dt
Payment Due Dt
Payment Due Period End Dt
Payment Due Period Start Dt
Payment Receipt Dt
Payment Rejection Dt
Payment Rejection Reason Code Sk
Payment Settlement Method Code Sk
Plan Transaction Num
Processing Engine Code Sk
Schedule Ind Code Sk
Sender Transaction Num
Source Code Sk
Supplier Financial Transaction 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
Valid From Ts
Valid To Ts

Relationship
SupplierTransaction Detail_Supplier Financial Transaction_FK

Primary Key
Supplier 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

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

Channel Code Sk

Description	The method used for the payment For example: Check Wire transfer
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

Check Num

Description	A reference number identifying the bank check used for 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 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

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

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

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

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

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

Description	The method used for the payment For example: Check Wire transfer
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 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

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

Supplier Financial Transaction Sk

Description	Surrogate key for the Supplier 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

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 amount to be posted to the patient 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 Financial 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

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

SupplierTransaction Detail_Supplier Financial Transaction_FK

Is Identifying Relationship	true
Child Table	Supplier 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	Supplier 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

Supplier Transaction Detail PK

Key Attribute	Supplier Financial Transaction Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model