Recruitment Pipeline

Entity summary

Name	data_object	Description
Applicant Flow Records	applicant_flow_records	OFCCP-mandated logs of every internet applicant against a requisition, capturing demographics, expressed interest, qualifications, and disposition for audit.
Application Dispositions	application_dispositions	Categorized reasons a job application was not selected, driving OFCCP applicant-flow reporting and internal hiring analytics.
Application Screening Answers	application_screening_answers	Candidate answers to screening questions on a specific job application, used to auto-disqualify on knockout rules.
Application Screening Questions	application_screening_questions	Custom screening questions attached to a job posting or template, including knockout and qualifying questions with their answer type and rules.
Application Stage Transitions	application_stage_transitions	Audit-trail records of an application moving between stages, with from-stage, to-stage, actor, timestamp, and reason for cycle-time analytics.
Application Stages	application_stages	Configured stages in the recruiting pipeline (sourced, applied, screened, onsite, offer, hired) that define a job application's lifecycle.
Applications	job_applications	Candidate submissions against a specific requisition, with pipeline stage, status, source, and full evaluation history.
EEO Responses	eeo_responses	Voluntary self-identification submitted by applicants for equal-employment reporting, stored separately from candidate records per regulation.
Hiring Team Assignments	hiring_team_assignments	Assignments of specific users to recruiter, hiring manager, coordinator, interviewer, and reviewer roles on a single requisition.
Job Posting Distributions	job_posting_distributions	Syndications of a job posting to external boards, with board name, post and expiry times, cost, and applicant attribution.
Job Postings	job_postings	Published, candidate-facing versions of a requisition on a career site or job board, one requisition possibly having many postings.
Job Requisitions	job_requisitions	Approved requests to hire for a specific role, carrying headcount, level, location, hiring manager, recruiter, and status.
OFCCP Audit Trails	ofccp_audit_trails	Immutable, append-only audit logs of every applicant-flow event for federal contractors, carrying the actor, timestamp, and compliance-relevant fields.
Requisition Approvals	requisition_approvals	Approval steps that gate opening a job requisition, each recording the approver, decision, timestamp, and rationale.
Voluntary Self-Identifications	voluntary_self_identifications	Voluntary candidate disclosures of protected-class membership per EEOC and OFCCP requirements, recording the offer or decline-to-answer decision and audit metadata.
Candidates	candidates	People known to the recruiting organization, with or without an active application, carrying contact details, resume, tags, consent, and source.
Job Profiles	job_profiles	Canonical role definitions in the job catalog: title, family, level, responsibilities, required skills, pay range, and FLSA class. Many positions share one profile.
Locations	locations	Physical or organizational locations referenced across the system, used to place and group other records.
Org Units	org_units	Nodes in the organizational hierarchy such as divisions, departments, and teams, with manager, cost center alignment, geographic scope, and parent-child links.
Positions	hcm_positions	Approved org slots with role definition, cost center, reporting line, location, and FTE allocation. Each can be open, filled, or eliminated.

flowchart TD
  classDef master fill:#d4f4dd,stroke:#27ae60,color:#0b3d20;
  classDef embedded_master fill:#fff4cc,stroke:#c79100,color:#5b4500;
  classDef platform_builtin fill:#e0e0e0,stroke:#424242,color:#1a1a1a;
  job_requisitions["Job Requisitions"]
  job_postings["Job Postings"]
  job_applications["Applications"]
  candidates["Candidates"]
  hcm_positions["Positions"]
  org_units["Org Units"]
  locations["Locations"]
  job_profiles["Job Profiles"]
  application_stages["Application Stages"]
  application_stage_transitions["Application Stage Transitions"]
  requisition_approvals["Requisition Approvals"]
  job_posting_distributions["Job Posting Distributions"]
  application_screening_questions["Application Screening Questions"]
  application_screening_answers["Application Screening Answers"]
  eeo_responses["EEO Responses"]
  hiring_team_assignments["Hiring Team Assignments"]
  application_dispositions["Application Dispositions"]
  ofccp_audit_trails["OFCCP Audit Trails"]
  applicant_flow_records["Applicant Flow Records"]
  voluntary_self_identifications["Voluntary Self-Identifications"]
  users["Users"]
  job_requisitions -->|"defines_pipeline"| application_stages
  job_applications -->|"transitions_via"| application_stage_transitions
  application_stages -->|"lands_at"| application_stage_transitions
  job_requisitions -->|"gated_by"| requisition_approvals
  job_postings -->|"syndicates_via"| job_posting_distributions
  job_postings -->|"asks"| application_screening_questions
  job_applications -->|"answers_via"| application_screening_answers
  application_screening_questions -->|"answered_by"| application_screening_answers
  candidates -->|"self_identifies_via"| eeo_responses
  candidates -->|"self_ids_via"| voluntary_self_identifications
  job_applications -->|"disposed_via"| application_dispositions
  job_applications -->|"logged_via"| applicant_flow_records
  job_requisitions -->|"staffed_by"| hiring_team_assignments
  applicant_flow_records -->|"audited_via"| ofccp_audit_trails
  org_units -->|"contains"| hcm_positions
  job_profiles -->|"defines"| hcm_positions
  hcm_positions -->|"spawns"| job_requisitions
  job_profiles -->|"feeds"| job_postings
  job_requisitions -->|"is advertised through"| job_postings
  job_requisitions -->|"receives"| job_applications
  job_postings -->|"is applied to via"| job_applications
  candidates -->|"submits"| job_applications
  org_units -->|"rolls_up_to"| org_units
  locations -->|"rolls_up_to"| locations
  hiring_team_assignments -->|"assigns"| users
  candidates -->|"has owning recruiter"| users
  job_postings -->|"has publisher"| users
  application_stage_transitions -->|"has author"| users
  applicant_flow_records -->|"has owner"| users
  requisition_approvals -->|"has approver"| users
  ofccp_audit_trails -->|"has author"| users
  users -->|"manages"| hcm_positions
  users -->|"leads"| org_units
  users -->|"owns"| job_profiles
  job_requisitions -->|"has recruiter and hiring manager"| users
  job_applications -->|"has owning recruiter"| users
  org_units -->|"has members"| users
  locations -->|"houses"| users
  class job_requisitions master;
  class job_postings master;
  class job_applications master;
  class candidates embedded_master;
  class hcm_positions embedded_master;
  class org_units embedded_master;
  class locations embedded_master;
  class job_profiles embedded_master;
  class application_stages master;
  class application_stage_transitions master;
  class requisition_approvals master;
  class job_posting_distributions master;
  class application_screening_questions master;
  class application_screening_answers master;
  class eeo_responses master;
  class hiring_team_assignments master;
  class application_dispositions master;
  class ofccp_audit_trails master;
  class applicant_flow_records master;
  class voluntary_self_identifications master;
  class users platform_builtin;
  style hcm_positions stroke-dasharray:5 5;
  style org_units stroke-dasharray:5 5;
  style locations stroke-dasharray:5 5;
  style eeo_responses stroke-dasharray:5 5;
  style application_dispositions stroke-dasharray:5 5;
  style ofccp_audit_trails stroke-dasharray:5 5;
  style applicant_flow_records stroke-dasharray:5 5;
  style voluntary_self_identifications stroke-dasharray:5 5;