Dimensional Warehouse Model Data Model

Entity

Entity Supplier Financial Transaction Fact

Description

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

Attributes
Account Dk
Account Sk
Adjudication Type Cd
Adjudication Type Code Sk
Advance Payment Ind
Advance Payment Rt
AWM Load Info Sk
Batch Num
Channel Cd
Channel Code Sk
Check Num
Currency Cd
Currency Code Sk
Current Ind
Debit Or Credit Ind
Denial Ts
Discount Lost Amt
Discount Taken Amt
DWM Load Info Sk
Effective From Dt
Effective To Dt
Exchange Rt
Financial Transaction Dt
Financial Transaction Posted Dt
Financial Transaction Type Cd
Financial Transaction Type Code Sk
Financial Transaction Value Dt
Immediate Payment Ind
Invoice Dk
Invoice Maximum Check Dt
Invoice Sk
Originating Currency Amt
Payee Type Cd
Payee Type Code Sk
Payer Type Cd
Payer Type Code Sk
Pay Item Maximum Check Dt
Payment Approach Cd
Payment Approach Code Sk
Payment Channel Cd
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 Cd
Payment Rejection Reason Code Sk
Payment Settlement Method Cd
Payment Settlement Method Code Sk
Payment Void Dt
Plan Transaction Num
Processing Engine Cd
Processing Engine Code Sk
Schedule Ind Cd
Schedule Ind Code Sk
Sender Transaction Num
Source Cd
Source Code Sk
Supplier Dk
Supplier Financial Transaction Bk
Supplier Financial Transaction Cnt
Supplier Financial Transaction Dk
Supplier Financial Transaction Sk
Supplier Sk
Tenant Sk
Third Party Transaction Num
Transaction Amt
Transaction Calendar Dk
Transaction Cd
Transaction Cnt
Transaction Code Sk
Transaction Currency Cd
Transaction Currency Code Sk
Transaction Descr
Transaction Dt
Transaction Num
Transaction Posted Calendar Dk
Transaction Posted Ts
Transaction Reason
Transaction Status Cd
Transaction Status Code Sk
Transaction Status Reason Cd
Transaction Status Reason Code Sk
Transaction Submit Type Cd
Transaction Submit Type Code Sk
Transaction Ts
Transaction Type Cd
Transaction Type Code Sk
Transaction Value Calendar Dk
Transaction Value Dt
Valid From Ts
Valid To Ts

Relationship
Supplier Financial Transaction Fact_Transaction Calendar Dimension_FK
Supplier Financial Transaction Fact_Organization Dimension_FK
Supplier Financial Transaction Fact_Invoice Dimension_FK
Supplier Financial Transaction Fact_Account Dimension_FK
Supplier Financial Transaction Fact_Poseted Calendar Dimension_FK
Supplier Financial Transaction Fact_Value Date Calendar Dimension_FK

Primary Key
Supplier Financial Transaction Fact PK

Dependencies

Reverse Dependencies

Attribute Details

Account 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Account 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

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

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

Channel Cd

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

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

Discount Lost Amt

Label	AP Discount Lost Amount
Description	This item is the value of the accounts payable discounts that were offered but not taken on fully paid pay 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

Discount Taken Amt

Label	AP Discount Taken Amount
Description	This item is the value of the accounts payable discounts that were claimed on payments made.
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

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

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

Invoice 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Invoice Maximum Check Dt

Label	AP Maximum Check Date for Invoice
Description	This item is the last payment date for the Invoice.
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

Invoice 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

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 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 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 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 Maximum Check Dt

Label	AP Maximum Check Date for Pay Item
Description	This item is the last payment date for the pay item.
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 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 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 Cd

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

Label	AP Payment Void Date
Description	The void date 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

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 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 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 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 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/Tenant Common Code [VARCHAR(80)]
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

Supplier 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

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

Supplier Financial Transaction Cnt

Description	Used to count fact rows. Always set to 1.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Default Value	1
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

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

Supplier 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

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	false
Is Derived	false
Is Surrogate Key	false

Transaction Calendar 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	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	false
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	false
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 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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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	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 Calendar 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	false
Is Required	true
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 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 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 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	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	false
Is Derived	false
Is Surrogate Key	false

Transaction Value Calendar 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	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	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

Relationship Details

Supplier Financial Transaction Fact_Transaction Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Supplier Financial Transaction Fact
Child Role Name	transaction date
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Supplier Financial Transaction Fact_Organization Dimension_FK

Is Identifying Relationship	false
Child Table	Supplier Financial Transaction Fact
Child Role Name	supplier
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	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Supplier Financial Transaction Fact_Invoice Dimension_FK

Is Identifying Relationship	false
Child Table	Supplier Financial Transaction Fact
Child Role Name	purchase invoice
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	Invoice Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Supplier Financial Transaction Fact_Account Dimension_FK

Is Identifying Relationship	false
Child Table	Supplier Financial Transaction Fact
Child Role Name	posted to payable account
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	Account Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Supplier Financial Transaction Fact_Poseted Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Supplier Financial Transaction Fact
Child Role Name	posted date
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Supplier Financial Transaction Fact_Value Date Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Supplier Financial Transaction Fact
Child Role Name	value date
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	Calendar Dimension
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 Financial Transaction Fact PK

Key Attribute

Supplier Financial Transaction Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model