| FH_Client |
smallint |
NUMBER(38,0) |
smallint |
smallint |
false |
client |
| FH_Title |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
varchar (200) |
false |
Title of the forecast |
| FH_Idnr |
int |
NUMBER(38,0) |
int |
int |
false |
primary key of the forecast |
| FH_AH_Idnr |
int |
NUMBER(38,0) |
int |
int |
true |
reference to the executive header (EH) |
| FH_USR_Idnr |
int |
NUMBER(38,0) |
int |
int |
true |
executing user |
| FH_LStartTime |
datetime |
DATE |
timestamp |
timestamp |
true |
Logical startdate and time |
| FH_LEndTime |
datetime |
DATE |
timestamp |
timestamp |
true |
Logical enddate and time |
| FH_CStartTime |
datetime |
DATE |
timestamp |
timestamp |
true |
Starttime of forecast |
| FH_CEndTime |
datetime |
DATE |
timestamp |
timestamp |
true |
Endtime of forecast |
| FH_Status |
int |
NUMBER(38,0) |
int |
int |
true |
Forecast status |
| FH_MsgNr |
int |
NUMBER(38,0) |
int |
int |
true |
Fehlermeldungsnummer |
| FH_MsgInsert |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
varchar (1024) |
true |
Fehlermeldungs-Insert |
| FH_UseEntries |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
1=Calculate groups through entries 0=do not calculate groups |
| FH_GroupRT |
int |
NUMBER(38,0) |
int |
int |
true |
Runtime of groups if not calcualted, -1 means use ERT of group |
| FH_LDate |
datetime |
DATE |
timestamp |
timestamp |
true |
Logical Date |
| FH_Signal |
int |
NUMBER(38,0) |
int |
int |
true |
Signals in any task (bitmask): 1=TCP exceeded, 2=MRT exceeded, 4=SRT not reached |
| FH_Type |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Type of forecast i.e. Objecttype |
| FH_TZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Timezone for this forecast |
| FH_ContainerType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Object type of childs |
| FH_NextCheck |
datetime |
DATE |
timestamp |
timestamp |
true |
Evnt: time when the event will be checked the next time, Call-Op: time when to escalate, schedule: end of the period |
| FH_Timespan |
int |
NUMBER(38,0) |
int |
int |
true |
Duration of Forecast (for periodic activities) |
| FH_LastEnd |
datetime |
DATE |
timestamp |
timestamp |
true |
Last end time of preceding job in period |
| FH_OccurCount |
int |
NUMBER(38,0) |
int |
int |
true |
number of occurred activities in period |
| FH_AEVersion |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
AE system version |