FH_Client |
smallint |
NUMBER(38,0) |
smallint |
false |
client |
FH_Title |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
false |
Title of the forecast |
FH_Idnr |
int |
NUMBER(38,0) |
int |
false |
primary key of the forecast |
FH_AH_Idnr |
int |
NUMBER(38,0) |
int |
true |
reference to the executive header (EH) |
FH_USR_Idnr |
int |
NUMBER(38,0) |
int |
true |
executing user |
FH_LStartTime |
datetime |
DATE |
timestamp |
true |
Logical startdate and time |
FH_LEndTime |
datetime |
DATE |
timestamp |
true |
Logical enddate and time |
FH_CStartTime |
datetime |
DATE |
timestamp |
true |
Starttime of forecast |
FH_CEndTime |
datetime |
DATE |
timestamp |
true |
Endtime of forecast |
FH_Status |
int |
NUMBER(38,0) |
int |
true |
Forecast status |
FH_MsgNr |
int |
NUMBER(38,0) |
int |
true |
Fehlermeldungsnummer |
FH_MsgInsert |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
Fehlermeldungs-Insert |
FH_UseEntries |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
1=Calculate groups through entries 0=do not calculate groups |
FH_GroupRT |
int |
NUMBER(38,0) |
int |
true |
Runtime of groups if not calcualted, -1 means use ERT of group |
FH_LDate |
datetime |
DATE |
timestamp |
true |
Logical Date |
FH_Signal |
int |
NUMBER(38,0) |
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) |
true |
Type of forecast i.e. Objecttype |
FH_TZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Timezone for this forecast |
FH_ContainerType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Object type of childs |
FH_NextCheck |
datetime |
DATE |
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 |
true |
Duration of Forecast (for periodic activities) |
FH_LastEnd |
datetime |
DATE |
timestamp |
true |
Last end time of preceding job in period |
FH_OccurCount |
int |
NUMBER(38,0) |
int |
true |
number of occurred activities in period |
FH_AEVersion |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
AE system version |