Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Revise get_new_project_invoice_line_items to use organizational data #231

Open
pbchase opened this issue Jul 15, 2024 · 0 comments
Open

Comments

@pbchase
Copy link
Contributor

pbchase commented Jul 15, 2024

Revise get_new_project_invoice_line_items (See PR #230) to use organizational data to determine if we should charge DSO Shands customers the $215, external non-profit rate.

ctsi_rcc_billing.org_hierarchies will tell you DEPT_IDs have string::str_detect(dept_name, "DSO-SHANDS"). ctsi_rcc_billing.person_org will tell you which people are in which organization. The orgs of interest all have this pattern:

SELECT * FROM org_hierarchies
where
DEPT_ID like '9501%';

So you can filter for people that work for UF Health Shands like this:

SELECT * FROM ctsi_rcc_billing.person_org
where
primary_uf_fiscal_org like '9501%';

Any PI/Owner who has stringr::str_starts(primary_uf_fiscal_org, "9501") should be charged the $215/hour (or $215/project) rate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant