asset_org_site
Base Entity asset_on_segment
Attribute Name site_code
Definition

asset_org_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


asset_id
Base Entity asset_on_segment
Attribute Name asset_id
Definition

asset_id Logical Attribute Properties
Logical Attribute Name asset_id
Datatype INTEGER
Nullable NO


segment_site
Base Entity asset_on_segment
Attribute Name site_code
Definition

segment_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


segment_id
Base Entity asset_on_segment
Attribute Name segment_id
Definition

segment_id Logical Attribute Properties
Logical Attribute Name segment_id
Datatype INTEGER
Nullable NO


gmt_installed
Base Entity asset_on_segment
Attribute Name gmt_installed
Definition

gmt_installed Logical Attribute Properties
Logical Attribute Name gmt_installed
Datatype DATETIME
Nullable NO


gmt_removed
Base Entity asset_on_segment
Attribute Name gmt_removed
Definition

gmt_removed Logical Attribute Properties
Logical Attribute Name gmt_removed
Datatype DATETIME
Nullable YES


installed_by_agent_site
Base Entity asset_on_segment
Attribute Name site_code
Definition

installed_by_agent_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


installed_by_agent_id
Base Entity asset_on_segment
Attribute Name agent_id
Definition

installed_by_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype INTEGER
Nullable YES


removed_by_agent_site
Base Entity asset_on_segment
Attribute Name site_code
Definition

removed_by_agent_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


removed_by_agent_id
Base Entity asset_on_segment
Attribute Name agent_id
Definition

removed_by_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype INTEGER
Nullable YES


gmt_last_updated
Base Entity asset_on_segment
Attribute Name gmt_last_updated
Definition

gmt_last_updated Logical Attribute Properties
Logical Attribute Name gmt_last_updated
Datatype DATETIME
Nullable YES


last_upd_db_site
Base Entity asset_on_segment
Attribute Name site_code
Definition

last_upd_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


last_upd_db_id
Base Entity asset_on_segment
Attribute Name db_id
Definition

last_upd_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


rstat_type_code
Base Entity asset_on_segment
Attribute Name rstat_type_cod
Definition

rstat_type_code Logical Attribute Properties
Logical Attribute Name rstat_type_cod
Datatype SMALLINT
Nullable YES