Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / ctsit/rcc.billing issues and pull requests

#253 - Move revenue report to typst

Pull Request - State: closed - Opened by pbchase 18 days ago - 4 comments

#252 - Add SIPOC for cleanup_bad_email_addresses

Pull Request - State: closed - Opened by saipavan10-git 2 months ago

#251 - Move test data 1

Pull Request - State: closed - Opened by pbchase 2 months ago - 2 comments

#250 - Add staff

Pull Request - State: closed - Opened by pbchase 2 months ago

#249 - Add ORCIDs

Issue - State: closed - Opened by pbchase 3 months ago - 1 comment

#247 - Add vignettes for delete_abandoned_projects and sequester_orphans

Pull Request - State: closed - Opened by pbchase 3 months ago

#246 - Add vignettes/update_project_billable_attribute.Rmd

Pull Request - State: closed - Opened by pbchase 3 months ago

#245 - Fix cleanup_bad_email_addresses.R

Pull Request - State: closed - Opened by saipavan10-git 3 months ago - 6 comments

#244 - Add etl vignettes

Pull Request - State: closed - Opened by pbchase 3 months ago - 6 comments

#242 - Address mermaid TODO in `cleanup_bad_email_addresses` vignette

Issue - State: closed - Opened by pbchase 3 months ago - 1 comment

#241 - Revert "Merge branch 'release/1.41.4' "

Pull Request - State: closed - Opened by saipavan10-git 3 months ago

#240 - Merge branch 'release/1.41.4'

Pull Request - State: closed - Opened by saipavan10-git 3 months ago

#239 - Add return_all_records param to get_service_request_lines()

Pull Request - State: closed - Opened by pbchase 3 months ago

#238 - Add fiscal contact details to get_billable_candidates

Pull Request - State: closed - Opened by saipavan10-git 3 months ago - 1 comment

#237 - Add fiscal contact details in some places

Pull Request - State: closed - Opened by pbchase 3 months ago - 2 comments

#236 - Add always bill

Pull Request - State: closed - Opened by pbchase 4 months ago

#235 - Bind service_request_line_items output to all invoice lines

Pull Request - State: closed - Opened by saipavan10-git 4 months ago - 2 comments

#234 - Modify `get_service_request_lines()` to also return `username`

Issue - State: closed - Opened by pbchase 4 months ago - 1 comment

#233 - Add get_service_request_line_items.R

Pull Request - State: closed - Opened by saipavan10-git 4 months ago - 2 comments

#232 - Update messaging to describe variable rates

Issue - State: open - Opened by pbchase 4 months ago

#230 - Refactor create and send

Pull Request - State: closed - Opened by pbchase 4 months ago - 2 comments

#226 - Add fiscal contact details in `get_billable_candidates()`

Issue - State: closed - Opened by pbchase 5 months ago - 1 comment

#225 - Update Schemata and transform tables

Issue - State: closed - Opened by pbchase 5 months ago - 2 comments

#224 - Add update free support time remaining

Pull Request - State: closed - Opened by pbchase 5 months ago

#223 - Modernize imports and conform to tidyselect

Pull Request - State: closed - Opened by pbchase 5 months ago

#221 - Give Fiscal email addresses of project users

Issue - State: closed - Opened by pbchase 5 months ago - 1 comment

#220 - Enumerate active users on past due project

Pull Request - State: closed - Opened by pbchase 5 months ago - 1 comment

#219 - Create get service request lines

Pull Request - State: closed - Opened by ljwoodley 6 months ago - 1 comment

#218 - Make pro bono service request records

Pull Request - State: closed - Opened by ljwoodley 7 months ago - 4 comments

#217 - Merge draft billing features into production service request project

Issue - State: closed - Opened by pbchase 7 months ago - 1 comment

#216 - Add 'REDCap consulting' service_type to test data

Pull Request - State: closed - Opened by pbchase 7 months ago

#215 - Fix build check errors of 'get_project_details_for_billing()'

Pull Request - State: closed - Opened by pbchase 7 months ago

#214 - CC REDCAP_BILLING_L in request_correction_of_bad_ownership_data.R

Pull Request - State: closed - Opened by pbchase 7 months ago

#213 - add service request time

Pull Request - State: closed - Opened by ljwoodley 7 months ago - 2 comments

#212 - add get_ctsi_study_id_to_project_id_map

Pull Request - State: closed - Opened by ljwoodley 7 months ago - 6 comments

#211 - use service_identifier pk

Pull Request - State: closed - Opened by ljwoodley 7 months ago - 2 comments

#209 - Get project details for billing

Pull Request - State: closed - Opened by ljwoodley 7 months ago

#208 - Write a function, `get_ctsi_study_id_to_project_id_map()`

Issue - State: closed - Opened by pbchase 8 months ago - 3 comments

#207 - Mark pro-bono service request records

Issue - State: closed - Opened by pbchase 8 months ago - 4 comments

#206 - Create service_request_time()

Issue - State: closed - Opened by pbchase 8 months ago - 2 comments

#205 - Write a function `get_service_request_lines()`

Issue - State: closed - Opened by pbchase 8 months ago - 6 comments

#204 - Create get_project_details_for_billing()

Issue - State: closed - Opened by pbchase 8 months ago - 3 comments

#203 - Add create_service_request_line_items()

Issue - State: closed - Opened by pbchase 8 months ago - 7 comments

#202 - Add required static data to rcc.billing tables for support billing

Issue - State: closed - Opened by pbchase 8 months ago - 3 comments

#200 - Fix bad collect() syntax

Pull Request - State: closed - Opened by pbchase 8 months ago

#199 - Fix crashes in sequester_unpaid_projects.R

Pull Request - State: closed - Opened by pbchase 9 months ago

#197 - Add owner's org data to get_billable_candidates() output

Pull Request - State: closed - Opened by pbchase 9 months ago

#196 - Add fiscal year reporting to `revenue_status_and_projections.qmd`

Pull Request - State: closed - Opened by pbchase 9 months ago

#195 - Curate and use CTSI Study IDs

Pull Request - State: closed - Opened by pbchase 9 months ago

#194 - Update update invoice line items to handle more details

Pull Request - State: closed - Opened by ChemiKyle 10 months ago

#193 - Invoice projects not invoiced in the previous months

Issue - State: open - Opened by pbchase 12 months ago - 1 comment

#192 - Implement code changes required for the Fall 2023 rate increase

Pull Request - State: closed - Opened by pbchase about 1 year ago

#191 - Update revenue_status_and_projections.qmd

Pull Request - State: closed - Opened by pbchase about 1 year ago

#190 - Update update_invoice_line_items_with_invoicing_details.R to handle more details

Issue - State: closed - Opened by pbchase about 1 year ago - 1 comment

#185 - On 11/10, execute this SQL code...

Issue - State: closed - Opened by pbchase about 1 year ago - 2 comments

#184 - On 10/24, update the email templates to reflect the new price

Issue - State: closed - Opened by pbchase about 1 year ago - 2 comments

#183 - `sequester_orphans.R` has a bad link

Issue - State: closed - Opened by pbchase about 1 year ago - 1 comment

#181 - warn_owners_of_impending_bill.R knows nothing of sequestration

Issue - State: closed - Opened by pbchase about 1 year ago - 1 comment

#165 - `sequester_unpaid_projects.R` sent multiple emails with an `NA` body

Issue - State: closed - Opened by pbchase over 1 year ago - 2 comments

#146 - Set `ctsi_study_id` in `service_instance` when we get novel values from CSBT

Issue - State: closed - Opened by pbchase over 1 year ago - 1 comment

#139 - Add a `banned_owner` rule to get_orphaned_projects

Issue - State: closed - Opened by pbchase over 1 year ago

#130 - Design processes for invoicing for twilio projects

Issue - State: closed - Opened by pbchase almost 2 years ago
Labels: wontfix

#129 - Write a report of twilio-enabled projects so we can claim them

Issue - State: open - Opened by pbchase almost 2 years ago
Labels: wontfix

#125 - Create an ETL `write_uf_fiscal_orgs_to_person_org.R`

Issue - State: closed - Opened by pbchase almost 2 years ago - 4 comments

#124 - Create an ETL `write_uf_fiscal_orgs_to_org_hierarchies.R`

Issue - State: closed - Opened by pbchase almost 2 years ago - 1 comment

#120 - Add org data to `billable_candidates.R`

Issue - State: closed - Opened by pbchase about 2 years ago - 1 comment

#109 - Conditionally set status when updating invoice_line_item

Issue - State: closed - Opened by pbchase about 2 years ago - 2 comments

#103 - Write a function to scrape email bounces from log data

Issue - State: closed - Opened by pbchase about 2 years ago - 1 comment

#100 - Fix invoice line item months both past and future

Issue - State: closed - Opened by pbchase about 2 years ago - 1 comment

#99 - Add `inactive_projects_with_no_viable_users` rule to get_orphans

Pull Request - State: closed - Opened by pbchase about 2 years ago - 1 comment

#98 - Create transform_invoice_line_items_for_ctsit function and test

Pull Request - State: closed - Opened by ChemiKyle about 2 years ago - 3 comments

#97 - Make PIs and faculty project owners

Pull Request - State: closed - Opened by pbchase about 2 years ago - 1 comment

#96 - Revise get orphans to check for viable users

Pull Request - State: closed - Opened by ChemiKyle about 2 years ago - 1 comment

#94 - Write new invoice details into DB

Issue - State: closed - Opened by pbchase about 2 years ago - 2 comments

#93 - `service_instance` table does not have a primary key

Issue - State: open - Opened by pbchase about 2 years ago
Labels: bug

#92 - Dig for associated users during orphan sequestration

Pull Request - State: closed - Opened by ChemiKyle about 2 years ago

#91 - Add the REDCap IRB # to the data we send CSBT

Issue - State: closed - Opened by pbchase about 2 years ago - 4 comments

#90 - Fix create and send inv line items

Pull Request - State: closed - Opened by pbchase about 2 years ago - 1 comment

#89 - Unify schema of sent spreadsheets

Issue - State: open - Opened by ChemiKyle about 2 years ago

#88 - Add get_orphaned_projects()

Pull Request - State: closed - Opened by pbchase about 2 years ago

#87 - Add `sequester_project()` and `sequester_orphans.R`

Pull Request - State: closed - Opened by pbchase about 2 years ago

#86 - Run billable candidates

Pull Request - State: closed - Opened by pbchase about 2 years ago

#85 - create initial billable_candidates digest

Pull Request - State: closed - Opened by ChemiKyle about 2 years ago

#84 - Ignore deleted projects when creating invoices

Pull Request - State: closed - Opened by pbchase about 2 years ago

#83 - Run warn_owners_of_impending_bill.R on 1st and 23rd of the month

Pull Request - State: closed - Opened by pbchase about 2 years ago

#82 - Sequester unpaid projects 100 days after invoicing

Issue - State: closed - Opened by pbchase about 2 years ago - 1 comment

#81 - Run `warn_owners_of_impending_bill.R` on 1st and 23rd of the month

Issue - State: closed - Opened by pbchase about 2 years ago - 1 comment

#80 - Add project filters to `create_and_send_new_redcap_prod_per_project_line_items.R`

Issue - State: closed - Opened by pbchase about 2 years ago - 1 comment