| EJPP_AH_Idnr |
int |
NUMBER(38,0) |
int |
false |
reference to the executive header (EH) |
| EJPP_Lnr |
smallint |
NUMBER(38,0) |
smallint |
false |
ascending number of the process |
| EJPP_Status |
int |
NUMBER(38,0) |
int |
true |
state of the process line of the jobplan (blocking ...) |
| EJPP_JobStatus |
int |
NUMBER(38,0) |
int |
true |
state of the process line from the job execution (ok,ended,abended) |
| EJPP_SubStatus |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
sub state (H, A) if precondition (WHEN) is not true |
| EJPP_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 |
| EJPP_Object |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
object name |
| EJPP_Comment |
varchar (40) |
VARCHAR2 (40 CHAR) |
varchar(40) |
true |
Bemerkung zb. f. Eindeutig machen |
| EJPP_ErlstStTime |
varchar (10) |
VARCHAR2 (10 CHAR) |
varchar(10) |
true |
Earliest start time |
| EJPP_LtstStTime |
varchar (10) |
VARCHAR2 (10 CHAR) |
varchar(10) |
true |
Latest start time |
| EJPP_LtstEndTime |
varchar (10) |
VARCHAR2 (10 CHAR) |
varchar(10) |
true |
Latest end time |
| EJPP_WElse |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
WHEN ... ELSE S=SKIP, H=HALT, A=ABEND, X=Block + Abort Signal |
| EJPP_WCType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
WHEN condition type: space = AND, O=OR |
| EJPP_CCType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
CALE condition type: 2=CALE EQ, 3=CALE NE, 1 =CALE AND, 4=CALE Ext. |
| EJPP_StartTime |
datetime |
DATE |
timestamp |
true |
start time |
| EJPP_EndTime |
datetime |
DATE |
timestamp |
true |
end time |
| EJPP_PreCnt |
smallint |
NUMBER(38,0) |
smallint |
true |
number of internal predecessors (EJPPA) of this EJPP |
| EJPP_PreOpen |
smallint |
NUMBER(38,0) |
smallint |
true |
number of not yet completed internal predecessors (EJPPA) of this EJPP |
| EJPP_TimeOk |
smallint |
NUMBER(38,0) |
smallint |
true |
flag whether or not the "after time condition" is true |
| EJPP_Row |
smallint |
NUMBER(38,0) |
smallint |
true |
y-coordinate for jobplan graphic |
| EJPP_Col |
smallint |
NUMBER(38,0) |
smallint |
true |
x-coordinate for jobplan graphic |
| EJPP_MsgNr |
int |
NUMBER(38,0) |
int |
true |
return code |
| EJPP_MsgInsert |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
message insert to the message number |
| EJPP_RetCode |
int |
NUMBER(38,0) |
int |
true |
return code |
| EJPP_ErlstStTimeT |
datetime |
DATE |
timestamp |
true |
Earliest start time (timestamp) |
| EJPP_LtstStTimeT |
datetime |
DATE |
timestamp |
true |
Latest start time (timestamp) |
| EJPP_LtstEndTimeT |
datetime |
DATE |
timestamp |
true |
Latest end time (timestamp) |
| EJPP_Restart |
smallint |
NUMBER(38,0) |
smallint |
true |
was this a restarted activation? |
| EJPP_RefNr |
int |
NUMBER(38,0) |
int |
true |
reference job number |
| EJPP_WhenExecute |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Call-Operator for HALT |
| EJPP_Active |
smallint |
NUMBER(38,0) |
smallint |
true |
bitmask: bit 1= active/inactiv, bit 2: hold/normal |
| EJPP_RWhen |
varchar (30) |
VARCHAR2 (30 CHAR) |
varchar(30) |
true |
Result: standard result |
| EJPP_RExecute |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Result: Call Operator |
| EJPP_RElse |
int |
NUMBER(38,0) |
int |
true |
Result: else 1=halt 2=ignore 3=JP abend |
| EJPP_RRepMTimes |
int |
NUMBER(38,0) |
int |
true |
Result: number of maximum repeats |
| EJPP_RRepWait |
int |
NUMBER(38,0) |
int |
true |
Result: time between repeats |
| EJPP_RRepTimes |
int |
NUMBER(38,0) |
int |
true |
Result: repeat counter |
| EJPP_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 |
| EJPP_Mrt |
int |
NUMBER(38,0) |
int |
true |
Max. runtime in sec. |
| EJPP_MrtTime |
char (6) |
CHAR (6 CHAR) |
char(6) |
true |
Max. runtime in time ddhhmm |
| EJPP_MrtErt |
smallint |
NUMBER(38,0) |
smallint |
true |
MRT=ERT+xx% |
| EJPP_MrtExecute |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Object to start |
| EJPP_TcpATime |
char (6) |
CHAR (6 CHAR) |
char(6) |
true |
AFTER TIME > time |
| EJPP_TcpExecute |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Object to start |
| EJPP_TcpATimeT |
datetime |
DATE |
timestamp |
true |
AFTER TIME > time (timestamp) |
| EJPP_Srt |
int |
NUMBER(38,0) |
int |
true |
Min. runtime in sec. |
| EJPP_SrtErt |
smallint |
NUMBER(38,0) |
smallint |
true |
SRT=ERT+xx% |
| EJPP_TaskIdnr |
int |
NUMBER(38,0) |
int |
true |
AH_IDNR of the task, -1 if there is no task (inactive); EXT: AH_IDNR which satisfied this condition |
| EJPP_TcpATimetTZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Timezone for time check point |
| EJPP_ErlstStTimeTZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Timezone for erleast start time |
| EJPP_LtstTimeTZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Timezone for latest time |
| EJPP_MrtTZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Timezone for max. Runtime when a fixed time is used |
| EJPP_ConFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
Bitmask: bit 1=Task is not connected to END |
| EJPP_RExecFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
Result: 0=execute after each unsuccessful execution, 1=execute only after all retries are unsuccessful |
| EJPP_NextOccur |
datetime |
DATE |
timestamp |
true |
Next occurence of this task in case of calendar conditions |
| EJPP_ModFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
1=Task was modified |
| EJPP_USR_Idnr |
int |
NUMBER(38,0) |
int |
true |
Only UC_SYSTEM_SCHEDULE: reference to user who activated this task |
| EJPP_LDate |
datetime |
DATE |
timestamp |
true |
Only UC_SYSTEM_SCHEDULE: logical date of this task |
| EJPP_PreCntExt |
smallint |
NUMBER(38,0) |
smallint |
true |
nimber of external predecessors (EJPPA) of this EJPP |
| EJPP_PreExtOpen |
smallint |
NUMBER(38,0) |
smallint |
true |
number of not yet completed external predecessors (EJPPA) of this EJPP |
| EJPP_ParentObject |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Only EXTERNAL: Jobplan Name |
| EJPP_ExtWhen |
varchar (30) |
VARCHAR2 (30 CHAR) |
varchar(30) |
true |
External Precondition: (Status) |
| EJPP_ExtSLTType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after job plan start, 2=within hh:mm |
| EJPP_ExtSLTWithin |
int |
NUMBER(38,0) |
int |
true |
External Precondition: Time in Seconds |
| EJPP_ExtElse |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend |
| EJPP_ExtElseAlarm |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
External Precondition: Else Alarm: 0=no, 1=yes |
| EJPP_ExtTimeout |
int |
NUMBER(38,0) |
int |
true |
External Precondition: Timeout in Seconds |
| EJPP_ExtTimeoutE |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
External Precondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend |
| EJPP_ExtTimeoutA |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
External Precondition: Timeout Alarm: 0=no, 1=yes |
| EJPP_ExtExecute |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
External Precondition: Alarm Object |
| EJPP_ExtFirstCheck |
smallint |
NUMBER(38,0) |
smallint |
true |
On=1. Check done, ELSE processed |
| EJPP_ExtTimeoutT |
datetime |
DATE |
timestamp |
true |
UTC Time for timeout |
| EJPP_ExtSLTT |
datetime |
DATE |
timestamp |
true |
UTC Timestamp for Satisfaction Lead Time |
| EJPP_TimeoutFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
External Precondition: Timeout On=1, Off =0 |
| EJPP_CmtFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
0/1 flag for menue prompting + flag in runnr# field |
| EJPP_CType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Containertype when Hostgroup ALL |
| EJPP_CondOpen |
smallint |
NUMBER(38,0) |
smallint |
true |
0 = No open conditions, 1 = Open Conditions |
| EJPP_CondNextCheck |
datetime |
DATE |
timestamp |
true |
Next check for next condition check |
| EJPP_EJPPV_Flag |
smallint |
NUMBER(38,0) |
smallint |
true |
Task has EJPPVs |
| EJPP_PreCondFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
Task has Pre-Conditions |
| EJPP_PostCondFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
Task has Post-Conditions |
| EJPP_Alias |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Alias Name for ProcessFlow task |
| EJPP_ParentAlias |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Alias Name for ProcessFlow task in ExternalDependencies |
| EJPP_ChildFlags |
char (16) |
CHAR (16 CHAR) |
char(16) |
true |
Flags for Subtables |
| EJPP_ShowPrompt |
smallint |
NUMBER(38,0) |
smallint |
true |
Prompt will be shown, or not |
| EJPP_PromptAtGen |
smallint |
NUMBER(38,0) |
smallint |
true |
Prompt at Processflow-Generation or at Job-Generation |
| EJPP_BranchType |
smallint |
NUMBER(38,0) |
smallint |
true |
position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath |
| EJPP_RunPerPatch |
smallint |
NUMBER(38,0) |
smallint |
true |
Flag, if Task is running per Patch |
| EJPP_RollbackFlag |
smallint |
NUMBER(38,0) |
smallint |
true |
Rollback is enabled for task (overrides EH Flag) |
| EJPP_RBPreOpen |
smallint |
NUMBER(38,0) |
smallint |
true |
Number of internal predecessors (EJPPA) of this EJPP |
| EJPP_RollbackMark |
smallint |
NUMBER(38,0) |
smallint |
true |
Task is marked for automatic rollback |
| EJPP_RunPerTarget |
smallint |
NUMBER(38,0) |
smallint |
true |
Run per Deployment Target (1=serial, 2=parallel) |
| EJPP_SubType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
OType specific SubType |