Definition of table: OSLOA - Attribute table for flat attributes of an SLO object

generated: 09.12.2016 10:28:48
by UC2010.accdb

AE Database 12.0 (Step 013)



Name Type Len Attributes Description
OSLOA_OH_Idnr Long Integer 4 UC: Null=False foreign key to OH
OSLOA_MonitorMode Byte 1 UC: Typ=Boolean Null=True flag for monitoring mode/ 0 = permanently 1 = restricted
OSLOA_ServQueryDef Memo 0 UC: Null=True L=0 Typ=clob inlinelength=1024 output from query builder xml or json format/ service query xml or json
OSLOA_ConsiderMRT Byte 1 UC: Typ=Boolean Null=True consider MRT for fulfillment
OSLOA_ConsiderSRT Byte 1 UC: Typ=Boolean Null=True consider SRT for fulfillment
OSLOA_ConsiderStat Byte 1 UC: Typ=Boolean Null=True consider end status for fulfillment
OSLOA_ExpectStatus Text 30 UC: Null=True Single status from UC_ZUTYP where ZUTYP_IsAlive = 0 / e.g "ANY_OK" or "ENDED_OK"
OSLOA_ExeOnFulfill Byte 1 UC: Typ=Boolean Null=True flag for execute on fulfillment
OSLOA_OnFulfilObj Text 200 UC: Null=True object to execute on on fulfillment / name of an alarm object
OSLOA_EmlOnFulfill Byte 1 UC: Typ=Boolean Null=True flag for sending email on fulfillment
OSLOA_OnFulfillRcp Memo 0 UC: Null=True L=0 Typ=clob inlinelength=1024 mail recipients to inform on fulfillment / mail recipients separated by ";"
OSLOA_ExeOnViolat Byte 1 UC: Typ=Boolean Null=True flag for execute on violation
OSLOA_OnViloatObj Text 200 UC: Null=True object to execute on on fulfillment/violation / name of an alarm object
OSLOA_EmlOnViolat Byte 1 UC: Typ=Boolean Null=True flag for sending email on violation
OSLOA_OnViolatRcp Memo 0 UC: Null=True L=0 Typ=clob inlinelength=1024 mail recipients to inform on violation / mail recipients separated by ";"
OSLOA_ConsiderStrt Byte 1 UC: Typ=Boolean Null=True consider latest start for fulfillment
OSLOA_ConsiderEnd Byte 1 UC: Typ=Boolean Null=True consider latest end for fulfillment
OSLOA_LtstStrtTime Text 4 UC: Null=True time format "hhmm" / latest start time
OSLOA_LtstEndTime Text 4 UC: Null=True time format "hhmm" / latest end time
OSLOA_OnWeekdays Text 8 UC: Null=True weekdays per no. e.g. "1234567" / weekdays to start on
OSLOA_MonitorFrom Text 4 UC: Null=True begin time of monitoring window with values = time format "hhmm"
OSLOA_MonitorTo Text 4 UC: Null=True end time of monitoring window with values = time format "hhmm"


Indexes:

Name Fields
PK_OSLOA OSLOA_OH_Idnr


Return to the Index File