SiriusSQL
The following changes have been made to these stored procedures in the SiriusSQL database in support of the new verification code (PIN) functionality which has been added to In-House Cards module:
• siriussp_GetDebitwareApproval: Added a new optional tcPIN parameter. This parameter is required to obtain an approval code when passing a DebitWare card that has PIN Required enabled on the Pass template. The passed verification code (PIN) must match the Verification Code (PIN) on file for this pass in order to generate an approval code. There is no need to pass the verification code (PIN) if simply querying the balance or spending limits on the pass.
• siriussp_ImportCreditNumbers: Now imports the new PIN column.
• siriussp_get_assignno: If the assignno returned has a non-empty PIN associated with it. It now includes a comma followed by the PIN value after the num_assign value. If the PIN is empty, then just the num_assign value is returned.
• siriussp_get_assignno_web: Now returns a second "NewPIN" column, which contains the PIN number for that returned num_assign value.
The following changes have been made to the SiriusSQL database:
• Assignno table: Added pin (varchar(4))
• Gst_pass table: Added pin (varchar(4))
• Template table: Added dw_pin (bit)