enrollment.data.update: Query and update current enrollment data for a term

In UW-L-S-Academic-Information-Management/UWdataUTIL: UW R Admit Data Utils

Query and update current enrollment data for a term

Description

Returns a data frame and saves to a file of current enrollment data from the UW-Madison UW.STDNT_CRSE_ROSTER_MULTITERM.

Usage

  enrollment.data.update(TERM, INFOACCESScon, FILE)

Arguments

TERM	Char SIS term
INFOACCESScon	DBI connection to UW-Madison InfoAccess
FILE	csv file path with an existing data to be updated. Defaults to enrollment.csv in the current working directory. If no file exists it creates one.

Details

This function queries the course enrollment information for a specified term found in the UW.STDNT_CRSE_ROSTER_MULTITERM directory. It will update an existing data file with past enrollment information to create a time-stamped enrollment file. It also returns the data frame that is output to the csv file.

Examples

  INFOACCESScon <- DBI::dbConnect(odbc::odbc(), "INFOACCESS", uid="usr", pwd="password")
  enrollment.data.update("1232", INFOACCESScon)
  enrollment.data.update("1232", INFOACCESScon, "C:\R_Projects\Enrollment_Tracking\CourseEnrollments1232.csv")
  enrollment <- enrollment.data.update("1232", INFOACCESScon, "C:\R_Projects\Enrollment_Tracking\CourseEnrollments1232.csv")

UW-L-S-Academic-Information-Management/UWdataUTIL documentation built on April 25, 2022, 1:11 a.m.