Skip to contents

update_project_billable_attribute

Source: vignettes/update_project_billable_attribute.Rmd
update_project_billable_attribute.Rmd

update_project_billable_attribute identifies and new projects that do not have the billable attribute set and sets that attribute according to business rules. It marks projects as billable once they are one month old. It marks projects as non-billable if they are owned by the REDCap admin team.

 Customers
 Outputs
 Process
 Inputs
 Suppliers
REDCap Database
RCC Billing System: rcc_job_log
redcap_entity_project_ownership
updates
Identify projects older than one month without
a billable attribute, exclude projects owned by
CTS-IT staff, set the billable attribute
on the remaining projects to TRUE.
Identify projects owned CTS-IT staff, set the
billable attribute on them to FALSE.
redcap_entity_project_ownership
redcap_projects
ctsit_staff_employment_periods
REDCap Database
RCC Billing package datasets