Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AJPP_AH_Idnr int NUMBER(38,0) int int false reference to the archive header (AH)
AJPP_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the jobplan process
AJPP_Status int NUMBER(38,0) int int true state of the process line of the jobplan (blocking ...)
AJPP_JobStatus int NUMBER(38,0) int int true state of the process line from the job execution (ok,ended,abended)
AJPP_Substatus char (1) CHAR (1 CHAR) char(1) char (1) true sub state (H, A) if precondition (WHEN) is not true
AJPP_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
AJPP_Object varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true object name
AJPP_ErlstStTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Earliest start time
AJPP_LtstStTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Latest start time
AJPP_LtstEndTime varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Latest end time
AJPP_WElse char (1) CHAR (1 CHAR) char(1) char (1) true WHEN ... ELSE S=SKIP, H=HALT, A=ABEND, X=Block + Abort Signal
AJPP_WCType char (1) CHAR (1 CHAR) char(1) char (1) true WHEN condition type: space = AND, O=OR
AJPP_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.
AJPP_StartTime datetime DATE timestamp timestamp true start time
AJPP_EndTime datetime DATE timestamp timestamp true end time
AJPP_PreCnt smallint NUMBER(38,0) smallint smallint true number of internal predexessors (AJPPA) of this AJPP
AJPP_Row smallint NUMBER(38,0) smallint smallint true y-coordinate for jobplan graphic
AJPP_Col smallint NUMBER(38,0) smallint smallint true x-coordinate for jobplan graphic
AJPP_MsgNr int NUMBER(38,0) int int true return code
AJPP_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true message insert to the message number
AJPP_RetCode int NUMBER(38,0) int int true return code
AJPP_Restart smallint NUMBER(38,0) smallint smallint true was this a restarted activation?
AJPP_RefNr int NUMBER(38,0) int int true reference job number
AJPP_WhenExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Call-Operator for HALT
AJPP_Active smallint NUMBER(38,0) smallint smallint true bitmask: bit 1= active/inactiv, bit 2: hold/normal
AJPP_RWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Result: standard result
AJPP_RExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Result: Call Operator
AJPP_RElse int NUMBER(38,0) int int true Result: else 1=halt 2=ignore 3=JP abend
AJPP_RRepMTimes int NUMBER(38,0) int int true Result: number of maximum repeats
AJPP_RRepWait int NUMBER(38,0) int int true Result: time between repeats
AJPP_RRepTimes int NUMBER(38,0) int int true Result: repeat counter
AJPP_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
AJPP_Mrt int NUMBER(38,0) int int true Max. runtime in sec.
AJPP_MrtTime char (6) CHAR (6 CHAR) char(6) char (6) true Max. runtime in time ddhhmm
AJPP_MrtErt smallint NUMBER(38,0) smallint smallint true MRT=ERT+xx%
AJPP_MrtExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Object to start
AJPP_TcpATime char (6) CHAR (6 CHAR) char(6) char (6) true AFTER TIME > time
AJPP_TcpExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Object to start
AJPP_Srt int NUMBER(38,0) int int true Min. runtime in sec.
AJPP_SrtErt smallint NUMBER(38,0) smallint smallint true SRT=ERT+xx%
AJPP_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
AJPP_TcpATimetTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for time check point
AJPP_ErlstStTimeTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for erleast start time
AJPP_LtstTimeTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for latest time
AJPP_MrtTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Timezone for max. Runtime when a fixed time is used
AJPP_RExecFlag smallint NUMBER(38,0) smallint smallint true Result: 0=execute after each unsuccessful execution, 1=execute only after all retries are unsuccessful
AJPP_LDate datetime DATE timestamp timestamp true Only UC_SYSTEM_SCHEDULE: logical date of this task
AJPP_PreCntExt smallint NUMBER(38,0) smallint smallint true number of external predecessors (AJPPA) of this AJPP
AJPP_ParentObject varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Only EXTERNAL: Jobplan Name
AJPP_ExtWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true External Precondition: (Status)
AJPP_ExtSLTType char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after jop plan start, 2=within hh:mm
AJPP_ExtSLTWithin int NUMBER(38,0) int int true External Precondition: Time in Seconds
AJPP_ExtElse char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend
AJPP_ExtElseAlarm char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Else Alarm: 0=no, 1=yes
AJPP_ExtTimeout int NUMBER(38,0) int int true External Precondition: Timeout in Seconds
AJPP_ExtTimeoutE char (1) CHAR (1 CHAR) char(1) char (1) true External Predondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend
AJPP_ExtTimeoutA char (1) CHAR (1 CHAR) char(1) char (1) true External Precondition: Timeout Alarm: 0=no, 1=yes
AJPP_ExtExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true External Precondition: Alarm Object
AJPP_TimeoutFlag smallint NUMBER(38,0) smallint smallint true External Precondition: Timeout On=1, Off=0
AJPP_ErlstStTimeT datetime DATE timestamp timestamp true Earliest start time (timestamp)
AJPP_CmtFlag smallint NUMBER(38,0) smallint smallint true 0/1 flag for menue prompting + flag in runnr# field
AJPP_Alias varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Alias Name for ProcessFlow task
AJPP_ParentAlias varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Alias Name for ProcessFlow task in ExternalDependencies
AJPP_ShowPrompt smallint NUMBER(38,0) smallint smallint true Prompt will be shown, or not
AJPP_PromptAtGen smallint NUMBER(38,0) smallint smallint true Prompt at Processflow-Generation or at Job-Generation
AJPP_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
AJPP_RunPerPatch smallint NUMBER(38,0) smallint smallint true Flag, if Task is running per Patch
AJPP_RollbackFlag smallint NUMBER(38,0) smallint smallint true Rollback is enabled for task (overrides AH Flag)
AJPP_RunPerTarget smallint NUMBER(38,0) smallint smallint true Run per Deployment Target (1=serial, 2=parallel)
AJPP_SubType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true OType specific SubType

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_AJPP_Object AJPP_Object, AJPP_AH_Idnr, AJPP_JobStatus, AJPP_EndTime, AJPP_TaskIdnr false false false false
NK_AJPP_RefNr AJPP_RefNr, AJPP_AH_Idnr false false false false
NK_AJPP_TaskIdnr AJPP_TaskIdnr, AJPP_AH_Idnr false false false false
PK_AJPP AJPP_AH_Idnr, AJPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPP_AH AJPP_AH_Idnr AH_Idnr

Return to the Index File