asset_org_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | asset_org_site |
Definition | |
Note |
asset_org_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
asset_id |
Base Entity | asset |
Attribute Name | asset_id |
ColumnName | asset_id |
Definition | |
Note |
asset_id Logical Attribute Properties |
Logical Attribute Name | asset_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
as_db_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | as_db_site |
Definition | |
Note |
as_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
as_db_id |
Base Entity | asset |
Attribute Name | db_id |
ColumnName | as_db_id |
Definition | |
Note |
as_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
as_type_code |
Base Entity | asset |
Attribute Name | as_type_code |
ColumnName | as_type_code |
Definition | |
Note |
as_type_code Logical Attribute Properties |
Logical Attribute Name | as_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
user_tag_ident |
Base Entity | asset |
Attribute Name | user_tag_ident |
ColumnName | user_tag_ident |
Definition | |
Note |
user_tag_ident Logical Attribute Properties |
Logical Attribute Name | user_tag_ident |
Datatype | NVARCHAR(254) |
Nullable | YES |
name |
Base Entity | asset |
Attribute Name | name |
ColumnName | name |
Definition | |
Note |
name Logical Attribute Properties |
Logical Attribute Name | name |
Datatype | NVARCHAR(254) |
Nullable | YES |
long_description |
Base Entity | asset |
Attribute Name | long_description |
ColumnName | long_description |
Definition | |
Note |
long_description Logical Attribute Properties |
Logical Attribute Name | long_description |
Datatype | VARCHAR(4000) |
Nullable | YES |
criticality |
Base Entity | asset |
Attribute Name | criticality |
ColumnName | criticality |
Definition | |
Note |
criticality Logical Attribute Properties |
Logical Attribute Name | criticality |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
cs_type_db_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | cs_type_db_site |
Definition | |
Note |
cs_type_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
cs_type_db_id |
Base Entity | asset |
Attribute Name | db_id |
ColumnName | cs_type_db_id |
Definition | |
Note |
cs_type_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
cs_type_code |
Base Entity | asset |
Attribute Name | cs_type_code |
ColumnName | cs_type_code |
Definition | |
Note |
cs_type_code Logical Attribute Properties |
Logical Attribute Name | cs_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
mf_db_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | mf_db_site |
Definition | |
Note |
mf_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
mf_db_id |
Base Entity | asset |
Attribute Name | db_id |
ColumnName | mf_db_id |
Definition | |
Note |
mf_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
manuf_code |
Base Entity | asset |
Attribute Name | manuf_code |
ColumnName | manuf_code |
Definition | |
Note |
manuf_code Logical Attribute Properties |
Logical Attribute Name | manuf_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
model_db_site |
Base Entity | asset |
Attribute Name | model_db_site |
ColumnName | model_db_site |
Definition | |
Note |
model_db_site Logical Attribute Properties |
Logical Attribute Name | model_db_site |
Datatype | CHAR(16) |
Nullable | YES |
model_db_id |
Base Entity | asset |
Attribute Name | model_db_id |
ColumnName | model_db_id |
Definition | |
Note |
model_db_id Logical Attribute Properties |
Logical Attribute Name | model_db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
model_id |
Base Entity | asset |
Attribute Name | model_id |
ColumnName | model_id |
Definition | |
Note |
model_id Logical Attribute Properties |
Logical Attribute Name | model_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
serial_number |
Base Entity | asset |
Attribute Name | serial_number |
ColumnName | serial_number |
Definition | |
Note |
serial_number Logical Attribute Properties |
Logical Attribute Name | serial_number |
Datatype | NVARCHAR(254) |
Nullable | YES |
asr_db_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | asr_db_site |
Definition | |
Note |
asr_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
asr_db_id |
Base Entity | asset |
Attribute Name | db_id |
ColumnName | asr_db_id |
Definition | |
Note |
asr_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
asr_type_code |
Base Entity | asset |
Attribute Name | asr_type_code |
ColumnName | asr_type_code |
Definition | |
Note |
asr_type_code Logical Attribute Properties |
Logical Attribute Name | asr_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
segment_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | segment_site |
Definition | |
Note |
segment_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
segment_id |
Base Entity | asset |
Attribute Name | segment_id |
ColumnName | segment_id |
Definition | |
Note |
segment_id Logical Attribute Properties |
Logical Attribute Name | segment_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
last_upd_db_site |
Base Entity | asset |
Attribute Name | site_code |
ColumnName | last_upd_db_site |
Definition | |
Note |
last_upd_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
last_upd_db_id |
Base Entity | asset |
Attribute Name | db_id |
ColumnName | last_upd_db_id |
Definition | |
Note |
last_upd_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
gmt_last_updated |
Base Entity | asset |
Attribute Name | gmt_last_updated |
ColumnName | gmt_last_updated |
Definition | |
Note |
gmt_last_updated Logical Attribute Properties |
Logical Attribute Name | gmt_last_updated |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
rstat_type_code |
Base Entity | asset |
Attribute Name | rstat_type_cod |
ColumnName | rstat_type_code |
Definition | |
Note |
rstat_type_code Logical Attribute Properties |
Logical Attribute Name | rstat_type_cod |
Datatype | NUMERIC(5, 0) |
Nullable | YES |