Package index • rcc.billing

All functions

connect_to_rcc_billing_db(): Connect to the rcc_billing DB

csbt_column_names: csbt_column_names

ctsit_staff: CTS-IT Staff

ctsit_staff_employment_periods: ctsit_staff_employment_periods

draft_communication_record_from_line_item(): Adds metadata necessary for sending emails to an invoice_line_item dataframe, e.g. transform_invoice_line_items_for_csbt

fiscal_years: fiscal_years

fix_data_in_invoice_line_item(): fix_data_in_invoice_line_item

fix_data_in_invoice_line_item_communication(): fix_data_in_invoice_line_item_communication

fix_data_in_redcap_log_event(): fix_data_in_redcap_log_event

fix_data_in_redcap_projects(): fix_data_in_redcap_projects

fix_data_in_redcap_user_information(): fix_data_in_redcap_user_information

get_bad_emails_from_log(): Get bad email addresses from the rcc.billing log

get_billable_candidates(): get_billable_candidates

get_creators(): get_creators

get_ctsi_study_id_to_project_id_map(): Map CTSI Study IDs to Project IDs

get_last_project_user(): get_last_project_user

get_new_ctsi_study_ids(): Find previously unknown CTSI Study IDs in invoice_line_item data

get_new_project_invoice_line_items(): Get new project billing invoice line items given a dataframe of projects to invoice, the initial state of the invoice_line_item table, a connection to the redcap database, and a connection to the rcc billing database.

get_new_project_service_instances(): Get new service instances that need to be created given a dataframe of projects_to_invoice and a dataframe of the initial service_instance records.

get_orphaned_projects(): get_orphaned_projects

get_privileged_user(): get_privileged_user

get_probono_service_request_updates(): Update Pro Bono Service Request Details

get_project_details_for_billing(): Get Project Details for Billing

get_project_flags(): Get important boolean flags that describe projects

get_project_pis(): get_project_pis

get_projects_needing_new_owners(): get_projects_needing_new_owners

get_projects_without_owners(): get_projects_without_owners

get_reassigned_line_items(): Get a dataframe of reassigned line items

get_research_projects_not_using_viable_pi_data(): get_research_projects_not_using_viable_pi_data

get_service_request_line_items(): Assemble line items for service requests billing

get_service_request_lines(): Get Service Request Lines

get_target_projects_to_invoice(): Get details on the projects we need to create invoice line items for.

get_unpaid_redcap_prod_per_project_line_items(): Create a dataframe of unpaid REDCap production per project line items that were sent

get_user_rights_and_info(): Get every attribute of every permission entry and userinfo for each user on each permission

get_user_rights_and_info_v1(): get_user_rights_and_info_v1

invoice_line_item_communications_test_data: invoice_line_item_communications_test_data

invoice_line_item_df_from(): Creates a invoice_line_item data from invoice_line_item_communications_data

invoice_line_item_reasons: invoice_line_item_reasons

invoice_line_item_statuses: invoice_line_item_statuses

invoice_line_item_test_data: Sample data for invoice_line_item table

log_event_tables: log_event_tables

mutate_columns_to_posixct(): mutate_columns_to_posixct

next_n_months(): next_n_months

one_deleted_project_record: one_deleted_project_record

previous_month(): previous_month

previous_n_months(): previous_n_months

projects_table_fragment: projects_table_fragment

redcap_log_event_test_data: redcap_log_event_test_data

redcap_rights_test_data: redcap_rights_test_data

redcap_user_information_test_data: redcap_user_information_test_data

sequester_projects(): sequester_projects

service_instance_test_data: Sample data for service_instance table

service_request_time(): Calculate Service Request Time

service_type_test_data: Sample data for service_type table

transform_invoice_line_items_for_csbt(): Renames columns of a dataframe from CTSIT format to CSBT format

transform_invoice_line_items_for_ctsit(): Renames columns of a dataframe from CSBT format to CTSIT format

update_billable_by_ownership(): 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_if_owned_by_ctsit(): Get a dataframe of updated billable status for project owned by CTS-IT staff