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:
|
See Modifying activities in the Future students manual. |
crspFutureStatus-ChangedPrint |
Return data based on future student enquiry or application status change. |
Mandatory:
Optional:
|
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:
|
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 |
© 2016 Synergetic Management Systems. Published 16 September 2016.