Data Models

What is the Legal Metrics Data Model?

A Data Model is like a view, a “virtual table” that sits on top of your actual data table. Data Models are used to support specific metrics reports. Legal Metrics has developed standard Data Models for your onboarding convenience.

The Legal Metrics Data Model used to locally aggregate your data has 2 data sources:

These 2 data sources are necessary for all Legal Metrics standard reports. The data sources have multiple data tables and fields that are used by your Local Calculator.

Think of the data source tables and fields as a set of spreadsheets that are combined to calculate business management metrics on your behalf.

Legal Metrics Data Models can seamlessly map to your data sources, link your data with your business logic, and expose enriched datasets to relevant end-users for self-exploration through interactive reports. See the bottom right hand corner of this diagram (and read on) to see where this data fits into your business analytics flow:

Accounting Tables

Projects

Field Label	Data Type	Calculator Usage	Value/Example
projectId	varchar	Join ID	Source System ID
name	varchar	Metric Dependency	For display purposes
companyId	varchar	Join ID	Source System ID
country	varchar	Metric Dependency	USA
city	varchar	Metric Dependency	Anytown
department	varchar	Metric Dependency	Corporate, Litigation
practice	varchar	Metric Dependency	Finance, M&A
feeType	varchar	Metric Dependency	Fixed, Hourly
isActive	bit	Metric Dependency	Yes, No
sourceCreatedDate	date	Metric Dependency	6/25/2020

Companies

Field Label	Data Type	Calculator Usage	Value/Example
companyID	varchar	Join ID	Source System ID
name	varchar	Metric Dependency	For display purposes
isActive	bit	Metric Dependency	Yes, No
sourceCreatedDate	bit	Metric Dependency	9/25/2012

People

Field Label	Data Type	Calculator Usage	Value/Example
sourceUserId	varchar	Join ID	Source System ID
companyUserId	varchar	Join ID	Source System ID
isActive	bit	Metric Dependency	Yes, No
sourceCreatedDate	date	Metric Dependency	7/25/2017

ProjectsTime

Field Label	Data Type	Calculator Usage	Value/Example
projectsTimeId	varchar	Join ID	Source System ID
projectId	varchar	Join ID	Source System ID
sourceUserId	varchar	Join ID	Source System ID
hoursDecimal	decimal	Metric Dependency	28.25
hours	varchar	Metric Dependency	28
minutes	int	Metric Dependency	25
isBilled	bit	Metric Dependency	Yes, No
invoiceId	varchar	Join ID	Source System ID
sourceCreatedDate	date	Metric Dependency	6/28/2020

Invoices

Field Label	Data Type	Calculator Usage	Value/Example
invoiceId	varchar	Join ID	Source System ID
invoiceStatus	varchar	Metric Dependency	Active, Complete
invoiceDateSent	date	Metric Dependency	6/25/2020
fixedCost	bit	Metric Dependency	Yes, No
fixedCostValue	decimal	Metric Dependency	$50,000

ProjectsPeople

Field Label	Data Type	Calculator Usage	Value/Example
projectsPeopleId	varchar	Join ID	Source System ID
projectId	varchar	Join ID	Source System ID
sourceUserId	varchar	Metric Dependency	Source System ID
leadsProject	bit	Metric Dependency	Yes, No
startedDate	decimal	Metric Dependency	4/25/2022
finishedDate	decimal	Metric Dependency	6/25/2022

InvoicesPeople

Field Label	Data Type	Calculator Usage	Value/Example
invoicesPeopleId	varchar	Join ID	Source System ID
invoiceID	varchar	Join ID	Source System ID
sourceUserId	varchar	Join ID	Source System ID
roleRate	decimal	Metric Dependency	$400

Human Resources Tables

People

Field Label	Data Type	Calculator Usage	Value/Example
sourceUserId	varchar	Join ID	Source System ID
companyUserId	varchar	Join ID	Source System ID
firstName	varchar	Metric Dependency	Luke
lastName	varchar	Metric Dependency	Morrison
department	varchar	Metric Dependency	Corporate, Litigation
practice	varchar	Metric Dependency	Finance, M&A
jobTitle	varchar	Metric Dependency	Associate, Partner
country	varchar	Metric Dependency	USA
city	varchar	Metric Dependency	Houston
sourceCreatedDate	date	Metric Dependency	6/25/2015
gender	varchar	Metric Dependency	Male, Female, Other, Skip
ethnicity	varchar	Metric Dependency	White, African American, Hispanic, Skip
isLGBTQ	bit	Metric Dependency	Yes, No, Skip
isDisabled	bit	Metric Dependency	Yes, No, Skip
isMilitary	bit	Metric Dependency	Yes, No, Skip
isActive	bit	Metric Dependency	Yes, No
isFTE	bit	Metric Dependency	Yes, No
hourlyRoleRate	decimal	Metric Dependency	$250