Event and Activity Actions

The Events Action table may be used to describe each of the jobs or actions that must be undertaken to successfully sponsor an Event, or an Activity within the Event. Once the actions have been planned and entered, the assignment of the responsibility for each action is made by linking a Task data row to the Event Action row. Each Event Action may have multiple linked Tasks. And each Task will belong to the constituent who will have the responsibility for completing the event action (or a portion of it). Each Event Action row will 'belong' to either a specific Event row, or belong to a specific Activity within the Event. It will not belong to any constituent in the system.

In the Events World, when Event Action rows are displayed in standard short mode, the Type, Completion Date, Priority, and Due On date fields are shown. When displayed in standard long mode, in addition to the fields shown in short mode, the Campaign, Campaign Year, Division, Source, Location, Comments, Change Date, and User id are also displayed. Also in long mode, or when the Display Linked Data in Short Display User Option is checked, any linked Tasks are shown as secondary rows, indented below the primary row and labeled as Event Actions Tasks.

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

Display Event Actions Linked to an Event

1. Access the Event whose Actions data rows you want to view. Refer to Accessing an Existing Event for instructions.
2. In the Millennium Explorer, click on Event Info.
3. Click the Actions item, under Event Info. The system will display all of the Actions that are linked to the Event you accessed in step 1. If Tasks have been linked to any of these Action rows, they will display as well (provided the display mode is set to Long, or the Display Linked Data in Short DisplayUser Option is checked).

Display Event Actions Linked to an Activity

1. Access the Event whose Activity's Actions data you want to view. Refer to Accessing an Existing Event for instructions.
2. In the Millennium Explorer, click on Activities to expand that item
3. From within the data display area, click on the desired Activity name hyperlink. For more information see, Accessing an Existing Activity.
4. Click the Actions item under Activities. The system will display all of the Actions that are linked to the Activity you accessed in step 3. If Tasks have been linked to any of these Action rows, they will display as well (provided the display mode is set to Long, or the user option Display Linked Data in Short Display User Option is checked).

Create a New Event Action Row

1. To create an Event Action linked to an Event, begin by following the instructions for accessing the display of Event Actions linked to an Event, shown directly above. To create an Event Action linked to an Activity, begin by following the instructions for accessing the display of Event Actions linked to an Activity, shown directly above.
2. Pass the mouse pointer over the Event Actions section header edit button to the left of any existing Event Actions, to access a context menu. Click Insert or Insert via Default.
3. You will be given an Insert form either blank or with your current active default definition for Event Actions. If you want to use a default definition that is not currently flagged as your active one, then point to the Choose Default item from the section header edit button context menu instead, and click on the name of the desired default definition.
4. Enter the appropriate data for each of the data columns.

5. When all data appears in the form as you want, click on Insert to create the Event Action row. A Tasks insert form will automatically be presented. You may choose, at this point, to link a Task to the Event Action row by completing the Tasks insert form See the Tasks topic for instructions. If not, click Cancel on the Tasks insert form to close this form without creating the linked Task

   OR

   Click Cancel to halt the process without creating a new row.

Edit Existing Event Action Data

1. To edit an Event Action linked to an Event, begin by following the instructions for accessing the display of Event Actions linked to an Event, shown above. To edit an Event Action linked to an Activity, begin by following the instructions for accessing the display of Event Actions linked to an Activity, shown above.
2. Pass the mouse pointer over the edit button to the left of the desired Event Action row to access a context menu. Click Update/Delete. An Update form showing the current data will be presented.

3. Tab or mouse click to each text box containing data that you want to edit. Make the desired changes, and click on the Update button to make the changes to the data,

   OR

   Click Delete to remove the data row from the system,

   OR

   Click Cancel to halt the process without making any changes to the data row.

4. Note: if you delete an Event Action to which one or more Tasks are linked, the linked Tasks will be deleted as well.

Link a Task to an Existing Event Action

1. To link a Task to an Event Action linked to an Event, begin by following the instructions for accessing the display of Event Actions linked to an Event, shown above. To link a Task to an Event Action linked to an Activity, begin by following the instructions for accessing the display of Event Actions linked to an Activity, shown above.
2. Pass the mouse pointer over the edit button to the left of the desired Event Action row to access a context menu. Point to Link, and then click on Task, or Task via Default.
3. You will be given either a blank Insert form or one populated with your current active default definition for Tasks. From this point forward, refer to the Tasks topic for instructions for completing this insert form.

Customize Event Action 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 on the Actions 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.)

Event Actions Field Descriptions

Event Actions data is stored in the event_actions 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
eactkey 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)
eactdoc 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)
eactdate no label	none	datetime/date   [getdate()]	The date that this Actions row was last updated. This field is automatically entered by the system. (System field)
eactuserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator that last edited this Actions row. It is automatically entered by the system. (System field)
eactugroup non-displaying	none	char 1 ['Z']	This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field)
eactevncd non-displaying	none	char 10	This system-generated field holds a copy of the code for the Event row with which this Event Action row is associated. (System field)
eactevent non-displaying	none	varchar/varchar2 110	This system-generated field holds a copy of the name of the Event row with which this Event Action row is associated. (System field)
eactactvty non-displaying	none	varchar/varchar2 110	This system-generated field holds a copy of the name of the Activity row with which this Event Action row is associated (if any). (System field)
eactcompdt Completion Date	none	datetime/date	This is the actual date of completion of this action.
eactduedat Due Date	none	datetime/date	This is the date on which this action is (or was) due to be completed.
eactlocatn Location	none	char 50	This is the location where the action is to take place.
eactprior Priority	Priority	char 6 [' ']	The priority assigned to this action.
eactdivis Division	Division	char 6 [' ']	The Division within the institution that is responsible for, or who will benefit from the action.
eacttype Type	Action Types	char 6 [' ']	This is the category of action that is described in this row.
eactlnkfil non-displaying	none	char 2	This field holds a copy of the file (table) number of the row to which this Event Action is attached If the Event Action is linked to the Event, it is populated with '21'. If the Event Action is linked to an Activity, it is populated with '52'. (System field)
eactlnkkey non-displaying	none	numeric/number 13,0 [0]	This field holds a copy of the key field from the row to which this Event Action is attached. (System field)
eactcamp Campaign	Campaigns	char 6 [' ']	This is the campaign that is responsible for this action.
eactcampyr Campaign Year	none	char 4	This is the year of the campaign that is responsible for this action. This is a four-digit year between 1600 and 2200.
eactdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactmny1	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.
eactmny2	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.
eactnum1	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.
eactnum2	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.
eactyesno	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.
eactlook1	Event Action 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.
eactlook2	Event Action 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.
eactlook3	Event Action 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.
eacttext	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.
eacttaskfl non-displaying	none	char 1	A flag telling the system whether there is or is not a Task linked to this Event Action. (System field)
eactcompfl non-displaying	none	char 1 ['N'] {'Y' or 'N'}	A flag indicating whether this Action has or has not been completed. It is automatically set to 'Y' when a completed date is entered in the eactcompdt field. This field (actcompflg) is used to define a Sort involving non-completed Actions. (SQL treats blank datetime fields in such a way that simply sorting on the actcompdat field may not produce the desired results.) To display non-completed Actions at the top of the display, the Sort definition should begin with the actcompflg in ascending order. It may then be followed by any additional Sort criteria you want. (System field)
eactsource Source	Source	char 6 [' ']	The source for the information in this row.
eactcrdate non-displaying	none	datetime/date   [getdate()]	The date that the row was created. (System field)
eactfnum non-displaying	none	char 2 ['66'] {'66'}	The file (table) number for the Events Actions table. (System field)
eactcomm no label	none	varchar/varchar2 4000	A free text Comment that may be entered and displayed with this row only.
eactdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
eactmny3	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.
eactmny4	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.
eactmny5	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.
eactmny6	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.
eactmny7	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.
eactmny8	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.
eactmny9	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.
eactmny10	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.
eactmny11	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.
eactmny12	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.
eactnum3	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.
eactnum4	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.
eactnum5	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.
eactnum6	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.
eactnum7	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.
eactnum8	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.
eactnum9	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.
eactnum10	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.
eactnum11	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.
eactnum12	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.
eactchk1	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.
eactchk2	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.
eactchk3	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.
eactchk4	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.
eactchk5	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.
eactchk6	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.
eactchk7	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.
eactchk8	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.
eactchk9	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.
eactchk10	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.
eacttxt1	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.
eacttxt2	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.
eacttxt3	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.
eacttxt4	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.
eacttxt5	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.

Indices - Event Actions

Index	Primary	Foreign	Unique	Fields	Sort
pk_event_actions	Y		Y	eactkey	ASC
event_actions02		Y		eactevncd	ASC
event_actions03		Y		eactdivis	ASC
event_actions04				eactduedat	ASC
event_actions05		Y		eactlnkkey eactlnkfil	ASC
event_actions06				eactcompdt	DESC
event_actions07				eactuserid	ASC

Top of Page