Opus Negotium Opportunities – Deasy Corporation

Opportunity Viewer

Opportunity ID: internal master row ID from [Work].[Opus Negotium].[Opportunity]; loads one exact opportunity.
Suggestions: assisted Opportunity ID selector; labels combine opportunity ID, company, standard title, and status.
Filter Suggestions: narrows the suggestion list by company, title, status, or other label text.
Go: loads the selected or typed Opportunity ID.
Refresh: reloads the Opportunity options from [Opportunity Live View].

Company / Logo: hiring company name and logo from [LinkedIn].[Company Live View].
Status: current lifecycle status assigned on the Opportunity master row.
Standard Title: normalized job-title bucket used for comparison across postings and applications.
Workplace: remote, hybrid, on-site, or not-listed workplace type from the application/opportunity data.
Location: stated work location for the opportunity.
Compensation: actual compensation text captured on the Opportunity row, only where stated.
Evidence: counts of linked postings, applications, finished applications, and emails.
Opportunity ID: the unique master ID for this opportunity.

Opportunity ID: unique ID for the master opportunity row.
Opportunity Name: readable opportunity name, initially company plus job title.
Current Status: main opportunity status.
Current Status Subcategory: source-specific or reason detail under the main status.
Standard Job Title: normalized title used for grouping and sorting.
Work Location: stated city, region, or work location.
Workplace: remote, hybrid, on-site, or not listed.
Stated Compensation: compensation information explicitly stated in the evidence.

Company ID: linked company row ID from [Work].[LinkedIn].[Company].
Company: hiring company name from the LinkedIn company live view.
LinkedIn Company URL: LinkedIn company page URL for the hiring company.
Website URL: company website URL from the company live view.
Vendor Link: mapped DZC vendor page link, when the LinkedIn company is tied to a vendor.
Poster Count: count of job postings tied to the company.
Offerer Count: count of applications/opportunities tied to the company as offerer.
Applied Count: count of submitted/applied records tied to the company.
Passed Over Count: count of not-submitted or passed-over company rows in the company live view.

Job Application Count: number of linked rows from [LinkedIn].[Job Application].
Primary Job Application ID: main application evidence row used for single-row display.
Application Company: company name captured on the application record.
Application Job Title: job title captured on the application record.
Application Job ID: external/application job identifier captured with the application.
Location: location captured on the application record.
Workplace Type: workplace type captured on the application record.
Employment Type: employment type captured on the application record.
Apply URL: original application URL.
Final URL: final URL reached during the application flow.
Apply Domain: domain parsed from the apply URL/final URL.
ATS Platform: applicant tracking system or apply platform identified for the application.
Linked Posting ID: linked posting row ID from [LinkedIn].[Job Postings].
Posted Date: posting date carried through from the application evidence where available.

Posting Count: number of linked posting rows.
Posting IDs: comma-separated linked posting row IDs.
LinkedIn Job IDs: LinkedIn job identifiers from the linked postings.
Titles: posting title list from linked posting rows.
Companies: posting company list from linked posting rows.
Locations: posting location list from linked posting rows.
Workplace Types: workplace types from linked posting rows.
Source URLs: LinkedIn/source posting URLs.
Apply URLs: apply URLs captured from linked postings.
Earliest Posting Date: earliest posted date among linked postings.
Latest Posting Date: latest posted date among linked postings.
Any Easy Apply: yes/no flag showing whether any linked posting used LinkedIn Easy Apply.

Finished Count: number of linked finished-application evidence rows.
Finished IDs: comma-separated linked finished-application IDs.
First Submitted UTC: earliest submitted timestamp in UTC.
Latest Submitted UTC: latest submitted timestamp in UTC.
First Submitted Date: earliest submitted date.
Latest Submitted Date: latest submitted date.
Status List: distinct finished-application statuses from linked rows.
Latest Finished ID: most recent finished-application row ID.
Latest Status: status on the latest finished-application row.
Latest ATS Platform: ATS/apply platform on the latest finished-application row.
Latest Confirmation URL: confirmation URL on the latest finished-application row.
ATS Platform List: distinct ATS/apply platforms across linked finished applications.
Confirmation URL List: confirmation URLs across linked finished applications.

Email Count: number of linked email evidence rows.
Email IDs: comma-separated linked email IDs.
First Received: earliest received email datetime.
Latest Received: latest received email datetime.
Latest Email ID: ID of the most recent linked email.
Latest Subject: subject of the most recent linked email.
Latest Body Preview: short preview from the most recent linked email body.
Latest Display URL: URL to open or view the most recent linked email.
Latest Sender: sender on the most recent linked email.
DZON Category List: distinct DZON email categories across linked emails.
DZON SubCategory List: distinct DZON email subcategories across linked emails.
Attachment Count: total linked email attachment count.

Row Count: current visible row range and matching row total after filters.
Last Refresh: time the iframe last loaded live data from Mega.
Source: source view name, [Work].[Opus Negotium].[Opportunity Live View].
Row Limit: number of rows shown per page.
Sort: selected ordering for the visible table rows.
First: jumps to the first page of matching results.
Prev: moves back one page.
Page: current page number.
Next: moves forward one page.
Last: jumps to the last page of matching results.
Refresh: reloads the live table data from Mega.
Search: all-fields text search across the loaded opportunity rows.
Status: filters by current opportunity status.
Subcategory: filters by current status subcategory.
Company: filters by hiring company.
Standard Title: filters by normalized job title.
Workplace: filters by remote, hybrid, on-site, or not-listed workplace value.
Compensation Present: filters to rows with or without stated compensation.
Postings: filters to rows with or without linked posting evidence.
Applications: filters to rows with or without linked application evidence.
Finished: filters to rows with or without finished-application evidence.
Emails: filters to rows with or without linked email evidence.

Logo / Opportunity ID: hiring company logo plus the master Opportunity ID.
Opportunity / Job Title: hiring company link, opportunity name/link, and normalized job title.
Status / Subcategory: current status and current status subcategory from the Opportunity row.
Workplace / Location: workplace type and stated work location.
Compensation: stated compensation text, or not stated when blank.
Postings / Applications / Finished / Emails: counts of linked evidence rows for the opportunity.