The data dictionary listed below is for the LeanLaw-Prod - Activities v1 dataset available as part of the LeanInsights custom reporting solution. The Activities dataset contains information about time entries, fixed fees, and expenses combined to allow users to build reports based on that data. This data dictionary lists the field name, the type of data, and a description of what the data point is to allow users to easily determine how they should use the data.
Data Point | Type of Data | Definition |
CompanyId | GUID | Internal LeanLaw unique identifier for a company (firm); used to permission data |
InvoiceId | GUID | Internal LeanLaw unique identifier for an invoice |
Invoice Date | Date | Date of the invoice |
Invoice Number | String | Number assigned to the invoice to allow for the identification of invoices |
Invoice Status | String | Current status of the invoice; values include Approved, Closed, Deleted, Draft, Open, Review |
Activty Type | String | Indicates the type of activity; values include fixed fee, expense, and time entry |
Description | String | Description of the time entry, fixed fee, or expense as input by the relevant user |
Activity Id | GUID | Internal LeanLaw unique identifier for an activity; used to uniquely identify a fixed fee, expense, or time entry |
Created At | Date | Date at which the activity was created |
Activity Date | Date | Date of the activity |
Modified At | Date | Date at which the activity was modified |
Hours | Decimal | Amount of time entered for the particular time entry |
Billed Hours | Decimal | Amount of billable time entered for a particular time entry |
Write Down Hours | Decimal | Amount of time that has been written down for a particular time entry |
Billable Amount | Decimal | Dollar amount of the rate multiplied by the number of billed hours for a time entry |
Rate | Decimal | Dollar value of the rate that applied to a particular time entry |
Billable Activity Amount | Decimal | Amount of the activity; for expenses and fixed fees, the amount billed; for time entries the billable amount |
Value of Time | Decimal | Hours multiplied by the Rate associated with the time entry |
Activity Code | String | LEDES Activity Code for the associated activity entry |
Task Code | String | LEDES Task Code for the associated activity entry |
Amount | Decimal | The dollar amount of an expense or fixed fee; does not include time entry amounts |
FixedFee Type | String | Indicated the type of fixed fee; values include DateBased and CompletionBased |
FixedFee Recurrence | String | For recurring fixed fees, the time period of the recurrence; values include Month, Quarter, Year, Day, Week |
BIlling Type | String | Indicates the type of billing that applies to the time entry; values include fixed fee, billable and non-billable |
FixedFeeId | GUID | Internal LeanLaw unique identifier for a fixed fee; used to uniquely identify a fixed fee and link to fixed fee data |
UserId | GUID | Internal LeanLaw unique identifier for a user associated with the time entry, fixed fee or expense; used to permission data and uniquely identify a user |
User FullName | String | Full name of the user associated with the activity |
FixedFee Completion State | String | For completion based fixed fees, indicates the state of completion; values include NotCompleted and Completed |
Uesr FirstName | String | First name of the user associated with the activity |
User LastName | String | Last name of the user associated with the activity |
User Role | String | Assigned role of the user associated with the time entry, fixed fee, or expense; values include "Timekeeper", "Paralegal", "Attorney", "Principal", "Accountant", "Operator" |
User Initials | String | Initials of the user associated with the activity |
ClientId | GUID | Internal LeanLaw unique identifier for a company's client; used to uniquely identify clients |
Client Name | String | Name of the client |
Client Label | String | The client number and client name combined; if no client number is present then the value will reflect the client name alone |
Client Display Name | String | The display name of the client populated upon client set up |
MatterId | GUID | Internal LeanLaw unique identifier for a company's matter; used to uniquely identify matters |
Matter Name | String | Name of the matter |
Matter Label | String | Combination of matter reference and name of the matter |
Matter Reference | String | Reference number that can be used to track a specific matter, if provided |
Practice Area | String | Practice area associated with the time entry based on firm's designated practice areas |
Matter Opened | Date | Date at which the matter was opened |
Billed | Boolean | True or false indicator for a time entry about whether the time entry has a billed status or not |