Add price information to the sample table in cg

[pbiology]

As a project manager, I want to have information about the invoicing price in the sample table in statusDB, So that I can trend prices for samples over time.

Acceptance Criteria

• [ ] The sample table has a column called "invoice_price"

Notes

Today we do have information about application_version_id and priority in the cg sample table. We also have application price by priority in the application_version table. This would be more useful if this was linked together in a new column in the sample table which just takes the information about application_version_id and priority from the sample table and pulls price info from the application_version table (columns: price_standard, price_priority... etc)

• Additional information.
• Dependencies.
• Related user stories.

Implementation plan

• [ ] Work item 1
• [ ] Work item 2

[pbiology]

At some point @vwirta should be brought into this to confirm that the prices in the application_version table is accurate and in use

[vwirta]

I am working on new pricing. Hopefully done during this week

[Vince-janv]

@pbiology Each sample has an application version with the cost of that sample. If it's trending you want do we not have access to how much we charged for that sample via that information?

I the problem that one needs to map the sample priority to the correct column?

Is providing a functioning SQL query sufficient to solve this issue?

[pbiology]

I think I can set up an IF statement which would be able to get the correct pricing info based on what is already there. So I can concede that perhaps this can be put on ice for now

[Vince-janv]

If you need any help to get it working in Tableau, just ping us and we'll help you figure it out!