Template · Recruiting and hiring

Applicant flow log

By TapTalent Editorial TeamUpdated

In short

An applicant flow log is a record of every applicant for each requisition showing the stages they reached, the final disposition and their voluntary self-identification data, kept separate from hiring decisions. This template gives a requisition header, per-applicant fields, standard disposition codes and a stage summary you can use to check selection rates for adverse impact.

Applicant Flow Log template

Applicant Flow Log

Complete one log per requisition, or export the same fields from your applicant tracking system. Self-identification data comes only from the candidate's voluntary form and must not be visible to recruiters or hiring managers making decisions. Store this log with restricted access.

Requisition details

Requisition number
Job title
Job group / EEO-1 job category
Location (establishment)
Number of openings
Date opened
Date closed or filled
Basic qualifications used to define applicants (objective, set before review)
Method used to limit the pool, if any (e.g. first 300 complete applications, random sample)
Recruiter
Hiring manager

Applicant entry (one per applicant)

Applicant ID (not name, where your system allows)
Date applied
Source
Career siteJob boardEmployee referralAgencyHiring eventInternalRehireOther
Meets basic qualifications
YesNoNot reviewed (outside pool limit)
Sex (self-identified)
FemaleMaleDeclined to self-identify
Race / ethnicity (self-identified)
Hispanic or LatinoWhiteBlack or African AmericanAsianNative Hawaiian or Other Pacific IslanderAmerican Indian or Alaska NativeTwo or more racesDeclined to self-identify
Protected veteran status (self-identified)
Protected veteranNot a protected veteranDeclined to self-identify
Disability status (only if a current rule requires it; Form CC-305 was retired in 2026)
YesNoDeclined to self-identify
Date screened
Date assessed
Date interviewed
Date offered
Date hired / start date
Final disposition code
Disposition date
Disposition notes (job-related reason only)

Disposition codes

  • 01 Did not meet basic qualifications
  • 02 Not reviewed: outside the defined pool limit
  • 03 Withdrew before screening
  • 04 Did not respond to contact (two attempts recorded)
  • 05 Not selected after screen: less qualified than others screened
  • 06 Did not pass assessment (state the assessment and cut score)
  • 07 No-show for interview
  • 08 Not selected after interview
  • 09 Withdrew after interview
  • 10 Offer declined
  • 11 Offer withdrawn after background check or other contingency
  • 12 Hired
  • 13 Requisition cancelled before decision

Stage summary (complete when the requisition closes)

Total expressions of interest received
Total applicants (met the definition used for this requisition)
Applicants by sex and race/ethnicity
Interviewed by sex and race/ethnicity
Hired by sex and race/ethnicity
Protected veteran applicants and hires
Applicants and hires who self-identified as having a disability (if collected)
Lowest group selection rate ÷ highest group selection rate at each stage
Any stage below 80%: reviewed by, date and action taken

How to use this template

  1. Before you review any applications, write the requisition's objective basic qualifications and any method you will use to limit a very large pool.
  2. Collect voluntary self-identification through a separate form or ATS step, and make sure recruiters and hiring managers cannot see the answers.
  3. Record each applicant's stage dates as they move, not from memory at the end; your ATS should timestamp these automatically.
  4. Close every record with a disposition code so no applicant is left open when the requisition is filled.
  5. When the requisition closes, complete the stage summary and calculate selection rates for each group at each stage.
  6. Investigate any stage where one group's rate is below 80% of the highest group's, and record what you found and did.
  7. Keep logs for the retention period that applies to you, with access restricted to HR, compliance and counsel.

Who keeps one, after the 2025 changes

For decades the applicant flow log was mainly a federal contractor document, built to support affirmative action plans under Executive Order 11246. That order was revoked in January 2025, and the OFCCP stopped enforcing its race and sex affirmative action requirements. Two contractor programs remain in force: Section 503 of the Rehabilitation Act (disability) and VEVRAA (protected veterans). VEVRAA still requires contractors to invite applicants to self-identify as protected veterans and to keep yearly data on applicants and hires for three years. OFCCP rules effective September 2026 removed the Section 503 disability self-identification invitation and disability data collection, though written affirmative action programs for covered contractors remain. Confirm current rules with counsel.

The log is also useful well beyond contractors. Title VII still prohibits selection procedures that cause disparate impact without being job related, and the Uniform Guidelines on Employee Selection Procedures (1978) expect covered employers to keep data showing whether their selection steps affect groups differently. Federal enforcement priorities on disparate impact shifted in 2025, but the statute did not, and private plaintiffs and state agencies can still bring claims. EEOC rules generally require keeping hiring records for at least one year. The glossary entry on the applicant flow log covers the definitions in more detail.

Defining who counts as an applicant

The hardest part of the log is not the spreadsheet; it is deciding who belongs in it. A requisition for 40 customer service agents might draw 2,500 clicks, 1,400 started applications and 900 completed ones. Counting every click inflates the pool with people who never really applied.

The long-standing OFCCP approach for online hiring counts someone as an applicant when they applied electronically for a specific position, were actually considered, met the basic qualifications and did not withdraw before an offer. Many employers apply a similar definition voluntarily because it is defensible. Basic qualifications must be objective and set before review: "available for the 6-week day-shift training class" works; "good communicator" does not.

If you cannot review everyone, write down a neutral method, such as the first 300 complete applications or a random sample, and apply it every time. Collect self-identification with your EEO self-identification form and keep it away from decision-makers.

Worked example: checking a stage for adverse impact

A regional bank's operations center fills 40 seats. 600 people meet the basic qualifications: 360 women and 240 men. All take a typing and data-entry assessment. 216 women pass (60%) and 120 men pass (50%).

The impact ratio is the lower rate divided by the higher: 50% ÷ 60% = 83%. That is above the four-fifths rule threshold of 80%, so on this measure alone the assessment does not show adverse impact by sex.

Now the interview stage. Of 336 who passed, 100 are interviewed: 70 of the 216 women (32.4%) and 30 of the 120 men (25%). Ratio: 25% ÷ 32.4% = 77%. Below 80%. That does not prove discrimination, especially with small numbers, but it is the signal to look at how interview slots were offered, whether scheduling favored some shifts, and whether a statistical test confirms the difference. Run the same checks by race and ethnicity. Doing this per stage, not just at hire, is the point of the log; a final hire ratio can look fine while one step is screening a group out.

High-volume hiring and your ATS

At a few hundred hires a year, a manual log is possible. At a few thousand, it has to come from the recruitment tracker or ATS. Check that your system timestamps each stage, forces a disposition code when a candidate is closed, keeps self-ID data in a separate restricted table, and can export stage counts by group. Build a monthly stage-by-stage report rather than waiting for a requisition to close; evergreen requisitions for agents or warehouse associates may never close.

Automated screening deserves a closer look. If a knockout question, chatbot screen or AI scoring step removes candidates, it is a selection procedure and belongs in your stage analysis. New York City's Local Law 144 already requires bias audits for certain automated hiring tools, and other jurisdictions have similar rules. Requirements vary by state, city and country.

Common mistakes

  • No written basic qualifications, so the applicant pool cannot be defined after the fact.
  • Dispositions left blank, or a single catch-all code like "not selected" for every rejection.
  • Recruiters able to see self-ID answers in the candidate profile.
  • Analyzing only hires, never the screen, assessment and interview stages.
  • Deleting data from cancelled or evergreen requisitions before the retention period ends.

Frequently asked questions

What is an applicant log template?

It is a structured record listing every applicant for a job with dates for each hiring stage, a final disposition and voluntary self-identification data. This template includes a requisition header, per-applicant fields, disposition codes and a stage summary.

Do I still need EEO applicant flow data after Executive Order 11246 was revoked?

Federal contractors still have VEVRAA data collection duties for protected veteran status; OFCCP removed the Section 503 disability data collection requirement in September 2026. Race and sex flow data is no longer required under EO 11246, but it remains the practical way to check selection steps for disparate impact under Title VII and state law.

How is an applicant tracking log different from an applicant flow log?

An applicant tracking log follows candidates through the process for day-to-day recruiting. An applicant flow log uses the same stages but adds self-identification data, held separately, and a defined applicant pool so selection rates can be compared by group.

How long should applicant flow records be kept?

EEOC rules generally require hiring records for at least one year. VEVRAA data collection records are kept for three years. Many employers keep logs for two to three years to cover both and any claims period.

Should hiring managers see applicant self-identification data?

No. Self-identification must be voluntary and kept separate from the application, and it should not be available to anyone making selection decisions. Only HR, compliance and counsel need access, usually in aggregate.