BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_HW_MODEL_POWER - Hardware model power related information table

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CAT_HW_MODEL_POWER_ID numeric 20  √  null CAT_HW_MODEL_POWER table's unique identifier
CREATE_DATE datetime 16,3  √  null The date when row was first created
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_HW_MODEL_ID numeric 20  √  null CAT_HW_MODEL table's unique identifier
ENERGY_STAR varchar 3  √  null A flag to indicate whether the device has earned the Energy Star certification or not
EPEAT varchar 20  √  null A flag to indicate which EPEAT certification the device has earned: Gold, Silver, or Bronze
POWER_RATING varchar 256  √  null Summary of the device's various power ratings: Voltage, Frequency, Current
AC_POWER_AVG numeric 20,2  √  null The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up to AC power (in watt or volt-amp)
AC_AVG_UNIT varchar 8  √  null The unit for AC_POWER_AVG column (watt or volt-amp)
AC_POWER_MAX numeric 20,2  √  null The peak/maximum amount of power (energy per-unit of time) consumed by the device when it is hooked up to AC power (in watt or volt-amp)
AC_MAX_UNIT varchar 8  √  null The unit for AC_POWER_MAX column (watt or volt-amp)
DC_POWER_AVG numeric 20,2  √  null The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up to DC power (in watt or volt-amp)
DC_POWER_MAX numeric 20,2  √  null The peak/maximum amount of power (energy per-unit of time) consumed by the device when it is hooked up to DC power (in watt or volt-amp)
AC_HEAT_DISS_AVG numeric 20,2  √  null The average amount of heat per-unit of time generated by the device during typical use when it is hooked up to AC power (in BTU/hr)
AC_HEAT_DISS_MAX numeric 20,2  √  null The peak/maximum amount of heat per-unit of time generated by the device when it is hooked up to AC power (in BTU/hr)
DC_HEAT_DISS_AVG numeric 20,2  √  null The average amount of heat per-unit of time generated by the device during typical use when it is hooked up to DC power (in BTU/hr)
DC_HEAT_DISS_MAX numeric 20,2  √  null The peak/maximum amount of heat per-unit of time generated by the device when it is hooked up to DC power (in BTU/hr)
MIN_OPERATING_TEMP numeric 20,2  √  null Manufacturer's suggested minimum temperature of the device during operation (in F)
MAX_OPERATING_TEMP numeric 20,2  √  null Manufacturer's suggested peak/maximum temperature of the device during operation (in F)
MIN_NON_OPERATING_TEMP numeric 20,2  √  null Manufacturer's suggested minimum temperature of the device when it is non-operational or in storage (in F)
MAX_NON_OPERATING_TEMP numeric 20,2  √  null Manufacturer's suggested peak/maximum temperature of the device when it is non-operational or in storage (in F)
MIN_OPERATING_HUMIDITY numeric 20,2  √  null Manufacturer's suggested minimum humidity of the device during operation (in %)
MAX_OPERATING_HUMIDITY numeric 20,2  √  null Manufacturer's suggested peak/maximum humidity of the device during operation (in %)
MIN_NON_OPERATING_HUMIDITY numeric 20,2  √  null Manufacturer's suggested minimum humidity of the device when it is non-operational or in storage (in %)
MAX_NON_OPERATING_HUMIDITY numeric 20,2  √  null Manufacturer's suggested peak/maximum humidity of the device when it is non-operational or in storage (%)
AC_INPUT_LOW_VOLT_MIN numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: minimum voltage when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_LOW_VOLT_MAX numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: maximum voltage when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_LOW_CURRENT_MIN numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: minimum current when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_LOW_CURRENT_MAX numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: maximum current when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
AC_INPUT_HIGH_VOLT_MIN numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: minimum voltage when the voltage switch is turned on the high range setting
AC_INPUT_HIGH_VOLT_MAX numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: maximum voltage when the voltage switch is turned on the high range setting
AC_INPUT_HIGH_CURRENT_MIN numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: minimum current when the voltage switch is turned on the high range setting
AC_INPUT_HIGH_CURRENT_MAX numeric 20,2  √  null Manufacturer's suggested AC electrical input requirements: maximum current when the voltage switch is turned on the high range setting
AC_FREQ_MIN numeric 20,2  √  null Manufacturer's suggested AC input requirements: minimum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)
AC_FREQ_MAX numeric 20,2  √  null Manufacturer's suggested AC input requirements: maximum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)
DC_LOW_VOLT numeric 20,2  √  null Manufacturer's suggested DC input requirements: voltage when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage)
DC_LOW_CURRENT numeric 20,2  √  null Manufacturer's suggested DC input requirements: current when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage)
DC_HIGH_VOLT numeric 20,2  √  null Manufacturer's suggested DC input requirements: voltage when the voltage switch is turned on the high setting
DC_HIGH_CURRENT numeric 20,2  √  null Manufacturer's suggested DC input requirements: current when the voltage switch is turned on the high setting
AC_PHASE varchar 1  √  null AC Phase
DEDICATED_CIRCUIT varchar 5  √  null Dedicated Circuit
PLUG_TYPE varchar 50  √  null Plug Type (NEMA)
BATTERY_LIFE numeric 40  √  null Battery Life (hours)
BATTERY_TYPE varchar 500  √  null Battery Type
EMERGENCY_POWER varchar 5  √  null Emergency Power
TO_BE_DELETED varchar 1  √  null Would this record be deleted? eg: Y
TO_BE_DELETED_ON datetime 16,3  √  null The date when this record would be deleted
DELETE_REASON varchar 500  √  null The reason why the entry is marked to be deleted (Values: Duplicate,Inaccurate)
PRIVATE_FLAG numeric 3  √  null 0 = Not Modified (i.e. original Technopedia entry),1 = Modified Technopedia object, 2 = Proprietary object (those that have negative ids)
IS_PRIVATE varchar 1  √  null y = a private entry, n = original Technopedia entry
PRIVATE_TYPE varchar 500  √  null PRIVATE_TYPE = NULL if PRIVATE_FLAG = 0,PRIVATE_TYPE = Modified Technopedia entry if PRIVATE_FLAG = 1,PRIVATE_TYPE = Proprietary entry if PRIVATE_FLAG = 2
REPLACEMENT_ID numeric 20  √  null Unique identifier of the replacement entry whenever the entry is marked to be deleted for 'Duplicate' reason

Analyzed at Thu Jul 20 12:14 PDT 2017

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:

Confidential and Proprietary to BDNA