Business Data Model Data Model

Entity

Entity Financial Transaction

Description

An agreement, communication or movement that creates, alters, or settles a monetary liability.

Attributes
Adjudication Type Cd
Advance Payment Ind
Advance Payment Rt
Batch Num
Currency
Debit Or Credit Ind
Denial Ts
Exchange Rt
Financial Transaction Date
Financial Transaction Posted Date
Financial Transaction Type
Financial Transaction Value Date
Immediate Payment Ind
Originating Currency Amt
Payee Type
Payer Type
Payment Approach
Payment Clearance Date
Payment Due Date
Payment Due Period End Date
Payment Due Period Start Date
Payment Receipt Date
Payment Rejection Date
Payment Rejection Reason
Payment Settlement Method
Plan Transaction Num
Processing Engine
Schedule Ind
Sender Transaction Num
Third Party Transaction Num
Transaction Amt
Transaction Cnt
Transaction Descr
Transaction Num
Transaction Reason
Transaction Status
Transaction Status Reason
Transaction Submit Type Cd
Transaction Ts

Relationship
Financial Transaction_Financial Transaction_FK
Financial Transaction_Encounter_FK
Financial Transaction_Party Name_FK
Financial Movement executes Payment
Financial Transaction_Document_FK
Financial Transaction_Party_FK

Dependencies
NONE

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/Enumeration [VARCHAR(20)]
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

Currency

Description	The currency that is used as the basis for all monetary amounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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

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 Date

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 Date

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

Description	Indicates the type of financial transaction. For example: Charges Credits Adjustments Payments Co-payments
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Financial Transaction Value Date

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

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

Description	Indicates the type of payee in the financial transaction.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Payer Type

Description	Indicates the type of payer in the financial transaction.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Payment Approach

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Payment Clearance Date

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 Date

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 Date

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 Date

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 Date

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 Date

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

Description	Indicates the reason for which the payment has been rejected.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Payment Settlement Method

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/Enumeration [VARCHAR(20)]
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

Description	The application, mainframe or server used to process the payment.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Schedule Ind

Description	Indicates whether the transaction is a part of a schedule of payments.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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

Third Party Transaction Num

Description	The transaction number that is 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 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 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

Description	Indicates the status of the transaction. For example: Replaced Stopped Unallocated Valued Written off
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transaction Status Reason

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/Enumeration [VARCHAR(20)]
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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transaction Ts

Description	The date and time when the transaction actually occurred.
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

Relationship Details

Financial Transaction_Financial Transaction_FK

Is Identifying Relationship	false
Child Table	Financial Transaction
Child Role Name	transaction reference
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	Financial Transaction
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Financial Transaction_Encounter_FK

Is Identifying Relationship	false
Child Table	Financial Transaction
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	Encounter
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Financial Transaction_Party Name_FK

Is Identifying Relationship	false
Child Table	Financial Transaction
Child Role Name	entered by
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	Party Name
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Financial Movement executes Payment

Is Identifying Relationship	false
Child Table	Financial Transaction
Child Role Name	is executed by
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Financial Movement
Parent Role Name	executes
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Financial Transaction_Document_FK

Is Identifying Relationship	false
Child Table	Financial Transaction
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	Document
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Financial Transaction_Party_FK

Is Identifying Relationship	false
Child Table	Financial Transaction
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	Party
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model