Connect · item 15
Data quality gates at intake
Bad data does not become less expensive further down the line. more
Health
What the rules are catching
Active and monitoring rules, and everything they have held, released or rejected.
What the gates test for
Six dimensions. A check that has never fired is shown as never having fired, not as evidence of a clean estate.
What happens on failure
The action is stated on the gate, not decided later.
Gates that have never fired
Reported as a zero, not as a pass.
The gates
Each names the dimension it tests, the expression it evaluates, what happens when it fails, and who owns the failures.
| Gate | Dimension | Applies to | Expression | On failure | Run | Failed | Pass | Held | Owner |
|---|---|---|---|---|---|---|---|---|---|
| DQ-02 Supplier exists and is not blocked Critical | Referential | Source-to-pay intake function Source-to-Pay Suite | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Block threshold 100% | 8,379 | 44 | 99.5% | 9 | K. Boateng |
| DQ-05 Cost center is open in the period High | Referential | Anything that will post to the ledger all-lines Planning and Consolidation | cost center exists in planning and is open for the posting period | Quarantine threshold 99.5% | 15,036 | 62 | 99.6% | 6 | D. Halvorsen |
| DQ-06 Purchase order is open and has remaining value Critical | Referential | Three-way match intake function Group ERP — Materials and Inventory | referenced purchase order exists in materials management, is open, and remaining value covers the invoice | Quarantine threshold 99% | 19,227 | 100 | 99.5% | 8 | K. Boateng |
| DQ-08 Worker record active at the effective date Critical | Referential | Hire-to-retire intake function Core HR and Payroll | the worker referenced holds an active record in core human resources on the effective date of the change | Block threshold 100% | 18,379 | 75 | 99.6% | 7 | S. Bergqvist |
| DQ-11 Contract reference resolves to an executed agreement High | Referential | Legal, procurement and sales intake all-lines Contract Lifecycle Management | the contract identifier resolves to an executed, in-term agreement in contract lifecycle management | Quarantine threshold 99% | 13,082 | 39 | 99.7% | 5 | V. Marchetti |
Quarantine queue
14 items match the current filter. more
| Item | Function · line | Gate | Field | Observed | Expected | Source | Age | Status | Owner | Outcome |
|---|---|---|---|---|---|---|---|---|---|---|
| PR7A-1024 Supplier review at log DQ-02-Q-002 | Procurement & Source-to-Pay PR7A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 8.3 days | Held | K. Boateng | — |
| PR9A-1000 Invoice at auto-post in-tolerance DQ-02-Q-008 | Procurement & Source-to-Pay PR9A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 7.9 days | Held | K. Boateng | — |
| PR7B-1038 Supplier review at owner review DQ-02-Q-011 | Procurement & Source-to-Pay PR7B | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 7.5 days | Released | K. Boateng | Corrected at source and released back onto the line with the correction recorded. |
| PR8C-1025 Requisition at amend po DQ-02-Q-005 | Procurement & Source-to-Pay PR8C | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 7.3 days | Held | K. Boateng | — |
| PR9C-1016 Invoice at post DQ-02-Q-013 | Procurement & Source-to-Pay PR9C | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 6.6 days | Released | K. Boateng | Corrected at source and released back onto the line with the correction recorded. |
| PR6A-1036 Supplier record at register DQ-02-Q-009 | Procurement & Source-to-Pay PR6A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 6.6 days | In review | K. Boateng | — |
| PR6B-1035 Supplier record at notify DQ-02-Q-001 | Procurement & Source-to-Pay PR6B | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 6.5 days | Rejected at intake | K. Boateng | Rejected at intake. The unit never entered the line and the requester was told why. |
| PR3A-1035 Sourcing event at shortlist DQ-02-Q-012 | Procurement & Source-to-Pay PR3A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 6.3 days | Held | K. Boateng | — |
| PR8A-1004 Requisition at guide to catalog DQ-02-Q-010 | Procurement & Source-to-Pay PR8A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 5.0 days | Held | K. Boateng | — |
| PR3A-1018 Sourcing event at analyze bids DQ-02-Q-003 | Procurement & Source-to-Pay PR3A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 2.5 days | Held | K. Boateng | — |
| PR8B-1003 Requisition at approve DQ-02-Q-007 | Procurement & Source-to-Pay PR8B | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 2.5 days | Rejected at intake | K. Boateng | Rejected at intake. The unit never entered the line and the requester was told why. |
| PR2C-1009 Spend line at rank DQ-02-Q-014 | Procurement & Source-to-Pay PR2C | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 2.4 days | In review | K. Boateng | — |
| PR2A-1020 Spend line at enrich supplier DQ-02-Q-006 | Procurement & Source-to-Pay PR2A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 40 hr | Held | K. Boateng | — |
| PR9A-1047 Invoice at capture DQ-02-Q-004 | Procurement & Source-to-Pay PR9A | DQ-02 | supplier identifier resolves to | no matching record | supplier identifier resolves to an active, non-blocked record in the source-to-pay suite | Source-to-Pay Suite | 31 hr | Rejected at intake | K. Boateng | Rejected at intake. The unit never entered the line and the requester was told why. |
Which lines carry the intake burden
Quarantine volume by function, all time.
Actions
What is waiting on a person
Quarantine is a holding pen, not a decision. more
Judge a quarantined item
Held by a rule. Nobody has looked at it yet.
Fix the source behind a rejection
Rejected items keep arriving until the upstream cause changes.
Finish a review already open
Picked up, not concluded.
Promote a monitoring rule to active
The rule watches and reports but does not hold anything.
Operations
What this desk is allowed to start
A surface that only reports is not operable. more
Trigger and bound
This desk can start a rule run across a named batch, and it can move an item into quarantine. more
Live observability
What the record shows right now
What happened to everything the rules have held.
Current distribution
171 items
Is policy and strategy coming to fruition
Whether the written intent is holding here
14 of 16 rules are enforcing. 95 items are held and undecided.
Not holding on the record
The written intent is that no unchecked record reaches a downstream figure. 14 rules enforce that today and 2 only watch. more
The gates, the expressions, the thresholds and the quarantine queue are real mechanisms. more
2 of the 16 gates are set to monitor rather than enforce. They are counted in the check totals but they stop nothing. That is a deliberate state for a gate whose false-positive rate has not yet been characterized, and it is shown rather than hidden behind an overall pass rate.
62 items have been held for more than seventy-two hours, the oldest for 9.1 days. A quarantine queue that ages without clearing is a queue that people have learned to route around, so the age is shown on every row and never averaged away.