Opus Negotium Job Applications Live Table
Job Application Fields Key
Definitions are listed in the same order the fields appear on this page.
Live Table Controls
- Row Count: current page range and matching row count after filters.
- Last Refresh: local time when the live table last refreshed.
- Rows: number of application rows shown per page.
- Sort: selected ordering for the table rows.
- Page Controls: first, previous, page number, next, and last navigation for paged results.
- Refresh: manually reloads the live table from SQL.
Filters
- Search All Fields: broad search across the application fields returned by the API.
- Job App ID: aided exact filter for
[Job Application].[Job Application ID]. - Posting ID: aided exact filter for the linked
[Job Postings].[Job Posting ID]. - Application Status: exact filter for the latest matching
[Finished Applications].[Application Status]. - LinkedIn ID: aided exact filter for the linked posting's LinkedIn job ID.
- Job Title: exact application job-title dropdown filter.
- Company: logo-assisted exact company filter from
[Application Company]. - ATS Platform: exact filter for the detected application system or company career page type.
- Apply Domain: exact filter for the application page domain.
- Location: exact cleaned application location filter.
- Workplace: exact workplace-type filter.
- Posted Date: exact posted-date filter.
- Employment Type: exact employment-type filter.
Live Table Columns
- Job App ID / Posting ID: application row ID over linked posting row ID.
- Application Status / LinkedIn ID: latest matching finished-application status over the linked posting's LinkedIn job ID.
- Job Title: application-page job title; links to
Final URL, falling back toApply URL. - Company: company logo over company name, enriched from
[Company Live View]; links to the LinkedIn company page when available. - ATS Platform / Apply Domain: detected application platform over the application page domain.
- Location / Workplace: cleaned application location over workplace type.
- Posted Date / Employment Type: stored application posted date over employment type; blank dates display as
No Posted Date.