Integrated Data
Integrated Data Types
By integrating your Ajera on-premise data with Mosaic, you will be able to import the following:
- Employees
- Clients
- Projects
- Phases
- Time Entries
- Work Categories
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 - Title | Employees - Name - Title |
| Clients - Name | Clients - Title |
| Project and Phases - 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 - Activity - Notes - Billable - Rate | Time Entries - Date - Hours - Employee - Project - Phase - Work Category - Description - Billable - Rate |
| Activities - 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
Please Note:
If there is a data endpoint not listed in this documentation and it is required for your integration, it will be a customization, charged at an hourly rate.
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 prjOrder prjDescription prjID prjProjectType prjProjectManager prjPrincipalInCharge prjMarketingContact prjLocation prjEstimatedStartDate prjEstimatedCompletionDate prjActualStartDate prjActualCompletionDate prjApplySalesTax prjSalesTaxCode prjSalesTaxRate prjHoursCostBudget prjLaborCostBudget prjExpenseCostBudget prjConsultantCostBudget prjBillingType prjRateTable 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 tOriginalTransaction tType tBeginningBalanceType tDate tProject tEmployee tActivity tActivityType tTimesheet tRow tStatus tUnits tCostRate tEarnedRate tEarnedAmount tBilledUnits tBilledRate tBilledAmount tNotes tIsDeleted tIsCurrent | 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.
Updated 3 months ago