StudentInternetAccessDim View - Experimental

July 22, 2021

This view is already in the main branch and will be included in the Analytics Middle Tier version 2.5.0. This is considered experimental functionality with its initial release and may be subject to significant changes during the course of ongoing work with the /wiki/spaces/SKD/pages/26841349. Because of the experimental nature, patch releases of the Analytics Middle Tier might have breaking changes in this view, so it is not recommended that anyone take a hard dependency on this view until further notice.

Purpose

Describe's a Student's Internet Access, as defined for a student's relationship with the school.

SQL Object

analytics.AcademicTimePeriodDim

Usage Notes

(error) Not available for Data Standard 2.2, as the underlying entities were added in Data Standard 3.

(warning) As with many other views, this query relies on the Student's relationship with an EducationOrganization, via the StudentEducationOrganization  table in the ODS. Thus it is possible that the Student's InternetAccess could be recorded for the student's relationship with one or more agency, including School, Local Education Agency, Service Network, etc. For this view's purpose, only the School relationship is considered. Data recorded for any other type of Education Agency will be ignored.

For more information on recording appropriate student indicator data for Internet Access, please see /wiki/spaces/EFDSDRAFT/pages/22773854.

Sources

Data Standard 2.2

Not available for Data Standard 2.

Data Standard 3+

There are five joins to the StudentEducationOrganizationAssociationStudentIndicator , one for each of the following indicators:

  • InternetAccessInResidence
  • InternetAccessTypeInResidence
  • InternetPerformance
  • DigitalDevice
  • DeviceAccess

Structure

Same for both 2.2 and 3+ data standards.

Column

Data Type

Source

Description

StudentSchoolKeyString"{Student.StudentUniqueId}-{School.SchoolId}"Surrogate key so that modeling tools will have a unique primary key
StudentKeyStringStudent.StudentUniqueId
SchoolKeyStringSchool.SchoolId
InternetAccessInResidenceString

Indicator from 

StudentEducationOrganizationAssociationStudentIndicator 

if available, otherwise "n/a"


InternetAccessTypeInResidenceString

Indicator from 

StudentEducationOrganizationAssociationStudentIndicator 

if available, otherwise "n/a"


InternetPerformanceString

Indicator from 

StudentEducationOrganizationAssociationStudentIndicator 

if available, otherwise "n/a"


DigitalDeviceString

Indicator from 

StudentEducationOrganizationAssociationStudentIndicator 

if available, otherwise "n/a"


DeviceAccessString

Indicator from 

StudentEducationOrganizationAssociationStudentIndicator 

if available, otherwise "n/a"