XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Appendix G: Data Mapping
XYPRO Technology Corporation 295 Proprietary and Confidential
G22: XYGATE User Authentication (XUA) Data Mapping
XUA Audit Detail Table
Column Type Record Contents
PARTITIONKEY
See General Note 1, pg 240.
numeric 4
RECORDGMT See General Note 2.
timestamp
GMTSEQNO char 2 MOVER Generated
RECORDLCT char 26 Date-time-data
RECORDAUDITKEY MOVER Generated
RECORDSESSIONKEY timestamp MOVER Generated
SEQNO char 9 Sequence-number
Outcome See General Note 3.
char 1 1 - Success , 2 - No Record,
3 - Failure
WARNINGMODE char 1
TESTMODE char 1 Test-flag
SEVERITY char 1
ALERTED See General Note 4.
char 1
PRODUCTCODE char 10 XYGATEUA
SUBJECT_USERNUMBER_MAJOR char 8 Subject-Group-number
SUBJECT_USERNUMBER_MINOR char 8 Subject-User-number
TARGET_USERNUMBER_MAJOR char 8 Target-Group-number
TARGET_USERNUMBER_MINOR char 8 Target-User-number
SUBJECTLOGIN varchar 40 Subject-Login-name
SUBJECTSYSTEM varchar 64 Subject-System
TARGETLOGIN varchar 40 Target-Login-name
OBJECTTYPE - Type of Object varchar 32 USER/ALIAS
OBJECTNAME - Name of Object varchar 200 Target-Login-name
OPERATION-Activity varchar 128 AUTHENTICATE
TERMINAL varchar 64 Home-Terminal
MESSAGEID varchar 20 n/a
MESSAGECODE varchar 20 OUTCOME
RULENAME varchar 50 UAGROUP
RESULT-details of OUTCOME varchar 256 COMMENT