Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description
The luActivity lookup table is used within current, future and past students to:

  • set the activity on the Create New Activity window, along with related information

Image Modified

  • filter activities displayed on the Activity tab

...

Image Modified

  • sort entries for use in either current, future or past students

...

...

Image Modified

  • specify reports and an optional parameter when printing from the Activity tab.

...


Example

Anchor
O_22027
O_22027

Anchor
O_42436
O_42436

 

Fields

Field

Description

Code

Unique identifier for the activity.

Description

Description for the activity.

MailRequest-Flag

Indicates whether or not:

  • mailed information is required
  • a letter is being sent using the mail merge feature of Microsoft Word.

    You can use a database query or a stored procedure to list all the people who have this flag set. For example, this can be used in mail merges with Microsoft Word. The crspFutureActivityPrint stored procedure has the advantage that, in addition to retrieving key activity data, it also updates fields to indicate when the letter was printed.
    See Using stored procedures to retrieve Synergetic data in the Extracting data manual.
    In the following example, the MailRequestFlag is selected for the Request accommodation lookup entry.
    Anchor
    O_22047
    O_22047
    Image Modified
    When creating a new activity, the Mail Request flag is already selected when Request accommodation is selected from the drop-down list.
    Anchor
    O_22048
    O_22048
    Image Modified

ReportCode

File name of the Crystal Report to run when the Image Modified button is clicked on the Activity tab. See:

ActiveFlag

Activity is active when this field is selected. Clear the field to set the activity to inactive.

ReportPrompt-ContactType-Flag

Used when a form letter, or similar report, needs to be addressed to one of a student's contacts, when the

Anchor
O_10667
O_10667
Image Modified button is clicked on the Activity tab.
The Select Contact for Print window is displayed.
Anchor
O_22193
O_22193
Image Modified
The user can select one of the student's contacts from the drop-down list.
Anchor
O_22194
O_22194
Image Modified
The selected ContactType is passed to the report in the ReportCode field.
See:

SortOrder

Order that the activities are displayed on the Activity drop-down list.

Anchor
O_22037
O_22037
Image Modified
The higher the number the later in the list that the entry appears.
If you also use the Activity tab in current students, as well as in future students, use the SortOrder to group entries. For example, you could order the future students entries before the current student entries.
The following entries are used in future students and displayed first:
Anchor
O_22049
O_22049
Image Modified
The following entries are used in current students and displayed last:
Anchor
O_22050
O_22050
Image Modified

FollowUpFlag

Select whether the Follow Up field is automatically selected on the Create New Activity window.
In the following example, the FollowUpFlag is selected for the Request accommodation lookup entry.

Anchor
O_22043
O_22043
Image Modified
When creating a new activity, the Follow Up flag is already selected when Request accommodation is selected from the drop-down list.
Anchor
O_22044
O_22044
Image Modified

RequiredFor-Enrolment

Whether the activity is required for the enrolment application process.

ModifiedDate

Date and time the lookup table entry was last modified.

ModifiedUser

User that last modified the lookup table entry.