Entity Money Item Adjustment

DescriptionA money item that is an amount or percentage (factor) that alters a money provision, a money provision element or a money provision element part, either by increasing it (surcharge adjustment) or decreasing it (discount adjustment).

For example:
A surcharge of 2% applied to the WAC cost of a box of 500 Latex Gloves.
A discount of 5% that applies to the total patient charge amount.

Attributes
Adjustment AmtAdjustment Amt
Adjustment ReasonAdjustment Reason
Factor RtFactor Rt

Relationship
Adjustment_Money Item_FKAdjustment_Money Item_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Adjustment Amt
DescriptionA fixed monetary value that increases or decreases the value of a money provision.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Adjustment Reason
DescriptionIndicates the motivation for changing the value of a money provision.

For example: 
Specialty program
Policy duration
Class of business
Amount of purchases
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Factor Rt
DescriptionA multiplier that is applied to a money provision that increases or decreases the value of the money provision.

For example:
105,65
0,98
Data TypeStandards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Adjustment_Money Item_FK
Is Identifying Relationshipfalse
Child TableMoney Item Adjustment
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableMoney Item
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeMoney Item
SubtypeMoney Item Adjustment
Transform AsTABLE