Replacement for deprecated sis_source_id in enrollment_dim

[ismail_orabi]

Is there a way to differentiate between enrollments that are manually added vs imported via SIS? The field sis_source_id was used to do this and although still available through the API, it has been deprecated in the enrollment_dim table.

[stimme]

Hi  @ismail_orabi , 

The Enrollments API returns objects with an sis_import_id attribute that identifies the sis import that last updated the enrollment.  This value is null for manual enrollments.  I hope this helps!

[ismail_orabi]

Thanks  @stimme , but we'd like to use the Canvas Data flat files, if possible, in order to avoid the excessive API calls that are needed to retrieve this data across all enrollments.

As a workaround, we're currently using live events to capture enrollment_created and enrollment_updated events, which provide a job_id when triggered by a SIS Import.