Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EJPPO_AH_Idnr int NUMBER(38,0) int int false reference to the archive header (AH) (RunID)
EJPPO_EJPP_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the jobplan process (Task Lnr)
EJPPO_Location smallint NUMBER(38,0) smallint smallint false 1=Pre, 2=Post
EJPPO_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of conditions in a workflow-task
EJPPO_CarName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the Condition/Action
EJPPO_Type char (1) CHAR (1 CHAR) char(1) char (1) true Type Condition/Action or structure info (C=Condition, A=Action, E=ELSE, F=ENDIF)
EJPPO_Active smallint NUMBER(38,0) smallint smallint true 0=inactive, 1=active
EJPPO_Once smallint NUMBER(38,0) smallint smallint true 0=every, 1=ONCE
EJPPO_Status smallint NUMBER(38,0) smallint smallint true Status of Condition/Action
EJPPO_Count int NUMBER(38,0) int int true Counter how often the conditions was checked/actions was taken
EJPPO_UIInfo varchar(max) CLOB clob(20480 k) COMPACT text true User field for UI

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EJPPO EJPPO_AH_Idnr, EJPPO_EJPP_Lnr, EJPPO_Location, EJPPO_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File