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

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_EJPP_Object EJPP_Object, EJPP_EndTime false false false false
NK_EJPP_OType EJPP_OType, EJPP_AH_Idnr false false false false
NK_EJPP_RefNr EJPP_RefNr false false false false
NK_EJPP_Status EJPP_Status, EJPP_ExtTimeoutT false false false false
NK_EJPP_TASKIdnr EJPP_TaskIdnr false false false false
NK_EJPP_TaskIdnr2 EJPP_AH_Idnr, EJPP_TaskIdnr false false false false
NK_EJPP_TcpATimeT EJPP_TcpATimeT false false false false
NK_EJPP_TimeOk EJPP_TimeOk false false false false
PK_EJPP EJPP_AH_Idnr, EJPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File