StaffSectionDim View

Owned by David Clements
May 26, 2021
1 min read

Purpose

Attributes related to a staff's leading a section. Part of the Core View Collection.

SQL Object

analytics.StaffSectionDim

Usage Notes

Instead of providing a view with one row per section (SectionDim ), the StaffSectionDim provides one row per staff and section. 


Structure

ColumnData TypeSource Description
StaffSectionKeystring​Staff.StaffUniqueId, StaffSectionAssociation.SchoolId, StaffSectionAssociation.LocalCourseCode, 
StaffSectionAssociation.SchoolYear, StaffSectionAssociation.SectionIdentifier,
StaffSectionAssociation.SessionName		Primary Key
StaffUSIintStaff.StaffUSI
UserKeystringStaff.StaffUniqueId 
SchoolKeystringStaffSectionAssociation.SchoolId
SectionKeystring

Section.SchoolId, Section.LocalCourseCode, Section.SchoolYear, Section.SectionIdentifier, Section.SessionName


PersonalTitlePrefixstringStaff.PersonalTitlePrefix
FirstNamestring

Staff.FirstName


MiddleNamestringStaff.MiddleName
LastSurnamestringStaff.LastName
ElectronicMailAddressstringStaffElectronicMail.ElectronicMailAddress
SexTypestringStaff.SexDescriptorIdShort Description
BirthDatedatetimeStaff.BirthDateYYYY-MM-DD
RaceTypestringStaffRaceShort Description
HispanicLatinoEthnicitybooleanStaff.HispanicLatinoEthnicity
HighestCompletedLevelofEducationstringStaff.HighestCompletedLevelOfEducationDescriptorId Short Description
YearsOfPriorProfessionalExperiencedecimalStaff.YearsOfPriorProfessionalExperience
YearsOfPriorTeachingExperiencedecimalStaff.YearsOfPriorTeachingExperience
HighlyQualifiedTeacherbooleanStaff.HighlyQualifiedTeacher

Contents