Waiver Action Queue

Loading…

Rule	Vendor / Job	$ At risk	Coverage have → need	Age	Why it's here
Loading queue…

Rule logic · How rows enter the queue

Blocks pay

Trigger: In-period Amount to Pay > 0 (open AP with CE invoice date ≤ Need Waiver Thru) and status is short of Submitted/Granted.
Exit: Status moves to Submitted or Granted, or in-period open AP clears.

Coverage gap

Trigger: Covered-thru (waiver date on file for Submitted/Granted) is earlier than period need (CE pay-app period end proxy = month end).
Exit: Covered-thru ≥ need, or Final filed when closing out.

Stale

Trigger: Status = Requested and Date Requested is ≥ 7 days ago with no submission.
Exit: Status leaves Requested.

Missing final

Trigger: Job Period = Final and Final is unchecked while dollars remain.
Exit: Final checked (or period leaves Final).

Hygiene

Trigger: Submitted/Granted with no waiver-thru and/or no request date — unverifiable.
Exit: Dates filled so coverage can be confirmed.

Key derivation

need_thru defaults to CE pay-app period end (month-end proxy until CE period is wired).
covered_thru = Need Waiver Thru on Submitted/Granted lines (the date the waiver covers).
Amount at risk uses in-period open AP only (CE invdate ≤ Need Waiver Thru).