Event Guests

The following information is included in this topic:

• Concepts
• Finding registered Guests
• Viewing Guest information for a Registrant
• Viewing Guest information for an Activity
• Creating a new Guest row as the Registration is created
• Adding a new Guest to an existing Registration
• Editing Event Guest data
• Guest table field descriptions
• Guest table indices

Concepts

When a constituent registers for an Event, he or she may do so on behalf of several event attendees. The registrant may or may not attend the event. For example, one spouse may register on behalf of both spouses and the children in the family, and all will be attending the event. Or, an employer might register for a set of employees who will attend, though the employer will not.

Within the Events World, a single Registration row will be created in each case. Then, in order to track all of the details for the actual event attendees, a row is created in the Event Guest data table for each person who will be attending the event. Event Guest rows will be linked to the Registration row, and belong to the constituent who is responsible for that registration. If the Registrant is attending the event, an Event Guest row will also be created for him or her.

Important! The registrant must be a constituent on the system, but Event Guests can be either constituents or non-constituents.

There are several other data rows that may be linked to each Event Guest row. This system allows you to track information for each guest independently of the other guests under the same Registration. Very often, different guests (even under the same Registration) will choose to participate in different Activities within the Event, will receive different Items because of their participation, may stay in separate accommodations, may pledge different amounts, etc. Some of this guest-specific information is stored in the Event Guest row itself and some is stored in other data table rows that are linked to the Event Guest row.

Even though the Registration row stores information about the complete registration package, an Event Guest row will be created for each person who will participate in any part of the Event. Each of these Guest rows will be linked to a particular Registration row. An Event Guest row will also be created for the owner of the Registration if that constituent will be attending the Event. Other data rows may be linked to each Guest row to describe the Items that guest will receive, what Activities the guest will attend, Lodging arrangements, Tournament Needs, or other Special Needs. To prevent duplication, the system checks and does not allow a Registrant to be a Guest of a different Registrant or for an existing Guest to become a Registrant for the same Event.

The Event Guest row holds name, address and phone information for the guest, name tag information, a flag that may be used to signal whether the name tag has or has not been printed, an amount that the Guest has pledged, an organization that the Guest will represent at the Event, and the name of the Event for which the person will be a Guest.

In addition to those data columns, Event Guest rows may have links to multiple data rows in the following tables:

Attendance - Each row describes the Guest's participation in one of the Activities within the Event.

Guest Items - Each row describes an Item that the Guest may be offered as a result of participation in the Event or Activity.

Lodging - This row may be used to track the Guest's hotel accommodations.

Special Needs - This row may be used to track the Guest's special dietary requirements or a disability.

Tourney Needs - This row may be used to track information about the Guest's participation in an athletic tournament.

Transportation - This row may be used to track information about the Guest's transportation needs or plans.

Each Event Guest row is linked to a single Registration row, but each Registration may serve as the primary link for multiple Event Guest rows. In the same pattern, Event Guest rows may serve as the primary link for multiple other data rows in the tables listed above. The following chart illustrates one possible example of the links between these data rows.

In this example, one constituent has registered on behalf of three Guests. Each of the Guests has Lodging information and each is attending one Activity (which may be the same or different for each Guest). The second Guest in the diagram has some special dietary or disability needs. The third Guest has information on special Tournament assignments and is receiving an Item based on the Activity he or she is attending. The Registrant has paid a fee toward the cost of registering all of the Guests for all of the Activities they are scheduled to attend.

Important! For the same Event, a person can not be both a Registrant and a Guest of a different Registrant. Therefore, as you enter Guest information, the system will verify that the constituent is not already a Registrant. And as you enter Registrant information, the system will verify that the constituent is not already a Guest of another Registrant.

Finding registered Guests

Find the constituent and non-constituent Guests who are registered to attend an Event either by Registrant or by Activity.

• Once you locate an Event, the Search/Create Registration form can be used to find Guests by the constituent who registered them.
• Once you locate an Event Activity, the Attendee Search form will find Guests who are attending the Activity

Search/Create Registration form

For instructions on using this form to locate Guests by registrant, see View Guest Information for a Registrant section of this topic.

The Search/Create Registration form is also used to locate existing Event registration records (and as the starting point for creating new registrations). See the Event Registration topic for more details about this form.

Attendee Search form

The top portion of the form resembles the standard constituent Search form used throughout the system. This portion of the form may be used to locate an existing Guest when you know either the ID Number or a name or partial name for the Guest. Address information may be added to the search form to narrow the search, but it is not intended to be the basis for a search. Note that Guests may be constituents or non-constituents and if searching for a non-constituent Guest, there will be no ID Number and therefore only Name (and Address) information may be used.

For instructions on using this form to locate Guests by Activity, see Accessing the Display of Guest Info for an Activity section of this topic.

Attendance Listing Report

The Attendee Search page includes a link to access the Attendance Listing report. Click the link to display a quick listing of all of the guests who will be attending currently displayed Activity. Also shown on the report are the names of the constituents who registered the Guests.

Viewing Guest information for a Registrant

Information about all Guests for a registrant can be viewed on the Registration details page for the constituent who registered the Guests. Complete the following steps to locate the Registration Detail page for a registrant.

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 record for the constituent who registered the Guest(s).

   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. Each Guest record will have his or her own section on the Registration details page. Use the Collapse button in each Guest section header to collapse and expand the individual guest sections as needed.

Viewing Guest information for an Activity

The information about a Guest who is attending an activity can be viewed on the Attendee page. Complete the following steps to locate the Attendee page 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 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/ID box. Format for the name search is Last/First Middle. An ID number search can be used only when the Guest is a constituent.
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).

Creating a new Guest row as the Registration is created

1. If the Guest row will belong to the same constituent who owns the Registration, begin the process of creating a new Registration row for the current Event, verifying that the Create Guest Row for this Registrant check box is checked. You will automatically be prompted with an Event Guest Insert form with default data taken from the Registrant's Profile data. This will include Name and Address information.

   Enter additional data or edit the data that was pulled into this form as described in Step 7 below.

2. If the Registrant is a Guest, and if you want to create additional Guest rows for the same Registration at the time the Registration is created, the system will prompt you through the process.

   Begin by creating the new Registration row. As part of the process of creating the Registrant's Guest information (including Attendance and Guest Item info), you will be shown an Available Activities form. When you have entered all Activity and Guest Item info for the Registrant's Guest row and are ready to initiate the creation of a new Event Guest row from that form, click on the Guest's Activity list is complete check box on the Available Activities form. The radio buttons below that check box will be made available. Click to activate the button labeled Add a New Guest to this Registrant and then click OK. You will be given a Guest Search form.

3. Use this search form and enter the Guest's name or ID number (if applicable) and Address info (if desired) .
4. Click Search.

5. If the data you entered matches one or more constituents on the database, a Search Results page displays, listing the constituent or constituents.

   1. A constituent will appear in the search results more than one time if he or she has more than one Lookup Name row. Click the Sort by ID and Display Unique List hyperlink to remove duplicate rows from the Search Results display. If you re-sort the search results, the duplicates will display again.
   2. Locate the desired constituent and click on the name hyperlink. You will be given a Guest Insert form showing Name and Address data for that constituent.
   3. If the desired constituent is not shown, click the Refine the Query hyperlink. The Search form re-displays to allow you to redo your constituent search.
6. When you enter data that does not match any existing constituents on the database, your search form will include a Create a Non-Constituent Guest hyperlink to allow you to create a non-constituent event guest. Click the hyperlink if that is what you want to do.

7. On Guest Detail, edit of type in information for the following fields, as necessary.

   If your organization uses Instant Address:

   Guest Detail includes fields for mailing address information. The Envelope button displays next to the Address Line 1 field to indicate that Instant Address is available to help you enter a valid mailing address for the guest, or to verify that the guest's address is valid according to "postal authority data". Instructions for using Instant Address are located in the Using Instant Address to enter and verify addresses topic.

   What is Instant Address?

   Instant Address is a third party service that is offered by Initium Software and integrated into Millennium. It assists users when entering and updating address information by providing real-time address autocomplete functionality and address verification. For information about Initium Software and Instant Address, visit www.initiumsoftware.com.

   Information about the guest name

   The preferred name information is used by default for the Title, First, Middle, Last, and Suffix text boxes. If the Guest is a constituent and has a Name row with a Type of Event Name, that information will be used as default data for the Name Tag Line 1 text box on the form. If no such Name row exists, the system will use the data in the preferred name as the default for the Name Tag Line 1 as well as the other Name text boxes. Any data that appears in the form by default, may be edited before the row is created.

   Insert Spouse as Guest for this Event: Check this box to insert the Spouse as a Guest for this Event.

   Title: Guest's name title

   First Name: Guest's first name

   Middle Name: Guest's middle name

   Last Name: Guest's last name

   Suffix: Guest's name suffix

   Pledge: Type the total amount (if any) that the Guest has pledged for this Event.

   ID number: If the Guest is a constituent, this field will show the Constituent ID.

   Phone: Phone number for the Guest

   Tag Printed - select this box if the Guest's name tag has been printed.

   Attended? - Denotes the Guest's attendance at any one of the event's activities: the system will automatically select this box when one of the Guest Attendance Attended boxes is manually selected.

   Address Line 1- The first line of the Guest's address. If the Guest is a constituent, this information will automatically be shown in the Insert form, but it can be edited.

   Address Line 2: The second line of the Guest's address.

   Address Line 3: The third line of the Guest's address.

   City: Guest's city.

   Place: Guest's state.

   ZIP : If you edit the ZIP Code, and if the Country is blank or USA, the City and State will be automatically entered based on the first five characters entered here and the corresponding entry in the ZIP Code lookup table. Also, the data will be formatted as a USA code. If the Zip Code is not found in the Zip Code lookup table, then the address fields will not be populated. But, if the country is not blank and not USA, then the ZIP Code may be any free text and no automated address data entry occurs.

   E-Mail: The guest's email address.

   Tag Line 1: The information that you want to have appear on the first line of a name tag. For constituent Guests, the system will first use the formatted name from a Name row of the type Event Name as the default for this field in the Insert form. If no such Name row exists, the preferred name will be used. In either case, you may edit this information before inserting the row.

   Tag Line 2: The information that you want to have appear on the second line of a name tag.

   Tag Line 3: The information that you want to have appear on the third line of a name tag.

   Rep of - (Representative Of) Type in the name of a business or organization (if any) that this Guest will represent at this Event.

   Comment: A free text comment that may be associated with this Guest.

8. When all data appears in the form as you want, click on Insert to create the row,

   OR

   Cancel to halt the process without creating a new row.

Note: Although Name and Address information is pulled into the Insert form by default, edits you may make here in an Event Guest row do not automatically update the Name or Address row in the Profiles World.

Adding a new Guest to an existing Registration

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 existing Registration record.

   After you locate the Event:

   1. In Millennium Explorer, click Registrations to display the Search/Create Registration page.
   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.
3. Point to the Edit button located to the left of the registrant's name, and click Link > Guest or Link > Guest via Default.
4. Another way:

   Point to an Edit button located either in an existing Guest section header or to the left of any existing Guest name. Click Insert or Insert via Default.

5. The Constituent Guest ID Search form displays. Enter the Guest's name or ID number (if applicable) and Address information (if desired).
6. Click Search.

7. If the data you entered matches one or more constituents on the database, a Search Results page displays, listing the constituent or constituents.

   1. A constituent will appear in the search results more than one time if he or she has more than one Lookup Name row. Click the Sort by ID and Display Unique List hyperlink to remove duplicate rows from the Search Results display. If you re-sort the search results, the duplicates will display again.
   2. Locate the desired constituent and click on the name hyperlink. You will be given a Guest Insert form showing Name and Address data for that constituent.
   3. If the desired constituent is not shown, click Refine the Query to redo your search. Or, click Create a Non-Constituent Guest to create a non-constituent event guest.
8. If the information that you entered does not match an existing constituent, the Constituent Guest ID Search form re-displays. Enter in different information for the Name/ID and Address (if desired) and click Search again. Or click Create a Non-Constituent Guest to create a non-constituent event guest.
9. Complete Steps 7 and 8 in the Creating a new Guest row as the Registration is created section of this topic.

Editing Event Guest data

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 record 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. Point to the Edit button located to the left of the Guest name. An Update form showing the current data will be presented.
4. Tab or mouse click to each text box containing data that you want to edit. Make the desired changes.

5. Click the Update to make the changes to the data,

   OR

   Click Delete to remove the data record from the system,

   OR

   Click Cancel to close the update form. There will be no changes to existing data.

Event Guest Table Field Descriptions

Event Guest data is stored in the event_guest 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.

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] {Check}	Description
guestkey 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 field)
guestdoc 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 field)
guestdate no label	none	datetime/date   [getdate()]	The date that this row was last updated. This field is automatically entered by the system. (System field)
guestuid 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 field)
guestugrp 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 field)
guestevncd non-displaying	none	char 10 [' ']	This system-generated field holds a copy of the Event code from the Event with which this row is associated. (System field)
guestevent Event	none	varchar/varchar2 110 [' ']	This system-generated field holds a copy of the Event Name from the Event with which this row is associated. (System field)
guestpldge Pledge Amount	none	money/number (19,4)/(16,2) [0]	This field may be used to record the total amount that this Guest has pledged for this Event. It should be entered as the sum of any pledges to the Event or any Activities for this Event for this Guest. The system will then calculate a sum of all Guest Pledge Amounts for the same Registration and store that total in the Registration field, Total Pledge (regpledge).
guestid ID number	none	char 10	If the Guest is a constituent, this field will show the Constituent ID.
guesttitle Title	none	char 30	This field holds the name title for the Guest.
guestlname Last	none	char 55	This field holds the last name of the Guest.
guestfname First	none	char 30	This field holds the first name of the Guest.
guestmname Middle	none	char 30	This field holds the middle name of the Guest.
guestsuffx Suffix	none	char 30	This field holds the suffix for the name of the Guest.
guestsmash non-displaying	none	char 30	This system-generated field holds a formatted version of the name, used for alphabetizing. (System field)
guestntype non-displaying	Name Type	char 6	If the Guest is a constituent, this field will contain the Name type for the name information that is used in this Event Guest row. (System field)
guestaddr1 Address Line 1	none	varchar/varchar2 60	The first line of the Guest's address. If the Guest is a constituent, this information will automatically be shown in the Insert form, but it may be edited in that form. Address edits that are made in that form are not automatically made to the Address data row.
guestaddr2 Address Line 2	none	varchar/varchar2 60	The second line of the Guest's address.
guestaddr3 Address Line 3	none	varchar/varchar2 60	The third line of the Guest's address.
guestcity City	none	varchar/varchar2 40	The City for the Guest's address.
gueststate State	Places	char 6	The State (Place) for the Guest's address.
guestzipcd Postal Code	none	char 15	The ZIP or postal code for the Guest's address.
guestntag1 Name Tag Line 1	none	varchar/varchar2 65	This field is used to show the information that you want to have appear on the first line of a name tag. For constituent Guests, the system will first use the formatted name from a Name row of the type Event Name as the default for this field in the Insert form. If no such Name row exists, the preferred name will be used. In either case, you may edit this information before inserting the row. Edits made on the Insert form do not affect the data in the Name row in the Profiles World.
guestntag2 Name Tag Line 2	none	varchar/varchar2 65	This field is used to show the information that should appear on the second line of a name tag.
guestntag3 Name Tag Line 3	none	varchar/varchar2 65	This field is used to show the information that should appear on the third line of a name tag.
guestnprnt Name Tag Printed?	none	char 1 ['N'] {'Y', 'N'}	This field may be used to track whether a Guest's name tag has or has not been printed.
guestattnd Attended?	none	char 1 ['N'] {'Y', 'N'}	This system-generated flag is set to yes (Y) when one of this Guest's Attendance row's Attended flag (attattnded) is manually set to yes. (System field)
guestrepof Representative Of	none	varchar/varchar2 110	This free text field may be used to show the company or organization with which the Guest is associated.
guestlnkfl non-displaying	none	char 2	This system-generated field shows the table number for the Registration table (56). (System field)
guestlnkky non-displaying	none	numeric/number 13, 0 [0]	This system-generated field shows a copy of the key field from the Registration row to which it is linked. (System field)
guestfnum non-displaying	none	char 2 ['54'] {'54'}	This system-generated field shows the table number of the Event Guest table (54). (System field)
guestcrdat non-displaying	none	datetime/date   [getdate()]	This system-generated field shows the date on which the row was created. (System field)
guestcomm not labeled	none	varchar/varchar2 4000	This is a free text comment that may be associated with this row.
guestothfl 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 field).
guestattfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This system-generated field is used to indicate that the row also has linked Attendance rows. (system field)
guestphone Phone	none	varchar/varchar2 30	This free text field is used to show the phone number for the Guest.
guestdupfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field which will indicate to the system whether this Guest has another Guest row linked to the same Event row. This indicator is used in the system calculation of the Event statistics. (system field)
guestregid non-displaying	none	char 10	This is a system-generated field which holds a copy of the id number of the constituent who owns the Registration row to which this Guest row is linked, whether the same as the owner of the Guest row or belonging to a different constituent.
guestgitmf non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field which will indicate to the system whether this Guest has another Guest row linked to the same Registration row. This indicator is used in the system calculation of the Event statistics. (system field)
guesttype non-displaying	none	char 6	This field is reserved for future use.
guestcntry Country	Countries	char 6 [' ']	This field is used to track the Country associated with the address information in this row. If the Country is blank or USA, the system will treat the information entered in the ZIP Code field as a US ZIP Code and will automate the entry of the City and State based on the ZIP Code info that is entered.
guestemail email Address	none	char 200	This field may be used to track the email address for the Guest.
guestdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestmny1	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.
guestmny2	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.
guestnum1	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.
guestnum2	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.
guestyesno	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.
guestlook1	Event Guest 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.
guestlook2	Event Guest 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.
guestlook3	Event Guest 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.
guesttext	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.
guestpend non-displaying	none	char 1 ['N'] {'N' or 'Y'}	This field is a flag to indicate that this data row has linked information in the 'pending' event_guest 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 field)
guestupkey	none	numeric/number 13, 0	This field holds the timekey of the pending data row that may be updated from the event_guest_pending table. (System field)
guestdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
guestmny3	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.
guestmny4	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.
guestmny5	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.
guestmny6	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.
guestmny7	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.
guestmny8	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.
guestmny9	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.
guestmny10	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.
guestmny11	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.
guestmny12	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.
guestnum3	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.
guestnum4	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.
guestnum5	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.
guestnum6	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.
guestnum7	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.
guestnum8	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.
guestnum9	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.
guestnum10	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.
guestnum11	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.
guestnum12	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.
guestchk1	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.
guestchk2	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.
guestchk3	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.
guestchk4	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.
guestchk5	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.
guestchk6	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.
guestchk7	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.
guestchk8	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.
guestchk9	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.
guestchk10	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.
guesttxt1	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.
guesttxt2	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.
guesttxt3	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.
guesttxt4	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.
guesttxt5	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.
guestadesr non-displaying	ade_source	char 30	If this row is created or updated from data that originally came from the event_guest_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.
guestinitm Initium Status	none	char 1 [null] {' ','O','V'}	This column displays the status of the address if your organization uses Initium Instant Address. It contains a single character that indicates whether the address has been validated or overridden, as follows: O - Overridden V - Validated Blank - no status
guestinitd non-displaying	none	char 1 [''] {'','E','T','M','S', 'U','F','P'}	This field is available for use with Initium Instant Address. It contains a single character that describes the detail status of the address as follows: E - Exact T - Tentative M - Multiple S - Secondary U - Unmatched F - Foreign P - Primary Blank - No detail status
guestindte Initium verification date	none	datetime	This field specifies the last date and time that the address was validated using Initium Instant Address.
guestinitv Initium verification Info	none	varchar 30	This field contains the verification information returned from Initium for the address, if any.

Guest Table Indices

Index	Primary	Foreign	Unique	Fields	Sort
pk_event_guest	Y			guestkey
event_guest02				guestid
event_guest03				guestlname
event_guest04				guestregid
event_guest05				guestdate
event_guest06				guestuid

Top of Page