Exporting Occupancy Information for Brycer TCE

Exporting Occupancy Information for Brycer TCE

Purpose

This article is designed to show you how to build an Ad Hoc report to export your occupancies for Brycer TCE.

Instructions


  1. Log in to your First Due Account and navigate to the Reports Module.





  2. Select Ad-Hoc Reports.




  3. Select Add Report to create a report.




  4. Under the Basic information section:
    1. Name your Report Ex: "Occupancies for Brycer TCE
    2. In the Module dropdown select Occupancies




  5. In the Data Source Configuration section, select Occupancies from the list.  ("Occupancies" can easily be found by typing the name in the open box)





  6. In the Report Type section select Tabular Report.




  7. In the Columns sections select the following items:
    1. Occupancy Id
    2. Address 1
    3. Address 2
    4. City
    5. State
    6. Zip
    7. Latitude
    8. Longitude
    9. Business Name
    10. Property Use
    11. Property Class



      Once selected use the  symbol to move them over





  8. In the Criteria section select the   and enter: "Address 1 is not null"





  9. In the Settings section select the following options:
    1. Document Orientation > Portrait
    2. Sharing > Everyone
    3. Allow other users to apply changes to this report > Select





  10. Select the Play button to run the report.





  11. Once you have ran the report you will need to download the report using the  Icon.



If your report contains more than 20,000 rows you will need to email the report to yourself from the Actions column in Reports.





    • Related Articles

    • The Compliance Engine - Alert Tiles

      Purpose The purpose of this Knowledge Base Article is how to view data received from Brycer - The Compliance Engine in your First Due account. Related Article Brycer - Places for Review Video Instructions 1. Click on Pre-Planning. 2. Click on ...

    • Places for Review

      Purpose The purpose of this Knowledge Base Article is to review and demonstrate how a user will create an Occupancy using data from Brycer - The Compliance Engine (TCE). Special Notes Requires an Integration between your Brycer account and First Due. ...

    • TCE Premise ID Field

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to view and edit the TCE Premise ID field. Video Instructions 1. Click on Pre-Planning. 2. Click on Pre-Plan Organizer. 3. Click on Columns to show. 4. Click on TCE Premise ID. ...

    • v_occupancy_history

      Purpose Historical occupancy information. Relationships v_occupancy: Many-to-One (N:1) Many history records link to one occupancy Referenced through place_id Table Column Type Description id integer Primary key place_id integer Location reference ...

    • Managing the Occupancy Record

      Purpose To demonstrate navigating through and updating the Occupancy Record. Related Articles Editing Occupancy Address Video Instructions 1. Click on Inspections. 2. Click on Inspection Organizer. 3. Select an inspection type and then change. 4. ...