Name Type MSSql Type Oracle Type DB2 Nullable Description
EJPPA_AH_Idnr int NUMBER(38,0) int false reference to the execution header (EH)
EJPPA_EJPP_Lnr smallint NUMBER(38,0) smallint false reference to the jobplan process (EJPP)
EJPPA_Lnr smallint NUMBER(38,0) smallint false ascending number of the jobplan after
EJPPA_PreLnr smallint NUMBER(38,0) smallint false ascending number of the precondition
EJPPA_Status int NUMBER(38,0) int true state of the precondition
EJPPA_LineDef varchar (255) VARCHAR2 (255 CHAR) varchar(255) true desctiption of the line: aaa/bbb/c/d;.... aaa=row bbb=column c=position in the job d=option (line width)
EJPPA_When varchar (30) VARCHAR2 (30 CHAR) varchar(30) true when precondition
EJPPA_PreOk smallint NUMBER(38,0) smallint true flag whether or not the precondition is OK (does not matter how), is only "no" when blocking
EJPPA_RetCode int NUMBER(38,0) int true user return code
EJPPA_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Name of the line
EJPPA_BranchType smallint NUMBER(38,0) smallint true position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EJPPA EJPPA_AH_Idnr, EJPPA_EJPP_Lnr, EJPPA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File