Get a dataframe of updated billable status for project owned by CTS-IT staff — update_billable_if_owned_by_ctsit • rcc.billing

Ignore the current state billable and review every project owned by CTS-IT staff

Usage

update_billable_if_owned_by_ctsit(conn)

Arguments

conn: - A REDCap database connection, e.g. the object returned from connect_to_redcap_db

Value

A dataset_diff containing updates to project ownerhsip's "billable" column

Examples

if (FALSE) { # \dontrun{
conn <- redcapcustodian::connect_to_redcap_db()
billable_updates <- update_billable_if_owned_by_ctsit(conn)
dbx::dbxUpdate(conn,
  table = "redcap_entity_project_ownership",
  records = billable_updates$update_records,
  where_cols = c("id")
)
} # }