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

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

Closed pbchase closed 7 months ago

pbchase commented 8 months ago

Add required static data to rcc.billing tables:

service_type

First,

delete from service_type where service_type_code in (2,3,4,5,6)

Then insert this record:

ljwoodley commented 7 months ago

Adding the sql to do this here. We can run this once we're ready to implement these changes in prod.

delete from service_type where service_type_code in (2,3,4,5,6)

insert into service_type (service_type_code, service_type, price, billing_frequency)
values (2, 'REDCap consulting', 130, 0)
pbchase commented 7 months ago

Adding the sql to do this here. We can run this once we're ready to implement these changes in prod.

delete from service_type where service_type_code in (2,3,4,5,6)

insert into service_type (service_type_code, service_type, price, billing_frequency)
values (2, 'REDCap consulting', 130, 0)

I went ahead and applied this to prod

pbchase commented 7 months ago

Addressed by PR #216