Data Lake Schema– Activity

Important

After careful consideration we are currently not onboarding new customers to the Education Data Lake Export feature.

We understand that this might be inconvenient, and we encourage you to direct educators to the Insights tab in the classes they own. This will allow teachers to utilize the available data to inform and enhance their teaching.

We appreciate your understanding during this transition.

Education data lake Export allows an Education data lake customer to get a copy of the Insights data lake in their own custom analytics using Azure Data Share services. Export uses Data Share to copy blobs from the Microsoft subscription into the customer Azure subscription. Data Share generates a snapshot of the Insights data that can be exported to an organization’s Azure Data Lake. Data Share helps simplify this process to securely export data. Organizations can then use Microsoft Synapse, Azure Machine Learning, and/or Power BI to create their own customized analytics and reports.

With Education Insights signal data in their Azure Data Lake, organizations can then combine it with other data sources such as SIS, LMS, or assessment data.

Along with Activity data captured when Education data lake Export is enabled, the snapshot will also contain a copy of the Student Information System (SIS) / Student Management System (SMS) roster data has been captured, along with Microsoft Entra ID. Learn more here: - Data Lake Schema – Rostering - Data Lake Schema – Microsoft Entra ID

Note

Activity data is only stored in SDS's Data Lake if Education data lake Export is enabled.

Category	Column	Data Type	Column Description
All	SignalType	String	Sharepoint:
			Like
			Unlike
			FileAccessed
			FileModified
			FileDownloaded
			FileUploaded
			ShareNotificationRequested
			AddedToSharedWithMe
			CommentCreated
			CommentDeleted
			UserAtMentioned
			Teams Channel:
			PostChannelMessage
			ReplyChannelMessage
			VisitTeamChannel
			ExpandChannelMessage
			ReactedWithEmoji
			Teams Meeting:
			CallRecordSummarized
			Assignment Services:
			AssignmentEvent
			SubmissionEvent
			OneNote:
			OneNotePageChanged
			Reading progress:
			ReadingAssignment
			ReadingSubmission
			Reflect (is the signal type)
All	StartTime	DateTime	Action time
All	UserAgent	String	Device information
All	SignalId	String	Can be used to remove potential signal duplications
All	SisClassId	String	Only for tenants running SDS [empty is the sample]
All	ClassId	String	Office Group ID
All	ChannelId	String	Optional, the channel in which action took place. In some cases such as AS signal empty==general. In cases of meetings this will identify the channel the meeting took place and hence can be used as a meeting ID.
All	AppName	String	Application used: Assignments, SharePoint Online, Teams, OneDrive for Business, OneNote, TeamsMobile, ReadingProgress, Reflect
All	ActorId	String	Microsoft Entra Object ID
All	ActorRole	String	Student – only for tenants running SDS
All	SchemaVersion	Real	Technical, used to track data changes or bugs in the export
Assignments	AssignmentId	String	GUID, identifies the assignment. Can be used to access Graph for more information.
Assignments	SubmissionId	String	GUID, identifies the student submission. Can be used to access Graph for more information.
Assignments	SubmissionCreatedTime	DateTime	Time the submission was created.
Assignments, Reflect, Reading Progress	Action	String	Assigned (also for Reading Progress), Updated, Returned, Visited (also for Reading Progress), Submitted, Unsubmitted, Deleted, FeedbackSubmitted (also for Reflect), CardPosted (Reflect), EditMiscue (Reading Progress), Submit (Reading Progress), Attempt (Reading Progress)
Assignments	DueDate	DateTime	Assignments due date
All	ClassCreationDate	DateTime	Time the class was created
Assignments	Grade	String	Optional. Submission grade points. Example: 100 (when action = Returned)
Files	SourceFileExtension	String	For file signals, captures the type of file: aspx, docx, web, mp4, jpg, pptx, etc.
Meetings	Meeting Duration	TimeSpan	Duration in seconds the student spent in the meeting
Meetings	Meeting Session ID	String	The meeting session ID
Meetings	Meeting type	String	The meeting type
Reading Progress	ReadingSubmissionWordsPerMinute	Int	Student submission result, reading pace
Reading Progress	ReadingSubmsssionAccuracyScore	Real	Student submission result, reading progress accuracy score
Reading Progress	ReadingSubmissionMispronunciationCount	Int	Per student attempt, number of works mispronounced
Reading Progress	ReadingSubmissionRepetitionsCount	Int	Per student attempt, number of words repeated
Reading Progress	ReadingSubmissionInsertionsCount	Int	Per student attempt, number of words inserted
Reading Progress	ReadingSubmissionObmissionCount	Int	Per student attempt, number of works omitted
Reading Progress	ReadingSubmissionAttemptNumber	Int	Index of student attempts
Reading Progress	ReadingAssignmentWordCount	Int	Assignment details – number of works in the text of the assignment. Student submission definition – total number of words the user read.
Reading Progress	ReadingAssignmentFleschKincaidGradeLevel	Real	Only in the Assignment definition signals (not per student attempt)
Reading Progress	ReadingAssignmentLanguag	String	Only in the assignment definition signals (not per student attempt)