The Worker I-9 Topic in Fountain Analytics holds each worker's I-9 submissions, with their I-9 details and their E-Verify case status. Use it to list I-9s by E-Verify status, find every closed case, or match a status you see in the I-9 Center.
This article covers the I-9 fields only. To learn how workbooks, fields and filters work in general, read Create Analytics Insights first.
Before You Start
You need access to Fountain Analytics and to the Worker I-9 Topic. You see only the I-9s of the companies and workers your Fountain permissions cover.
Open the Worker I-9 Topic
Start a new analysis from the Analytics homepage:
Click New > Workbook in the top right corner.
Under TOPICS, select Worker I9.
Add your fields and filters, then click Run.
The Topic does not run on its own when it opens. Nothing shows in the results until you click Run.
Check the Default Filters
The Worker I-9 Topic opens with three filters already in the filter bar. They keep the results to the I-9s most reports need:
Is Current I9 Submission is true: only each worker's latest I-9 submission.
Is Worker Terminated is false: only active workers.
Source Application is Fountain: only I-9s completed in Fountain.
Remove Filters to Widen Results
To include earlier submissions, terminated workers or I-9s completed outside Fountain, remove the matching filter from the filter bar and click Run again.
Find the E-Verify Fields
In the field browser, expand I-9 Form Submission Details. Its E-Verify fields are:
Everify Current Status: the overall E-Verify status of the I-9, such as Authorized, Processing, Mismatch, Pending Referral, Requires Attention, Error or Other.
Everify Government Status: the case status E-Verify returns, such as Submitted, Referred, Closed - Authorized, Closed - Non-Confirmation, Closed - Other or Manually Closed.
Is Everify Case Closed: true when the E-Verify case is closed.
Everify Case Deadline Date: the estimated date by which the case needs action.
To find I-9s whose E-Verify submission failed, expand I-9 Everify Errors. Has Everify Error flags them, and Everify Error Message shows what E-Verify returned.
Match a Status From the I-9 Center
On a worker's I-9 profile, the I-9 Center shows the E-Verify status as two tags: the main status, then the case status. To find the same I-9s in Analytics, filter on Everify Government Status, which matches the case status exactly.
The I-9 Center shows | Filter Everify Government Status on |
Other • Closed | Closed - Other |
Other • Manually closed | Manually Closed |
To set the filter:
Click Everify Government Status in the field browser and select Filter.
Choose is equal to and select the status, such as Closed - Other.
Click Update, then click Run.
Report on Closed E-Verify Cases
To list every closed case at once, filter Is Everify Case Closed is true. It counts four government statuses as closed:
Closed - Authorized
Closed - Non-Confirmation
Closed - Other
Manually Closed
Try It!
Add Everify Government Status as a field next to the filter. Your results then show which kind of closure each case had.
A case with the government status Close Case and Resubmit is not counted as closed. To find those cases, filter Everify Government Status on Close Case and Resubmit.


