Access the information about a Circle by using Millennium Explorer, Profiles > Circle Definition. |
Access the information about the Circle's Members by using Millennium Explorer, Profiles > Circle Definition. |
Access the information for all of the Circles that a single constituent is a member of by using Millennium Explorer, Profiles > Biographical > Circle. |
Circles offer a way to track relationships between a constituent and a group of constituents. For examples, Circles can be created and maintained for constituents who:
Circles is a sub-World of the Profiles World. There are two major components to Circles functionality. One is the Circle itself. A Code and a Name must be created for a Circle, and other Circle definition options can be set as desired. The other component is Membership within the Circle. Once the Circle is defined, constituents can then be assigned as members to it.
To get the overall picture for a single Circle, use Millennium Explorer, to access the Circle Search form, and then use the Circle Search form to locate (or create) a Circle. Once located (or created), the details about the Circle and the details about all of the members of that Circle will display.
To get the overall picture for a single constituent's participation in the Circles sub-World, locate the desired constituent, and then use Millennium Explorer, to access the constituent's standard Profiles World Circle data display. Every Circle that the constituent is a member of is shown as a separate data record in that display.
This topic is a discussion of the Circles sub-World when viewed from the perspective of the Circle. It discusses the creation, maintenance, and display of Circle records, and the display and maintenance of Circle Member records when those records are accessed and maintained from the Circle definition display.
The Circle Membership topic is a discussion of the Circles sub-World as viewed from the perspective of the constituent. It will discuss the creation, maintenance and display of the constituent's Circle Member records when those records are maintained from the constituent's Circle data display.
If you intend to assign Types to the Circles that you will be maintaining, then active entries in the Circle Types lookup table must be created before inserting and updating Circles. Examples of common types include Family, Business, Social, Club, Fundraising, Scholarship, Alumni Class.
The Circle Types (circle_types) table is a Profiles lookup table. The Lookup Table Maintenance topic provides the details for creating these entries.
If you intend to assign Circle Members to Positions within a Circle, then active entries in the Circle Position lookup table must be created before inserting and updating Circle Members. Examples of common positions include Elder, Father, Mother, Grandmother, Grandfather for Family Circles, President, Vice-President for Club Circles, Class Agent, Secretary for Alumni Class Circles, various dollar levels for Scholarship circles.
The Circle Position (circle_position) table is a Profiles lookup table. The Lookup Table Maintenance topic provides the details for creating these entries.
If a Circle is going to have an owner, then the owner must be an Abila Millennium constituent.
Circle Members must be Abila Millennium constituents.
The Circle Definition display and maintenance forms can be changed to add fields that are not included on the standard forms, to remove standard, but not required fields, to change labels, and to change the placement of the fields on the forms. (Refer to the Custom Display Designer topic for complete instructions on customizing display and maintenance forms.)
The Circle Member display and maintenance forms can also be changed to add fields that are not included on the standard forms, to remove standard, but not required fields, to change labels, and to change the placement of the fields on the forms. (Refer to the Custom Display Designer topic for complete instructions on customizing display and maintenance forms.)
Note:
The forms that are used to maintain and display Circle Membership from
the individual member Profiles World display are customized by using a different Custom
Display Designer menu sequence.
Once a Circle is accessed, information about the Circle displays under the Circle Definition header. The standard information shown includes the Name, the Code, the Circle Type, to display or not display a summary of Circle Members' gift giving history, to include or not to include the Circle on an individual member's Relation Tree display, and the Circle's Active/Inactive status.
The Circle owner's name, if one is assigned, is a hyperlink. When clicked, the display will switch to the owner's Basic Data page.
If the option to display a summary of the Circle Members' gift giving history is selected, a financial summary line will be shown directly below the Circle information. Two totals are calculated and displayed - one for Giving and one for Outstanding Pledges. The totals will include only transactions from the active Circle Members. Each user can select the options that the system will use when picking the transactions to include in each of the totals.
Information about all of the constituents who have been assigned as members to the Circle will be shown under the Circle Members header. The Circle Member display will be sorted in alphabetical order by member name. The standard information that displays for each Member includes his or her Name, position within the Circle, Join and End Dates, and the Member's Active/Inactive status within the Circle. Each member's name is a hyperlink. When clicked, the display will switch to the display of all of his or her Circle Membership records.
Use the Circle Search form to access an existing Circle's information, add members to it, and update or delete it.
The Circle Search form is also used as the starting point for creating a new Circle.
If the Circle
will be owned, enter the owner's ID number, or the owner's name using
standard Name
search
formatting, in the Circle Owner field .
If you have entered Circle
Owner information, the system will use that information to perform
a constituent standard
ID Search
before creating the Circle record.
Canceling the Circle ID Search will not cancel the creation of the Circle record.
Tip: The system will not restrict you from creating more than one Circle with the same name. If you want to avoid duplicate Circle names, verify that your Circle's name is not already in use by selecting the Include Inactive Circles in the Search check box when using the Circle Search form.
Click Update.
If your changes include updating Circle Owner
information, the system will perform a constituent standard ID Search
before updating the Circle record.
Click Delete.
If a Circle has Members, you will be asked to confirm the Delete. Click OK to continue the delete process, or click Cancel to halt it.
Note: When you delete a Circle that has members, the system will delete all of the Circle member records from the circles data table, and then delete the Circle record from the circle_definition table.
All Circle Membership maintenance tasks can be performed from the display of the Circle. This eliminates the need for the user to locate and display the data for each and every constituent who is or will be a Circle Member.
Access the Circle Members Insert form.
Point to the Edit
button located to
the left of the Circle's name. Click the Insert
Member menu item.
Or
Point to or click the Circle
Members header Edit button .
Click the Insert Member menu item.
Enter the constituent's
ID number or name in the ID field using standard
Name search
formatting.
Click Insert.
The system will use the ID field information
to perform a constituent standard
ID Search
before creating the Circle Member record.
Canceling the Circle ID Search will not cancel the creation of the Circle record.
Note: Constituents who are already members of the Circle will not be listed in the ID Search Results.
The Circle Member record will be marked Active by default. However, once you assign an End Date, the system will uncheck the flag and mark it as Inactive. Therefore, do not assign an End Date to the Circle Member record until the Circle Membership for the constituent has ended.
The system will not automatically make the Circle Owner a member of the Circle. You must explicitly add him or her as a Circle Member.
Click Delete.
You will be asked to confirm the Delete. Click OK to continue the Delete process, or click Cancel to halt it.
If the option to display a summary of the Circle Members' gift giving history is selected, the system calculates two totals and displays them below the information about the Circle. Outstanding Pledges is the total balance remaining on the pledges, sustainer pledges, expectancies, and match pledges that have been made by the Circle Members. Donations that have been made by Circle Members are used in the Giving total. Each user can select the options that the system will use when selecting which transactions to include in these totals. At the user's discretion, these totals can include the donations and outstanding pledge balances for all Giving Campaigns, or donations and outstanding balances for only one. These options are the same options that the system uses when calculating Giving Trends for a single constituent. The Giving Trends topic provides complete information about the various options.
To display the Giving and Outstanding Pledge totals, select the Financials check box when creating a new Circle or updating an existing one.
To set the options that the system will use when calculating the Giving and Outstanding Pledges totals:
Select the other options as desired. Click OK.
Or
Click Cancel to discard your changes.
Information about Circles is stored in the circle_definition lookup table. The following fields are included. The field labels and the non-displaying designations that are listed are those that the system uses by default. All custom fields are non-displaying by default. If you want to override these default settings, you must customize your display definition.
Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.
Field Name Field Label |
Lookup Table |
Type SQL/Oracle Length [Default] SQL/Oracle {Check} |
Description |
---|---|---|---|
cir_code Code |
char 6
|
This field is the site-assigned code for the Circle. This field should not be blank. Each Circle must have a unique code. | |
cir_val Name |
varchar/varchar2 65
|
The free text name given to the Circle. This field should not be blank. | |
cir_type (non-displaying) |
table_groups |
char 6 [' ']
|
This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution.
This field is not the same as the Circle Type (cir_ctype) field. The lookup table that 'drives' the Circle Type field is specific to the Circle sub-World. The table_groups lookup table is used here and also used by the Profiles, Events, and Reporting Worlds. |
cir_amt1 (non-displaying) |
money/number (19,4)/(16,2) [0]
|
This field is reserved for future use by Abila Millennium. | |
cir_amt2 (non-displaying) |
money/number (19,4)/(16,2) [0]
|
This field is reserved for future use by Abila Millennium. | |
cir_mgp1 Maintenance |
numeric/number 10,0 [67108863]
|
This field is used to track Maintenance Group information for security purposes. | |
cir_mgp2 Maintenance |
numeric/number 10,0 [67108863]
|
This field is used to track Maintenance Group information for security purposes. | |
cir_agp1 Access |
numeric/number 10,0 [67108863]
|
This field is used to track Access Group information for security purposes. | |
cir_agp2 Access |
numeric/number 10,0 [67108863]
|
This field is used to track Access Group information for security purposes. | |
cir_date no label |
datetime/date
[getdate()]/sysdate
|
This field holds the date of the last edit to this row. (system field) | |
cir_user no label |
varchar/varchar2 30 [suser_sname()]/user
|
This field holds the User ID of the last user to edit this row. (system field) | |
cir_ugrp (non-displaying) |
char 1 [' ']
|
This field holds the User Group letter of the last user to edit this row. (system field) | |
cir_actv Active? |
char 1 ['N']
|
This field flags the row as Active or Inactive. | |
cir_comm Comment |
varchar/varchar2 255
|
This is a free text comment that may be attached to this lookup table entry. | |
cir_dspfin Financials |
char 1 ['N']
|
If this Yes/No flag field is set to 'Y', then a summary of the active circle members' giving data will display with the Circle. If it is set to 'N', then it will not. | |
cir_relnet Relation Tree
|
char 1 ['N']
|
If this Yes/No flag field is set to 'Y', then this Circle and all of its active members is available for display with each active member's Relation Tree. | |
cir_owner Circle Owner
|
char 10
|
This field holds the ID number of the constituent who owns the Circle. It is not mandatory that a Circle be owned by a constituent. | |
cir_ctype Circle Type
|
circle_types |
char 6 [' ']
|
This field holds the Type that is assigned to the Circle. Family and Business are two examples of Circle Types. |
cir_dte1 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte2 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_mny1 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny2 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_num1 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num2 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_chck |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_lku1 | circle_def_lookup1 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
cir_lku2 | circle_def_lookup2 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
cir_lku3 | circle_def_lookup3 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
cir_text |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. | |
cir_dte3 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte4 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte5 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte6 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte7 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte8 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dte9 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dt10 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dt11 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_dt12 |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. | |
cir_mny3 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny4 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny5 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny6 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny7 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny8 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mny9 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mn10 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mn11 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_mn12 |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. | |
cir_num3 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num4 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num5 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num6 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num7 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num8 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_num9 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_nm10 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_nm11 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_nm12 |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. | |
cir_chk1 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk2 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk3 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk4 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk5 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk6 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk7 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk8 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_chk9 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_ch10 |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. | |
cir_txt1 |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. | |
cir_txt2 |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. | |
cir_txt3 |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. | |
cir_txt4 |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. | |
cir_txt5 |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
Index | Primary | Foreign | Unique | Fields | Sort |
---|---|---|---|---|---|
pk_cir_code | Y | Y | cir_code | ASC |