Mapping Rules
5
Source-to-contract rules
Approved
3
Ready for internal workpaper use
Needs Review
2
Reviewed or regulatory reference TODO
Official Gate
Blocked
TODO_REGULATORY_REFERENCE present
Mapping Rules
Targets are calculation contracts, not spreadsheet cells.
| Source | Match | Target Contract | Status |
|---|---|---|---|
| GL | account_prefix=1 | capital.cet1.paid_up_capital | APPROVED |
| CORE_BANKING | product=TERM_LOAN | credit_on_balance.exposure | APPROVED |
| CORE_BANKING | product=LC,BG | credit_off_balance.face_value | REVIEWED |
| RATES | currency!=ETB | market_fx.etb_equivalent | APPROVED |
| EXCEL_LEGACY | schedule=operational_loss | operational_risk.gross_income | TODO_REGULATORY_REFERENCE |
Reconciliation Checks
Controls must pass before official export can be enabled.
| Check | Expected | Actual | Diff | Status |
|---|---|---|---|---|
| GL to credit exposure control | 18,500,000,000 | 18,500,000,000 | 0 | PASS |
| FX rates completeness | 14 | 14 | 0 | PASS |
| Manual operational schedule tie-out | 3 | 2 | 1 | WARNING |