| EPD_AH_Idnr |
int |
NUMBER(38,0) |
int |
int |
false |
Reference to AH |
| EPD_Lnr |
smallint |
NUMBER(38,0) |
smallint |
smallint |
false |
Number of Definiton |
| EPD_FreqMode |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
0=every, 1=gap, 2=once |
| EPD_Every |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Seconds for every |
| EPD_Gap |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Seconds for gap |
| EPD_Once |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
time for once (format HHMM) |
| EPD_Overlap |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
0=no overlap, 1=one overlap |
| EPD_FromTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
time frame from (format HHMM) |
| EPD_ToTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
time frame to (format HHMM) |
| EPD_Adjust |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
0=no adjustment, 1=adjust to time frame |
| EPD_RangeMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
0=no end, 1=end date, 2=max runs |
| EPD_RangeStart |
datetime |
DATE |
timestamp |
timestamp |
true |
Start date of the range |
| EPD_RangeEnd |
datetime |
DATE |
timestamp |
timestamp |
true |
End date (optional) |
| EPD_MaxRuns |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Ends after n occurencies |
| EPD_DaysMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
W=Weekdays, C=Cale |
| EPD_Weekdays |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
1234567 or "" |
| EPD_CaleType |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
CALE Type: 1=CALE AND, 2=CALE EQ, 3=CALE NE |
| EPD_TZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Timezone for calculation |