This online report lists members alphabetically by chapter, member class and subclass, and member name. The report contains member information at the individual level, to serve the needs of professional associations (where individuals are members). Members who belong more than one chapter will appear on the roster for each chapter to which they belong. For this reason, the report selects chapter members based on current order records in the Order_Detail table, because the Cus_Membership_Info_VW only contains information about the first two chapters to which a member belongs.
The members' employer company name is selected from Cus_Relationships, not from Cus_Address_Detail.
Because this roster is an external report, all communication flags are checked and users have the option of including the organization's logo in the header. Customer ID numbers are not included, nor is additional membership information, such as join date, expiration date, or other membership attributes such as chapter and section membership.