Overview

The attached excel workbook lists the common fields found in the Aptem OData feed. The data is stored across 22 tables listed below.

1. ApprenticeshipFinancialRecords
2. AwardingBodyQualifications
3. ComplianceDocuments
4. CrmActivities
5. DestinationProgressions
6. EmployerGroups
7. Episodes
8. Groups
9. IlrAims
10. Jobs
11. LearnerEmployment
12. LearningPlanComponents
13. Messages
14. Milestones
15. Notes
16. OnboardingResponses
17. OrganizationContacts
18. Organizations
19. Reviews
20. Tasks
21. Trackers
22. Users

The exact list of fields will vary across customer systems depending on the use of bespoke data collection in, for example, reviews and onboarding processes.

To view the list of fields in your account, use the url:  https://your_tenant_name.aptem.co.uk/odata/1.0/$metadata

The attached excel file lists all common fields, and can be filtered by table, fieldname etc. Example data/descriptions are also provided for some fields.

.