Name Type MSSql Type Oracle Type DB2 Nullable Description
OET_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OET_Lnr smallint NUMBER(38,0) smallint false ascrending number of the filter
OET_Code varchar (8) VARCHAR2 (8 CHAR) varchar(8) false id of the filter (XI Adapter: filter for 'Activation State')
OET_Filter varchar (255) VARCHAR2 (255 CHAR) varchar(255) false filter SAP: SAP event parameter, XI Adapter: filter for 'Channel Name'
OET_EventId int NUMBER(38,0) int true WIN_EVENT: event id
OET_EventType int NUMBER(38,0) int true WIN_EVENT: event type (1=error, 2=warning, 4=information, 8=success audit, 16=failure audit)
OET_Userid varchar (32) VARCHAR2 (32 CHAR) varchar(32) true WIN_EVENT: user OS/400:Msg_id, SAP: SAP Event id, XI Adapter: filter for 'State'
OET_SAPEventServer varchar (40) VARCHAR2 (40 CHAR) varchar(40) true SAP Event: Batch Server Name
OET_Filter2 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true filter for 'Service' (XI Adapter Monitoring)
OET_Filter3 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true filter for 'Party' (XI Adapter Monitoring)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OET OET_OH_Idnr, OET_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OET_OEA OET_OH_Idnr OEA_OH_Idnr

Return to the Index File