You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Members (Non) by Member Type, Expire Date and Dues Processed Status Query
Members (Non) by Member Type, Expire Date and Dues Processed Status Query
This query returns a list of individuals by member type, dues processed status, and membership expire date range.
Query Parameters
Parameter | Description |
---|---|
Member Flag Is Equal To | Select a member flag from the drop down list: Member, Non-Member, All. |
Product Is Equal To | Select a product (membership type) from the drop down list. |
Expire Date Greater Than or Equal To | Enter a date, or select a date from the drop down calendar, for the query. |
Expire Date Less Than or Equal To | Enter a date, or select a date from the drop down calendar, for the query. |
Processed? Is | Click the box to select all individuals with dues processed set to true. |
Query (Default) Fields
Field | Description |
---|---|
Query Header | Displays the query name, number of records returned, and the total number of pages for the query. |
Individual Sort Name | Lists the individual sort name. |
PriAddr Address Line 1, 2, 3, City, State/Territory, Postal Code | Lists the individual primary address. |
PriPhone Phone Number | Lists the individual primary phone number. |
PriEMail E-Mail Address | Lists the individual primary email address. |
membership Join Date | Lists the individual membership join date. |
membership Effective Date | Lists the individual membership effective date. |
membership Expire Date Member | Lists the individual membership expire date. |
Member Status | Lists the individual member status. |
MemPrd Product Code | Lists the individual membership product code. |
DuesForCst Processed? | Indicates whether or not the individual membership dues has been processed. |