XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Appendix G: Data Mapping
XYPRO Technology Corporation 274 Proprietary and Confidential
G12: XYGATE Access Control (XAC) Data Mapping
XAC Audit Detail Table
Column Type XAC-I XAC-O XAC-C
XAC-E
PARTITIONKEY
See General Note 1, pg 240.
numeric(4) MOVER Generated
RECORDGMT See General
Note 2.
timestamp
GMTSEQNO char 2 MOVER Generated MOVER Generated
RECORDLCT timestamp Date-time Date-time
RECORDAUDITKEY timestamp MOVER Generated MOVER Generated
RECORDSESSIONKEY timestamp MOVER Generated MOVER Generated
SEQNO char 9 Sequence-number
OUTCOME See General Note 3.
char 1
See XAC Note 1. See XAC Note 1.
WARNINGMODE char 1
TESTMODE char 1 'N' 'N'
SEVERITY char 1
ALERTED See General Note 4.
char 1
PRODUCTCODE char 10 MOVER Generated MOVER Generated
SUBJECT_USERNUMBER_MAJOR char 8 Group-number Group-number
SUBJECT_USERNUMBER_MINOR char 8 User-number User-number
SUBJECTLOGIN varchar 40 Login-name Login-name
SUBJECTSYSTEM varchar 64 System System
TARGET_USERNUMBER_MAJOR char 8 Target-Group-
number
TARGET_USERNUMBER_MINOR char 8 Target-User-
number
TARGETLOGIN varchar 40 Target-Login-name
OBJECTTYPE - Type of Object varchar 32 “XACCOMMAND” “XACCOMMAND
OBJECTNAME - Name of Object varchar 200 XAC Command
Name
XAC Command
Name
OPERATION-Activity varchar 128 "USER
COMMAND"
"USER
COMMAND"
TERMINAL varchar 64 Home-terminal Home-terminal
MESSAGEID varchar 20 Audit-type Audit-type
MESSAGECODE varchar 20 Command-status Command-status
RULENAME varchar 50 XAC Command
Name
XAC Command
Name
RESULT varchar 256
See XAC Note 2. See XAC Note 2.