asset_org_site |
Base Entity | asset_health |
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_health |
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 |
gmt_assessment |
Base Entity | asset_health |
Attribute Name | gmt_assessment |
ColumnName | gmt_assessment |
Definition | |
Note |
gmt_assessment Logical Attribute Properties |
Logical Attribute Name | gmt_assessment |
Datatype | TIMESTAMP/DATE |
Nullable | NO |
by_agent_site |
Base Entity | asset_health |
Attribute Name | site_code |
ColumnName | by_agent_site |
Definition | |
Note |
by_agent_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
by_agent_id |
Base Entity | asset_health |
Attribute Name | agent_id |
ColumnName | by_agent_id |
Definition | |
Note |
by_agent_id Logical Attribute Properties |
Logical Attribute Name | agent_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
loc_hr_delta |
Base Entity | asset_health |
Attribute Name | loc_hr_delta |
ColumnName | loc_hr_delta |
Definition | |
Note |
loc_hr_delta Logical Attribute Properties |
Logical Attribute Name | loc_hr_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
loc_min_delta |
Base Entity | asset_health |
Attribute Name | loc_min_delta |
ColumnName | loc_min_delta |
Definition | |
Note |
loc_min_delta Logical Attribute Properties |
Logical Attribute Name | loc_min_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
health_lev_db_site |
Base Entity | asset_health |
Attribute Name | site_code |
ColumnName | health_lev_db_site |
Definition | |
Note |
health_lev_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
health_lev_db_id |
Base Entity | asset_health |
Attribute Name | db_id |
ColumnName | health_lev_db_id |
Definition | |
Note |
health_lev_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
health_lev_type_code |
Base Entity | asset_health |
Attribute Name | health_lev_type_code |
ColumnName | health_lev_type_code |
Definition | |
Note |
health_lev_type_code Logical Attribute Properties |
Logical Attribute Name | health_lev_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
health_scale_precise |
Base Entity | asset_health |
Attribute Name | health_scale_precise |
ColumnName | health_scale_precise |
Definition | |
Note |
health_scale_precise Logical Attribute Properties |
Logical Attribute Name | health_scale_precise |
Datatype | FLOAT |
Nullable | YES |
likelihood_prob |
Base Entity | asset_health |
Attribute Name | likelihood_prob |
ColumnName | likelihood_prob |
Definition | |
Note |
likelihood_prob Logical Attribute Properties |
Logical Attribute Name | likelihood_prob |
Datatype | FLOAT |
Nullable | YES |
gmt_created |
Base Entity | asset_health |
Attribute Name | gmt_created |
ColumnName | gmt_created |
Definition | |
Note |
gmt_created Logical Attribute Properties |
Logical Attribute Name | gmt_created |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
cr_loc_hr_delta |
Base Entity | asset_health |
Attribute Name | cr_loc_hr_delta |
ColumnName | cr_loc_hr_delta |
Definition | |
Note |
cr_loc_hr_delta Logical Attribute Properties |
Logical Attribute Name | cr_loc_hr_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
cr_loc_min_delta |
Base Entity | asset_health |
Attribute Name | cr_loc_min_delta |
ColumnName | cr_loc_min_delta |
Definition | |
Note |
cr_loc_min_delta Logical Attribute Properties |
Logical Attribute Name | cr_loc_min_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
ch_patt_db_site |
Base Entity | asset_health |
Attribute Name | site_code |
ColumnName | ch_patt_db_site |
Definition | |
Note |
ch_patt_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
ch_patt_db_id |
Base Entity | asset_health |
Attribute Name | db_id |
ColumnName | ch_patt_db_id |
Definition | |
Note |
ch_patt_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
ch_patt_type_code |
Base Entity | asset_health |
Attribute Name | ch_patt_type_code |
ColumnName | ch_patt_type_code |
Definition | |
Note |
ch_patt_type_code Logical Attribute Properties |
Logical Attribute Name | ch_patt_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
gmt_audited |
Base Entity | asset_health |
Attribute Name | gmt_audited |
ColumnName | gmt_audited |
Definition | |
Note |
gmt_audited Logical Attribute Properties |
Logical Attribute Name | gmt_audited |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
aud_loc_hr_delta |
Base Entity | asset_health |
Attribute Name | aud_loc_hr_delta |
ColumnName | aud_loc_hr_delta |
Definition | |
Note |
aud_loc_hr_delta Logical Attribute Properties |
Logical Attribute Name | aud_loc_hr_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
aud_loc_min_delta |
Base Entity | asset_health |
Attribute Name | aud_loc_min_delta |
ColumnName | aud_loc_min_delta |
Definition | |
Note |
aud_loc_min_delta Logical Attribute Properties |
Logical Attribute Name | aud_loc_min_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
aud_quality_code |
Base Entity | asset_health |
Attribute Name | dqual_type_code |
ColumnName | aud_quality_code |
Definition | |
Note |
aud_quality_code Logical Attribute Properties |
Logical Attribute Name | dqual_type_code |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
aud_by_org_asite |
Base Entity | asset_health |
Attribute Name | site_code |
ColumnName | aud_by_org_asite |
Definition | |
Note |
aud_by_org_asite Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
aud_by_agent_id |
Base Entity | asset_health |
Attribute Name | agent_id |
ColumnName | aud_by_agent_id |
Definition | |
Note |
aud_by_agent_id Logical Attribute Properties |
Logical Attribute Name | agent_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
user_tag_ident |
Base Entity | asset_health |
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_health |
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 | asset_health |
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 | asset_health |
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_health |
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 | asset_health |
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 |