Event Activities

The following information is included in this topic:

• Concepts
• Create a New Activity
• View an Existing Activity
• Edit an Existing Activity
• View Data linked to an Activity
• Create Data linked to an Activity
• Sort Activities on the Express Registration Form
• Customize the Activity Data Display and Maintenance Forms
• Activity Field Descriptions
• Activity Table Indices

Concepts

When an institution plans and carries out an Event, there may be many individual functions that together make up the Event. In Millennium, these components are called Activities, and each is defined in a separate row in the Activity data table. Each Activity row is linked to one specific Event. This allows each Activity to have it's own timing, budget, invitations, guests, expenses, planning and merchandise, all of which can be maintained separately from the other Activities, yet coordinated as part of the same Event.

For example, an Event might be defined as a Fall Festival or as Homecoming. Within such Events, you might hold any combination of dinners, dances, picnics, football games, seminars, walk-a-thons, art exhibits, excursions and so forth. Each one of those functions is defined in Millennium as an Activity and each Event may be made up of any number of these functions, or Activities. You must first create the Event row, and then you may create any number of Activity rows that link to the Event.

Many of the fields in the Activity table contain information about the Activity that is entered by the operator. These include such things as the Activity Name, the Location, the Type of function, the Start and End Dates, Budgeted figures for Attendance, Costs, Income, and an Address for the Activity.

In addition to the data that is manually entered, the system will automatically maintain some additional information that is calculated based on the Expense, Guest, and Income rows that are linked to this Activity either directly or indirectly.

Beyond the data that is maintained in the Activity row itself, additional information about the Activity may be stored in linked secondary tables. This could include information about persons who will serve as Organizers for the Activity, gift or sales Items that are available to the Activity's participants, planned Actions and the Tasks assigned to carry out those plans, and Other Info such as the Activity's Audio-Visual needs. These linked data rows must be created after the Activity row has been created.

To display, edit, or create any Activity data, you must first access the display of the Event with which it is associated. The name of the accessed Event is then shown in the upper left corner of the display frame. Once an Activity has been accessed, its name is also shown in the upper left corner of that display frame. These two names remain in view in a non-scrolling area, as you access any other data that is linked to that Activity. This includes any of the data tables that are listed below Activities in the Millennium Explorer. If you access another data display (under Events, or Registration, for example) the current accessed Activity is closed. To return to the display of that Activity row, or any of its linked rows, you must re-access that Activity.

Examine the Millennium Explorer and look at the list of data tables under Event Info. You will see some of the same data tables that are also listed under Activities. In either case, if you click the table name in the Explorer, you are shown all of the rows from that table that are linked directly to either the Event Info or the Activity. For example, if you click Event Info>Items, you are shown only those Item rows that are linked to directly to the Event row. You will not be shown any of the Item rows that are linked to any of the Activities within that Event. Likewise, if you click Activities>Items you are shown those Item rows that are linked directly to the Activity, You will not be shown those Items that are linked to other Activities for the same Event or any that are linked to the Event itself.

Create a New Activity

1. Verify that the Activity Type lookup table includes an entry that describes the Activity you plan to create. If not, use Event Lookup Table Maintenance to create the desired entry.
2. Locate the Event with which the new Activity is associated.

   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.
3. Click the Activities item in the Millennium Explorer. You are shown a listing of the existing Activities for the current Event. Verify that the Activity has not been created already, and then use one of the Create a New Activity. links located near the top of the page to access either the Activity Insert form or an Activity Default insert form.

4. Enter data in the available fields, using standard data entry techniques in accordance with the nature of the data field. (Datetime fields must use acceptable date formats, lookup table-driven fields use a pull-down listing, etc.):

   If your organization uses Instant Address:

   The Activity insert and update forms include 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 activity, or to verify that the activity'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.

   Activity Name - Enter the desired text.

   Note: Names longer than 50 characters cannot be selected for reporting. If you enter a name longer than 50 characters, Millennium displays a warning.

   Type - Choose an entry from the Activity Type lookup table pull down list.

   Standard - Select this check box if this is a standard Activity. A standard Activity is one that you expect all Event participants will attend. On the Express Registration form for the Event, a guest is assigned to a standard activity by default, but you can unassign the activity.

   Location - Enter the name of the location for the Activity.

   Success Rating - Choose an entry from the Success Rating lookup table pull down list.

   Start Date - Enter the beginning date for the Activity.

   End Date - Enter the ending date for the Activity.

   Start Time - Enter the beginning time for the Activity.

   End Time - Enter the ending time for the Activity.

   Total Invited - Enter the number of invitations (or the number of persons) invited to the Activity.

   Total Attended - Enter the number of Attendees. IMPORTANT NOTE: The system will automatically increment this field based on the Attended check box on Attendance rows and therefore you should not enter a value in this text box that would include those attendees. You might want to enter a count of staff members or those who will not be entered into the system as Guests for this Activity.

   Total Goal - Enter the Goal that has been set for this Activity in total pledges.

   Min # of Guests - Enter the minimum number of Guests required to hold this Activity.

   Max # of Guests - Enter the maximum number of Guests who may attend this Activity.

   Stadium Seating - If the guests who are attending the activity will be assigned seating in a particular row, select the Stadium Seating? check box. If the activity does not have assigned seating, or if the attendees will be seated at tables, then leave this option unchecked.

   Budget # of Guests - Enter the planned number of Guests who will pay the fee to attend this Activity.

   Budget # Attending - Enter the planned number of Guests who will both pay the fee and actually attend this Activity.

   Budget Cost - Enter the planned amount of the cost (to the institution) for this Activity.

   Budget Income - Enter the planned amount of income that this Activity will generate.

   Activity Fee - Enter the cost (if any) of this Activity to the Attendees.

   Address Line 1 - Enter the desired text.

   Address Line 2 - Enter the desired text.

   Address Line 3 - Enter the desired text.

   City - Enter the desired text.

   State - Choose an entry from the Places lookup table-pull down list.

   ZIP Code - Enter the ZIP or postal code for the address. The treatment of this information is dependent on the Country you choose for the address.

   Country - Choose an entry from the Countries lookup table. If you leave this blank or choose USA, the system will treat the ZIP Code information as a standard USA ZIP Code. Otherwise, the ZIP Code info will be treated as free text.
   Comment - Enter the desired text.

   Special Needs - Enter the number of Attendance Special Needs sections that will available on the Express Registration form to record special needs for guests who will attend the Activity (example: gluten-free diet required).

   Tournament - Enter the number of Attendance Tourney Needs sections that will be available on the Express Registration form to record tournament needs for guests who will attend the Activity (example: team assignment).

5. When all data appears in the form as you want, click Insert to create the Activity,

   OR

   Click Cancel to halt the process without creating the Activity.

View an Existing 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. Click the Activities item in the Millennium Explorer. The display will automatically show a listing of all the Activities for the current Event. You can sort the list in ascending or descending order by Activity Sort Order, Activity Name, Start Date or Location by clicking the appropriate column name on the header. Locate the desired Activity from the listing and click its name. The system will then automatically display the details for that data row.
3. If you want to switch from the display of the information from one Activity to the display of another Activity from the same Event, click the Search item under Activities in the Millennium Explorer. The complete list of Activities for that Event will be shown in the display frame. Locate the desired Activity from the listing and click its name as in step 1. The system will automatically display the details for that data row.
4. If you have accessed the Activity, are now viewing the display of the other data (for example, Actions) linked to that Activity, and you now want to return to the display of the details for the accessed Activity itself, click the Details item under Activities in the Millennium Explorer.

Edit an Existing 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. Display 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. Point to the Edit button located to the left of the Activity name.
4. Click the Update/Delete context menu item. An Update form opens, populated with the existing data for that Activity
5. Make your changes and click Update.

View Data linked to an 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. Display information that is linked to the current Activity by clicking the appropriate data table name under Activities item in the Millennium Explorer. The available data tables and their displays are:

   Actions - which will also include any Task assignments that are linked to those Actions;

   Attendees - which includes information from the Event Guest row, the Attendance row, and any Guest Items rows that are linked to the Guest row.

   Correspond - which accesses the Search/Create Correspondence screen to either display a list of all constituents who have been sent a piece of correspondence regarding this Activity (Search Correspondence), to create a new Correspondence row related to this Event (Link New Correspondence to an Event or Activity), or launch an Activity Correspondence report.

   Expenses - which shows the Expense rows that are linked to the current Activity.

   Items - which shows the Items rows that are linked to the current Activity.

   Organizers - .which shows the Organizer rows that are linked to the current Activity.

   Speakers - which shows the Speaker rows that are linked to the current Activity.

4. To switch to the display of data from a different linked table, or to return to the display of the Activity Details, click the desired item in the Millennium Explorer.

Create Data linked to an 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. Create a new data row that is linked to the current Activity by clicking the appropriate data table name under Activities in the Millennium Explorer. The following data can be linked to an activity:

   Actions

   Correspondence

   Expenses

   Items

   Organizers.

   Speakers
   

4. When the appropriate data table is shown in the display area, pass the mouse pointer over the edit button to the left of the Header Edit Button to access a context menu. Click either the Insert or Insert via Default menu item. You will be given an insert form for that data row. (The system will automatically create the linkage between the secondary data row and the Activity.)

For more information, see the instructions for the individual data tables by using the links shown above.

Sort Activities on the Express Registration Form

1. Locate the Event with which the Activities are associated.

   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.

1. Use Millennium Explorer Events > Activities > Sort to show the Define Activity Sort Order page, which enables you to change the order in which the list of Activities will display on the Express Registration form. It is important to note that the sort order assigned here will not change the order of the Activities as listed under the Event. Define Activity Sort Order will only change the order in which activities are shown on the Express Registration form.

2. To change the order of the list of Activities (on the Express Registration form), click an Activity name and drag it to the desired position within the list,

   OR

   click an Activity Name to highlight it, and then click either Move Up or Move Down to change the sort order.

3. When the list of Activities is ordered as desired, click OK to save. Click Cancel to undo your changes.
4. Once the sort has been saved, the Activities will display as such during the Express Registration for all users. Each site may want to discuss this amongst its users as to which sort order would suit them best since when a change is made by one user it will affect all users inserting Registration.

Customize the Activity Data Display and Maintenance Forms

1. Using Internet Explorer as your browser, log on to the system as a Millennium system administrator.
2. Access the Events version of the Custom Display Designer by using Millennium Explorer, Tools>Display Design>Events.
3. Click the Events item on the Navigation Tool Bar to access the Display Designer's context menu, and then click the Activity item.
4. Click Display Type and click on the desired Display Type menu item (for example, Long or Short).
5. Utilize the Custom Display Designer's editing tools to make your customizations.
6. Click Save to save and apply your changes.

(Refer to the Custom Display Designer topic for complete instructions on customizing display and maintenance forms.)

Activity Field Descriptions

Activity data is stored in the activity 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.

• actvinitum (Status)
• actvindate (Date)
• actvinitvr (Verification)
• actvinitds (Detail Status)

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
actvkey 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)
actvdoc 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)
actvdate no label	none	datetime/date   [getdate()]	The date that this row was last updated. This field is automatically entered by the system. (system field)
actvuserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator that last edited this row. It is automatically entered by the system. (system field)
actvugroup 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)
actvevcode non-displaying	none	char 10 [' ']	This field is a system-generated link between the Activity row and the Event to which it belongs. (system field)
actvevent Event	none	varchar/varchar2 110 [' ']	This field holds a system-generated copy of the name of the Event to which this Activity is linked. (system field)
actvname Name	none	varchar/varchar2 110 [' ']	This field holds the name you want to use for this Activity row.
actvtype Type	Activity Type	char 6 [' ']	Indicates the type of activity described in this row (football game, dance, dinner, marathon run, etc.) as defined in the Activity Type lookup table.
actvlocat Location	none	varchar/varchar2 55	A free text description of the location for the Activity.
actvstart Start Date	none	datetime/date	The start date for the Activity.
actvend End Date	none	datetime/date	The end date for the Activity.
actvinvite Total Invited	none	numeric/number 10, 0 ['0']	The total number of invitations that were issued for this Activity.
actvattend Total Attended	none	numeric/number 10, 0 ['0']	The total number of attendees for this Activity. This data is system-generated based on the number of Attendance rows that are linked to this Activity, minus multiples. (system field)
actvcost Total Cost	none	money/number (19,4)/(16,2) ['0']	This field is system-generated and is a sum of the amounts from all Expense rows that are linked to this Activity. (system field)
actvgoal Total Goal	none	money/number (19,4)/(16,2) ['0']	This is the target amount that the site hopes to generate in income for this Activity.
actvprloss Total Profit/Loss	none	money (19,4)/(16,2) ['0']	This field is the difference in the income (actvincome) and the cost (actvcost) for this Activity. This field is automatically calculated by the system. (system field)
actvincome Total Income	none	money/number (19,4)/(16,2) ['0']	This system-generated field shows the sum of the Activity fees from all Attendance rows that are linked to this Activity. This amount shows the anticipated total income from this Activity. (system field)
actvtguest Total Guest	none	numeric/number 10, 0	This system-generated field shows a total count of Attendance rows that are linked to this Activity. (system field)
actvbcost Budget Cost	none	money/number (19,4)/(16,2) ['0']	This field may be used to record the amount that the institution has budgeted for the cost of the Activity.
actvbincom Budget Income	none	money/number (19,4)/(16,2) ['0']	This field may be used to record the amount that the institution has budgeted for the income from the Activity.
actvbprlos Budget Profit/Loss	none	money/number (19,4)/(16,2) ['0']	This system-generated field calculates the difference in the budgeted cost and the budgeted income for this Activity. (system field)
actvbguest Budget # of Guests	none	numeric/number 10, 0 ['0']	This field may be used to record the number of attendees that the institution has budgeted for the Activity.
actvbattnd Budget # Attending	none	numeric/number 10, 0 ['0']	This field may be used to record the projected number of guests that will actually attend the Activity.
actvmngues Min # Guests	none	numeric/number 10,0 ['0']	This field may be used to record the minimum number of guests required in order to hold the Activity.
actvmxgues Max # of Guests	none	numeric/number 10,0 ['0']	This field may be used to record the maximum number of guests who may attend the Activity. If data is entered for this field, then during the Registration process the system will limit the number of Attendance rows that may be created for this Activity to this maximum.
actvsucces Success Rating	Success Rating	char 6 [' ']	Indicates degree of success that you want to attribute to the Activity. The possible ratings are defined by your institution in the Success Rating lookup table.
actvaddr1 Address Line 1	none	varchar/varchar2 60	The first line of an address associated with this Activity. You may choose to use this address info as the mailing address for the Activity, the location address, or any other type of address that is desired.
actvaddr2 Address Line 2	none	varchar/varchar2 60	The second line of the address associated with this Activity.
actvaddr3 Address Line 3	none	varchar/varchar2 60	The third line of the address associated with this Activity.
actvcity no label	none	varchar/varchar2 40	The city for the address associated with this Activity. This is free text.
actvstate no label	Places	char 6	The state or place for the address associated with this Activity. This data is taken from the Places lookup table.
actvzipcod no label	none	char 15	The postal code for the address associated with this Activity. This is a free text field. The system will accept and use any formatting that you enter for this field.
actvlnkfil non-displaying	none	char 2	This is a system-use field showing the file number of the Event data table (21). (system field)
actvlnkkey non-displaying	none	numeric/number 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)
actvexpflg non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the Activity for the presence of linked Expenses row(s). (system field)
actvorgflg non-displaying	none	char 1 [' '] {'Y', 'N'}	This is a system-use field that flags the Activity for the presence of linked Organizer row(s). (system field)
actvitemfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the Activity for the presence of linked Item row(s). (system field)
actvvolflg non-displaying	none	char 1 ['N'] {'Y', 'N'}	This field is currently not in use. When the Volunteer data table is activated, this will be a system-use field that flags the Activity for the presence of linked volunteer row(s). (system field)
actvgstflg non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the Activity for the presence of linked Activity guest row(s). (system field)
actvfnum non-displaying	none	char 2 ['52'] {'52'}	This is a system-use field showing the file number of this data table (52). (system field)
actvcrdate non-displaying	none	datetime/date   [getdate()]	This is a system generated field showing the date that this Activity row was created. (system field)
actvcomm Comment	none	varchar/varchar2 4000	This is a free text comment that may be associated with this Activity row.
actvothrfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the Activity for the presence of linked Other Info row(s). (system field)
actvsmash non-displaying	none	varchar/varchar2 30	This is a system generated field containing a version of the Activity Name, used for alphabetizing. (system field)
actvcorrfl non-displaying	none	char 1 ['N']	This is a system-use field that flags the Activity for the presence of linked Correspondence row(s). (system field)
actvstrttm Start Time	none	char 8	This field is the starting time for the Activity.
actvendtm End Time	none	char 8	This field is the ending time for the Activity.
actvactflg non-displaying	none	char 1 ['N'] {'Y', 'N'}	This is a system-use field that flags the Activity for the presence of linked Actions row(s).
actvfee Registration Fee	none	money/number (19,4)/(16,2) [0]	This field may be used to record the fee that is charged for this Activity. This amount is automatically used as the default amount for the Fee text box on the Insert form for an Attendance row (though that amount may be edited on that form.)
actvdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvmny1	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.
actvmny2	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.
actvnum1	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.
actvnum2	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.
actvyesno	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.
actvlook1	Activity 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.
actvlook2	Activity 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.
actvlook3	Activity 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.
actvtext	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.
actvcntry 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. (system field)
actvspkrfl non-displaying	none	char 1 ['N'] {'Y' or 'N'}	This system-generated field is a flag to the system that indicates the existence of a linked Speaker row. (system field)
actvseatfl non-displaying	none	char 1 ['N'] {'Y' or 'N'}	This system-generated field is a flag to the system that indicates the existence of a linked Seating Layout row. (system field)
actvspec Special Needs	none	numeric/number 3, 0	This field holds the number of Attendance Special Needs sections that are available on the Express Registration form for this Activity.
actvtourn Tourney Needs	none	numeric/number 3, 0	This field holds the number of Attendance Tourney Needs sections that are available on the Express Registration form for this Activity.
actvstndrd Standard	none	char 1	This field is used to flag when an Activity is set to Standard on the Express Registration form.
actvorder non-displaying	none	numeric/number 3, 0	This field determines the order in which this Activity will appear on the Express Registration form.
actvdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actvmny3	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.
actvmny4	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.
actvmny5	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.
actvmny6	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.
actvmny7	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.
actvmny8	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.
actvmny9	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.
actvmny10	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.
actvmny11	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.
actvmny12	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.
actvnum3	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.
actvnum4	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.
actvnum5	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.
actvnum6	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.
actvnum7	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.
actvnum8	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.
actvnum9	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.
actvnum10	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.
actvnum11	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.
actvnum12	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.
actvchk1	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.
actvchk2	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.
actvchk3	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.
actvchk4	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.
actvchk5	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.
actvchk6	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.
actvchk7	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.
actvchk8	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.
actvchk9	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.
actvchk10	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.
actvtxt1	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.
actvtxt2	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.
actvtxt3	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.
actvtxt4	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.
actvtxt5	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.
actvstdium	none	char 1 ['N'] {'Y' or 'N'}	This field is set to 'Y' if the seating layout for this activity is in rows (stadium seating). This field is set to 'N' if the seating layout for the activity is in tables, or if there is no seating layout associated with it.
actvinitum 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
actvinitds 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
actvindate Initium verification date	none	datetime	This field specifies the last date and time that the address was validated using Initium Instant Address.
actvinitvr Initium verification Info	none	varchar 30	This field contains the verification information returned from Initium for the address, if any.

Indices - Activity

Index	Primary	Foreign	Unique	Fields	Sort
pk_activity	Y			actvkey	ASC
activity02				actvevent	ASC
activity03				actvname	ASC
activity04				actvlnkkey, actvlnkfil	ASC
activity05				actvuserid	ASC

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