Description |
* Issue/Requirements
** #1 - New Printer Software is not able to connect to table with field name of Key
*** This appears to be a reserved keyword in SQL
*** Rename Field of Key to be intKeyId
** #2 Clean Up other fields that are not required or inconsistently named
*** We originally matched an old access database and printing software that is being replaced at the same time.
*** Adjust tblCFMaximaPrinterCardSoftware as follows
**** Adjust table name to tblCFEncodingPrinterSoftware
**** Remove CardType
**** Remove CardNo
**** Rename EncodeString to EncodeTrack2
**** Rename EncodeString1 to EncodeTrack1
** #3 - Full Card is Wrong in Encode Printer Software Table
*** DispCardId should match same Values sent to NBS and displayed on Encode Cards Grid
*** It is showing 0 instead of actual card prompt and this is causing it to have a different check digit
** #4 - Expiration Date is showing incorrectly on EncodeString
*** Expiration should show properly as YYMM format on both Encode Tracks
*** Currently an Expiration Date of December 31, 2019 is showing as 1219 and should be 1912
*** Example: Card has Expiration Date of December, 31, 2019
**** EncodeTrack2 : 7392010299479339547=1912
**** EncodeTrack1: 7392010299479339547^LASSUSBROSOIL ^1912
** #5 - EncodeString (EncodeTrack2) is missing a proper delimiter should be =
*** Prior spec was set at a blank space between Full Card and Expiration Date
**** Example: 7392014299479339547=1912
** #6 Printed Expiration Date Field should have a prefix of EXP
*** Currently value is 12/19
*** Should be "EXP 12/19"
|