Name Type MSSql Type Oracle Type DB2 Nullable Description
JPA_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JPA_Name varchar (8) VARCHAR2 (8 CHAR) varchar(8) true name !!!!!!!!!!!!!
JPA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) true Account
JPA_AutoDeact char (1) CHAR (1 CHAR) char(1) true deactivate autom. when finished: J/N/A/F J=during first error-free program run, A=always, N=no, F=when errorfree
JPA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) true start type
JPA_ActAtRun smallint NUMBER(38,0) smallint true activation at runtime
JPA_DeactDelay int NUMBER(38,0) int true delay in minutes
JPA_DeactWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true ok state for autom. deactivation
JPA_RWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true ok state global result
JPA_RExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true global altering object
JPA_ReuseHostGroup smallint NUMBER(38,0) smallint true Reuse hostgroup resolution within job plan? (1=Yes, 0=No)
JPA_SubType char (2) CHAR (2 CHAR) char(2) true "IF"=IF, "FE"=FOREACH
JPA_Deployment smallint NUMBER(38,0) smallint true Is deployment Tab active or not
JPA_WFType smallint NUMBER(38,0) smallint true Deployment Workflow Type (0 standard, 1 application, 2 component)
JPA_AppName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Deployment Application Name
JPA_ComponentName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Deployment Component Name
JPA_WFName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Deployment Workflow Name
JPA_PassPrio smallint NUMBER(38,0) smallint true Pass on Workflow priority to children: 1 means True, 0 is False

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_JPA_AppWFName JPA_AppName, JPA_WFName false false false false
NK_JPA_RExecute JPA_RExecute false false false false
PK_JPA JPA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPA_OH JPA_OH_Idnr OH_Idnr

Return to the Index File