Queries for Real Estate Associations
The Real Estate specific queries are:
NRDS Push Status – This query shows status of data pushes to NRDS from netFORUM for all customers who match the query criteria.
NRDS Push Error Only Log – This query will list NRDS push errors only by date range.
MLS/Supra Subscriber List by Member Flag and Subscription Status - This query will pull a list of MLS and Lockbox subscribers based on member flag and subscription status. Helps reconcile MLS/Lockbox sync.
Outstanding Membership Dues Orders including Broker Name - This query will pull a list of open orders for Realtor Individuals which includes the name of their org and primary broker.
Outstanding Membership Dues Orders by NAR ID - This query will pull a list of all individuals who have an open dues order based on the Org NAR ID.
Realtor Event Registration/Sign In Sheet - This query will pull basic event registration information with NRDS demographics.
ACH Control Number Query - This query will allow staff to enter the ACH control number from Ecommerce to match with the payer of the transaction.
Realtor Payment Query - This query will pull basic payment information that includes NRDS demographics plus the ACH control number.
Realtor Donations (RPAC) by Payment Date Range - This query will pull detailed RPAC donation information.
Realtor Members by Member Status - This query will pull Realtor Members by Member Status.
Realtor Members by Join Date - This query will pull Realtor Members by Join Date.
Realtor Members by Member Type - This query will pull Active members based on more than one Membership Type.
Member Reconciliation (Flagged Members without Active NAR Status) - This query will pull flagged Members who don't have an Active NAR Status.
Secondary Members (Members Outside Primary Board) - This query will pull all Members who have a primary association outside of the primary board.
Realtor Committee Members by Committee - This query will pull committee participants with NRDS demographics
Brokers/Primary Contacts of Active Offices - This query will pull the primary broker (primary contact) of offices by office NAR status.
Realtor Membership Query - This query will pull a list of members with Active NAR status based on their primary board.
Query Tool – The following four fields are available for use in the Query Tool:
- Office Branch Type
- NRDS Join Date
- Office Non-Member
- Sales Person Count