| OPD_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
Reference to OH |
| OPD_FreqMode |
smallint |
NUMBER(38,0) |
smallint |
true |
0=every, 1=gap, 2=once |
| OPD_Every |
smallint |
NUMBER(38,0) |
smallint |
true |
Seconds for every |
| OPD_Gap |
smallint |
NUMBER(38,0) |
smallint |
true |
Seconds for gap |
| OPD_Once |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
time for once (format HHMM) |
| OPD_Overlap |
smallint |
NUMBER(38,0) |
smallint |
true |
0=no overlap, 1=one overlap |
| OPD_FromTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
time frame from (format HHMM) |
| OPD_ToTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
time frame to (format HHMM) |
| OPD_Adjust |
smallint |
NUMBER(38,0) |
smallint |
true |
0=no adjustment, 1=adjust to time frame |
| OPD_RangeMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
0=no end, 1=end date, 2=max runs |
| OPD_RangeStart |
datetime |
DATE |
timestamp |
true |
Start date of the range |
| OPD_RangeEnd |
datetime |
DATE |
timestamp |
true |
End date (optional) |
| OPD_MaxRuns |
smallint |
NUMBER(38,0) |
smallint |
true |
Ends after n occurencies |
| OPD_DaysMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
W=Weekdays, C=Cale |
| OPD_Weekdays |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
1234567 or "" |
| OPD_CaleType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
CALE Type: 1=CALE AND, 2=CALE EQ, 3=CALE NE |