Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

site

  • Last UpdatedNov 20, 2024
  • 1 minute read

The site table defines the time zone region and other information for a site. When entities belong to a site, the site's time zone is used to convert between UTC and local time.

Field

Datatype

PK

Nulls?

Description

ent_id

int32

Y

N

Entity ID of the site entity

site_name

string80

N

Y

Name of this site – usually equivalent to ent_name for the site but included here for convenience in that case

Note: This field is currently not used.

corporation

string40

N

Y

The corporation to which this site belongs

Note: This field is currently not used.

division

string40

N

Y

The division within the corporation to which this site belongs

Note: This field is currently not used.

sub_division

string40

N

Y

The sub-division within this division of the corporation to which this site belongs

Note: This field is currently not used.

region_id

string80

N

N

The time zone ID of this site as provided by Windows. For example, Eastern Standard Time, Pacific Standard Time.

Used to convert child entity UTC and local times as well as for generating an entity's shift history records.

spare1

string40

N

Y

Spare field

spare2

string40

N

Y

Spare field

spare3

string40

N

Y

Spare field

spare4

string40

N

Y

Spare field

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 1

N

N

Unique row identifier, for audit trail

FK from ent_id to ent. (Cascade delete)

TitleResults for “How to create a CRG?”Also Available in