Deployment status of the intercompany fee share To-record generation (see Intercompany Fee Share To-Records for the design). The load proc is also converted from truncate-and-reload to an incremental MERGE on RowHash as part of this change.
Current position: complete in Dev (QA data). Blocked on test data — no Forecast Intercompany Cost records exist in the source dataset. Once one is added, run the data through, Rocky David tests in QA, then deploy to UAT if successful.
SQL Objects
| SQL Object | Dev | UAT | Support | Prod |
|---|---|---|---|---|
landing.projforecastcost |
Deployed | Deployed | Pending | Pending |
staging.factforecastnetrevenue |
Deployed | Deployed | Pending | Pending |
staging.factforecastnetrevenue_rules |
Deployed | Deployed | Pending | Pending |
LOAD.usp_factforecastnetrevenue |
Deployed | Deployed | Pending | Pending |
Deployment Notes
Order: landing.projforecastcost → staging.factforecastnetrevenue → staging.factforecastnetrevenue_rules → LOAD.usp_factforecastnetrevenue. Each object references the previous one's new columns, so the order is required.
Load proc change: now a single-pass incremental MERGE on (SourceTable, SourceRecID) with a staging-side RowHash. First run after deployment updates every row (existing rows carry a NULL RowHash); the second run should touch zero. Failed dimension lookups land on the -1 Unknown member.
Verification: queries V1–V4 in _output\icfeeshare-draft.sql (one To-record per rule 6 line; no duplicates; pairs net to zero; missing-dimension worklist).