Tables [dbo].[NAW_ChargeList]
Charges associated with a Note
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_NAW_ChargeList_ID: ID\ChargeIDID[dbo].[uniqueid]9NOT NULLKey to the NAW_ChargeList table
Cluster Primary Key PK_NAW_ChargeList_ID: ID\ChargeIDForeign Keys FK_NAW_ChargeList_ChargeID_Charge_ID: [dbo].[Charge].ChargeIDChargeID[dbo].[uniqueid]9NOT NULLChange number within the note
ChargeUnitnumeric(16,8)9NOT NULL((0))Charge Units
StartDTTMdatetime8NOT NULL(getdate())Start time for a time based charge
EndDTTMdatetime8NULL allowedEnd time for a time based charge
Commentsvarchar(500)500NULL allowedComments
IsDeletedFlagchar(1)1NULL allowed('N')Deleted (Y/N)?
EncounterChargeID[dbo].[uniqueid]9NOT NULLCharge. Link to Charge.ID