| APD_AH_Idnr |
int |
NUMBER(38,0) |
int |
int |
false |
reference to the archive header (AH) |
| APD_Lnr |
smallint |
NUMBER(38,0) |
smallint |
smallint |
false |
Number of Definiton |
| APD_FreqMode |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
0=every, 1=gap, 2=once |
| APD_Every |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Seconds for every |
| APD_Gap |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Seconds for gap |
| APD_Once |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
time for once (format HHMM) |
| APD_Overlap |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
0=no overlap, 1=one overlap |
| APD_FromTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
time frame from (format HHMM) |
| APD_ToTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
time frame to (format HHMM) |
| APD_Adjust |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
0=no adjustment, 1=adjust to time frame |
| APD_RangeMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
0=no end, 1=end date, 2=max runs |
| APD_RangeStart |
datetime |
DATE |
timestamp |
timestamp |
true |
Start date of the range |
| APD_RangeEnd |
datetime |
DATE |
timestamp |
timestamp |
true |
End date (optional) |
| APD_MaxRuns |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Ends after n occurencies |
| APD_DaysMode |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
W=Weekdays, C=Cale |
| APD_Weekdays |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
1234567 or "" |
| APD_CaleType |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
CALE Type: 1=CALE AND, 2=CALE EQ, 3=CALE NE |
| APD_TZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Timezone for calculation |