BDNA Data Platform 5.4 July 2017 (SQL Server) CAT_HW_MODEL_POWER - Hardware model power related information table
|
View Definition:
CREATE VIEW CAT_HW_MODEL_POWER AS SELECT f_tcat.CAT_HW_MODEL_POWER_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.CAT_HW_MODEL_ID,f_tcat.ENERGY_STAR,f_tcat.EPEAT,f_tcat.POWER_RATING,f_tcat.AC_POWER_AVG,f_tcat.AC_AVG_UNIT,f_tcat.AC_POWER_MAX,f_tcat.AC_MAX_UNIT,f_tcat.DC_POWER_AVG,f_tcat.DC_POWER_MAX,f_tcat.AC_HEAT_DISS_AVG,f_tcat.AC_HEAT_DISS_MAX,f_tcat.DC_HEAT_DISS_AVG,f_tcat.DC_HEAT_DISS_MAX,f_tcat.MIN_OPERATING_TEMP,f_tcat.MAX_OPERATING_TEMP,f_tcat.MIN_NON_OPERATING_TEMP,f_tcat.MAX_NON_OPERATING_TEMP,f_tcat.MIN_OPERATING_HUMIDITY,f_tcat.MAX_OPERATING_HUMIDITY,f_tcat.MIN_NON_OPERATING_HUMIDITY,f_tcat.MAX_NON_OPERATING_HUMIDITY,f_tcat.AC_INPUT_LOW_VOLT_MIN,f_tcat.AC_INPUT_LOW_VOLT_MAX,f_tcat.AC_INPUT_LOW_CURRENT_MIN,f_tcat.AC_INPUT_LOW_CURRENT_MAX,f_tcat.AC_INPUT_HIGH_VOLT_MIN,f_tcat.AC_INPUT_HIGH_VOLT_MAX,f_tcat.AC_INPUT_HIGH_CURRENT_MIN,f_tcat.AC_INPUT_HIGH_CURRENT_MAX,f_tcat.AC_FREQ_MIN,f_tcat.AC_FREQ_MAX,f_tcat.DC_LOW_VOLT,f_tcat.DC_LOW_CURRENT,f_tcat.DC_HIGH_VOLT,f_tcat.DC_HIGH_CURRENT,f_tcat.AC_PHASE,f_tcat.DEDICATED_CIRCUIT,f_tcat.PLUG_TYPE,f_tcat.BATTERY_LIFE,f_tcat.BATTERY_TYPE,f_tcat.EMERGENCY_POWER,f_tcat.TO_BE_DELETED,f_tcat.TO_BE_DELETED_ON,f_tcat.DELETE_REASON,f_tcat.PRIVATE_FLAG,f_tcat.IS_PRIVATE,f_tcat.PRIVATE_TYPE,f_tcat.REPLACEMENT_ID from TCAT_HW_MODEL_POWER f_tcat where not exists (select 1 from TPC_HW_MODEL_POWER tpc_tab where tpc_tab.CAT_HW_MODEL_POWER_ID=f_tcat.CAT_HW_MODEL_POWER_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_HW_MODEL_POWER_ID,tcat.CAT_HW_MODEL_POWER_ID) CAT_HW_MODEL_POWER_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,CASE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') > tcat.LAST_MODIFIED_DATE THEN tpc.LAST_MODIFIED_DATE
WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') < tcat.LAST_MODIFIED_DATE THEN tcat.LAST_MODIFIED_DATE
ELSE tcat.LAST_MODIFIED_DATE
END LAST_MODIFIED_DATE, COALESCE(tpc.CAT_HW_MODEL_ID,tcat.CAT_HW_MODEL_ID) CAT_HW_MODEL_ID,COALESCE(tpc.ENERGY_STAR,tcat.ENERGY_STAR) ENERGY_STAR,COALESCE(tpc.EPEAT,tcat.EPEAT) EPEAT,COALESCE(tpc.POWER_RATING,tcat.POWER_RATING) POWER_RATING,COALESCE(tpc.AC_POWER_AVG,tcat.AC_POWER_AVG) AC_POWER_AVG,COALESCE(tpc.AC_AVG_UNIT,tcat.AC_AVG_UNIT) AC_AVG_UNIT,COALESCE(tpc.AC_POWER_MAX,tcat.AC_POWER_MAX) AC_POWER_MAX,COALESCE(tpc.AC_MAX_UNIT,tcat.AC_MAX_UNIT) AC_MAX_UNIT,COALESCE(tpc.DC_POWER_AVG,tcat.DC_POWER_AVG) DC_POWER_AVG,COALESCE(tpc.DC_POWER_MAX,tcat.DC_POWER_MAX) DC_POWER_MAX,COALESCE(tpc.AC_HEAT_DISS_AVG,tcat.AC_HEAT_DISS_AVG) AC_HEAT_DISS_AVG,COALESCE(tpc.AC_HEAT_DISS_MAX,tcat.AC_HEAT_DISS_MAX) AC_HEAT_DISS_MAX,COALESCE(tpc.DC_HEAT_DISS_AVG,tcat.DC_HEAT_DISS_AVG) DC_HEAT_DISS_AVG,COALESCE(tpc.DC_HEAT_DISS_MAX,tcat.DC_HEAT_DISS_MAX) DC_HEAT_DISS_MAX,COALESCE(tpc.MIN_OPERATING_TEMP,tcat.MIN_OPERATING_TEMP) MIN_OPERATING_TEMP,COALESCE(tpc.MAX_OPERATING_TEMP,tcat.MAX_OPERATING_TEMP) MAX_OPERATING_TEMP,COALESCE(tpc.MIN_NON_OPERATING_TEMP,tcat.MIN_NON_OPERATING_TEMP) MIN_NON_OPERATING_TEMP,COALESCE(tpc.MAX_NON_OPERATING_TEMP,tcat.MAX_NON_OPERATING_TEMP) MAX_NON_OPERATING_TEMP,COALESCE(tpc.MIN_OPERATING_HUMIDITY,tcat.MIN_OPERATING_HUMIDITY) MIN_OPERATING_HUMIDITY,COALESCE(tpc.MAX_OPERATING_HUMIDITY,tcat.MAX_OPERATING_HUMIDITY) MAX_OPERATING_HUMIDITY,COALESCE(tpc.MIN_NON_OPERATING_HUMIDITY,tcat.MIN_NON_OPERATING_HUMIDITY) MIN_NON_OPERATING_HUMIDITY,COALESCE(tpc.MAX_NON_OPERATING_HUMIDITY,tcat.MAX_NON_OPERATING_HUMIDITY) MAX_NON_OPERATING_HUMIDITY,COALESCE(tpc.AC_INPUT_LOW_VOLT_MIN,tcat.AC_INPUT_LOW_VOLT_MIN) AC_INPUT_LOW_VOLT_MIN,COALESCE(tpc.AC_INPUT_LOW_VOLT_MAX,tcat.AC_INPUT_LOW_VOLT_MAX) AC_INPUT_LOW_VOLT_MAX,COALESCE(tpc.AC_INPUT_LOW_CURRENT_MIN,tcat.AC_INPUT_LOW_CURRENT_MIN) AC_INPUT_LOW_CURRENT_MIN,COALESCE(tpc.AC_INPUT_LOW_CURRENT_MAX,tcat.AC_INPUT_LOW_CURRENT_MAX) AC_INPUT_LOW_CURRENT_MAX,COALESCE(tpc.AC_INPUT_HIGH_VOLT_MIN,tcat.AC_INPUT_HIGH_VOLT_MIN) AC_INPUT_HIGH_VOLT_MIN,COALESCE(tpc.AC_INPUT_HIGH_VOLT_MAX,tcat.AC_INPUT_HIGH_VOLT_MAX) AC_INPUT_HIGH_VOLT_MAX,COALESCE
Possibly Referenced Tables/Views: