| Business Data Model Data Model |
| Description | A record that tracks balances of an item of value to the organization. Can be financial (currency denominated) or unit based (for example, Inventory). |
| Relationship | |
 Account_Account_FK |
|
| Account_Budget_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Account Code
| Description | Indicates the specific type of the account being tracked. |
| 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 |
Account Descr
| Description | A free-form textual description of what is represented by the account. |
| 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 |
Accounting Scenario
| Description | Indicates the nature of the value represented by the account balance. For example: Actual Budget Estimated Forecast |
| 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 |
Account Name
| Description | A word or phrase used to identify (but not uniquely) the account. |
| 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 |
Account Num
| Description | Account Num is an identifier used by the healthcare organization to identify an individual account. |
| 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 |
Account Opening Date
| Description | The date upon which the account is opened and is ready for transactions. |
| 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 |
Account Status Date
| Description | The effective date for the account status. For example: Account is pending with effect from 01/05/2013 |
| 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 |
Account Status Reason
| Description | Indicates why the account status was changed to its current state. |
| 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 |
Account Status Type
| Description | The lifecycle state that the account is currently in. For example: Submitted For Approval Pending Open Open Pending Closed Closed Pending Deletion |
| 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 |
Account Type
| Description | Indicates the major classification or grouping to which an account naturally belongs. For example: Expense Revenue Asset Statistical |
| 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 |
Balance Amt
| Description | The current value or amount of the account. Can be derived from all the amounts posted in account entries for 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 |
Closing Date
| Description | The date upon which the account status is changed to closed. |
| 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 |
Debit Credit
| Description | Indicates whether an account or an entry is a debit or a credit. |
| 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 |
Measurement Period Type
| Description | Indicates the balance calendar period. For example: Day Week Month Quarter Half Year |
| 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 |
Period Balance Type
| Description | Indicates the method by which the amount reflected by the account balance is calculated. For example: Amount Maximum Minimum Mean Median Mode Total Total Average Net |
| 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 |
Point Balance Type
| Description | Indicates the nature of the point in time within an interval of time at which the account balance was recorded. For example: Beginning or Opening Balance Interim Balance - Statement Balance - Capital Balance - YTD Balance End or Closing Balance |
| 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 |
| Relationship Details |
Account_Account_FK
| Is Identifying Relationship | false |
| Child Table | Account |
| Child Role Name | is related to |
| 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 |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Account_Budget_FK
| Description | A relationship between an occurrence of Account and an occurrence of Budget. Typically to a Budget to track the Account. |
| Is Identifying Relationship | false |
| Child Table | Account |
| Child Role Name | has budget |
| 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 | Budget |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |