Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
FJPP_FE_Idnr int NUMBER(38,0) int int false reference to the forecast (FE)
FJPP_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the process
FJPP_Status int NUMBER(38,0) int int true state of the process line of the jobplan (blocking ...)
FJPP_JobStatus int NUMBER(38,0) int int true state of the process line from the job execution (ok,ended,abended)
FJPP_SubStatus char (1) CHAR (1 CHAR) char(1) char (1) true sub state (H, A) if precondition (WHEN) is not true
FJPP_ErlstStTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Earliest start time
FJPP_LtstStTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Latest start time
FJPP_LtstEndTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Latest end time
FJPP_WElse char (1) CHAR (1 CHAR) char(1) char (1) true WHEN ... ELSE S=SKIP, H=HALT, A=ABEND
FJPP_WCType char (1) CHAR (1 CHAR) char(1) char (1) true WHEN condition type: space = AND, O=OR
FJPP_CCType char (1) CHAR (1 CHAR) char(1) char (1) true CALE condition type: 2=CALE EQ, 3=CALE NE, 1 =CALE AND, 4=CALE Ext.
FJPP_TaskIdnr int NUMBER(38,0) int int true primary key of FE of this task
FJPP_Row smallint NUMBER(38,0) smallint smallint true y-coordinate for jobplan graphic
FJPP_Col smallint NUMBER(38,0) smallint smallint true x-coordinate for jobplan graphic
FJPP_ErlstStTimeT datetime DATE timestamp timestamp true Earliest start time (timestamp)
FJPP_LtstStTimeT datetime DATE timestamp timestamp true Latest start time (timestamp)
FJPP_LtstEndTimeT datetime DATE timestamp timestamp true Latest end time (timestamp)
FJPP_RWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Result: standard result
FJPP_RElse int NUMBER(38,0) int int true Result: else 1=halt 2=ignore 3=JP abend
FJPP_RRepMTimes int NUMBER(38,0) int int true Result: number of maximum repeats
FJPP_RRepWait int NUMBER(38,0) int int true Result: time between repeats
FJPP_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, 1024=JP overwrites Object-Settings
FJPP_Mrt int NUMBER(38,0) int int true Max. runtime in sec.
FJPP_MrtTime char (6) CHAR (6 CHAR) char(6) char (6) true Max. runtime in time ddhhmm
FJPP_MrtErt smallint NUMBER(38,0) smallint smallint true MRT=ERT+xx%
FJPP_TcpATime char (6) CHAR (6 CHAR) char(6) char (6) true AFTER TIME > time
FJPP_Srt int NUMBER(38,0) int int true Min. runtime in sec.
FJPP_SrtErt smallint NUMBER(38,0) smallint smallint true SRT=ERT+xx%
FJPP_TcpATimetTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for time check point
FJPP_ErlstStTimeTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for erleast start time
FJPP_LtstTimeTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for latest time
FJPP_MrtTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for max. Runtime when a fixed time is used
FJPP_Active smallint NUMBER(38,0) smallint smallint true bitmask: bit 1= active/inactiv, bit 2: hold/normal
FJPP_ConFlag smallint NUMBER(38,0) smallint smallint true Bitmask: bit 1=Task is not connected to END
FJPP_PreCnt smallint NUMBER(38,0) smallint smallint true number of internal predecessors (JPPA) of this JPP
FJPP_PreCntExt smallint NUMBER(38,0) smallint smallint true number of external predecessors (FJPPA) of this FJPP
FJPP_ParentObject varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Only EXTERNAL: JobplanName
FJPP_ExtWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true External Precondition: (Status)
FJPP_ExtSLTType char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after job plan start, 2=within hh:mm
FJPP_ExtSLTWithin int NUMBER(38,0) int int true External Precondition: Time in Seconds
FJPP_ExtElse char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend
FJPP_ExtElseAlarm char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Else Alarm: 0=no, 1=yes
FJPP_TimeoutFlag smallint NUMBER(38,0) smallint smallint true External Precondition: Timeout On=1, Off=0
FJPP_ExtTimeout int NUMBER(38,0) int int true External Precondition: Timeout in Seconds
FJPP_ExtTimeoutE char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend
FJPP_ExtTimeoutA char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Timeout Alarm: 0=no, 1=yes
FJPP_ExtExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true External Precondition: Alarm Object
FJPP_BranchType smallint NUMBER(38,0) smallint smallint true position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_FJPP FJPP_FE_Idnr, FJPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_FJPP_FE FJPP_FE_Idnr FE_Idnr

Return to the Index File