Purpose

Supports row-level security / authorization by linking a Student with the Schools and Sections ("classes") in which the student is enrolled. Part of the Row-Level Security Collection.

SQL Object Name

analytics.rls_StudentDataAuthorization

Data Definition and Sources

Note that this is returning the uniqueidentifier [Id] column from Section instead of using the natural key, because the natural key is too long to be practical when concatenating into a single column.

Column	Source Table	Source Column or Value	Data Type
StudentKey	Student	StudentUniqueId	int
SchoolKey	StudentSectionAssociation	SchoolId	int
SectionKey	Section	Id	nvarchar
BeginDate	StudentSectionAssociation	BeginDate	date
EndDate	StudentSectionAssociation	EndDate	date

Contents

Ed-Fi Tools

rls_StudentDataAuthorization View

Purpose

SQL Object Name

Data Definition and Sources