Field info

Field name Data type Length Mandatory Comments
OPRID String 30 Yes
VERSION Bigint 4 No
OPRDEFNDESC String 30 Yes
EMPLID String 11 Yes
EMAILID String 70 Yes
OPRCLASS String 30 No
ROWSECCLASS String 30 No
OPERPSWD String 32 No
ENCRYPTED Bigint 4 No
SYMBOLICID String 8 No
LANGUAGE_CD String 3 No
MULTILANG Bigint 4 No
CURRENCY_CD String 3 No
LASTPSWDCHANGE DateTime 8 No mm/dd/yyyy
ACCTLOCK Bigint 4 Yes The field can contain 0/1
  • 0 - Active User
  • 1 - Locked User
PRCSPRFLCLS String 30 No
DEFAULTNAVHP String 30 No
FAILEDLOGINS Bigint 4 No
EXPENT Bigint 4 No
OPRTYPE Bigint 4 No
USERIDALIAS String 70 No
LASTSIGNONDTTM DateTime 8 No mm/dd/yyyy hh:mi:ss:mmmm
LASTUPDDTTM DateTime 8 No mm/dd/yyyy

hh:mi:ss:mmmm
LASTUPDOPRID String 30 No
Note: The OPRID field must be unique.