BDNA Data Platform 5.4 July 2017 (Oracle) CAT_HW_MODEL_POWER - Hardware model power related information table
|
View Definition:
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 "CAT_HW_MODEL_POWER_ID","CREATE_DATE","LAST_MODIFIED_DATE","CAT_HW_MODEL_ID","ENERGY_STAR","EPEAT","POWER_RATING","AC_POWER_AVG","AC_AVG_UNIT","AC_POWER_MAX","AC_MAX_UNIT","DC_POWER_AVG","DC_POWER_MAX","AC_HEAT_DISS_AVG","AC_HEAT_DISS_MAX","DC_HEAT_DISS_AVG","DC_HEAT_DISS_MAX","MIN_OPERATING_TEMP","MAX_OPERATING_TEMP","MIN_NON_OPERATING_TEMP","MAX_NON_OPERATING_TEMP","MIN_OPERATING_HUMIDITY","MAX_OPERATING_HUMIDITY","MIN_NON_OPERATING_HUMIDITY","MAX_NON_OPERATING_HUMIDITY","AC_INPUT_LOW_VOLT_MIN","AC_INPUT_LOW_VOLT_MAX","AC_INPUT_LOW_CURRENT_MIN","AC_INPUT_LOW_CURRENT_MAX","AC_INPUT_HIGH_VOLT_MIN","AC_INPUT_HIGH_VOLT_MAX","AC_INPUT_HIGH_CURRENT_MIN","AC_INPUT_HIGH_CURRENT_MAX","AC_FREQ_MIN","AC_FREQ_MAX","DC_LOW_VOLT","DC_LOW_CURRENT","DC_HIGH_VOLT","DC_HIGH_CURRENT","AC_PHASE","DEDICATED_CIRCUIT","PLUG_TYPE","BATTERY_LIFE","BATTERY_TYPE","EMERGENCY_POWER","TO_BE_DELETED","TO_BE_DELETED_ON","DELETE_REASON","PRIVATE_FLAG","IS_PRIVATE","PRIVATE_TYPE","REPLACEMENT_ID" 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,GREATEST(NVL(tpc.LAST_MODIFIED_DATE,TO_DATE('31-DEC-1900','DD-MON-YYYY')),tcat.LAST_MODIFIED_DATE) 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(tpc.AC_INPUT_HIGH_CURRENT_MIN,tcat.AC_INPUT_HIGH_CURRENT_MIN) AC_INPUT_HIGH_CURRENT_MIN,COALESCE(tpc.AC_INPUT_HIGH_CURRENT_MAX,tcat.AC_INPUT_HIGH_CURRENT_MAX) AC_INPUT_HIGH_CURRENT_MAX,COALESCE(tpc.AC_FREQ_MIN,tcat.AC_FREQ_MIN) AC_FREQ_MIN,COALESCE(tpc.AC_FREQ_MAX,tcat.AC_FREQ_MAX) AC_FREQ_MAX,COALESCE(tpc.DC_LOW_VOLT,tcat.DC_LOW_VOLT) DC_LOW_VOLT,COALESCE(tpc.DC_LOW_CURRENT,tcat.DC_LOW_CURRENT) DC_LOW_CURRENT,COALESCE(tpc.DC_HIGH_VOLT,tcat.DC_HIGH_VOLT) DC_HIGH_VOLT,COALESCE(tpc.DC_HIGH_CURRENT,tcat.DC_HIGH_CURRENT) DC_HIGH_CURRENT,COALESCE(tpc.AC_PHASE,tcat.AC_PHASE) AC_PHASE,COALESCE(tpc.DEDICATED_CIRCUIT,tcat.DEDICATED_CIRCUIT) DEDICATED_CIRCUIT,COALESCE(tpc.PLUG_TYPE,tcat.PLUG_TYPE) PLUG_TYPE,COALESCE(tpc.BATTERY_LIFE,tcat.BATTERY_LIFE) BATTERY_LIFE,COALESCE(tpc.BATTERY_TYPE,tcat.BATTERY_TYPE) BATTERY_TYPE,COALESCE(tpc.EMERGENCY_POWER,tcat.EMERGENCY_POWER) EMERGENCY_POWER,COALESCE(tpc.TO_BE_DELETED,tcat.TO_BE_DELETED) TO_BE_DELETED,COALESCE(tpc.TO_BE_DELETED_ON,tcat.TO_BE_DELETED_ON) TO_BE_DELETED_ON,COALESCE(tpc.DELETE_REASON,tcat.DELETE_REASON) DELETE_REASON,COALESCE(uuid.PRIVATE_FLAG,tcat.PRIVATE_FLAG) PRIVATE_FLAG, COALESCE(uuid.IS_PRIVATE,tcat.IS_PRIVATE) IS_PRIVATE, COALESCE(uuid.PRIVATE_TYPE,tcat.PRIVATE_TYPE) PRIVATE_TYPE, COALESCE(tpc.REPLACEMENT_ID,tcat.REPLACEMENT_ID) REPLACEMENT_ID FROM TPC_HW_MODEL_POWER tpc LEFT JOIN TCAT_HW_MODEL_POWER tcat ON tcat.CAT_HW_MODEL_POWER_ID = tpc.CAT_HW_MODEL_POWER_ID inner JOIN TPC_UUID uuid ON tpc.CAT_HW_MODEL_POWER_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_HW_MODEL_POWER_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_HW_MODEL_POWER_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.CAT_HW_MODEL_ID,tpc.ENERGY_STAR,tpc.EPEAT,tpc.POWER_RATING,tpc.AC_POWER_AVG,tpc.AC_AVG_UNIT,tpc.AC_POWER_MAX,tpc.AC_MAX_UNIT,tpc.DC_POWER_AVG,tpc.DC_POWER_MAX,tpc.AC_HEAT_DISS_AVG,tpc.AC_HEAT_DISS_MAX,tpc.DC_HEAT_DISS_AVG,tpc.DC_HEAT_DISS_MAX,tpc.MIN_OPERATING_TEMP,tpc.MAX_OPERATING_TEMP,tpc.MIN_NON_OPERATING_TEMP,tpc.MAX_NON_OPERATING_TEMP,tpc.MIN_OPERATING_HUMIDITY,tpc.MAX_OPERATING_HUMIDITY,tpc.MIN_NON_OPERATING_HUMIDITY,tpc.MAX_NON_OPERATING_HUMIDITY,tpc.AC_INPUT_LOW_VOLT_MIN,tpc.AC_INPUT_LOW_VOLT_MAX,tpc.AC_INPUT_LOW_CURRENT_MIN,tpc.AC_INPUT_LOW_CURRENT_MAX,tpc.AC_INPUT_HIGH_VOLT_MIN,tpc.AC_INPUT_HIGH_VOLT_MAX,tpc.AC_INPUT_HIGH_CURRENT_MIN,tpc.AC_INPUT_HIGH_CURRENT_MAX,tpc.AC_FREQ_MIN,tpc.AC_FREQ_MAX,tpc.DC_LOW_VOLT,tpc.DC_LOW_CURRENT,tpc.DC_HIGH_VOLT,tpc.DC_HIGH_CURRENT,tpc.AC_PHASE,tpc.DEDICATED_CIRCUIT,tpc.PLUG_TYPE,tpc.BATTERY_LIFE,tpc.BATTERY_TYPE,tpc.EMERGENCY_POWER,tpc.TO_BE_DELETED,tpc.TO_BE_DELETED_ON,tpc.DELETE_REASON,tpc.PRIVATE_FLAG,tpc.IS_PRIVATE,tpc.PRIVATE_TYPE,tpc.REPLACEMENT_ID FROM TPC_HW_MODEL_POWER tpc WHERE SIGN(tpc.CAT_HW_MODEL_POWER_ID )= -1