Entity Fee Schedule Item

DescriptionAn item from a list of specified and agreed amounts payable.

Attributes
Fee AmtFee Amt
Fee Schedule Item CodeFee Schedule Item Code
Item Co-Payment AmtItem Co-Payment Amt
Item Co-Payment PctItem Co-Payment Pct
Service Fee UnitsService Fee Units
Standard Service Fee AmtStandard Service Fee Amt

Relationship
Fee Schedule Item_Order Master_FKFee Schedule Item_Order Master_FK
Fee Schedule Item_Fee Schedule_FKFee Schedule Item_Fee Schedule_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Fee Amt
DescriptionThe amount to be charged for the given Procedure/Diagnosis/DRG/Medication code under the terms of the given agreement.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fee Schedule Item Code
DescriptionIdentifies the item on the fee schedule.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Co-Payment Amt
DescriptionThe specific co-payment amount applying to a Procedure/Diagnosis/DRG/Medication fee from a Fee Schedule under the terms of the given agreement.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Co-Payment Pct
DescriptionThe specific co-payment percentage applying to a Procedure/Diagnosis/DRG/Medication fee from a Fee Schedule under the terms of the given agreement.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Service Fee Units
DescriptionThe service fee units associated with the given Procedure/Diagnosis/DRG/Medication code under the terms of the given agreement.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Standard Service Fee Amt
DescriptionThe amount normally charged for the given Procedure/Diagnosis/DRG/Medication code.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Fee Schedule Item_Order Master_FK
Is Identifying Relationshipfalse
Child TableFee Schedule Item
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrder Master
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Fee Schedule Item_Fee Schedule_FK
Is Identifying Relationshipfalse
Child TableFee Schedule Item
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFee Schedule
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE