Stored procedures

Modified on Sun, 19 Apr at 11:18 PM

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.

crspFutureStatus-ChangedPrint

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

Mandatory:

  • MergeCode

    Optional:
  • Campus
  • MergePrintedDate
  • IgnoreMailFlag{}*
  • StatusChangedBy.

crspEnquiry-ProspectusPrint

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

Optional:

  • Campus
  • ProspectusPrinted-Date

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article