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

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_APD APD_AH_Idnr, APD_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_APD_AH APD_AH_Idnr AH_Idnr

Return to the Index File