OSLOA_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
foreign key to OH |
OSLOA_MonitorMode |
smallint |
NUMBER(38,0) |
smallint |
true |
flag for monitoring mode/ 0 = permanently 1 = restricted |
OSLOA_ServQueryDef |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
true |
output from query builder xml or json format/ service query xml or json |
OSLOA_ConsiderMRT |
smallint |
NUMBER(38,0) |
smallint |
true |
consider MRT for fulfillment |
OSLOA_ConsiderSRT |
smallint |
NUMBER(38,0) |
smallint |
true |
consider SRT for fulfillment |
OSLOA_ConsiderStat |
smallint |
NUMBER(38,0) |
smallint |
true |
consider end status for fulfillment |
OSLOA_ExpectStatus |
varchar (30) |
VARCHAR2 (30 CHAR) |
varchar(30) |
true |
Single status from UC_ZUTYP where ZUTYP_IsAlive = 0 / e.g "ANY_OK" or "ENDED_OK" |
OSLOA_ExeOnFulfill |
smallint |
NUMBER(38,0) |
smallint |
true |
flag for execute on fulfillment |
OSLOA_OnFulfilObj |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
object to execute on on fulfillment / name of an alarm object |
OSLOA_EmlOnFulfill |
smallint |
NUMBER(38,0) |
smallint |
true |
flag for sending email on fulfillment |
OSLOA_OnFulfillRcp |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
true |
mail recipients to inform on fulfillment / mail recipients separated by ";" |
OSLOA_ExeOnViolat |
smallint |
NUMBER(38,0) |
smallint |
true |
flag for execute on violation |
OSLOA_OnViloatObj |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
object to execute on on fulfillment/violation / name of an alarm object |
OSLOA_EmlOnViolat |
smallint |
NUMBER(38,0) |
smallint |
true |
flag for sending email on violation |
OSLOA_OnViolatRcp |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
true |
mail recipients to inform on violation / mail recipients separated by ";" |
OSLOA_ConsiderStrt |
smallint |
NUMBER(38,0) |
smallint |
true |
consider latest start for fulfillment |
OSLOA_ConsiderEnd |
smallint |
NUMBER(38,0) |
smallint |
true |
consider latest end for fulfillment |
OSLOA_LtstStrtTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
time format "hhmm" / latest start time |
OSLOA_LtstEndTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
time format "hhmm" / latest end time |
OSLOA_OnWeekdays |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
weekdays per no. e.g. "1234567" / weekdays to start on |
OSLOA_MonitorFrom |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
begin time of monitoring window with values = time format "hhmm" |
OSLOA_MonitorTo |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
end time of monitoring window with values = time format "hhmm" |