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
Not available for Data Standard 2.2, as the underlying entities were added in Data Standard 3.
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 |
---|---|---|---|
StudentSchoolKey | String | "{Student.StudentUniqueId}-{School.SchoolId}" | Surrogate key so that modeling tools will have a unique primary key |
StudentKey | String | Student.StudentUniqueId | |
SchoolKey | String | School.SchoolId | |
InternetAccessInResidence | String | Indicator from StudentEducationOrganizationAssociationStudentIndicator if available, otherwise "n/a" | |
InternetAccessTypeInResidence | String | Indicator from StudentEducationOrganizationAssociationStudentIndicator if available, otherwise "n/a" | |
InternetPerformance | String | Indicator from StudentEducationOrganizationAssociationStudentIndicator if available, otherwise "n/a" | |
DigitalDevice | String | Indicator from StudentEducationOrganizationAssociationStudentIndicator if available, otherwise "n/a" | |
DeviceAccess | String | Indicator from StudentEducationOrganizationAssociationStudentIndicator if available, otherwise "n/a" |