| Business Data Model Data Model |
| Description | A set of prices defined for each item that can be used in the course of delivering healthcare or managing facilities. |
| Relationship | |
 Charge Master Price_Charge Master_FK |
|
| Charge Master Price_Organization_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Charge Active Ind
| Description | Indicates whether this is a usable charge master item. |
| 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 |
Charge Begin Ts
| Description | The date and time the price associated with the charge master item is effective from. |
| 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 |
Charge Billable Ind
| Description | Indicates if the charge master item is billable or not. For Example: N - charge is not billable, that is, do not create charges for this charge master iM entry; this is zero price item Y - item is billable |
| 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 |
Charge Billing Category Code
| Description | The billing category codes for any classification systems used. For Example: General ledger codes UB92 categories |
| 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 |
Charge Calculation Formula Txt
| Description | The textual description of the mathematical formula used to calculate the total price cost amount for the charge master item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Charge End Ts
| Description | The date and time the price associated with the charge master item is no longer in use. |
| 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 |
Charge Maximum Identical Charges Cnt
| Description | Indicates the maximum number of identical charges allowed on one patient's billing account for a charge master item. |
| 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 |
Charge Maximum Price Amt
| Description | The maximum total price (after computation of components of price) that can be charged for a charge master item. |
| 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 |
Charge Minimum Identical Charges Cnt
| Description | Indicates the minimum number of identical charges allowed on one patient's billing account for a charge master item. |
| 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 |
Charge Minimum Price Amt
| Description | The minimum total price (after computation of components of price) that can be charged for a charge master item. |
| 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 |
Charge On Code
| Description | Indicates when a charge for services or procedures should be accrued. For Example: Charge on order Charge on result |
| 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 |
Charge Price Cost Amt
| Description | The calculation of how much it costs to provide this item, that is, what the institution had to pay for the material plus any specified payment expenditure, effort or loss due to performing or providing the charge master item. |
| 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 |
Charge Price Type
| Description | Indicates the kind of price assigned to an charge master item. For Example: Administrative price or handling fee Direct unit cost Indirect unit cost Professional fee for performing provider Technology fee for use of equipment Total price Unit price, may be based on length of procedure or service |
| 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 |
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 |
| Relationship Details |
Charge Master Price_Charge Master_FK
| Is Identifying Relationship | true |
| Child Table | Charge Master Price |
| Child Role Name | detail of |
| 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 | Charge Master |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Charge Master Price_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Charge Master Price |
| Child Role Name | revenue provided 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 | Organization |
| 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 |