Previous icon

Next icon

luActivity lookup table

Description

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

In the Future students manual, see:

In the Current students manual, see:

In the Past students manual, see:

Example

Lookup Table Maintenance - luActivity

Lookup Table Maintenance - luActivity (part 2)

Fields

Field

Description

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.

Lookup Table Maintenance - luFutureActivity (cut down)

When creating a new activity, the Mail Request flag is already selected when Request accommodation is selected from the drop-down list.

Create New Activity window (cut down)

ReportCode

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

The report uses the following parameters:

  • StudentID
  • ActivityCode
  • MailedBy
  • MailedDate.

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.

ReportPrompt-
ContactType-
Flag

Used when a form letter, or similar report, needs to be addressed to one of a student's contacts, when the Print button button is clicked on the Activity tab.

The Select Contact for Print window is displayed.

Select Contact for Print window

The user can select one of the student's contacts from the drop-down list.

Contact drop-down list (Select Contact for Print window)

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.

Create New Activity (Activity)

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:

Lookup Table Maintenance - luFutureActivity (SortOrder, 1-7)

The following entries are used in current students and displayed last:

Lookup Table Maintenance - luFutureActivity (SortOrder, 11-18)

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.

Lookup Table Maintenance - luFutureActivity

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

Create New Activity window (cut down)

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.

Last modified: 8/04/2015 1:58:38 PM

See Also

Maintaining current students setup data

luActivityStatus lookup table

luCommunityAlertCategory lookup table

luIndividualPlanActivityStatus lookup table

luIndividualPlanActivityType lookup table

luIndividualPlanArea lookup table

luIndividualPlanStatus lookup table

luIndividualPlanType lookup table

luInterviewOutcome lookup table

luInterviewType lookup table

luLearningAreaPosition lookup table

luSchool lookup table

luStudentCourseStatus lookup table

luStudentStatus lookup table

luSubSchool lookup table

luTertiaryCourse lookup table

luTransport lookup table

luTransportStops lookup table

AllowStartDateBeforeFileSemesterStartDate configuration setting

BaseDate configuration setting

MedicalIncident configuration setting

ParentFlag configuration setting

ParentYearLevelNoConvert configuration setting

RelationDescription configuration setting

ShowCurrent configuration setting

ShowNZMOETabIfNotNZ configuration setting

Students:AutoAddCourse configuration setting

© 2015 Synergetic Management Systems. Published 6 May 2015.

Top of page