| OPD_OH_Idnr |
int |
NUMBER(38,0) |
int |
int |
false |
ID of the period object. |
| OPD_FreqMode |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Frequence mode. 0 = every, 1 = gap, 2 = once |
| OPD_Every |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Seconds for setting 'every'. |
| OPD_Gap |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Seconds for setting 'gap'. |
| OPD_Once |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
Time for setting 'once'. Format: HHMM |
| OPD_Overlap |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Defines whether one overlapse is allowed or not. 0 = no overlap allowed, 1 = one overlap allowed |
| OPD_FromTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
Start time of the time frame. Format: HHMM |
| OPD_ToTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
End time of the time frame: Format: HHMM |
| OPD_Adjust |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether the period needs to adjust to the time frame or not. 0 = no adjustment, 1 = adjust to time frame |
| OPD_RangeMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
Defines the end mode of the range. 0 = no end, 1 = use end date, 2 = use maximum number of runs defined |
| OPD_RangeStart |
datetime |
DATE |
timestamp |
timestamp |
true |
Start date of the range. |
| OPD_RangeEnd |
datetime |
DATE |
timestamp |
timestamp |
true |
End date of the range. (optional) |
| OPD_MaxRuns |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Defines the maximum number of occurencies. |
| OPD_DaysMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
How to define the days the period object should be activated. = daily, W = weekdays, C = based on calendar conditions |
| OPD_Weekdays |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Defines on what days the period object should be activated. (e.g. 12345 for Monday to Friday or ';') |
| OPD_CaleType |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
Defines how many calendar conditions have to match to activate the period object. 1 = all conditions match, 2 = one condition matches, 3 = no condition matches |