Build DOL LCA Employer Profile
lca_employer_profileCreate a comprehensive LCA employer profile with certification counts, wage statistics, top job titles, and willful violator flags using filters like employer name, fiscal year, and location.
Instructions
Build a DOL LCA-only employer profile with certification counts, wage statistics, top job titles, SOC codes, worksites, H-1B dependent, and willful violator flags.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| city | No | Worksite or employer city substring filter. | |
| state | No | Two-letter worksite or employer state filter. | |
| dateTo | No | Inclusive upper date bound in YYYY-MM-DD form. | |
| quarter | No | Fiscal quarter, 1 through 4. | |
| socCode | No | SOC code prefix filter. | |
| dateFrom | No | Inclusive lower date bound in YYYY-MM-DD form. | |
| jobTitle | No | Job title substring filter. | |
| dateField | No | DOL date field to filter on, default DECISION_DATE. | |
| localFile | No | Optional path to an already-downloaded official LCA disclosure XLSX file. | |
| naicsCode | No | NAICS code prefix filter. | |
| visaClass | No | Visa class, such as H-1B, H-1B1, or E-3. | |
| caseStatus | No | Case status, such as CERTIFIED or DENIED. | |
| fiscalYear | No | Federal fiscal year, such as 2026. | |
| maxResults | No | Maximum rows to return. | |
| searchMode | No | Employer match mode. | |
| employerName | Yes | Employer name to profile. | |
| minAnnualWage | No | Minimum annualized offered wage. |