Stored procedures

Stored procedures have been written by Synergetic development staff to return data based on one or more defined input parameters to restrict the data returned. The following stored procedures are defined:

Stored procedure

Description

Input parameters

Fields updated

crspFutureActivity-Print

Return data based on certain future student activities.

Optional:

Activity
Campus
MailedDate
IgnoreMailFlag{}*
ActivityCreatedBy.

Mailed Date
Mailed By.
See Modifying activities (enquiry students) in the Future students manual.

crspFutureStatus-ChangedPrint

Return data based on future student enquiry or application status change.

Mandatory:

MergeCode

Optional:
Campus
MergePrintedDate
IgnoreMailFlag{}*
StatusChangedBy.

Printed Date
Printed By.
See Future Student Maintenance - History tab in the Future students manual.

crspEnquiry-ProspectusPrint

Return data for all enquiries that have not had a letter created to accompany your organisation's prospectus.

Optional:

Campus
ProspectusPrinted-Date

Prospectus Date.
See Enquiry Student Maintenance - Enquiry tab in the Future students manual.

Note:* The default value for the IgnoreMailFlag parameter is 0 (zero).