Custom report template - Active employees

The My Reports feature allows company users to build custom reports that will be saved in this section. Once the report is built, it will live in the My Reports tab, automatically refreshed daily. Reports can be added, edited or removed any time for future reference. This feature is designed to provide users with the flexibility to build reports that support their specific immigration program allowing for robust reporting capabilities. 

If you are looking to build a custom report that includes all of your company's active employees in the Envoy Global platform, you can get started in My Reports by using the below template. Please note that Division Administrators will only be able to view employees that pertains to the divisions that they have access to. 

Only employees with an active Envoy Global account, will appear on this report. 

Active employees template

To build an active employees report in My Reports, follow the below steps. We recommend using the data fields exactly as they appear in the template. 

1. Go to the Analytics tile from the company home page.
2. Click on the My Reports tab. 
3. Select Build Custom Report.
4. From the left menu, enter the below measures into the Find columns search bar. Select the measure checkbox, then click the filter icon to apply the correct filter. Then, select Apply.
   1. Employee Active Flag - Filter: 'Yes'
   2. If applicable, you can filter by destination country
      • For United States inbound employees: 
        • Visa Status Country - Filter: Include 'United States'
      • For international only employees:
        • Document Country - Filter: Exclude '{Empty}', 'United States'
        • Document Type - Filter: Exclude '{Null}', Passport Expiration, Color Copy of Passport (all pages)

        • Employee Visa Status - Filter: Exclude any U.S. status listed

          

5. Enter the following data fields exactly as they appear below into the top Search bar. Click on the data field to add it as a column to the report. 
   1. Division Name 
   2. Employee Account Number 
   3. Employee Full Name 
   4. Employee Start Date_Filter (once this data field is added, then type 'daily' next to it, to ensure you can filter it by date once the report is built)
   5. Employee 
   6. Job Title 
   7. Department 
   8. Work Address 1 
   9. Work Address City 
   10. Work Address State or Province 
   11. Employee Citizenship Country 
   12. Employee Birth Country 
   13. Cases in Progress 
   14. Employee Email

For U.S. inbound casework, include these additional data fields: 

1. Employee Visa Status
2. Employee Status Expiration Date_Filter (once this data field is added, then type 'daily' next to it, to ensure you can filter it by date once the report is built)
3. Max-Out Date_Filter (once this data field is added, then type 'daily' next to it, to ensure you can filter it by date once the report is built)
4. Green Card Step in Progress
5. EB Category
6. Approved I-140 Flag
7. Priority Date
8. I-140 from Employer

For international casework, include these additional data fields: 

1. Document Country
2. Document Type
3. Expiration Date_Filter (once this data field is added, then type 'daily' next to it, to ensure you can filter it by date once the report is built)

6. Click Go.

Editing headers, formatting, and sorting

To edit the header of a column, simply click on the header and edit the text. To save the change, click off of the header and it will save automatically. Once a header is updated, it will reflect on the report moving forward, but it will not change the name of the corresponding data field. 

To rearrange columns, drag the column to the desired location. 

To sort a column on the report, click on the header and sort options will appear. For more complex filtering and sorting capabilities, we recommend downloading the report from three dots (edit option) to edit it using Excel or another program. 

Sharing custom reports

Reports built in this feature can be shared with any colleagues who have Company Administrator, Division Administrator, or Analytics user roles. To share a report, follow the below steps: 

1. Click the three dots at the top of the report and select Share. 
2. Enter the email address of the user you would like to share the report with. 
3. Select their editing permission Can View or Can Edit. 
4. Click Share.

They will receive an email notification that the report was shared with them. When they log into the Envoy Global platform, the report will appear under the My Reports tab.

Please note that users with Division Administrators access will only be able to data relevant to the divisions that they have access to.