Previous icon

Next icon

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
  • IgnoreMail
    Flag*
  • Activity
    CreatedBy.
  • Mailed Date
  • Mailed By.

See Modifying activities in the Future students manual.

crspFutureStatus-ChangedPrint

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

Mandatory:

  • MergeCode

Optional:

  • Campus
  • MergePrintedDate
  • IgnoreMail
    Flag*
  • Status
    ChangedBy.
  • 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
  • Prospectus
    Printed-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).

Last modified: 7/11/2011 1:25:16 PM

See Also

Using stored procedures to retrieve Synergetic data

Creating mail merge letters using stored procedures

Printing mail merge letters using an existing document

Reprinting mail merge letters

© 2013 Synergetic Management Systems. Published 15 October 2013.

Top of page