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) |