Integrated Data

Integrated Data Types

By integrating your Ajera on-premise data with Mosaic, you will be able to import the following:

  • Employees
  • Clients
  • Project, Phases and Tasks
  • Time Entries
  • Labor Codes

Mosaic is constantly working on adding more features to our integrations; you can expect additional data points to be added to your integration in the near future!

Integrated Data Fields

Data Sources

Ajera On-Premise Data Types

Mosaic Data Types

Employees

  • Name
  • Email
  • Title

Employees

  • Name
  • Email
  • Title

Clients

  • Name

Clients

  • Title

Project, Phases and Tasks

  • Description
  • Fee
  • Client (Projects only)
  • Start/Completion Dates

Project, Phases and Work Categories

  • Title
  • Fee
  • Client (Projects only)
  • Schedules

Timesheets

  • Date
  • Hours
  • Employee
  • Project
  • Phase
  • Labor Code
  • Notes
  • Billable
  • Rate

Time Entries

  • Date
  • Hours
  • Employee
  • Project
  • Phase
  • Work Category
  • Description
  • Billable
  • Rate

Labor Codes

  • Title
  • Number

Work Categories

  • Title
  • Number

Unsupported Data Sources

  • Changing field names in Mosaic to match custom labelling in Ajera
  • Integrating Data Types that are not explicitly listed in the Ajera Integration Documentation
  • Creating reports for exporting data from Ajera
  • Resolving duplicate Time Entry data imported as user error

Extended Data Fields

Replicated Data

Mosaic replicates a subset of the data tables that are available in Ajera on-premise. The following tables will be included in your replication:

Table Name

Fields

Usage in Mosaic

AxActivity

actKey
actDescription
actType

Time Entry integration

AxCompany

cmpKey
cmpDescription

Project integration

AxEntity

eKey
eDescription
eOverheadPercent

Project integration

AxInvoiceGroup

igKey
igClient
igProject

Project/Client integration

AxProject

prjKey
prjStatus
prjDescription
prjID
prjProjectType
prjProjectManager
prjPrincipalInCharge
prjMarketingContact
prjLocation
prjEstimatedStartDate
prjEstimatedCompletionDate
prjActualStartDate
prjActualCompletionDate
prjApplySalesTax
prjSalesTaxCode
prjSalesTaxRate
prjHoursCostBudget
prjLaborCostBudget
prjExpenseCostBudget
prjConsultantCostBudget
prjBillingType
prjTotalContractAmount
prjLaborContractAmount
prjExpenseContractAmount
prjConsultantContractAmount
prjBillLaborAsTE
prjBillExpenseAsTE
prjBillConsultantAsTE
prjConstructionCost
prjPercentOfConstructionCost
prjBillingDescription
prjNotes
prjEntity
prjIsCertified
prjInvoiceGroup
prjSummarizeBillingGroup
prjPercentDistribution
prjProject
prjPhaseLevel1
prjPhaseLevel2
prjPhaseLevel3
prjPhaseLevel4
prjPhaseLevel5
prjPhaseLevel6
prjFinalBudget
prjLockFee
prjLaborCostRate
prjLaborFeeRate
prjRequireTimeSheetNotes
prjState
prjLocalTax
prjCompany
prjTimeEntryRestriction
prjLastModifiedDate
prjLaborEntry
prjExpenseConsultantEntry

Project integration

AxProjectType

ptKey
ptDescription

Project integration

AxTransaction

tKey
tDate
tProject
tEmployee
tActivity
tRow
tUnits
tCostRate
tEarnedRate
tEarnedAmount
tBilledUnits
tBilledRate
tBilledAmount
tNotes

Time Entry integration

AxVEC

vecKey
vecStatus
vecEmail
vecIsEmployee
vecFirstName
vecMiddleName
vecLastName
vecTitle
vecDateHired
vecDescription
vecIsClient
vecLastModifiedDate

Employee integration

As Mosaic works on adding more data points to our integration with Deltek Ajera on-premise, this list may change. When a new feature is added to Mosaic, you can expect your Customer Success Manager to reach out requesting access to your server to update your replication.