generated: 12.12.2016 18:33:42
by UC2010.accdb
AE Database 11.2 (Step 018)
| Name | Type | Len | Attributes | Description |
|---|---|---|---|---|
| FJPP_FE_Idnr | Long Integer | 4 | UC: Null=False | reference to the forecast (FE) |
| FJPP_Lnr | Integer | 2 | UC: Null=False | ascending number of the process |
| FJPP_Status | Long Integer | 4 | UC: Null=True | state of the process line of the jobplan (blocking ...) |
| FJPP_JobStatus | Long Integer | 4 | UC: Null=True | state of the process line from the job execution (ok,ended,abended) |
| FJPP_SubStatus | Text | 1 | UC: Null=True | sub state (H, A) if precondition (WHEN) is not true |
| FJPP_ErlstStTime | Text | 10 | UC: Null=True | Earliest start time |
| FJPP_LtstStTime | Text | 10 | UC: Null=True | Latest start time |
| FJPP_LtstEndTime | Text | 10 | UC: Null=True | Latest end time |
| FJPP_WElse | Text | 1 | UC: Null=True | WHEN ... ELSE S=SKIP, H=HALT, A=ABEND |
| FJPP_WCType | Text | 1 | UC: Null=True | WHEN condition type: space = AND, O=OR |
| FJPP_CCType | Text | 1 | UC: Null=True | CALE condition type: 2=CALE EQ, 3=CALE NE, 1 =CALE AND, 4=CALE Ext. |
| FJPP_TaskIdnr | Long Integer | 4 | UC: Null=True | primary key of FE of this task |
| FJPP_Row | Integer | 2 | UC: Null=True | y-coordinate for jobplan graphic |
| FJPP_Col | Integer | 2 | UC: Null=True | x-coordinate for jobplan graphic |
| FJPP_ErlstStTimeT | Date/Time | 8 | UC: Null=True | Earliest start time (timestamp) |
| FJPP_LtstStTimeT | Date/Time | 8 | UC: Null=True | Latest start time (timestamp) |
| FJPP_LtstEndTimeT | Date/Time | 8 | UC: Null=True | Latest end time (timestamp) |
| FJPP_RWhen | Text | 30 | UC: Null=True | Result: standard result |
| FJPP_RElse | Long Integer | 4 | UC: Null=True | Result: else 1=halt 2=ignore 3=JP abend |
| FJPP_RRepMTimes | Long Integer | 4 | UC: Null=True | Result: number of maximum repeats |
| FJPP_RRepWait | Long Integer | 4 | UC: Null=True | Result: time between repeats |
| FJPP_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 |
| FJPP_Mrt | Long Integer | 4 | UC: Null=True | Max. runtime in sec. |
| FJPP_MrtTime | Text | 6 | UC: Null=True | Max. runtime in time ddhhmm |
| FJPP_MrtErt | Integer | 2 | UC: Null=True | MRT=ERT+xx% |
| FJPP_TcpATime | Text | 6 | UC: Null=True | AFTER TIME > time |
| FJPP_Srt | Long Integer | 4 | UC: Null=True | Min. runtime in sec. |
| FJPP_SrtErt | Integer | 2 | UC: Null=True | SRT=ERT+xx% |
| FJPP_TcpATimetTZ | Text | 8 | UC: Null=True | Timezone for time check point |
| FJPP_ErlstStTimeTZ | Text | 8 | UC: Null=True | Timezone for erleast start time |
| FJPP_LtstTimeTZ | Text | 8 | UC: Null=True | Timezone for latest time |
| FJPP_MrtTZ | Text | 8 | UC: Null=True | Timezone for max. Runtime when a fixed time is used |
| FJPP_Active | Byte | 1 | UC: Null=True | bitmask: bit 1= active/inactiv, bit 2: hold/normal |
| FJPP_ConFlag | Integer | 2 | UC: Null=True | Bitmask: bit 1=Task is not connected to END |
| FJPP_PreCnt | Integer | 2 | UC: Null=True | number of internal predecessors (JPPA) of this JPP |
| FJPP_PreCntExt | Integer | 2 | UC: Null=True | number of external predecessors (FJPPA) of this FJPP |
| FJPP_ParentObject | Text | 200 | UC: Null=True | Only EXTERNAL: JobplanName |
| FJPP_ExtWhen | Text | 30 | UC: Null=True | External Precondition: (Status) |
| FJPP_ExtSLTType | Text | 1 | UC: Null=True | External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after job plan start, 2=within hh:mm |
| FJPP_ExtSLTWithin | Long Integer | 4 | UC: Null=True | External Precondition: Time in Seconds |
| FJPP_ExtElse | Text | 1 | UC: Null=True | External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend |
| FJPP_ExtElseAlarm | Text | 1 | UC: Null=True | External Precondition: Else Alarm: 0=no, 1=yes |
| FJPP_TimeoutFlag | Byte | 1 | UC: Typ=Boolean Null=True | External Precondition: Timeout On=1, Off=0 |
| FJPP_ExtTimeout | Long Integer | 4 | UC: Null=True | External Precondition: Timeout in Seconds |
| FJPP_ExtTimeoutE | Text | 1 | UC: Null=True | External Precondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend |
| FJPP_ExtTimeoutA | Text | 1 | UC: Null=True | External Precondition: Timeout Alarm: 0=no, 1=yes |
| FJPP_ExtExecute | Text | 200 | UC: Null=True | External Precondition: Alarm Object |
| FJPP_BranchType | Integer | 2 | UC: Null=True | position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath |
Indexes:
| Name | Fields |
|---|---|
| PK_FJPP | FJPP_FE_Idnr, FJPP_Lnr |
Return to the Index File