admissions.data.update: Query and update current admissions data for a set of terms

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

Query and update current admissions data for a set of terms

Description

Returns a data frame and saves to a file of current admissions data for UW-Madison from UW.STDNT_UGRD_APPLICANT.

Usage

  admissions.data.update(TERMS, INFOACCESScon, FILE)

Arguments

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

Details

This function queries the admissions information for specified terms for UW-Madison. It will update an existing data file with past admissions 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")
  admissions.data.update(c("1226", "1232"), INFOACCESScon)
  admissions.data.update(c("1226", "1232"), INFOACCESScon, "C:\R_Projects\Enrollment_Tracking\Admissions1232.csv")
  admissions <- admissions.data.update(c("1226", "1232"), INFOACCESScon, "C:\R_Projects\Enrollment_Tracking\Admissions1232.csv")

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