Table: APEVENT

APEVENT

Name

APEVENT

Comment

APEVENT is the driving data defining the existence and timeframes of an administered pricing event.


Primary Key Columns

Name

APEVENTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

APEVENTID

NUMBER(22,0)

X

Unique identifier for this administered pricing event

EFFECTIVEFROMINTERVAL

DATE

 

Date Time of the first Dispatch Interval to which the administered event applies

EFFECTIVETOINTERVAL

DATE

 

Date Time of the final Dispatch Interval to which the administered event applies

REASON

VARCHAR2(2000)

 

Description of the driver for the Event

STARTAUTHORISEDBY

VARCHAR2(15)

 

Authorising staff for start of AP event

STARTAUTHORISEDDATE

DATE

 

Date-Time start authorised

ENDAUTHORISEDBY

VARCHAR2(15)

 

Authorising staff for end of AP event

ENDAUTHORISEDDATE

DATE

 

Date Time end authorised

LASTCHANGED

DATE

 

Date-Time the record was last modified