Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JPPV_OH_Idnr int NUMBER(38,0) int int false ID of the object.
JPPV_JPP_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the workflow tasks.
JPPV_OPU_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number within the prompt set list.
JPPV_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Prompt set name.
JPPV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Name of the value or the prompt set element.
JPPV_Type char (1) CHAR (1 CHAR) char(1) char (1) true Type of value. 1 = value, 2 = prompted value
JPPV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true Value or variable mapping to parent (&abc#) or system values
JPPV_HasList smallint NUMBER(38,0) smallint smallint true Indicates if this value uses an array.
JPPV_MsgNr int NUMBER(38,0) int int true Indicates whether or not the value has already been validated. -1 = not checked, 0 = check successful, >1 = check failed
JPPV_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Message insert(s) in case the validation of the value failed.
JPPV_AltView smallint NUMBER(38,0) smallint smallint true Flag for alternative view.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPV JPPV_OH_Idnr, JPPV_JPP_Lnr, JPPV_OPU_Lnr, JPPV_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPV_JPP JPPV_OH_Idnr, JPPV_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File