XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Appendix G: Data Mapping
XYPRO Technology Corporation 246 Proprietary and Confidential
G4: BASE24 Data Mapping
BASE24 Audit Detail Table
Column Type Record Contents
PARTITIONKEY
See General Note 1, pg 240.
numeric 4 MOVER Generated
RECORDGMT See General Note 2. timestamp MOVER Generated
GMTSEQNO char 2 MOVER Generated
RECORDLCT timestamp Date-time
RECORDAUDITKEY timestamp MOVER Generated
RECORDSESSIONKEY timestamp MOVER Generated
SEQNO char 9 MOVER Generated
OUTCOME char 1 4 (unknown) or 3 (Failure) if the result text
contains "Security Violation"
See BASE24 Note 5.
WARNINGMODE char 1
TESTMODE char 1 'N'
SEVERITY char 1
ALERTED See General Note 4. char 1 MOVER Generated
PRODUCTCODE char 10 "BASE24"
SUBJECT_USERNUMBER_MAJOR char 8 BASE24 Group Number
SUBJECT_USERNUMBER_MINOR char 8 BASE24 User Number
SUBJECTLOGIN varchar 40 BASE24 userid of the person performing
the action
SUBJECTSYSTEM varchar 64 SYSTEM where user was authenticated.
(uses Expand-number to get node name)
TARGET_USERNUMBER_MAJOR char 8
TARGET_USERNUMBER_MINOR char 8
TARGETLOGIN varchar 40 Person Name (Contents of the
DESCRIPTION field in the BASE24 IDs
SEC record). See BASE24 Note 3.
OBJECTTYPE - Type of Object varchar 32 USER or FILE
OBJECTNAME - Name of Object varchar 200 BASE24 username (= the IDs alias in the
SEC file record). If the SEC file is not
identified, then the SUBJECTLOGIN is
placed here. See BASE24 Note 1 and
Note 3.
OPERATION-Activity varchar 128 FM-TYP - See BASE24 Note 2.
TERMINAL varchar 64 \Node + TERM-ID
MESSAGEID varchar 20
MESSAGECODE varchar 20 See BASE24 Note 5.
RULENAME varchar 50
RESULT varchar 256 The before and after image of the SEC file
record changed. See BASE24 Note 4. For
other files, the field will be blank.