Skip to contents

make_fte_sql function will generate the standard SQL query for pulling Full-Time Equivalent (FTE) data from Edify.This function allows users to retrieve FTE data based on different available data sources. Use the type parameter to select the specific FTE data type. Available options are: "current", "census" and "eot" (end of term). For more details see the fte (full time quivalent) vignette. You can bring this up by running the following code in your console: vignette("full_time_equivalent", package = "utDataStoR") #' [Stable]

Source: R/make_fte_sql.R
make_fte_sql.Rd

make_fte_sql function will generate the standard SQL query for pulling Full-Time Equivalent (FTE) data from Edify.This function allows users to retrieve FTE data based on different available data sources. Use the type parameter to select the specific FTE data type. Available options are: "current", "census" and "eot" (end of term). For more details see the fte (full time quivalent) vignette. You can bring this up by running the following code in your console: vignette("full_time_equivalent", package = "utDataStoR") #' [Stable]

Usage

make_fte_sql(name, type = "current")

Arguments

name

The name you want the SQL file to have in your sql folder. This is a string and must be provided in quotes (e.g., "your_filename.sql").

type

The type of fte file you want. Defaults to 'current' fte data. Other options are

  • 'current' -- data as of the current snapshot

  • 'census_demographic' -- fte data with demographic data, as of census snapshot

  • 'eot' -- data as of the end of term snapshot

Value

A sql file in your SQL folder