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