ctsit / rcc.billing

Automated, data-driven service billing implemented on REDCap Custodian
https://ctsit.github.io/rcc.billing/
Apache License 2.0
0 stars 3 forks source link

Update Schemata and transform tables #225

Closed pbchase closed 2 months ago

pbchase commented 5 months ago

SQL Schemata

Add these line items after gatorlink

`fiscal_contact_fn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`fiscal_contact_ln` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`fiscal_contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`fiscal_contact_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,

in the schemata for invoice_line_item.sql and invoice_line_item_communications.sql

Transform tables

In csbt_column_names.R add these after pi_email:

   ,
  "fiscal_contact_name",
  "fiscal_contact_email"

Add these after "PI Email":

,
"Fiscal Contact Name",
"Fiscal Contact Email"

Run csbt_column_names.R to generate the new RDA file.

pbchase commented 5 months ago

Release and deploy these changes immediately after merging

pbchase commented 2 months ago

Addressed by PR #237