Activity Attendance

The following information is included in this topic:

• Concepts
• Viewing existing Attendance information for a Guest
• Assigning Activities during Registration
• Assigning Activities after a Guest is registered
• Unassigning Activities from a Guest
• Editing existing Activity Attendance information
• Viewing and maintaining Attendance information from the Attendee page
• Attendance table field Descriptions
• Attendance table indices

Concepts

An event guest can choose to attend any one or more of the activities that are available for that event. And a guest can choose those activities independently of the choices that are made by any other guest who is included in the same registration. When you specify an activity that a guest will attend, an attendance row is created to maintain information concerning the participation in that activity. If a guest chooses to attend three activities, then three attendance rows will be created for that guest. These activity attendance rows provide a link between the guest and the activity, and they can also be used to track seating assignments for the guest for each activity that he or she attends.

Standard Activities

Activities that (typically) every guest will attend are called standard activities. For example, your institution hosts a road race as event fund raiser. This event has three activities - the race itself, an after-race celebration, and a reception that will be held the evening before the race. Every participant (guest) is a member of a team, and each team has a captain. Every guest can participate in the road race and attend the after-race celebration. But, only team captains will be invited to the reception that will be held the evening before. The road race and the after-race celebration are standard activities because you expect every guest to attend. But, the reception before the race is not a standard activity because only certain event participants will be invited to attend.

Attendance Data Entry

Millennium uses the Express Registration process to add a registration to an event, and to add guests to event registrations that already exist. The Express Registration one-screen data entry page includes an Activities section (if the event has activities). You can assign an activity to a guest at the time the guest is registered for the event (on the Express Registration data entry page). Or you assign an activity after he or she has been registered for the event. For more information about the Express Registration process and one-screen data entry form, see the topic, Registration Process.

The system can audit data entry and changes for the attendance data table. This audit logging feature is optional, and it is configured by a Millennium System administrator or the database administrator. For more information, see Audit Log.

Viewing Attendance Information

Information about all of the activities that a Guest will attend can be viewed in the Guest section on the Registration details display page for the constituent who registered the guest. Each Guest (for the registrant) will have his or her own section on the page, and Activity Attendance information will display in the Guest Attendance section. The Attendance section is shown only if the Guest display mode is set to Long or Detail, or set to Short and the user option to Display Linked Data in Short Display is activated.

Information about one specific activity that a Guest will attend can be viewed on the Attendee display page for the specific activity. This concept is covered in the Viewing and maintaining Attendance information from the Attendee page section of this topic.

Top of Page

Viewing existing Attendance information for a Guest

1. Locate the Event.

   1. In the Millennium Explorer, click Events, and click Event Search if the search page is not already displayed.
   2. Type in the event code or event name in the Event Code/Name box and click Search.
   3. All Events that meet your search criteria will display on the Search Results page. Click the name of the Event that you want.
2. Locate the Registration Detail page for the constituent who registered the guest.

   After you locate the Event:

   1. In Millennium Explorer, click Registrations to display the Search/Create Registration form.
   2. If you know the name or id number of the constituent who registered the Guest, type it into the Name/ID box (format for the name is Last/First Middle)
   3. If you do not know who registered the Guest, click Search for a Guest to display the Guest ID Search page, and then type in the name or id number of the Guest into the Name/ID box (format for the name is Last/First Middle).

   4. Click Search. The Registration page displays. If a search results page is displayed instead, you will need to click on the name you want in order to display the Registration page.

      Information about Guests who are registered by this constituent is shown after the details about the Registration.

3. In Millennium Explorer, under Registrations, click Guests. All guest rows that are linked to that registration will be displayed. Scroll to locate the specific guest.

4. Once you have located the guest, locate the Attendance header. Information about every activity that the guest is attending is shown.

   If you do not see the Attendance section for the Guest:

   • Display the Guest record in Long display or Detail display.

Top of Page

Assigning Activities during registration

Millennium uses the Express Registration process to add a registration to an event and to add guests to event registrations that already exist. Express Registration uses a one-screen data entry page that includes the Registration Detail section and the Guest Detail section. If applicable to the event, the page will also include sections for Event Items, Activities, Guest Lodging, Guest Special Needs, Guest Tourney Needs, and Guest Transportation Needs (the Registration Detail section will not display if you are using Express Registration to add a guest to an existing event registration).

The Activities section includes information about each individual activity for the event. Activities that are standard will be selected by default. To assign a non-standard activity to a guest, then select the check box associated with the activity. If you do not want to assign a standard activity, then clear the check box associated with the activity.

For each activity that you are assigning, enter or edit the data for the following fields as desired:

Fee: By default, this text box will show the amount that is specified in the Fee field from the activity row. You can use this default amount or change it if desired.

Attended: Verify that this check box is checked or unchecked as appropriate.

Table: The name, number or other description of a table for a seating assignment.

Seat: The name, number or other description of a specific seating assignment.

Section: The name, number or other description of the section for a seating assignment.

Row: The name, number or other description of the row for a seating assignment.

The system will verify that the exact combination of Table, Seat, Section and Row assignment is not a duplicate of another activity row for the same activity. If so, it will prevent the creation of the activity row until or unless a unique assignment is made. From the error message that is given if you attempt to do so, you can use the Back button to return to the activity maintenance form and retain the data that you had previously entered. You must then change the seating information to avoid getting the error again.

Comment: Type any free text information concerning this activity row.

Top of Page

Assigning Activities after a Guest is registered

The Activities Available to Guest page is used to assign one or more activities to a guest after the guest has been registered.

1. Locate the Event.

   1. In the Millennium Explorer, click Events, and click Event Search if the search page is not already displayed.
   2. Type in the event code or event name in the Event Code/Name box and click Search.
   3. All Events that meet your search criteria will display on the Search Results page. Click the name of the Event that you want.
2. Locate the Registration Detail page for the constituent who registered the Guest.

   After you locate the Event:

   1. In Millennium Explorer, click Registrations to display the Search/Create Registration form.
   2. If you know the name or id number of the constituent who registered the Guest, type it into the Name/ID box (format for the name is Last/First Middle)
   3. If you do not know who registered the Guest, click Search for a Guest to display the Guest ID Search page, and then type in the name or id number of the Guest into the Name/ID box (format for the name is Last/First Middle).

   4. Click Search. The Registration page displays. If a search results page is displayed instead, you will need to click on the name you want in order to display the Registration page.

      Information about Guests who are registered by this constituent is shown after the details about the Registration.

3. Locate the Guest and locate the Attendance header for the Guest. If you do not see the Attendance header, then display the Guest record in Long display or Detail display.

4. Point to the Edit Button in the Attendance header and click Insert. The Activities Available to Guest page will display.

   The Unassigned Activities list shows all of the activities that are still available for the guest to attend. If none are available, then the Unassigned Activities list will have no items.

   The Assigned Activities list shows all of the activities that the guest is already attending. There will be no items in the Assigned Activities list if the guest is not attending any activities.

5. To assign one activity, click the name of the activity in the Unassigned Activities list and drag it to the Assigned Activities list. Alternate methods:

   Click the name of the activity to highlight it, and then click Add. Or, you can double click an activity name to add it to the Assigned Activities list.

6. To assign several activities at one time, click the activity names in the Unassigned Activities list to highlight them and then click Add.

7. To assign all of the activities in the Unassigned Activities list at one time, click Add All.

8. If you do not want to add a registration fee for the newly assigned activity, clear the Add Fee check box.

9. If you want to add additional information about the new activity that you are assigning (table and seat, for example), before the system will be creating the new attendance row for the guest, select the Edit Attendance row before insert check box. (You can recognize a newly assigned activity in the Assigned Activities list by the *** symbol next to its name.)

   Note: You can add additional information only if you are assigning one new activity.

10. Click OK. (At any step, you can click Cancel. No changes to the activity assignments for the guest will be made.)

    1. If the Edit Attendance row before insert check box is selected, the Attendance insert form is shown so that you can make changes before creating the row.

       1. Enter or edit the data for the fields shown on the form. More:

          Table: The name, number or other description of a table for a seating assignment.

          Seat: The name, number or other description of a specific seating assignment.

          Section: The name, number or other description of the section for a seating assignment.

          Row: The name, number or other description of the row for a seating assignment.

          The system will verify that the exact combination of Table, Seat, Section and Row assignment is not a duplicate of another activity row for the same activity. If so, it will prevent the creation of the activity row until or unless a unique assignment is made. From the error message that is given if you attempt to do so, you can use the Back button to return to the activity maintenance form and retain the data that you had previously entered. You must then change the seating information to avoid getting the error again.

          Fee: By default, this text box will show the amount that is specified in the Fee field from the activity row. You may use this default amount or change it if desired.

          Attended: Verify that this check box is checked or unchecked as appropriate.

          Comment: Type any free text information concerning this activity row.

       2. Click Insert to create the activity attendance row for the guest. If you click Cancel instead, then the activity attendance row will not be created.

    2. If the Add Fee check box is selected, the Fee insert form is shown after the system creates the new activity attendance row.

       1. Amount Paid defaults to outstanding fees (registration cost and other activity fees that have not yet been paid) plus the fee that is associated with the new activity or activities that you are assigning. You can change this amount and also enter data for the other fields, as necessary. (Review the Event Registration Fees topic for complete information about this form).
       2. Click Insert to create the registration fee row. If you click Cancel instead, then no fee row is added to the registration, but the new attendance rows representing the activity or activities that you have just assigned will still be created.

Top of Page

Unassigning Activities from a Guest

The Activities Available to Guest page is used to unassign one or more activities from a guest at one time. You can also unassign a single activity from a guest by following the steps in the Edit Existing Activity Attendance Data section of this topic, and then choose to click the Delete button.

1. Locate the Event.

   1. In the Millennium Explorer, click Events, and click Event Search if the search page is not already displayed.
   2. Type in the event code or event name in the Event Code/Name box and click Search.
   3. All Events that meet your search criteria will display on the Search Results page. Click the name of the Event that you want.
2. Locate the Registration Detail page for the constituent who registered the guest.

   After you locate the Event:

   1. In Millennium Explorer, click Registrations to display the Search/Create Registration form.
   2. If you know the name or id number of the constituent who registered the Guest, type it into the Name/ID box (format for the name is Last/First Middle)
   3. If you do not know who registered the Guest, click Search for a Guest to display the Guest ID Search page, and then type in the name or id number of the Guest into the Name/ID box (format for the name is Last/First Middle).

   4. Click Search. The Registration page displays. If a search results page is displayed instead, you will need to click on the name you want in order to display the Registration page.

      Information about Guests who are registered by this constituent is shown after the details about the Registration.

3. Locate the Guest and locate the Attendance header for the Guest. If you do not see the Attendance header, then display the Guest record in Long display or Detail display.

4. Point to the Edit Button in the Attendance header and click Insert. The Activities Available to Guest page will display.

   The Assigned Activities list shows all of the activities that the guest is already attending. Note that there will be no items in the Assigned Activities list if the guest is not attending any activities.

5. To unassign one activity, click the name of the activity in the Assigned Activities list and drag it back to the Unassigned Activities list. Alternate methods:

   Click the activity name in the Assigned Activities list to highlight it, and then click Remove. Or, double click the activity name to remove it from the Assigned Activities list.

6. To unassign several activities at one time, click the activity names in the Assigned Activities list to highlight them, and then click Remove.
7. To unassign all of the activities at one time, click Remove All.
8. Click OK to finish. The system deletes the attendance rows associated with the activities that you have unassigned. (At any step, you can click Cancel. Changes that you have just made will be discarded.)

Top of Page

Editing existing Activity Attendance information

1. Display the Attendance information for a Guest. Viewing existing Attendance information for a Guest You can either access every activity attendance row for the guest, or access just the activity attendance row that you want to edit. If necessary, review the steps in the Viewing existing Attendance information for a Guest section of this topic.
2. Click the Edit Button to the immediate left of the activity attendance row that you want to edit. An update form showing the current data will be presented.
3. If updating the data, Tab or mouse click to each box that you want to edit, and make the necessary changes.
4. Click Update to make the changes to the data,
   OR
   Click Delete to unassign the activity from the guest (and removes the data row from the system),
   OR
   Click Cancel to halt the process without making any changes to the row.

Top of Page

Viewing and maintaining Attendance information from the Attendee page

Community Brands provides an alternative way to view and maintain Activity Attendance information.

The Attendee page can be used to view and maintain Attendance information for one specific Event Activity after a Guest has been registered to attend that Activity. You can view and edit this one Activity Attendance record and also unassign this Activity from the Guest by using the Attendee page.

Complete the following steps to locate the Attendee page for a Guest who is attending a particular activity:

1. Locate the Event.

   1. In the Millennium Explorer, click Events, and click Event Search if the search page is not already displayed.
   2. Type in the event code or event name in the Event Code/Name box and click Search.
   3. All Events that meet your search criteria will display on the Search Results page. Click the name of the Event that you want.
2. Locate the Activity.

   After you locate the Event:

   1. In Millennium Explorer, click Activities, and click Search if the Activity Search page for the Event is not already displayed.
   2. Click the name of the Activity.
3. In Millennium Explorer, click Activity > Attendees to display the Attendee Search page.
4. Type the Guest's name or id number into the Name box (format for the name is Last/First Middle).

5. Click Search. The Attendee page for the guest displays (if the Guest search returns more than one name, the Attendee page will display after you click the name that you want).

The Attendance Details section is shown after the details about the Guest. To edit or unassign (delete) the Activity, point to the Edit button located to the left of the Activity name and click Update/Delete.

Top of Page

Attendance table field descriptions

Activity attendance data is stored in the attendance data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you want to override these default settings, you must customize your display definition.

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
attkey non-displaying	none	numeric/number 13, 0	The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System column)
attdoc non-displaying	none	char 1 ['N']	This field holds a Y/N flag to indicate the existence of a linked document for this row. (System column)
attdate no label	none	datetime/date   [getdate()]	The date that this row was last updated. This field is automatically entered by the system. (System column)
attuserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator who last edited this row. It is automatically entered by the system. (System column)
attugroup non-displaying	none	char 1 [' ']	This field holds the Group letter that was associated with the user ID of the operator who last edited this row. (System column)
attevcode non-displaying	none	char 10	This field holds a copy of the Event code from the Event with which this Attendance row is associated. (System column)
attevent Event	none	varchar/varchar2 110	This field holds a copy of the Event Name from the Event with which this Attendance row is associated. (System column)
attactvity Activity	none	varchar/varchar2 110	This field holds a copy of the Name of the Activity to which this Attendance row is linked. (System column)
atttable Table	none	varchar/varchar2 65	This field is designed to hold the Table seating assignment (if any) that is associated with this Attendee. The system will verify that the exact combination of Table, Seat, Section and Row assignment is not a duplicate of another Attendance row for the same Activity. If so, it will prevent the creation of the Attendance row until or unless a unique assignment is made.
attrow Row	none	varchar/varchar2 65	This field is designed to hold the Row assignment (if any) that is associated with this Attendee. See Note on atttable, above.
attseat Seat	none	varchar/varchar2 65	This field is designed to hold the Seat assignment (if any) that is associated with this Attendee. See Note on atttable, above.
attsectn Section	none	varchar/varchar2 65	This field is designed to hold the Section assignment (if any) that is associated with this Attendee. See Note on atttable, above.
attattnded Attended?	none	char 1 ['N'] {'Y', 'N'}	This field may be used to flag the Attendance row to confirm that the guest actually attended the Activity.
attgitemfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the row for the presence of linked Guest Item row(s). (System column)
attguestky non-displaying	none	numeric/number 13, 0 [0]	This field holds a copy of the key field from the Event_guest row to which this Attendance row is linked. (System column)
attregkey non-displaying	none	numeric/number 13, 0 [0]	This field holds a copy of the key field from the Registration row to which the Event_guest row is linked, to which this Attendance row is linked. (System column)
attlnkfil non-displaying	none	char 2	This field holds the file number for the data table to which this Attendance row is linked (52 - Activity) (System column)
attlnkkey non-displaying	none	numeric/number 13, 0 [0]	This field holds a copy of the Key field from the Activity row to which this Attendance row is linked. (System column)
attfnum non-displaying	none	char 2 ['53'] {'53'}	This field holds a copy of the file number for the Attendance data table (53). (System column)
attcrdate non-displaying	none	datetime/date   [getdate()]	This is a system-generated field showing the date that this Attendance row was created. (System column)
attcomm Comment	none	varchar/varchar2 4000	This is a free text comment that may be associated with this Attendance row.
attothrfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the row for the presence of linked Other Info row(s). (System column)
attfee non-displaying	none	money/number (19,4)/(16,2) [0]	This field shows the fee that is associated with this Attendance. The regcost field in the Registration table is automatically calculated using this field.
attsource Source	Source Types	char 6	This field may be used to track the source of the information in this data row.
attdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attmny1	none	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.
attmny2	none	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.
attnum1	none	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.
attnum2	none	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.
attyesno	none	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.
attlook1	Attendance 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.
attlook2	Attendance 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.
attlook3	Attendance 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.
atttext	none	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.
attseatkey non-displaying	none	numeric/number 13, 0	This system-generated field holds a copy of the key field from the Seating Layout row to which this Attendance row is linked. (System column)
attid non-displaying	none	char 1   {null}	If this row is linked to a constituent Guest row, this field will contain the ID of the constituent. If the Guest is a non-constituent, this field is blank. (System column)
attpend	none	char 1 ['N'] {'N' or 'Y'}	This field is a flag to indicate that this data row has linked information in the 'pending' attendance table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is awaiting incorporation into this data row. (System column)
attupkey	none	numeric/number 13, 0	This field holds the timekey of the pending data row that may be updated from the attendance_pending table. (System column)
attdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
attmny3	none	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.
attmny4	none	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.
attmny5	none	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.
attmny6	none	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.
attmny7	none	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.
attmny8	none	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.
attmny9	none	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.
attmny10	none	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.
attmny11	none	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.
attmny12	none	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.
attnum3	none	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.
attnum4	none	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.
attnum5	none	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.
attnum6	none	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.
attnum7	none	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.
attnum8	none	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.
attnum9	none	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.
attnum10	none	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.
attnum11	none	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.
attnum12	none	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.
attchk1	none	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.
attchk2	none	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.
attchk3	none	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.
attchk4	none	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.
attchk5	none	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.
attchk6	none	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.
attchk7	none	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.
attchk8	none	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.
attchk9	none	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.
attchk10	none	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.
atttxt1	none	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.
atttxt2	none	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.
atttxt3	none	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.
atttxt4	none	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.
atttxt5	none	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.
attlook4	Attendance Lookup4	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.
attlook5	Attendance Lookup5	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.
attlook6	Attendance Lookup6	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.
attadesrc non-displaying	ade_source	char 30	If this row is created or updated from data that originally came from the attendance_pending table, then this field will hold information about the data's import source. Data from the Online Constituent Directory will have a source of Online Directory. Data from Soft Edit users will have a source of Soft Edit. Data whose import source is the ADE Import Tool can be assigned a value (other than Online Directory or Soft Edit) from the ade_source lookup table by the user who executes the utility, or the source can be blank.

Attendance table indices

Index	Primary	Foreign	Unique	Fields	Sort
pk_attendance	Y			attkey
attendance02				attevent
attendance03				attactivity
attendance04				attlnkkey, attlnkfil
attendance05				attguestky
attendance06				attregkey
attendance07				attuserid

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.

Top of Page