XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Appendix G: Data Mapping
XYPRO Technology Corporation 272 Proprietary and Confidential
G11: Safeguard Data Mapping
Refer to Chapter 7, “Safeguard Selection Criteria” starting on page 135 for more
information.
SAFEGUARD 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 timestamp Datetime-data
RECORDAUDITKEY timestamp MOVER Generated
RECORDSESSIONKEY timestamp MOVER Generated
SEQNO char 9
See SFG Note 2.
OUTCOME See General Note 3.
char 1 Result-flag 'F',= 3 ‘U’ = 4,
Outcome 455 =2
else =1
WARNINGMODE char 1
TESTMODE char 1 'N'
SEVERITY char 1
ALERTED See General Note 4.
char 1
PRODUCTCODE char 10 MOVER Generated
SUBJECTSYSTEM varchar 64 Subject-System (if blank then
System of conf file)
SUBJECTLOGIN varchar 40 Subject-Login-name
SUBJECT_USERNUMBER_MAJOR char 8 Subject-Group-number
SUBJECT_USERNUMBER_MINOR char 8 Subject-User-number
TARGET_USERNUMBER_MAJOR char 8
See SFG Note 3.
TARGET_USERNUMBER_MINOR char 8
See SFG Note 3.
TARGETLOGIN varchar 40
See SFG Note 3.
OBJECTTYPE - Type of Object varchar 32 Objecttype-s
OBJECTNAME - Name of Object varchar 200 Objectname
OPERATION-Activity varchar 128 Operation-s
TERMINAL varchar 64 Terminal
MESSAGEID varchar 20 Primary/Secondary record type
MESSAGECODE varchar 20 Outcome code
RULENAME varchar 50
RESULT varchar 256 Comment1-s