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