Event Registration

The following information is included in this topic:

• Concepts
• The Search/Create Registration form
• Viewing existing Registration records
• Creating a new Registration record using the Express Registration form
• Creating a New Registration row from an Event or Activity Correspondence
• Importing registrants
• Editing existing Registration records
• Registration table field descriptions
• Registration table indices

Concepts

The Express Registration process allows users to enter all Event information for a Registrant and/or Guest on one form. Standard rows to insert include Registration Detail and Guest Detail and may include any of the following if applicable; Guest Lodging, Guest Special Needs, Guest Tourney Needs, Guest Transportation Needs, Activities Attendance, Activity Guest Special Needs (for attending an activity), and Activity Guest Tourney Needs (for attending an activity). From that same form users can Finish Registration, Add Another Registration, Add A Guest, Enter A Fee or Cancel This Insert.

The creation of a Registration row is the beginning step in describing a constituent, his or her Guests, and their involvement with an Event and Activities within the Event. While one constituent 'owns' the Registration row, any number of other parties may be included as Guests under that same Registration. In fact, the Registrant may or may not be a Guest at the Event.

In general, the Registrant is the constituent who will be the point of contact or the one responsible to the institution for the registration fees involved for all of the linked Guests.

Once an Event has been accessed and 'opened', the existing Registrations for that Event may be displayed by expanding the Millennium Explorer Registrations item and then click the Search item. To view an existing Registration (or to create a new one) you must use one of the techniques available on the Registration Search form that is presented in the display. When the system locates that row, the display frame will show the primary data with the label, Registration Detail. This includes the ID number, Create Guest Row For This Registrant, Insert Spouse for this Event, Solicitor, RSVP, Registration Status, Received Date and Comment.

Some of the fields that are shown in the display of the Registration row hold data that you enter directly into that data row. This includes the ID Number or Name of the constituent who will own the row, the name of the Solicitor for the Registration, the type of RSVP that the constituent returned, the Status of the Registration (paid in full, no payment received, partial payment received, etc.), the received date, and a free text Comment.

Other data that is displayed and stored in the Registration row is automatically entered into the Registration row by the system. This includes the Cost of the Registration (based on the chosen set of Activities that the Guests will attend), the Amount paid (the sum of the amounts from the Event Income (Fee) rows that are linked to this Registration, the Balance (the difference in the previous amounts), and the Name fields (copied from the constituent's Name row).

Note: Millennium system administrators or the database administrator can configure audit logging for the Registration data table. For more information, see Audit Log.

Search/Create Registration form

Use the Search/Create Registration form to search for existing registrations and to create new registrations.

Complete the following steps to access the Search/Create Registration form:

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. After you locate the event, access the form by using Millennium Explorer, Registrations > Search.

Fields

You must enter information in at least one of these fields in order to do a registration search.

Name/id - A constituents ID number or name, entered in standard search format.

City - The city in which constituents reside.

State - The state in which constituents reside.

Zip Code - The postal code in which constituents reside.

Buttons and Links

New - click this button to create a new registration. The Constituent Search Results page will display, and it will list all of the constituents who match your search criteria. An (R) next to a constituent's name indicates that he or she is already registered for the event. A (G) next to a constituent's name indicates that he or she is attending the event as a guest. You will not be allowed to create a registration row for a constituent who is either registered for the event or is attending the event as a guest.

Note: If a constituent is registered for an event and is also attending the event as a guest, an (R) displays next to his or her name.

Search - click this button to list the constituents who are registered for the event and who match your search criteria.

Import Registrants - click this button to automatically register constituents in a worktable for the event. A constituent will not be registered again if he or she is already registered for the event or attending the event as a guest of another constituent. Read more about importing registrants in the Import registrants section of this topic.

Registration Listing - click this link to generate a report that will list the event registrants. The report will show the constituent name, ID Number and Status for each Registration row linked to the current Event.

Search for a Guest - click this link to display the Guest ID Search form. You may find this form to be useful when it is necessary to display registration information when you not know the name of the constituent who registered a particular guest. The Guest ID Search form focuses the search on Guest rows that are linked to the Event instead of Registration rows that are linked to the Event.Read more about the Search for a Guest link and the Guest ID Search form in the Viewing existing Registration records section of this topic.

Viewing existing Registration records

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. In Millennium Explorer, click Registrations to display the Search/Create Registration form.

3. To locate a Registration record, type the registrant's name or ID number into the Name/ID text box. Format for a name search is Last/First Middle. (You can also type in partial name information and add address information to help with the search). Click Search to list only the constituents who have already registered for the Event.

   Note: Clicking New will return constituents who are not registered, constituents who are registered, and event guests. An (R) is shown next to the names of constituents who are already registered for the event. A (G) is shown next to the names of constituents who are already event guests.

4. To locate a Registration record by using a Guest name or id number search:
   1. Click the Search for a Guest link.
   2. On the Guest ID Search form, type the Guest name or ID number into the Name/ID text box. Format for a name search is Last/First Middle. (You can also type in partial name information and add address information to help with the search). If you are searching for a non-constituent Guest, then you must type in name information.

   3. Click Search to list Guests who match the search criteria.

      If no matches are found, you have the opportunity to enter different search criteria, or you can click the Search for a Registrant link to return to the Search/Create Registration form.

      Note: A Guest who is a constituent will appear in the list more than one time if he or she has more than one Lookup Name row. Click the Sort by ID and Display Unique List link to remove duplicate constituent Guest rows from the list. If you re-sort the list, the duplicate rows will display again.

Creating Registration Records

Registration records can be created in one of the following ways:

• Express Registration
• from a constituent's Event or Activity Correspondence record
• importing records in a worktable

Creating a new Registration record using the Express Registration form

The Express Registration process is used to add a Registration to an event and also to add Guests to Event Registrations that already exist. Express Registration uses a one-screen data entry form that includes the Registration Detail section and the Guest Detail section (note that the Registration Detail section will not display if you are using Express Registration to add a Guest to an existing Event Registration).

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. If applicable to a specific Event Activity, the Activities section will include additional sections for Attendance Special Needs and Attendance Tourney Needs below the Activity details and Activity Items (if any).

Complete the following steps to create a single Registration record by using the Express Registration form.

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. In Millennium Explorer, click on Registration and click on Search. The Search/Create Registration form displays (it may not be necessary to click Search; the form may display immediately upon clicking Registration).

3. Enter the ID Number (if known) or the name or partial name of the Registrant (using the form, Last/First Middle) in Name/ID text box on the form. You may also enter Address information. Click New. The Constituent Search Results page displays and it will list all of the constituents who match your search criteria.

   Note: An (R) is shown next to the names of constituents who are already registered for the event. A (G) is shown next to the names of constituents who are already event guests. You cannot create a registration for a constituent who is already registered for the event and you cannot register a constituent who is already a guest of a different registrant (for this event).

4. Click the name of the constituent for whom you are creating the registration record to display the Express Registration form.
5. Complete the Registration Detail section. More...

   ID/Name - The form will default to the information you entered in the Search form.

   Create Guest row for this Registrant - If this check box is selected, then the system will automatically create a Guest record for the Registrant when it creates the Registration record.

   Register Spouse for this Event - This check box is shown on the form if the constituent has a spouse. If this check box is selected, then the system will automatically register the spouse for this Event as well.

   Solicitor - Choose the name of a solicitor from the pull down list of the Event Solicitor names for this Event.

   RSVP - Choose an entry from the pull down list of the Registration RSVP entries from the Response Type lookup table.

   Reg. Status - Choose an entry from the pull down list of the Registration Status entries from that lookup table.

   Source - Choose an entry from the pull-down list of the Source Type entries from that lookup table.

   Comment - type any free text information concerning this Event Guest.

6. Complete the Guest Detail section. More...

   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.

   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. The Envelope button that displays next to Address Line 1 means that your organization uses Instant Address. Instructions for using Instant Address to fill in the guest address information are located in the Using Instant Address to enter and verify addresses topic.

   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.

7. If Event Items are available, complete the Event Items section for the Guest. More...

   • No action is needed to assign a standard Event Item to the Guest.
   • If you do not want to assign a standard Event Item, then clear the check box associated with the item.
   • To assign a non-standard Event item, then select the check box associated with the item.
   • If the Event itself is a meal (breakfast, lunch, dinner for examples) then items that are menu choices may be shown. These items display as options, and only one can be selected for the Event.
   • If an item is no longer available (its inventory is exhausted) then it cannot be selected.
8. If the Event was set up to record lodging information for Guests, then complete the Guest Lodging section(s). More...

   Location - Choose an entry from the lookup table pull-down list. This is designed to be the name of the hotel.

   # of Guests - Type the number of parties that will share the room.

   Room # - Type the room number assignment.

   Room Type - Choose an entry from the lookup table pull-down list. This is designed to be the nature of the room requested.

   Arriving - Type the arrival date.

   Departing - Type the departure date.

   Confirmation # - Type the confirmation number (if any).

   Comment - Type any free text comment concerning the lodging information.

9. If the Event was set up to record special needs that link to Guest records, then complete the Guest Special Needs section(s). More...

   Dietary Needs - Type any text that describes a dietary preference or requirement.

   Disabilities - Type any text that describes a handicap or disability.

   Comments - Type any text regarding this Special Needs information.

10. If the Event was set up to record tournament needs that link to Guest records, then complete the Guest Tourney Needs section(s). More...

    Course - Choose the name of the course that the tournament will be played on.

    Starting Place - Type the location (golf hole, bowling lane, etc.) where the guest will begin the tournament.

    Handicap - Type the Guest's handicap (as in golf or bowling).

    Team - Choose a team name from the pull-down list of entries from the Other lookup table.

    Locker - Type the locker number (if any).

    Course - Choose a Course name from the pull-down list of entries from the Other lookup table.

    Tee Date - Type a date for the Guest's tee date, using the appropriate format for datetime columns.

    Tee Time - Type a time for the Guest's tee time, using any desired format, up to 8 characters.

    Comment - Type any free text information concerning this information.

11. If the Event was set up to record transportation details for Guests, then complete the Guest Transportation Needs section(s). More...

    Transport Mode - From the pull-down list, choose the appropriate entry from the Other Info Lookup table.

    Date - Type in the appropriate travel date.

    Flight/Train Number - Type in the desired information for flight or train number.

    Departure Location - Type in any desired text to describe the point of origin for the travel.

    Connection Location - Type in any desired text to describe a connection location for the travel.

    Departure Time - Type in the appropriate time of departure.

    Arrival Time - Type in the appropriate time of arrival.

    Comment - Type any free text comment concerning the Transportation information.

12. Complete the Activities section.

    • Activities that are standard will be selected by default. No action is needed to assign a standard Activity.
    • If you do not want to assign a standard activity, then clear the check box associated with the activity.
    • To assign a non-standard activity to a guest, then select the check box associated with the activity.

    For each Activity:

    1. Enter/edit the Activity details. More...

       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.

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

    2. If Activity Items are available, assign or unassign the items as wanted. More...

       • No action is needed to assign a standard Activity Item to the Guest.
       • If you do not want to assign a standard Activity Item, then clear the check box associated with the item.
       • To assign a non-standard Activity item, then select the check box associated with the item.
       • If the Activity is a meal, then items that are menu choices may be shown. These items display as options, and only one can be selected for this Activity.
       • If an item is no longer available (its inventory is exhausted) then it cannot be selected.
    3. If an Activity was set up to record special needs that link to the Guest's Activity Attendance, then complete the Attendance Special Needs section for the activity. These are the same fields as shown in Step 9.
    4. If an Activity was set up to record tournament needs that link to the Guest's Activity Attendance, then complete the Attendance Tourney Needs section for the activity.These are the same fields as shown in Step 10.

13. Once all sections have been completed click on one of these buttons to continue.

    • Finish Registration - This option will bring you to the Registration Detail for the Registrant just inserted.
    • Add Another Registration - This option will return you to the original Search/Create Registration form to perform another Registration.
    • Add A Guest - This option will bring you to the Constituent Guest Search ID form and allow you to search for a Guest to insert.
    • Enter A Fee - This option will allow you to enter information on the Fees (Event Income) that are being paid toward this Registration. After that information is entered, you will be returned to the display of the Registration Detail for the current Registration and Fee rows.
    • Cancel This Insert - This option will return you to the original Search/Create Registration form to perform another Registrant search.

Creating a New Registration row from an Event or Activity Correspondence

Complete the following steps to create a single Registration record from a constituent's Event or Activity Correspondence record.

An Event or Activity Correspondence row must already exist for the constituent who is to be registered (You can use the Add Correspondence Utility to create correspondence records that link to Events or Event Activities.)

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.

   OR

   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.
2. Locate the Correspondence record.

   1. In the Millennium Explorer, click Event > Correspond (if looking for an Event Correspondence record) or click Activities > Correspond (if looking for an Activity Correspondence record).
   2. On the Search/Create Correspondence form, type the constituent's ID number or name into the Name/id box (format for the name is Last/First Middle).
   3. Click Search.
   4. Click the constituent's name to display the Correspondence record.
3. Point to the Edit button located to the left of the Correspondence record and click Check Registration. If a Registration row already exists, the Registration page is shown. If a Registration row does not exist, the Express Registration form displays instead.
4. Complete the Express Registration form to create the registration record for the constituent. If necessary, review the steps beginning at Step 5 in the Creating a new Registration record using the Express Registration form section of this topic to complete the form.

Importing registrants

Constituents that are listed in a worktable that your User ID owns can be registered for an Event, all at one time, by using the Import Registrants button on the Search/Create Registration page. Worktables that you own include your saved Search Results, your saved report worktables, and report worktables that were saved when reports were run on your behalf.

To load the worktable for import:

1. Click Import Registrants. The Load Table form displays. Every worktable that your User ID owns will be listed.
2. Select the name of the worktable that you want to use.

3. Click Accept.

   Other buttons on the Load Tables form:

   Cancel will close the Load Tables form.

   Delete will delete the selected worktable. A confirmation message will be shown before the system deletes the worktable.

The system will attempt to register each constituent in the worktable. A constituent can not be registered again if he or she is already registered for the event.

During the import, the system will tell you:

• import start date and time
• the name of the worktable
• the name of the error log
• a running count of the number of records that are processed

Once the import is complete, the system will tell you:

• import end date and time
• the total number of records that were processed
• the number of constituents who were registered
• the number of errors that the import process encountered. If this
• the number of duplicate constituents in the worktable
• the number of constituents who were already registered for the event

If there are errors, duplicate constituents in the worktable, or constituents who had already registered for the event, click on the name of the error log for more information.

Editing existing Registration records

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 Update/Delete.
4. Tab or mouse click to each text box containing data that you want to edit. Make the desired changes.
5. Note that the Create Guest Row for this Registrant check box will be disabled if the Registrant already has a linked Guest row. If not, it will be selected by default. If you do not want to create a Guest row at this time, clear the check box.

6. Click 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.

Registration table field descriptions

Event Registration data is stored in the registration 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
regkey 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)
regdoc 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)
regdate no label	none	datetime/date   [getdate()]	The date that this row was last updated. This field is automatically entered by the system. (system field)
reguserid 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)
regugroup 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)
regevncode non-displaying	none	char 10 [' ']	This system-generated field holds a copy of the code for the Event to which the Registration is linked. (system field)
regevent Event	none	varchar/varchar2 110 [' ']	This system-generated field holds a copy of the name of the Event to which the Registration is linked. (system field)
regstatus Registration Status	Registration Status	char 6 [' ']	This field specifies an entry from the Registration Status lookup table, used to standardize a description of each Registration row.
regcost Cost	none	money/number   [0]	This field is designed to hold the cost of the Activities which this Registration covers. (system field)
regpaid Paid	none	money/number   [0]	This system-generated field is designed to show the amount that has already been paid toward the Cost. If this amount includes an overpayment of the expected fees, the amount will be shown in the display, enclosed in parentheses. (system field)
regbalance Balance	none	money/number   [0]	This system-generated field shows the amount that remains to be received from the registrant. It is calculated as the difference between the regcost and the regpaid amounts. (system field)
regregid ID number	none	char 10 [' ']	This field holds a copy of the ID Number of the registrant for this row. (system field)
regtitle no label	none	char 30	This system-generated field holds the registrant's name title. (system field)
reglast no label	none	char 55	This system-generated field holds the registrant's last name. (system field)
regfirst no label	none	char 30	This system-generated field holds the registrant's first name. (system field)
regmiddle no label	none	char 30	This system-generated field holds the registrant's middle name. (system field)
regsuffix no label	none	char 30	This system-generated field holds the registrant's name suffix. (system field)
regntype non-displaying	Name Type	char 6	If the registrant is a constituent, this system-generated field shows the Name Type assigned to the name data shown in this row. (system field)
regsortnam non-displaying	none	char 30	This is a system-generated field containing a version of the Registration Name, used for alphabetizing. (system field)
regtickets non-displaying	none	numeric/number 10, 0 [0]	This field is not active at the present time.
regrsvp RSVP	Response Type	char 6 [' ']	This field may be used to track whether the registrant has responded to an invitation. It is controlled by the Response Type lookup table.
regincmflg non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the row for the presence of linked Income row(s) describing the fees that are linked to this Registration. (system field)
regguestfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the row for the presence of linked Guest row(s). (system field)
regsolflg non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the row for the presence of linked Event Solicitor row(s). (system field)
reglnkfil non-displaying	none	Char 2	This is a system-use field showing the file number of the Event data table (21). (system field)
reglnkkey non-displaying	none	Numeric 13,0 [0]	This is a system-use field showing the key field from the Event row to which this Activity is linked. (system field)
regfnum non-displaying	none	char 2 ['56'] {'56'}	This is a system-use field showing the file number of this data table (56). (system field)
regcrdate non-displaying	none	datetime/date   [getdate()]	This is a system-generated field showing the date that this row was created. (system field)
regcomm not labeled	none	varchar/varchar2 4000	This is a free text comment that may be associated with this row.
regothrfl 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)
regcorrfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the row for the presence of linked Correspondence row(s). (system field)
regesolkey non-displaying	none	numeric/number 13,0 [0]	This system-generated field holds the key field from an Event Solicitor data row for the solicitor identified in this Registration row. (system field)
regpledge Amt. Pledged	none	money/number   [0]	This system-generated field will hold the sum of the pledged amounts from all Event Guest rows that are linked to this Registration row. (system field)
regrcvddat Received Date	none	datetime/date	This field may be used to show the date on which the Registration was received.
regesolid Solicitor	none	char 10	When creating or editing a Registration row, the names of all Event Solicitors linked to this Event are shown in a pull-down list in the Registration maintenance form. When a name is chosen from this list, that solicitor's ID is copied into this regesolid data field. When this data is displayed, the system will show the Solicitor's name, rather than the ID. (system field)
regsource Source	Source Types	char 6	This field may be used to track the source of the information shown in this data row.
regdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regmny1	none	money/number	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
regmny2	none	money/number	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
regnum1	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.
regnum2	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.
regyesno	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.
reglook1	Registration 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.
reglook2	Registration 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.
reglook3	Registration 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.
regtext	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.
regpend non-displaying	none	char 1 ['N']	This field is a flag to indicate that this data row has linked information in the 'pending' registration 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)
regupkey non-displaying	none	numeric/number 13, 0	This field holds the timekey of the pending data row that may be updated from the registration_pending table. (system field)
regdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
regmny3	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.
regmny4	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.
regmny5	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.
regmny6	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.
regmny7	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.
regmny8	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.
regmny9	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.
regmny10	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.
regmny11	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.
regmny12	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.
regnum3	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.
regnum4	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.
regnum5	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.
regnum6	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.
regnum7	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.
regnum8	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.
regnum9	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.
regnum10	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.
regnum11	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.
regnum12	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.
regchk1	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.
regchk2	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.
regchk3	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.
regchk4	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.
regchk5	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.
regchk6	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.
regchk7	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.
regchk8	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.
regchk9	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.
regchk10	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.
regtxt1	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.
regtxt2	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.
regtxt3	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.
regtxt4	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.
regtxt5	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.
regadesrc non-displaying	ade_source	char 30	If this row is created or updated from data that originally came from the registration_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.

Registration table indices

Index	Primary	Foreign	Unique	Fields	Sort
pk_registration	Y			regkey
registration02				regevent
registration03				regregid
registration04				regesolid
registration05				regesolkey
registration06				regdate
registration07				reglnkkey reglnkfil
registration08				reguserid

Data table linking

The Registration data row is linked to an Event row. The Registration data row becomes the anchor for data rows from other tables which may be linked directly to the Registration row. Some of those rows will in turn have secondary linked data rows, creating a cascade of links.

Linked Table	Linking File Name	Linking File Values	Linking Key Names and Descriptions
Activity	actvlnkfil	21	actvlnkkey - the Event Key that the Activity is linked to.
Items	itemlnkfl	21 or 52	itemlnkky - the Event Key or the Activity Key that the Item is linked to.
Registration	reglnkfil	21	reglnkkey - the Event Key that the Registration is linked to.
Event_Guest	guestlnkfl	56	guestlnkky - the Registration Key that the Event Guest is linked to.
Attendance	attrlnkfil	52	attrlnkkey - the Activity Key that the Attendance row is linked to. attguestky - the Event Guest Key this Attendance row is related to attregkey - the Registration Key this Attendance row is related to.
Other Info	oinfolnkfl	21, 53, 54	oinfolnkky - the Key of the linked row.

Top of Page