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

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

get_currently_enrolled_students()

Value

a tbl_sql SQL Server object.


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