New Site Table (in FI_Data_2)

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.

corporation

string40

N

Y

The corporation to which this site belongs.

division

string40

N

Y

The division within the corporation to which this site belongs.

sub_division

string40

N

Y

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

cur_tz_delta

int32

N

N

Current difference from GMT (UTC); -300 for EST, -240 for EDT

std_tz_delta

int32

N

N

Difference from GMT (UTC) during standard time; -300 for ET

daylight_delta

int32

N

N

Difference between the standard time offset from GMT and the daylight time offset from GMT; 60 for ET

next_daylight_
change

tdatetime

N

Y

Datetime of the next change to or from daylight savings time, in the current time (std. or daylight). Null for sites that do not change.

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

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 0

N

N

Unique row identifier, for audit trail