Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Persons service (part of the Customer Management application) contains sample views in the following view types:

Anchor

...

_list

...

_list
List Views

The following sample list views are contained within the Persons service:

Anchor

...

_list1

...

_list1
Active Committee Members

Active Committee Members View
The Active Committee Members view lists all persons that are currently actively participating in a committee term.

Anchor

...

_list2

...

_list2
Active Individual Members

Active Individual Members VIew
The Active Individual Members view lists active individual members currently in the system. This view is filtered by the Member Type field on the Persons record where Member Type is not Non-Member.

Anchor

...

_list3

...

_list3
All Persons

All Persons View
The All Persons view displays all persons currently in the system. This view contains the person's ID, Name With Company, First Name, Last Name, Title, Address information (including Billing and Home address), Phone information, Fax information, and Cell information.

Anchor

...

_list4

...

_list4
All Persons Within Company

All Persons Within Company View
The All Persons Within Company view is a hierarchal view that can be used on a Companies form. The hierarchy drill-down shows the person's Functions and Subscription as shown above.

Note that this view does not contain any view filters because it is intended for use on a Companies form.

Anchor

...

_list5

...

_list5
Members Almost Expired (90 Days)

Members Almost Expired View
The Members Almost Expired (90 Days) view is a list of individual members who are currently active but within 90 days of their memberships expired date. This view is filtered by the Dues Paid Thru field.

Anchor

...

_list6

...

_list6
Prior Attendees, Not Registered for 06

Prior Attendees View
This view displays all persons that attended a prior Annual Conference but are not registered for the 2006 conference. This view is filtered by the Annual Conference meeting product series and the Sampco 2006 Annual Conference (derived from sample data).

Anchor

...

_list7

...

_list7
Person Drill-Down

Person Drill Down View
The Person Drill-Down view is a hierarchal view that displays Persons and their Functions.

Anchor

...

_list8

...

_list8
Prior Individual Members

Prior Individual Members View
The Prior Individual Members view lists individual members who are no longer active. This view is filtered based on the Dues Paid Thru field on the Persons form.

Anchor

...

_list9

...

_list9
Person Lookup

The Person Lookup view is a prompted view for a lookup of Persons by Last Name, First Name, Member Type or ID. For best results, only complete one of the four fields.
Prompt Value for Person Lookup
Once the appropriate information has been entered into the prompted dialog, clicking OK loads the view.
Person Lookup View

Anchor

...

_list10

...

_list10
Persons Modified Last 24 Hours

Person Modified Last 24 Hours View
The Person Modified Last 24 Hours list view displays Persons records that have been modified within the past 24 hours.

Anchor

...

_list11

...

_list11
Placed Orders in 2005, earlier, Not in 2006

Placed Orders in 2005 View
The Placed Orders in 2005, earlier, Not in 2006 view lists Persons who have placed orders in 2005 or earlier, but not in 2006. This view examines orders where the Person is the Ship To ID of an order.

Anchor
_chart
_chart
Chart Views

The following sample chart views are contained within the Persons service:

Anchor

...

_chart1

...

_chart1
Avg. Age By Join Year

Avg. Age By Join Year View
The Avg. Age By Join Year line chart shows the average age of members by their join year by showing the age of the member at the time they joined plotted over time.

Anchor

...

_chart2

...

_chart2
Avg. Age By Member Type

Avg. Age By Member Type View
The Avg. Age By Member Type list view is a column chart that displays the average age of current members by Member Type. This view filters out Non-Members.

Anchor

...

_chart3

...

_chart3
By Primary Function

By Primary Function View
The By Primary Function list view is a pie chart that analyzes Persons by their primary function which is found on the Functions tab of the Persons record.

Anchor

...

_chart4

...

_chart4
Comparative New Members By Year/Qtr


The Comparative New Members By Join Year/Qtr chart view lists all new memberships by quarter and year. This view is filtered by the Join Date field on a Persons record. This column chart analyzes year-over-year membership trends.

Anchor

...

_chart5

...

_chart5
New Members By Year

New Members By Year View
The New Members By Year line chart identifies the number of new members of each Member Type that joined in a particular year. It excludes Persons with a blank Join Date field.

Anchor

...

_chart6

...

_chart6
Pie Chart By Country (Form)

Pie Chart By Country (Form) View
The Pie Chart By Country (Form) view can be found on the Companies form's Analysis tab to show the distribution across countries of a company's associated Persons.

Anchor

...

_chart7

...

_chart7
Pie Chart By State (Form)

Pie Chart By State (Form) View
The Pie Chart By State view can be found on the Companies form's Analysis tab to show the distribution across states of a company's associated Persons.

Anchor

...

_pivot

...

_pivot
Pivot Table Views

The following sample pivot tables are contained within the Persons service:

Anchor

...

_pivot1

...

_pivot1
Members By Topic/Country/State


The Members By Topic/Country/State pivot table lists members grouped by Topic Code, Country, and State.

Anchor

...

_pivot2

...

_pivot2
People By Topics

People By Topics View
The People By Topics pivot table groups Persons by Topic Code associations.