luActivity lookup table
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
- filter activities displayed on the Activity tab
- sort entries for use in either current, future or past students
- specify reports and an optional parameter when printing from the Activity tab.
In the Future students manual, see:
- Future Student Maintenance - Activity tab
- Creating activities (enquiry students)
- Modifying activities (enquiry students).
In the Current students manual, see:
- Current Student Maintenance - Activity tab
- Creating activities (Current students)
- Modifying activities (Current students).
In the Past students manual, see:
- Past Student Maintenance - Activity tab
- Creating activities (Past students)
- Modifying activities (Past students).
Example
Fields
Field | Description |
---|---|
Code | Unique identifier for the activity. |
Description | Description for the activity. |
MailRequest-Flag | Indicates whether or not:
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. When creating a new activity, the Mail Request flag is already selected when Request accommodation is selected from the drop-down list. |
ReportCode | File name of the Crystal Report to run when the button is clicked on the Activity tab. See:
The report uses the following parameters:
For an additional parameter that is available, see the ReportPromptContactTypeFlag field. Crystal reports prompts for any parameters that are not specified. Contact Synergetic Management Systems to set up a report for this purpose. Alternatively, consider using the crspFutureActivityPrint stored procedure. See the MailRequestFlag field. |
ActiveFlag | Activity is active when this field is selected. Clear the field to set the activity to inactive. |
ReportPromptContactTypeFlag | Used when a form letter, or similar report, needs to be addressed to one of a student's contacts, when the button is clicked on the Activity tab. The Select Contact for Print window is displayed. The user can select one of the student's contacts from the drop-down list. The selected ContactType is passed to the report in the ReportCode field. See:
|
SortOrder | Order that the activities are displayed on the Steps tab The higher the number the later in the list that the entry appears. |
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. When creating a new activity, the Follow Up flag is already selected when Request accommodation is selected from the drop-down list. |
RequiredForEnrolment | Whether the activity is required for the enrolment application process. |
FormEditorFlag | Whether the selected activity is available to be used in the Online form builder. Note: For information about using the Online form builder, see Online Form Builder. |
ModifiedDate | Date and time the lookup table entry was last modified. |
ModifiedUser | User that last modified the lookup table entry. |