Get a dataframe of updated billable status for project ownership projects, set all projects as billable except those created by CTS-IT staff — update_billable_by_ownership • rcc.billing

Get a dataframe of updated billable status for project ownership projects, set all projects as billable except those created by CTS-IT staff

Usage

update_billable_by_ownership(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_by_ownership(conn)
dbx::dbxUpdate(conn,
  table = "redcap_entity_project_ownership",
  records = billable_updates$update_records,
  where_cols = c("id")
)
} # }