Name Type MSSql Type Oracle Type DB2 Nullable Description
OKB_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OKB_Lnr smallint NUMBER(38,0) smallint false ascending number of the keyword
OKB_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) true name of the calendar keyword
OKB_DefFrom datetime DATE timestamp true default from time
OKB_DefTo datetime DATE timestamp true default to time
OKB_CType char (1) CHAR (1 CHAR) char(1) true Calendar Type (Y=Yearly, M=Monthly, W=Weekly, S=Static, R=Roll, G=Group, O=Old fashioned CALE)
OKB_SType char (1) CHAR (1 CHAR) char(1) true Calendar Sub Type (A=Absolute, R=Relative, I=Interval, ' ' none (roll or group)
OKB_ValidFrom datetime DATE timestamp true Valid from Static: user defined period, Valid from Dynamic: calculated period
OKB_ValidTo datetime DATE timestamp true Valid to Static: user defined period, Valid to Dynamic: calculated period
OKB_MsgNr int NUMBER(38,0) int true Message Numer for national holiday calendars
OKB_ErrMsgNr int NUMBER(38,0) int true Error Message Number (0 -> Errorfree else Error)
OKB_ErrMsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) true Error Message Insert
OKB_Period smallint NUMBER(38,0) smallint true Period (every n)
OKB_PeriodStart smallint NUMBER(38,0) smallint true Perod start (e.g. month 02)
OKB_PeriodEnd smallint NUMBER(38,0) smallint true Period end (e.g. To month 02)
OKB_DefDays varchar(2600) VARCHAR2 (2600 CHAR) varchar(2600) true Defined Days (24.12;31.12;) or (1;3;12) or (SU;MO;WE)
OKB_Interval smallint NUMBER(38,0) smallint true Interval (every n days)
OKB_Direction char (1) CHAR (1 CHAR) char(1) true From B(egin) E(nd)
OKB_IntervalStart varchar (4) VARCHAR2 (4 CHAR) varchar(4) true Start of Interval (DDMM or DD)
OKB_IntervalEnd varchar (4) VARCHAR2 (4 CHAR) varchar(4) true End of Interval (DDMM or DD)
OKB_RCaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Name of calendar (basis for roll calendar)
OKB_RCaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Name of calendar keyword (basis for roll calendar)
OKB_RCaleAdjust smallint NUMBER(38,0) smallint true Adjust plus/minus days
OKB_RCaleOperator char (1) CHAR (1 CHAR) char(1) true Operator for roll calendar ('+'=shift forward,' '-=shift backward
OKB_RCaleOffset smallint NUMBER(38,0) smallint true plus/minus days for roll calendar (0=adjust to next workingday according to operator; >0=adjust to next workingday according to operator + offset workingdays
OKB_RCaleRef smallint NUMBER(38,0) smallint true Use reference calendar (e.g. workingdays)
OKB_RRCaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Ref. calendar name
OKB_RRCaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Ref. calendar key name

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OKB_RCale OKB_RCaleName, OKB_RCaleKeyName false false false false
NK_OKB_RRCale OKB_RRCaleName, OKB_RRCaleKeyName false false false false
PK_OKB OKB_OH_Idnr, OKB_Lnr true true true false
UK_OKB_Key OKB_OH_Idnr, OKB_Name false true false false

Foreign Keys:

Name Local References Foreign References
FK_OKB_OH OKB_OH_Idnr OH_Idnr

Return to the Index File