Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OSA_OH_Idnr int NUMBER(38,0) int int false ID of the schedule object.
OSA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Start type of the object.
OSA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) varchar (16) true Name of the internal account.
OSA_ActAtRun smallint NUMBER(38,0) smallint smallint true Indicates that the object is generated at runtime or at activation time.
OSA_Period smallint NUMBER(38,0) smallint smallint true Defines the duration of the period (in days).
OSA_StartTime datetime DATE timestamp timestamp true Start time of the period.
OSA_RWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true The status range for a successful run.
OSA_RExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Alarm object that is activated if a run fails.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OSA OSA_OH_Idnr true true true false
NK_OSA_RExecute OSA_RExecute false false false false

Foreign Keys:

Name Local References Foreign References
FK_OSA_OH OSA_OH_Idnr OH_Idnr

Return to the Index File