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

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EPD EPD_AH_Idnr, EPD_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File