Name Type MSSql Type Oracle Type DB2 Nullable Description
JBA_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JBA_HostDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) true host name
JBA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) true start type
JBA_MaxCpu int NUMBER(38,0) int true max. CPU time
JBA_LoginDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of login object
JBA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) true Account
JBA_AttDialog smallint NUMBER(38,0) smallint true attribute dialog ?
JBA_Message varchar (50) VARCHAR2 (50 CHAR) varchar(50) true ? message receiver !!!!!!
JBA_Priority varchar (5) VARCHAR2 (5 CHAR) varchar(5) true . priority
JBA_Express smallint NUMBER(38,0) smallint true . express
JBA_Output varchar (8) VARCHAR2 (8 CHAR) varchar(8) true . destination of the job reports
JBA_JobClass varchar (8) VARCHAR2 (8 CHAR) varchar(8) true . job class
JBA_Rest varchar(1024) VARCHAR2 (1024 CHAR) varchar(1024) true . additional attributes
JBA_ActAtRun smallint NUMBER(38,0) smallint true activation at runtime?
JBA_CodeName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the code table
JBA_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
JBA_DeactDelay int NUMBER(38,0) int true delay in minutes
JBA_DeactWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true ok state for autom. deactivation
JBA_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) true attribute type of the host
JBA_Resource int NUMBER(38,0) int true Count of resources needed by this job (0=value from UC_SYSTEM_SETTINGS)
JBA_Flag smallint NUMBER(38,0) smallint true 0=CIT Agent Solution, 1=CIT Module Solution
JBA_JobType varchar (200) VARCHAR2 (200 CHAR) varchar(200) true e.g. CITC-Object or SAP jobtype
JBA_SubType varchar (200) VARCHAR2 (200 CHAR) varchar(200) true e.g. SubComponent name
JBA_RefTimeStamp datetime DATE timestamp true version of CITC, information only
JBA_OptReport varchar (64) VARCHAR2 (64 CHAR) varchar(64) true Optional reports
JBA_ReqParameters smallint NUMBER(38,0) smallint true Request Parameters (0=No, 1=Yes)
JBA_Connection varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Reference to connection object

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JBA JBA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JBA_OH JBA_OH_Idnr OH_Idnr

Return to the Index File