Table: EMSMASTER

EMSMASTER

Name

EMSMASTER

Comment

EMSMASTER provides a description of the SCADA measurements that are associated with the SPD_ID points utilised in generic equation RHS terms


Primary Key Columns

Name

SPD_ID

SPD_TYPE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SPD_ID

VARCHAR(21)

X

ID defining data source

SPD_TYPE

VARCHAR(1)

X

ID describing type of data source

DESCRIPTION

VARCHAR(255)

 

The detailed description of the SCADA point associated with the SPD_ID

GROUPING_ID

VARCHAR(20)

 

The Grouping associated with the SPD ID - most often a RegionID

LASTCHANGED

DATE

 

Last date and time record changed