/
Stored procedures

Stored procedures

Owned by Former user (Deleted)
Last updated: Mar 06, 2017 by Former user (Deleted)

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).

Related content