| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| JPOP_OH_Idnr | int | NUMBER(38,0) | int | int | false | ID of the workflow. |
| JPOP_JPP_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | Sequenced number of the workflow tasks. |
| JPOP_Location | smallint | NUMBER(38,0) | smallint | smallint | false | Execution time of the condition/action. 1 = pre condition, 2 = post condition, 3 if workflow |
| JPOP_JPOV_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | Sequenced number of parameters within the condition/action. |
| JPOP_JPOV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | Variable name (S = Parameter set). |
| JPOP_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | Variable name of the refereneced prompt set. |
| JPOP_Value | varchar(max) | CLOB | clob(128 M) INLINE LENGTH 1024 COMPACT | text | true | Variable value. |
| JPOP_AltView | smallint | NUMBER(38,0) | smallint | smallint | true | Flag for alternative view. |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_JPOP | JPOP_OH_Idnr, JPOP_JPP_Lnr, JPOP_Location, JPOP_JPOV_Lnr, JPOP_JPOV_VName, JPOP_VName | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_JPOP_JPOV | JPOP_OH_Idnr, JPOP_JPP_Lnr, JPOP_Location, JPOP_JPOV_Lnr, JPOP_JPOV_VName | JPOV_OH_Idnr, JPOV_JPP_Lnr, JPOV_Location, JPOV_JPPO_Lnr, JPOV_VName |
Return to the Index File