Definition of table: JPP - jobplan process

generated: 12.12.2016 18:33:51
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
JPP_OH_Idnr Long Integer 4 UC: Null=False reference to the object header (OH)
JPP_Lnr Integer 2 UC: Null=False ascending number of the element
JPP_OType Text 8 UC: Null=True 1=START, 2=JOB, 3=JP, 4=GROUP, 5=Script, 6=FT, 7=Event, 8=Call Operator, 9=END
JPP_Object Text 200 UC: Null=True object name
JPP_Comment Text 40 UC: Null=True comment
JPP_ErlstStTime Text 10 UC: Null=True Earliest start time
JPP_LtstStTime Text 10 UC: Null=True Latest start time
JPP_LtstEndTime Text 10 UC: Null=True Latest end time
JPP_WElse Text 1 UC: Null=True WHEN ... ELSE S=SKIP, H=HALT, A=ABEND, X=Block + Abort Signal
JPP_WCType Text 1 UC: Null=True WHEN condition type: space = AND, O=OR
JPP_CCType Text 1 UC: Null=True CALE condition type: 2=CALE EQ, 3=CALE NE, 1 =CALE AND, 4=CALE Ext.
JPP_PreCnt Integer 2 UC: Null=True number of internal predecessors (JPPA) to this JPP
JPP_Row Integer 2 UC: Null=True y-coordinate for jobplan graphic
JPP_Col Integer 2 UC: Null=True x-coordinate for jobplan graphic
JPP_WhenExecute Text 200 UC: Null=True Call-Operator
JPP_Active Byte 1 UC: Null=True bitmask: bit 1= active/inactiv, bit 2: hold/normal
JPP_RWhen Text 30 UC: Null=True Result: standard result
JPP_RExecute Text 200 UC: Null=True Result: Call Operator
JPP_RElse Long Integer 4 UC: Null=True Result: else 1=halt 2=ignore 3=JP abend
JPP_RRepMTimes Long Integer 4 UC: Null=True Result: number of maximum repeats
JPP_RRepWait Long Integer 4 UC: Null=True Result: Repeat Waittime
JPP_MrtMethod Long Integer 4 UC: Null=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 Long Integer 4 UC: Null=True Max. runtime in sec.
JPP_MrtTime Text 6 UC: Null=True Max. runtime in time ddhhmm
JPP_MrtErt Integer 2 UC: Null=True MRT=ERT+xx%
JPP_MrtExecute Text 200 UC: Null=True Object to start
JPP_TcpATime Text 6 UC: Null=True AFTER TIME > time
JPP_TcpExecute Text 200 UC: Null=True Object to start
JPP_Srt Long Integer 4 UC: Null=True Min. runtime in sec.
JPP_SrtErt Integer 2 UC: Null=True SRT=ERT+xx%
JPP_TcpATimetTZ Text 8 UC: Null=True Timezone for time check point
JPP_ErlstStTimeTZ Text 8 UC: Null=True Timezone for erleast start time
JPP_LtstTimeTZ Text 8 UC: Null=True Timezone for latest time
JPP_MrtTZ Text 8 UC: Null=True Timezone for max. Runtime when a fixed time is used
JPP_ConFlag Integer 2 UC: Null=True Bitmask: bit 1=Task is not connected to END
JPP_RExecFlag Integer 2 UC: Null=True Result: 0=execute after each unsuccessful execution, 1=execute only after all retries are unsuccessful
JPP_PreCntExt Integer 2 UC: Null=True number of external predecessors (JPPA) of this JPP
JPP_ParentObject Text 200 UC: Null=True Only EXTERNAL: Jobplan Name
JPP_ExtWhen Text 30 UC: Null=True External Precondition (Status)
JPP_ExtSLTType Text 1 UC: Null=True External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after jp plan start, 2=within hh:mm
JPP_ExtSLTWithin Long Integer 4 UC: Null=True External Precondition: Time in Seconds
JPP_ExtElse Text 1 UC: Null=True External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend
JPP_ExtElseAlarm Text 1 UC: Null=True External Precondition: Else Alarm: 0=no, 1=yes
JPP_ExtTimeout Long Integer 4 UC: Null=True External Precondition: Timeout in Seconds
JPP_ExtTimeoutE Text 1 UC: Null=True External Precondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend
JPP_ExtTimeoutA Text 1 UC: Null=True External Precondition: Timeout Alarm: 0=no, 1=yes
JPP_ExtExecute Text 200 UC: Null=True External Precondition: Alarm Object
JPP_TimeoutFlag Byte 1 UC: Typ=Boolean Null=True External Precondition: Tomeout On=1, Off=0
JPP_JPPV_Flag Byte 1 UC: Typ=Boolean Null=True Object has JPPVs
JPP_PreCondFlag Byte 1 UC: Typ=Boolean Null=True Object has Pre-Conditions
JPP_PostCondFlag Byte 1 UC: Typ=Boolean Null=True Object has Post-Conditions
JPP_Alias Text 200 UC: Null=True Alias Name for ProcessFlow task
JPP_ParentAlias Text 200 UC: Null=True Alias Name for ProcessFlow task in ExternalDependencies
JPP_ChildFlags Text 16 UC: Null=True Flags for Subtables
JPP_ShowPrompt Byte 1 UC: Typ=Boolean Null=True Prompt will be shown, or not
JPP_PromptAtGen Byte 1 UC: Typ=Boolean Null=True Prompt at Processflow-Generation or at Job-Generation
JPP_BranchType Integer 2 UC: Null=True position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath
JPP_RunPerPatch Long Integer 4 UC: Typ=Boolean Null=True Flag, if Task is running per Patch
JPP_RollbackFlag Byte 1 UC: Typ=Boolean Null=True Rollback is enabled for task (overrides OH Flag)
JPP_RunPerTarget Integer 2 UC: Null=True Run per Deployment Target (1=serial, 2=parallel)


Indexes:

Name Fields
NK_JPP_ExtExecute JPP_ExtExecute
NK_JPP_MrtExecute JPP_MrtExecute
NK_JPP_Object JPP_Object, JPP_OType
NK_JPP_ParObject JPP_ParentObject
NK_JPP_RExecute JPP_RExecute
NK_JPP_TcpExecute JPP_TcpExecute
NK_JPP_WhenExecute JPP_WhenExecute
PK_JPP JPP_OH_Idnr, JPP_Lnr


Return to the Index File