BillingActivity

The BillingActivity.sql script is used by Billing To Milan to add shortcuts to the My Matters of users who have exceeded a certain number of hours billed for a particular matter.

When Billing To Milan is run either without any command line options or in matters mode, the following operations occur:

1. Billing To Milan executes the SELECT query in BIllingActivity.sql against the database specified in the billing connection string.
2. Billing To Milan updates the Milan.BillingActivity table, which keeps a running total of the hours billed by each attorney for every client matter.
3. If an attorney's total billing hours for a client matter exceeds the value specified in the billing-hours application setting, Billing To Milan creates a Provisioning Service job to add a shortcut for that particular matter to the attorney's My Matters.

Required Fields

Field Names	Description
ClientID	Custom1 field, which represents the Client ID.
MatterID	Custom2 field, which represents the Matter ID.
UserID	WorkSite user account for which Milan will create a My Matters shortcut.
Hours	The number of billing hours, in decimal format, for the given matter.

Optional Fields

Field Names	Description
MatterCategory	The category name or format under which Milan should create the shortcut in My Matters.