000024971 - Contents of SDToken table differ from the documentation

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000024971
Applies ToRSA ACE/Server 5.0.1 (no longer supported as of 8-15-2004)
IssueContents of SDToken table differ from the documentation
If attempting to run SQL queries to pull information from the ACE/Server database, the information does not correlate with the published field structure in the documentation.
CauseThe documentation is in error and will be changed.
ResolutionThe SDToken fields are as follows:
chSerialNum  character
chSecurityBlock  character
iNumDigits  integer
iInterval  integer
todLastLogin  integer
bEnabled  logical
bHex  logical
iType  integer
dateLastLogin  date
todDeath  integer
dateDeath  date
iTokenNum  integer
todBirth  integer
dateBirth  date
iNextTCodeStatus  integer
bNewPINMode  logical
iUserNum  integer
iBadTokenCodes  integer
iBadPINs  integer
todPIN  integer
datePIN  date
todEnabled  integer
dateEnabled  date
todCountsLastModified  integer
dateCountsLastModified  date
bLost  logical
dateLostStatusExpires  date
todLostStatusExpires  integer
iLostAuthMethod  integer
iReplacingTokenNum  integer
iReplacedByTokenNum  integer
bSoftID_CopyProtected  logical
bSoftID_Deployed  logical
iSoftID_Count  integer
Legacy Article IDa8334