meas_loc_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | meas_loc_site |
Definition | |
Note |
meas_loc_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
meas_loc_id |
Base Entity | meas_location |
Attribute Name | meas_loc_id |
ColumnName | meas_loc_id |
Definition | |
Note |
meas_loc_id Logical Attribute Properties |
Logical Attribute Name | meas_loc_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
ml_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | ml_db_site |
Definition | |
Note |
ml_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
ml_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | ml_db_id |
Definition | |
Note |
ml_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
ml_type_code |
Base Entity | meas_location |
Attribute Name | ml_type_code |
ColumnName | ml_type_code |
Definition | |
Note |
ml_type_code Logical Attribute Properties |
Logical Attribute Name | ml_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
segment_or_asset |
Base Entity | meas_location |
Attribute Name | segment_or_asset |
ColumnName | segment_or_asset |
Definition | |
Note |
segment_or_asset Logical Attribute Properties |
Logical Attribute Name | segment_or_asset |
Datatype | CHAR(1) |
Nullable | NO |
segment_site |
Base Entity | meas_location |
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 | meas_location |
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 |
asset_org_site |
Base Entity | meas_location |
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 | YES |
asset_id |
Base Entity | meas_location |
Attribute Name | asset_id |
ColumnName | asset_id |
Definition | |
Note |
asset_id Logical Attribute Properties |
Logical Attribute Name | asset_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ml_eu_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | ml_eu_db_site |
Definition | |
Note |
ml_eu_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
ml_eu_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | ml_eu_db_id |
Definition | |
Note |
ml_eu_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ml_eu_type_code |
Base Entity | meas_location |
Attribute Name | eu_type_code |
ColumnName | ml_eu_type_code |
Definition | |
Note |
ml_eu_type_code Logical Attribute Properties |
Logical Attribute Name | eu_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ds_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | ds_db_site |
Definition | |
Note |
ds_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
ds_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | ds_db_id |
Definition | |
Note |
ds_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ds_type_code |
Base Entity | meas_location |
Attribute Name | ds_type_code |
ColumnName | ds_type_code |
Definition | |
Note |
ds_type_code Logical Attribute Properties |
Logical Attribute Name | ds_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
tr_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | tr_db_site |
Definition | |
Note |
tr_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
tr_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | tr_db_id |
Definition | |
Note |
tr_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
tr_type_code |
Base Entity | meas_location |
Attribute Name | as_type_code |
ColumnName | tr_type_code |
Definition | |
Note |
tr_type_code Logical Attribute Properties |
Logical Attribute Name | as_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ta_orient_deg |
Base Entity | meas_location |
Attribute Name | ta_orient_deg |
ColumnName | ta_orient_deg |
Definition | |
Note |
ta_orient_deg Logical Attribute Properties |
Logical Attribute Name | ta_orient_deg |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ta_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | ta_db_site |
Definition | |
Note |
ta_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
ta_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | ta_db_id |
Definition | |
Note |
ta_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ta_type_code |
Base Entity | meas_location |
Attribute Name | ta_type_code |
ColumnName | ta_type_code |
Definition | |
Note |
ta_type_code Logical Attribute Properties |
Logical Attribute Name | ta_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
mim_loc_seq |
Base Entity | meas_location |
Attribute Name | mim_loc_seq |
ColumnName | mim_loc_seq |
Definition | |
Note |
mim_loc_seq Logical Attribute Properties |
Logical Attribute Name | mim_loc_seq |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
motion_direction |
Base Entity | meas_location |
Attribute Name | motion_direction |
ColumnName | motion_direction |
Definition | |
Note |
motion_direction Logical Attribute Properties |
Logical Attribute Name | motion_direction |
Datatype | CHAR(1) |
Nullable | YES |
mim_user_prefix |
Base Entity | meas_location |
Attribute Name | mim_user_prefix |
ColumnName | mim_user_prefix |
Definition | |
Note |
mim_user_prefix Logical Attribute Properties |
Logical Attribute Name | mim_user_prefix |
Datatype | NVARCHAR(254) |
Nullable | YES |
mc_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | mc_db_site |
Definition | |
Note |
mc_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
mc_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | mc_db_id |
Definition | |
Note |
mc_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
mc_type_code |
Base Entity | meas_location |
Attribute Name | mc_type_code |
ColumnName | mc_type_code |
Definition | |
Note |
mc_type_code Logical Attribute Properties |
Logical Attribute Name | mc_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
mc_calc_size |
Base Entity | meas_location |
Attribute Name | mc_calc_size |
ColumnName | mc_calc_size |
Definition | |
Note |
mc_calc_size Logical Attribute Properties |
Logical Attribute Name | mc_calc_size |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
update_interval |
Base Entity | meas_location |
Attribute Name | update_interval |
ColumnName | update_interval |
Definition | |
Note |
update_interval Logical Attribute Properties |
Logical Attribute Name | update_interval |
Datatype | FLOAT |
Nullable | YES |
int_eu_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | int_eu_db_site |
Definition | |
Note |
int_eu_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
int_eu_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | int_eu_db_id |
Definition | |
Note |
int_eu_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
int_eu_type_code |
Base Entity | meas_location |
Attribute Name | eu_type_code |
ColumnName | int_eu_type_code |
Definition | |
Note |
int_eu_type_code Logical Attribute Properties |
Logical Attribute Name | eu_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
collect_duration |
Base Entity | meas_location |
Attribute Name | collect_duration |
ColumnName | collect_duration |
Definition | |
Note |
collect_duration Logical Attribute Properties |
Logical Attribute Name | collect_duration |
Datatype | FLOAT |
Nullable | YES |
dur_eu_db_site |
Base Entity | meas_location |
Attribute Name | site_code |
ColumnName | dur_eu_db_site |
Definition | |
Note |
dur_eu_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
dur_eu_db_id |
Base Entity | meas_location |
Attribute Name | db_id |
ColumnName | dur_eu_db_id |
Definition | |
Note |
dur_eu_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
dur_eu_type_code |
Base Entity | meas_location |
Attribute Name | eu_type_code |
ColumnName | dur_eu_type_code |
Definition | |
Note |
dur_eu_type_code Logical Attribute Properties |
Logical Attribute Name | eu_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
xml_data_type |
Base Entity | meas_location |
Attribute Name | xml_data_type |
ColumnName | xml_data_type |
Definition | |
Note |
xml_data_type Logical Attribute Properties |
Logical Attribute Name | xml_data_type |
Datatype | NVARCHAR(254) |
Nullable | YES |
xml_pattern_regex |
Base Entity | meas_location |
Attribute Name | xml_pattern_regex |
ColumnName | xml_pattern_regex |
Definition | |
Note |
xml_pattern_regex Logical Attribute Properties |
Logical Attribute Name | xml_pattern_regex |
Datatype | NVARCHAR(254) |
Nullable | YES |
user_tag_ident |
Base Entity | meas_location |
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 |
barcode |
Base Entity | meas_location |
Attribute Name | barcode |
ColumnName | barcode |
Definition | |
Note |
barcode Logical Attribute Properties |
Logical Attribute Name | barcode |
Datatype | NVARCHAR(254) |
Nullable | YES |
name |
Base Entity | meas_location |
Attribute Name | name |
ColumnName | name |
Definition | |
Note |
name Logical Attribute Properties |
Logical Attribute Name | name |
Datatype | NVARCHAR(254) |
Nullable | YES |
gmt_last_updated |
Base Entity | meas_location |
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 |
last_upd_db_site |
Base Entity | meas_location |
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 | meas_location |
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 |
rstat_type_code |
Base Entity | meas_location |
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 |