get_currently_enrolled_students: Connect to 'Students' table on 'PROD1' in 'Schools' schema...

View source: R/get_PROD1.R

get_currently_enrolled_studentsR Documentation

Connect to Students table on PROD1 in Schools schema only pull currently enrolled students

Description

Specifically, pull students data where EnrollmentStatus == 0, RowIsCurrent = TRUE and SchoolTermID = max(SchoolTermID)

Usage

get_currently_enrolled_students()

Value

a ⁠tbl_sql SQL Server⁠ object.

Examples


# This attaches to the school db with \code{conn_PROD1} connection
## Not run: 
current <- get_currently_enrolled_students()

## End(Not run)


idea-analytics/ideadata documentation built on Feb. 1, 2024, 5:40 a.m.