Atomic Warehouse Model Data Model

Entity

Entity Account Agreement Detail

Description

An agreement between a healthcare organization and an account holder related to the management of an account.

Attributes
Account Agreement Type Code Sk
Agreement Descr
Agreement End Dt
Agreement Past Due Status Code Sk
Agreement Sk
Agreement Start Dt
Agreement Status Code Sk
Agreement Status Reason Code Sk
Allow Multi Currency Balances Ind
Allow Multi Currency Transactions Ind
Bound Dt
Effective From Dt
Effective To Dt
Endorsement Code Sk
Interest Posting Frequency Code Sk
Line Of Business Code Sk
Load Info Sk
Minimum Monthly Repayment
Next Renewal Dt
Next Review Dt
Planned End Dt
Selected Currency Code Sk
Source Code Sk
Tax Status Ind
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Account Agreement Detail_Agreement_FK

Primary Key
Account Agreement Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Account Agreement Type Code Sk

Description	Classifies account agreement according to the nature or purpose of the Account Agreement.
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

Agreement Descr

Description	Textual description of the Agreement.
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

Agreement End Dt

Description	The date upon which the agreement actually terminates. This may pre- or post-date the Planned End Date. For example, early termination of a contract due to poor performance. The termination date of the agreement is also represented in the status date for the terminated status.
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

Agreement Past Due Status Code Sk

Description	Classifies account agreement according to the length of time that the account agreement has been delinquent with respect to due 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

Agreement Sk

Description	The generated surrogate key of the Agreement anchor.
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

Agreement Start Dt

Description	The date upon which the agreement first starts. For renewable agreements, this date represents the date of the original agreement before any renewal. Derived from the status related information.
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

Agreement Status Code Sk

Description	Indicates the agreement's current status. For Example: Active Cancelled Expired Final In Force In Process Initial Lapsed Not taken up Offered Rejected Suspended Terminated Under Negotiation
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

Agreement Status Reason Code Sk

Description	Indicates the motivation or cause for changing the Agreement Status of the agreement. For example: Not eligible (if agreement rejected) Not taken up (if agreement 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

Allow Multi Currency Balances Ind

Description	Indicates whether the account can hold balances in multiple currencies.
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

Allow Multi Currency Transactions Ind

Description	Indicates whether the account holder can make transactions in multiple currencies on this account.
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

Bound Dt

Description	The date upon which the agreement is considered legally binding, or in force. Depending on the legislation the bound date can be the date when the agreement is signed by both parties and/or when the first premium has been paid. Derived from the status related information.
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

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

Endorsement Code Sk

Description	Indicates the type of card endorsement according to whether the card has the stamp or endorsement of a third party such as a non-profit organization, for promotional purposes. For example: Non-endorsed Private
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

Interest Posting Frequency Code Sk

Description	Classifies account agreement according to the frequency at which interest is posted on the account agreement. This usually depends on the type of account but individual exceptions are possible.
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

Line Of Business Code Sk

Description	Indicates the nature of commercial enterprise of the modeled 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

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

Minimum Monthly Repayment

Description	The minimum proportion of the outstanding balance which must be paid by the owner monthly.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Next Renewal Dt

Description	The next date at which the enforce status of the agreement must be re-evaluated or re-conducted.
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

Next Review Dt

Description	The date upon which a review of the agreement is planned.
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

Planned End Dt

Description	The date upon which the end of the agreement is planned.
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

Selected Currency Code Sk

Description	Indicates the currency as selected by the customer to be used on any monetary information provided to the customer.
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

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

Tax Status Ind

Description	Indicates whether or not taxing is required.
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

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

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

Account Agreement Detail_Agreement_FK

Is Identifying Relationship	true
Child Table	Account Agreement 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	Agreement
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Account Agreement Detail PK

Key Attribute	Agreement Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model