Post-Ingestion Template
FinanceUnited StatesWave 1 (Pilot)
- Stage
- 3. Ingestion
- Phase
- Post
- Owner
- Suresh D. (Sigmoid)
- Updated
- Today, 09:30
- Open actions
- 2
Object-level Template
| Source object | Target Bronze table | Final status | Record count source | Record count Bronze | Variance | Load SLA met | Exceptions logged | Remediation required | Sign-off owner | Sign-off date | Output artifact |
|---|---|---|---|---|---|---|---|---|---|---|---|
| GL_LINE_ITEMS | bronze.fin_gl_line_items | Completed | 412,884,220 | 412,884,220 | 0.00% | Yes | 0 | No | D. Kowalski | 31 May 2026 | |
| COST_CENTERS | bronze.fin_cost_centers | Completed | 18,442 | 18,442 | 0.00% | Yes | 0 | No | D. Kowalski | 31 May 2026 | |
| FIN_CUSTOMER_ATTR | bronze.fin_customer_attr | In progress | 1,204,881 | 982,110 | 18.49% | — | 1 | Monitor | — | — | — |
| TAX_CODES | bronze.fin_tax_codes | Failed | 2,104 | 0 | 100% | No | 3 | Yes — access provisioning | — | — | — |
Stage Gate Checklist — Ingestion
3/5 approved
| Checklist item | Status | Owner | Evidence link | Approval status |
|---|---|---|---|---|
| Source access granted for all in-scope objects | ||||
| Bronze target tables created | ||||
| Extraction type and watermark confirmed | ||||
| Row count parity source vs Bronze | ||||
| Rejected record handling documented |
Open Actions & Blockers
2 open
| Action | Owner | Due | Status |
|---|---|---|---|
| Chase AP Basis on source access INC44821 (TAX_CODES) | |||
| Re-run FX_RATES after GL completion |
1 blocker(s)
| Blocker | Impact | Owner | Raised | Status |
|---|---|---|---|---|
| TAX_CODES source access not provisioned | 1 object cannot land in Bronze |
Change Log
| Version | Date | Changed by | Summary |
|---|---|---|---|
| v1.4 | Today, 09:30 | Suresh D. (Sigmoid) | Sign-off roles and approval states updated for post-stage template |
| v1.3 | 04 Jun 2026 | AP business owner | Object-level metrics refreshed |
| v1.2 | 29 May 2026 | Sigmoid migration lead | Gate checklist extended with evidence links |
| v1.1 | 21 May 2026 | AP IT owner | Object scope aligned to package inventory |
| v1.0 | 12 May 2026 | Sigmoid migration lead | Baseline template published |
Sign-off on version v1.4
| Approver | Role | Date | Sign-off status |
|---|---|---|---|
| AP business owner | |||
| AP IT owner | |||
| Sigmoid migration lead |