Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
FE_FH_Idnr int NUMBER(38,0) int int true primary key of forecast header
FE_Idnr int NUMBER(38,0) int int false primary key of the task
FE_Otype varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Objekt type
FE_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true name of the object
FE_AH_Idnr int NUMBER(38,0) int int true EH_IDNR of the task
FE_StartTime datetime DATE timestamp timestamp true Time of start
FE_EndTime datetime DATE timestamp timestamp true Time of end
FE_Status int NUMBER(38,0) int int true Task state
FE_HostDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true host name
FE_FileNameDst varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true filename for FT
FE_HostSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true host name (sender)
FE_FileNameSrc varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true filename for FT (sender)
FE_Count bigint NUMBER(38,0) bigint bigint true JP: recursive level
FE_TaskCount smallint NUMBER(38,0) smallint smallint true number of EJPP
FE_MaxParallel smallint NUMBER(38,0) smallint smallint true group: maximum number of parallel tasks
FE_ParentPrc int NUMBER(38,0) int int true FE_IDNR of parent task
FE_Ert int NUMBER(38,0) int int true Estimated Runtime
FE_FcstStatus int NUMBER(38,0) int int true Default status for forecast (i.e. STOP NOMSG)
FE_RealStartTime datetime DATE timestamp timestamp true Time of start of origin task
FE_RealEndTime datetime DATE timestamp timestamp true Time of end of origin task
FE_RealStatus int NUMBER(38,0) int int true Task state of origin task
FE_Signal int NUMBER(38,0) int int true Signals (bitmask): 1=TCP exceeded, 2=MRT exceeded, 4=SRT not reached
FE_MrtMethod int NUMBER(38,0) int int true Method for Max. Runtime (bitmask) 0=no audit, 1=fix in seconds, 2=fix time, 4=ERT+xx%, 256=Cancel, 512=Start Object
FE_Mrt int NUMBER(38,0) int int true Max. runtime in sec.
FE_MrtTime char (6) CHAR (6 CHAR) char(6) char (6) true Max. runtime in time ddhhmm
FE_MrtErt smallint NUMBER(38,0) smallint smallint true MRT=ERT+xx%
FE_Srt int NUMBER(38,0) int int true Min. runtime in sec.
FE_SrtErt smallint NUMBER(38,0) smallint smallint true SRT=ERT+xx%
FE_MrtTimeT datetime DATE timestamp timestamp true MRT as Timestamp f. Check
FE_UC4Priority smallint NUMBER(38,0) smallint smallint true UC4 priority
FE_TZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for object and script
FE_MrtTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for max. runtime when HHMM is used
FE_OccurCount int NUMBER(38,0) int int true count of executions
FE_ContainerType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Object type of childs
FE_ReuseHostGroup smallint NUMBER(38,0) smallint smallint true Reuse hostgroup resolution within job plan? (1=Yes, 0=No)
FE_HGSrc varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of source hostgroup
FE_HGDst varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of destination hostgroup
FE_MaxParallelHG int NUMBER(38,0) int int true max amount of parallel running tasks in host group
FE_ChildCnt int NUMBER(38,0) int int true Amount of childs
FE_HostAttrTypeDst varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Type of the Destination Host.
FE_Icon varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true object icon

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_FE_FH_IDNR FE_FH_Idnr false false false false
PK_FE FE_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_FE_FH FE_FH_Idnr FH_Idnr

Return to the Index File