Table: ADG_DETAIL

ADG_DETAIL

Name

ADG_DETAIL

Comment

Table for tracking evolving Aggregate Dispatch Group attributes


Primary Key Columns

Name

ADG_ID

EFFECTIVEDATE

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

ADG_ID

VARCHAR2(20)

X

Identifies the Aggregate Dispatch Group

EFFECTIVEDATE

DATE

X

Effective calendar date of record

VERSION_DATETIME

DATE

X

Date and time of the version of Dispatchable Unit details

ADG_TYPE

VARCHAR2(20)

 

Conformance Type for the Aggregate Dispatch Group.   One of the following: CAP, MIXED, TARGET

AUTHORISEDDATE

DATE

 

Date record authorised

AUTHORISEDBY

VARCHAR2(15)

 

User authorising record

LASTCHANGED

DATE

 

Last date and time record changed