FMCSA Drug and Alcohol Clearinghouse Query Automation: Pre Employment Full Queries, Annual Limited Queries, Consent Tracking, and Return to Duty Records
Authoritative Research and Advisory

FMCSA Drug and Alcohol Clearinghouse Query Automation: Pre Employment Full Queries, Annual Limited Queries, Consent Tracking, and Return to Duty Records

The Clearinghouse turned drug and alcohol history from a phone call to a prior employer into a federal database with query rules, consent rules, reporting deadlines, and a 24 hour escalation clock. This monograph shows carriers how to model those rules in the TMS or safety system so no driver is dispatched on a stale or missing query.

How should a carrier automate FMCSA Clearinghouse queries and keep the records an auditor expects?

Store every query as a structured record with the Clearinghouse query identifier, driver, type, date, result status, and linked consent, schedule the annual query from the date of the last one, escalate a limited query that returns information to a full query within 24 hours, and compute a driver dispatch status from the most recent result so a prohibited driver cannot be assigned a load. Reporting obligations, return to duty follow up plans, and the three year query retention then become tables and scheduled jobs rather than items on a safety manager's to do list.

Founded in 2008 by Scott Elliott in Minnesota, Strong Tower Consulting, LLC (Minnesota File No. 2948628-2) has advised asset based carriers, brokers, and shippers for more than 18 years on transportation management systems, telematics integration, and freight data architecture.

What the Clearinghouse Is and Which Rules Govern It

The FMCSA Commercial Driver's License Drug and Alcohol Clearinghouse is a federal database that holds records of drug and alcohol program violations by CDL and CLP holders, together with the return to duty information that shows whether a driver who had a violation has completed the process to drive again. The operating rules for employers are in 49 CFR part 382 subpart G, sections 382.701 through 382.727, which cover query requirements, consent, reporting by employers, medical review officers, substance abuse professionals, and consortia or third party administrators, access to records, retention, and driver rights. The rest of part 382 and part 40 of Title 49 govern the testing program itself and the return to duty process that the Clearinghouse records.

Before the Clearinghouse, a hiring carrier learned about a candidate's prior violations by asking previous employers under 391.23(e), and the answer depended on the previous employer responding completely and honestly. The Clearinghouse replaced that uncertainty with a database query, and once the database held three years of records the query became the sole method of satisfying the part 382 portion of the previous employer investigation. For the carrier, the change is structural: compliance now depends on running the right query at the right time with the right consent and acting correctly on the result, every time, for every driver. That is a scheduling and data problem, and the carrier's TMS or safety system should own it.

Pre-Employment Full Queries

Section 382.701(a) prohibits an employer from employing a driver subject to part 382 testing to perform safety sensitive functions without first conducting a pre-employment full query of the Clearinghouse. A full query returns the driver's actual records: violations, refusals, and return to duty progress. The driver must grant electronic consent inside the Clearinghouse itself, which means the driver must have registered in the Clearinghouse and must respond to the consent request the employer initiates. A full query cannot proceed on a paper consent, and a driver who declines consent cannot be allowed to perform safety sensitive functions.

The system design for pre-employment begins in the applicant tracking or driver onboarding workflow. When a candidate reaches the stage where a conditional offer is extended, the system should create a pending full query record, record the date the consent request was sent, and block the orientation completion milestone until the query record carries a result. The result status that permits dispatch is that the driver is not prohibited from performing safety sensitive functions. If the result shows a violation with incomplete return to duty steps, the driver is prohibited and the onboarding stops. If the result shows a completed return to duty process, the driver may be eligible, but the follow up testing plan from the substance abuse professional becomes the hiring carrier's obligation to continue, and that plan must be captured at the same moment.

Timing also interacts with the pre-employment drug test under 382.301, which must have a verified negative result before the driver first performs safety sensitive functions. The two requirements are separate, and both should appear on the onboarding checklist as distinct gates with their own evidence. Our TMS implementation work typically models onboarding gates as a configurable checklist so that safety can add or reorder gates without a code change.

Annual Limited Queries and the 24 Hour Escalation

Section 382.701(b) requires the employer to conduct a query of the Clearinghouse at least once per year for each driver it employs who is subject to part 382 testing. The annual query may be a limited query. A limited query returns only an indication of whether the Clearinghouse holds any information about the driver; it does not reveal what the information is. If the limited query indicates that information exists, the employer must conduct a full query within 24 hours, and if the full query is not completed within that window the driver must not perform safety sensitive functions until it is. The limited query is therefore an efficient screening step that works only if the escalation is automatic and fast.

Model the annual cycle as a recurring obligation computed from the prior query. Each driver record carries the date of the most recent query that satisfied the annual requirement, and the system schedules the next one no later than one year from that date. Many carriers run the annual query for the whole roster in a single batch, which simplifies the calendar but creates a concentration of work in one week each year. A rolling schedule tied to each driver's hire anniversary spreads the work and reduces the risk that a batch failure leaves the entire fleet past due at once. Either way, the system should show a roster level view of days until the next required query and should flag any driver whose annual window closes within a configurable lead time.

The escalation is the step that most often fails in manual programs. When a limited query returns an indication that information exists, the system should immediately create a full query obligation with a 24 hour deadline stamped from the limited query result time, send the electronic consent request, notify the safety manager, and start a visible countdown. If the deadline passes without a full query result, the driver status must change to held automatically. The hold is not a punishment; it is what the regulation requires, and an automatic hold protects the carrier from the far worse outcome of a prohibited driver operating while someone waits for a consent email.

Query eventRegulationConsent formDeadline logic
Pre-employment full query382.701(a)Electronic consent in the ClearinghouseBefore first safety sensitive function
Annual query, limited or full382.701(b)General written consent for limited; electronic for fullAt least once in any 12 month period
Full query after limited query shows information382.701(b)Electronic consent in the ClearinghouseWithin 24 hours of the limited result or driver stops safety sensitive functions
Query record retention382.701(d)Consent record retained with queryThree years

Consent Records: General Consent and Electronic Consent

Section 382.703 describes consent. For limited queries, the employer obtains the driver's general consent, which may cover more than one year and which the employer keeps outside the Clearinghouse. For full queries, the driver must provide specific electronic consent through the Clearinghouse for each query. The consent record is part of what 382.701(d) requires the employer to retain for three years, so the system must store it as data, not as a vague memory that the driver signed something at orientation.

A consent table solves this. Each row carries the driver, the consent type, the date signed, the period covered, the method, the image or digital signature reference, and the status. When the system schedules a limited query, it first checks for an active general consent covering the query date, and it refuses to run the query without one. When the system requests a full query, it records the date the electronic consent request was initiated in the Clearinghouse and the date the driver responded, so the carrier can show the timeline if a 24 hour escalation is later questioned. Carriers that use a consortium or third party administrator to run queries on their behalf should still hold the consent records and the query results in their own system, because the obligation and the audit belong to the employer.

What the TMS or Safety System Should Store

The Clearinghouse portal retains the query history, but the carrier cannot build dispatch logic, alerts, or audit exports from a portal screen. The carrier's own system needs a query table with, at minimum, the Clearinghouse query identifier, the driver, the query type, the date and time requested, the date and time of the result, the result status, the consent record referenced, the user or integration that initiated it, and the reason, such as pre-employment, annual, escalation, or other. For full queries that return records, store the violation details and the return to duty status as a child table, with the dates of each step, because the follow up testing plan depends on them. Store the Clearinghouse response document as an image or PDF linked to the query record so the exact result the carrier saw on that date can be reproduced.

  • Query record - Identifier, driver, type, requested and result timestamps, status, reason, consent reference, initiated by.
  • Consent record - Driver, type, signed date, coverage period, method, image reference, status.
  • Violation record - Linked to a full query; violation type, date, reporting party, return to duty stage, SAP eligibility date, follow up plan reference.
  • Follow up plan - Minimum test counts by period, tests completed, next due window, completion date.
  • Driver status - Computed from the most recent query, license status, and DQ file state, with reasons.

Protect this data carefully. Clearinghouse records are sensitive personal information with access restrictions under 382.717 and part 40, and a carrier that exposes them in a general dispatch screen has created a privacy failure. Role based access should limit violation details to the designated employer representative and the safety roles that need them, while dispatch sees only the computed status and the reason category. These controls are standard data protection practice and should be documented alongside the retention rules.

Employer Reporting Obligations

Section 382.705 sets out who reports what. The medical review officer reports verified positive, adulterated, and substituted drug test results and refusals the MRO determines. The employer reports alcohol confirmation test results of 0.04 or greater, refusals to test that are not reported by a collector or MRO, actual knowledge of prohibited use as defined in 382.107, negative return to duty test results, and completion of the follow up testing plan. The substance abuse professional reports the initial assessment and the date the driver becomes eligible for return to duty testing. The employer's reports are generally due by the close of the third business day after the employer obtains the information, and the exact timing for each reporting party is in 382.705, which should be read directly before configuring deadlines.

In the system, each reportable event should generate a reporting task with the deadline computed from the date the information was obtained, the Clearinghouse report identifier once submitted, the submitter, and a link to the underlying evidence such as the breath alcohol test form or the documented refusal. A report that is not submitted by the deadline should escalate to the safety director. A carrier that uses a consortium or third party administrator to submit reports should still record the task and the completion in its own system, since the employer remains responsible for timely and accurate reporting.

Return to Duty Process and Follow Up Testing

A driver with a violation is prohibited from performing safety sensitive functions until the return to duty process in 49 CFR part 40 subpart O is complete. The driver is evaluated by a substance abuse professional, completes the education or treatment the SAP prescribes, is re-evaluated, and then may take a return to duty test, which must be conducted under direct observation for drug tests. A negative return to duty result allows the driver to resume safety sensitive functions, but the SAP also prescribes a follow up testing plan, which under 40.307 requires at least six unannounced tests in the first 12 months and may extend for up to 60 months. The employer is responsible for carrying out that plan, and the plan follows the driver to any subsequent employer during its term.

The follow up plan is where many carriers lose track. Model it as a plan header with the SAP, the start date, the total duration, and the minimum number of tests per period, plus a schedule of test windows generated from those parameters. Each completed follow up test links to its window, and the system raises an alert when a window is approaching its close without a test. Because the tests must be unannounced, the scheduling logic should be visible only to the designated employer representative and the testing coordinator, never on the driver's own schedule or the dispatch board. When the plan completes, the employer reports completion to the Clearinghouse under 382.705, and the system closes the plan with the report identifier.

Return to duty stageEvidence to storeStatus effect
Violation recordedClearinghouse record, date, reporting partyProhibited; dispatch hold
SAP initial assessmentSAP identity, assessment date, prescribed programProhibited
SAP eligibility for RTD testEligibility date reported by SAPProhibited until negative RTD result
Negative return to duty testTest date, directly observed indicator, result, employer report identifierEligible; hold released; follow up plan starts
Follow up plan in progressPlan parameters, windows, completed testsEligible with active plan
Follow up plan completeCompletion date, employer report identifierEligible; plan closed

Driver Status Holds in Dispatch

The single most valuable output of the design is a driver status that dispatch cannot ignore. Compute it nightly and on every relevant event: a driver is dispatchable for safety sensitive functions when a pre-employment full query exists with a not prohibited result, the most recent annual query is within 12 months, no limited query escalation is open past its 24 hour deadline, no active violation lacks a negative return to duty result, the driver qualification file is complete and current, and the license is valid. When any condition fails, the status is held and the reasons are listed in plain language that dispatch understands, such as annual query past due or Clearinghouse escalation pending. The planning board, the trip assignment screen, and any automated dispatch optimization engine should all read this status and refuse to assign a held driver.

Holds should be cleared by data, not by a dispatcher's judgment. Resolving the underlying condition, such as a completed query with a not prohibited result, clears the hold automatically. An override by a safety role should be rare, documented with authority and reason, and visible in the audit trail. The companion article on driver qualification file architecture describes the DQ file side of the same status in detail, and the two designs should share one status table rather than two competing flags.

Query Plans, Purchasing, and Third Party Administrators

Employers pay for queries by purchasing a query plan in the Clearinghouse, and the plan balance is consumed as queries run. The system should not try to replicate the Clearinghouse billing, but it should forecast demand so the plan does not run out at the moment an escalation requires a full query. A simple forecast adds the expected pre-employment queries from the recruiting pipeline, the annual queries due in the coming period, and a margin for escalations, and alerts the designated employer representative when the remaining balance falls below that forecast. Current pricing and plan options are published by FMCSA and should be checked there rather than assumed.

Many carriers, and nearly all owner operators, use a consortium or third party administrator to run queries and submit reports. Owner operators who are both the employer and the driver are required to designate a C/TPA. When a C/TPA is involved, the integration question is how the query results and report confirmations reach the carrier's own system. The best answer is a scheduled file or API feed from the C/TPA that populates the query table; the fallback is a disciplined manual entry procedure with the Clearinghouse identifier as the key. In either case the carrier's system remains the source for dispatch status and audit exports, because the obligation is the employer's.

State Driver Licensing Agency Checks Under the Second Rule

FMCSA's second Clearinghouse rule, often called Clearinghouse II, extended the database's reach to the state driver licensing agencies. Under that rule, described here generally, a state agency must query the Clearinghouse before issuing, renewing, transferring, or upgrading a CDL or CLP, must deny the transaction for a driver in prohibited status, and must downgrade the commercial privilege of a driver who is in prohibited status, restoring it only after the driver completes the return to duty process. The practical effect is that a prohibited driver's license itself may change, and a carrier may see the consequence on a motor vehicle record before or after it sees the Clearinghouse result.

For the system design, this means the driver status should watch license status and Clearinghouse status as two independent inputs that may move together. Continuous license monitoring, where the carrier uses it, becomes an early warning that a Clearinghouse violation may exist, and a Clearinghouse violation becomes a reason to expect a license downgrade and to pull a fresh motor vehicle record for the file. Compliance dates, state implementation details, and the downgrade mechanics vary, so confirm the current requirements with FMCSA and the relevant state agency rather than relying on any summary.

Audit Exports, KPIs, and Rollout

An FMCSA investigator reviewing part 382 compliance will ask for evidence that pre-employment and annual queries were conducted, that consents were obtained, that escalations were handled within 24 hours, that violations were reported on time, and that return to duty and follow up testing were carried out. The export should produce, for a requested set of drivers and a date range, the query table with consent references, the escalation timeline for any limited query that returned information, the reporting tasks with submission dates, and the return to duty records with follow up test completion. Produce it as a PDF with a cover index and a CSV of the structured data, and log every export.

Five KPIs keep the program healthy. Query currency is the share of active drivers whose most recent annual query is within 12 months. Escalation timeliness is the share of limited queries that returned information and were followed by a full query within 24 hours. Consent coverage is the share of active drivers with a current general consent on file. Reporting timeliness is the share of employer reports submitted within the regulatory deadline. Follow up adherence is the share of follow up test windows satisfied on time. Each should be reported monthly, trended, and reviewed by the safety director. A SQL data mining engagement can build all five as views over the query, consent, reporting, and follow up tables.

Rollout follows the same pattern that works for other compliance systems. First, inventory the roster and reconcile it against the Clearinghouse query history to find any driver without a documented pre-employment query or a current annual query. Second, build the consent table and collect general consents where they are missing. Third, load historical queries with their identifiers and results, then turn on the annual scheduler in report only mode. Fourth, enable escalation automation and the reporting task workflow. Fifth, turn on the dispatch hold once the data is clean enough that a hold means a real deficiency, and generate the first audit export as a test. Carriers that run the inventory honestly often find the gaps are in record keeping rather than in queries actually performed, and closing those gaps before an investigator finds them is the entire point.

Related practice areas for this work include TMS Implementation Data Protection SQL Data Mining Predictive Dispatch Optimization. Each practice page describes scope, deliverables, and how an engagement starts with a short discovery call.

How Strong Tower Consulting Helps

Strong Tower Consulting helps carriers move Clearinghouse compliance out of a portal login and a spreadsheet into the TMS or safety system, with query and consent tables, an annual scheduler, 24 hour escalation automation, reporting tasks with deadlines, return to duty and follow up plan tracking, a driver status that dispatch must obey, and an audit export that prints on request. The engagement starts with the roster reconciliation and ends with the hold enabled and the first export tested. Strong Tower Consulting, LLC and Exspeedite LLC are separately organized sister companies under common ownership. That separation keeps the consulting advice vendor neutral and focused on the carrier's own obligations as the employer.

To discuss your roster, your current query process, and whether a consortium or third party administrator is part of the picture, call 763-244-1373 and ask for Scott Elliott. A short call is enough to scope the reconciliation and decide where the first automation should land.

Frequently Asked Questions

When must a carrier run a pre-employment Clearinghouse query?

Under 49 CFR 382.701(a), an employer must conduct a full query of the Clearinghouse before allowing a driver subject to part 382 testing to perform safety sensitive functions for the first time. The driver must give electronic consent in the Clearinghouse for a full query, and the result must show the driver is not prohibited before dispatch.

What is the difference between a limited query and a full query?

A limited query tells the employer only whether the Clearinghouse holds any information about the driver and can be run with a general written consent kept by the employer. A full query returns the actual violation and return to duty records and requires the driver's electronic consent inside the Clearinghouse. If a limited query shows information exists, 382.701(b) requires a full query within 24 hours or the driver must stop performing safety sensitive functions until it is completed.

What must an employer report to the Clearinghouse and how fast?

Under 382.705(b), employers report alcohol confirmation tests at 0.04 or greater, refusals to test that are not reported by a collector or MRO, actual knowledge of prohibited use, negative return to duty results, and completion of follow up testing, generally by the close of the third business day after the employer obtains the information. MROs report verified positive, adulterated, and substituted results and refusals they determine, and SAPs report the initial assessment and eligibility for return to duty testing.

How long must Clearinghouse query records be retained?

Under 382.701(d), employers must retain records of each query, including the driver's consent for limited queries, for three years. Storing the query identifier, date, type, result, and consent reference as structured data makes that retention easy to prove.

What did the second Clearinghouse rule change for state licensing agencies?

The second Clearinghouse rule required state driver licensing agencies to check the Clearinghouse before issuing, renewing, transferring, or upgrading a CDL or CLP and to downgrade the commercial privilege of a driver in prohibited status. A carrier's driver status model should therefore watch both Clearinghouse status and license status, since a prohibited driver's license may change. Confirm current details with FMCSA and the state agency.

Corporate Affiliation Notice: Strong Tower Consulting, LLC and Exspeedite LLC are separately organized sister companies under common ownership.

Strong Tower Consulting, LLC, Minnesota File No. 2948628-2, founded in 2008. Direct inquiries: 763-244-1373.