Skip to main content
All CollectionsProduct Support and How to?Lean Insights
Lean Insights Data: Activities Dataset
Lean Insights Data: Activities Dataset

Data dictionary for the Activities Dataset available as part of Lean Insight's custom reporting solution.

Gabe Blanchet avatar
Written by Gabe Blanchet
Updated over a year ago

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

Did this answer your question?