Name Type MSSql Type Oracle Type DB2 Nullable Description
JPP_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JPP_Lnr smallint NUMBER(38,0) smallint false ascending number of the element
JPP_OType varchar (8) VARCHAR2 (8 CHAR) varchar(8) true 1=START, 2=JOB, 3=JP, 4=GROUP, 5=Script, 6=FT, 7=Event, 8=Call Operator, 9=END
JPP_Object varchar (200) VARCHAR2 (200 CHAR) varchar(200) true object name
JPP_Comment varchar (40) VARCHAR2 (40 CHAR) varchar(40) true comment
JPP_ErlstStTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) true Earliest start time
JPP_LtstStTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) true Latest start time
JPP_LtstEndTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) true Latest end time
JPP_WElse char (1) CHAR (1 CHAR) char(1) true WHEN ... ELSE S=SKIP, H=HALT, A=ABEND, X=Block + Abort Signal
JPP_WCType char (1) CHAR (1 CHAR) char(1) true WHEN condition type: space = AND, O=OR
JPP_CCType char (1) CHAR (1 CHAR) char(1) true CALE condition type: 2=CALE EQ, 3=CALE NE, 1 =CALE AND, 4=CALE Ext.
JPP_PreCnt smallint NUMBER(38,0) smallint true number of internal predecessors (JPPA) to this JPP
JPP_Row smallint NUMBER(38,0) smallint true y-coordinate for jobplan graphic
JPP_Col smallint NUMBER(38,0) smallint true x-coordinate for jobplan graphic
JPP_WhenExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Call-Operator
JPP_Active smallint NUMBER(38,0) smallint true bitmask: bit 1= active/inactiv, bit 2: hold/normal
JPP_RWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true Result: standard result
JPP_RExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Result: Call Operator
JPP_RElse int NUMBER(38,0) int true Result: else 1=halt 2=ignore 3=JP abend
JPP_RRepMTimes int NUMBER(38,0) int true Result: number of maximum repeats
JPP_RRepWait int NUMBER(38,0) int true Result: Repeat Waittime
JPP_MrtMethod int NUMBER(38,0) 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
JPP_Mrt int NUMBER(38,0) int true Max. runtime in sec.
JPP_MrtTime char (6) CHAR (6 CHAR) char(6) true Max. runtime in time ddhhmm
JPP_MrtErt smallint NUMBER(38,0) smallint true MRT=ERT+xx%
JPP_MrtExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Object to start
JPP_TcpATime char (6) CHAR (6 CHAR) char(6) true AFTER TIME > time
JPP_TcpExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Object to start
JPP_Srt int NUMBER(38,0) int true Min. runtime in sec.
JPP_SrtErt smallint NUMBER(38,0) smallint true SRT=ERT+xx%
JPP_TcpATimetTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Timezone for time check point
JPP_ErlstStTimeTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Timezone for erleast start time
JPP_LtstTimeTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Timezone for latest time
JPP_MrtTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Timezone for max. Runtime when a fixed time is used
JPP_ConFlag smallint NUMBER(38,0) smallint true Bitmask: bit 1=Task is not connected to END
JPP_RExecFlag smallint NUMBER(38,0) smallint true Result: 0=execute after each unsuccessful execution, 1=execute only after all retries are unsuccessful
JPP_PreCntExt smallint NUMBER(38,0) smallint true number of external predecessors (JPPA) of this JPP
JPP_ParentObject varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Only EXTERNAL: Jobplan Name
JPP_ExtWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true External Precondition (Status)
JPP_ExtSLTType char (1) CHAR (1 CHAR) char(1) true External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after jp plan start, 2=within hh:mm
JPP_ExtSLTWithin int NUMBER(38,0) int true External Precondition: Time in Seconds
JPP_ExtElse char (1) CHAR (1 CHAR) char(1) true External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend
JPP_ExtElseAlarm char (1) CHAR (1 CHAR) char(1) true External Precondition: Else Alarm: 0=no, 1=yes
JPP_ExtTimeout int NUMBER(38,0) int true External Precondition: Timeout in Seconds
JPP_ExtTimeoutE char (1) CHAR (1 CHAR) char(1) true External Precondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend
JPP_ExtTimeoutA char (1) CHAR (1 CHAR) char(1) true External Precondition: Timeout Alarm: 0=no, 1=yes
JPP_ExtExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true External Precondition: Alarm Object
JPP_TimeoutFlag smallint NUMBER(38,0) smallint true External Precondition: Tomeout On=1, Off=0
JPP_JPPV_Flag smallint NUMBER(38,0) smallint true Object has JPPVs
JPP_PreCondFlag smallint NUMBER(38,0) smallint true Object has Pre-Conditions
JPP_PostCondFlag smallint NUMBER(38,0) smallint true Object has Post-Conditions
JPP_Alias varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Alias Name for ProcessFlow task
JPP_ParentAlias varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Alias Name for ProcessFlow task in ExternalDependencies
JPP_ChildFlags char (16) CHAR (16 CHAR) char(16) true Flags for Subtables
JPP_ShowPrompt smallint NUMBER(38,0) smallint true Prompt will be shown, or not
JPP_PromptAtGen smallint NUMBER(38,0) smallint true Prompt at Processflow-Generation or at Job-Generation
JPP_BranchType smallint NUMBER(38,0) smallint true position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath
JPP_RunPerPatch smallint NUMBER(38,0) smallint true Flag, if Task is running per Patch
JPP_RollbackFlag smallint NUMBER(38,0) smallint true Rollback is enabled for task (overrides OH Flag)
JPP_RunPerTarget smallint NUMBER(38,0) smallint true Run per Deployment Target (1=serial, 2=parallel)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_JPP_ExtExecute JPP_ExtExecute false false false false
NK_JPP_MrtExecute JPP_MrtExecute false false false false
NK_JPP_Object JPP_Object, JPP_OType false false false false
NK_JPP_ParObject JPP_ParentObject false false false false
NK_JPP_RExecute JPP_RExecute false false false false
NK_JPP_TcpExecute JPP_TcpExecute false false false false
NK_JPP_WhenExecute JPP_WhenExecute false false false false
PK_JPP JPP_OH_Idnr, JPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPP_OH JPP_OH_Idnr OH_Idnr

Return to the Index File