Overview

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

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

.