-
Notifications
You must be signed in to change notification settings - Fork 6
Open
Labels
enhancementNew feature or requestNew feature or request
Description
Context
PR #1868 added tfact_order covering order totals. Reviewer noted that tax amounts should be captured when a tax was applied.
What
Add tax information to tfact_order once source staging models expose tax line items:
- Identify the tax line-item source in MITx Online and xPro order systems
- Add staging model(s) if not already present
- Add
order_tax_amount,order_tax_rate, and/ororder_pre_tax_pricecolumns totfact_order
Dependencies
- Requires investigation of tax data availability in
stg__mitxonline__app__postgres__ecommerce_*andstg__mitxpro__app__postgres__ecommerce_*sources - May require new intermediate models
Acceptance Criteria
- Tax source tables identified and documented
- Staging/intermediate models created if needed
-
tfact_orderupdated with tax columns -
_fact_tables.ymlupdated with column descriptions and tests
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or request