Skip to main content

Code of Ethics - Agents Missing Report

Updated

 

The Goal: Run the Code of Ethics Missing Report to identify and notify agents who have not completed their required training for the current cycle, so they can stay in good standing and remain members of your association.

Before You Begin:

  • You must be the PRIMARY board. Only the primary board is the recording entity/authority that can determine whether an agent has completed the NAR Code of Ethics requirement — this report will not pull data for secondary agents.
  • Know which cycle you want to report on.
  • To turn the results into a synchronized list for ongoing communication, review Smart List - Dynamically Update Contacts in Lists/Committee from Report Results for details on setting up your lists. The companion Code of Ethics Completed Report is also available to show who has completed the required training, including the date of completion and the cycle.

Step-by-Step Instructions

  1. Click Reports in the left-hand rail.

  2. Use the Quick Filter or the Customize Filter to apply the Contacts category.

  3. Select the Code of Ethics Missing Report.
  4. Select your search filtering criteria:
    • Missing Cycle: the cycle that you wish to report on.
    • Membership Status: are we looking for a member, a non-member, a dropped member, etc?
    • Membership Type: select your Realtor® membership types.
      • Affiliate membership can be excluded as they are not required to take COE.
      • Secondary memberships can also be excluded as they are meeting the requirement by the primary Realtor® Association.
    • Membership Level: are we looking for a list of agents with a specific membership level?
    • Membership Category: if you have several membership types under a certain category, you can use this filter to report on them as a group rather than selecting them individually under the Membership Type filter.
    • Tags: does the contact contain a specific tag or tags?
    • State/Province: does the contact have a specific state/province in their address?
  5. (Optional) Enter any Additional Criteria/Filters as needed. Click the small plus on the left to add additional criteria/filters. We don’t need any additional criteria for this report, so this will remain empty.
  6. (Optional) Select Display Options. The report is set up with default fields to display; you may add or remove fields by clicking on the Fields to Display drop-down arrow and searching or scrolling for the field you want to include. To add a field to the display options, enable the checkbox to the left of the field name. You may wish to add the “M1 ID” field.
  7. (Optional) Select Summarize By criteria. This optional field allows you to select how you wish report results grouped. (Summarize options are listed alphabetically in the dropdown, but recently/commonly used selections will “stick” to the top of the list.) You may wish to select “Primary Business” in order to group the results by the office that the agent belongs to. This will allow you to better assist the brokers with their office.
  8. Click Run Report.

See the following for Common Report Functions:

Common Pitfalls

  • Running it from a secondary board: Only the PRIMARY board can determine COE completion. If you run this from a secondary board, the report will not pull data for those agents — confirm you are the primary board before reporting.
  • Forgetting to exclude Affiliates and secondary memberships: Affiliates are not required to take COE, and secondary members meet the requirement through their primary association. Filter them out in Membership Type so your missing list reflects only the agents who truly still need training.

Related articles