get_banner_snapshots: get_banner_snapshots

In iancj88/msuopa: Utility Functions for the MSU OPA Team

Description

get_banner_snapshots

Usage

get_banner_snapshots(year, sql_file_name, by = "week", debug_date,
  include_leave = FALSE, opt_banner_conn)

Arguments

year	calendar year overwhich snapshots will be pulled. For one date only, see debug_date
sql_file_name	optional file name and path if an alternative sql query is needed. Defaults to OPA snapshot sql query.
by	a character vector containing one of "day", "week", "month", "quarter", or "year". Alternatively, may be a numeric integer. Used to determine the date sequence from which the sql queries are built.
debug_date	an optional date used to specify a single date to run for a snapshot. Will supersede any values used in year or by parameters
include_leave	an optional boolean value indicating whether or not to include LWOP and LWOP/WB (with Benefits) Jobs in the snapshot
opt_banner_conn	an active banner connection object typically derived from get_banner_conn(). If not provided will create a temp connection

Value

a list of snapshot query returns. The names of the list items specify the date on which query is set.

iancj88/msuopa documentation built on May 17, 2019, 7:07 p.m.