BDNA Data Platform 5.4 July 2017 (Oracle)
CAT_HW_MODEL - Hardware model 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_ID number 0  √  null CAT_HW_MODEL table's unique identifier
CREATE_DATE date 7  √  null The date when row was first created
LAST_MODIFIED_DATE date 7  √  null The date when last modification on the row was made
CAT_MANUFACTURER_ID number 0  √  null Manufacturer's unique identifier
CAT_HW_PRODUCT_ID number 0  √  null Hardware product's unique identifier
HAS_FP number 0  √  null A flag to indicate whether the device has a fingerprint(BDNA Internal column)
MODEL varchar2 2000  √  null The device's model name/number
SUPPORTED_OS varchar2 2000  √  null The list of supported operating systems that can be run on the device
DATE_INTRODUCED varchar2 30  √  null The date the hardware was introduced/announced, captured the way it was published by the vendor
DATE_AVAILABLE varchar2 2000  √  null The date the hardware was available for sale, captured the way it was published by the vendor
END_OF_LIFE_DATE varchar2 2000  √  null The date where a device is announced to "discontinued" or "legacy" by the manufacturer
END_OF_SALES_DATE varchar2 2000  √  null The last date to order the product through manufacturer point-of-sale mechanisms.
LAST_SHIP_DATE varchar2 2000  √  null The last-possible ship date that can be requested of the manufacturer and/or its contract manufacturers
LAST_SUPPORT_DATE varchar2 2000  √  null The last date the support will be provided by the manufacturer (even after the device has been discontinued). After this date, all support services for the product are unavailable, and the product becomes obsolete.
CPUMAX number 0  √  null Maximum number of CPU sockets available in the machine
CPUURL varchar2 2000  √  null URL as a reference to the information on CPUMAX column
CAT_TAXONOMY2012_ID number 18  √  null BDNA Taxonomy's unique identifier
DESUPFLAG varchar2 10  √  null A flag that indicates the entry has been de-supported by the vendor. De-support date is in the past (whether the exact date is known or unknown)
TO_BE_DELETED varchar2 1  √  null Would this record be deleted? eg: Y
TO_BE_DELETED_ON date 7  √  null The date when this record would be deleted
DELETE_REASON varchar2 500  √  null The reason why the entry is marked to be deleted (Values: Duplicate,Inaccurate)
PRIVATE_FLAG number 0  √  null 0 = Not Modified (i.e. original Technopedia entry),1 = Modified Technopedia object, 2 = Proprietary object (those that have negative ids)
IS_PRIVATE varchar2 1  √  null y = a private entry, n = original Technopedia entry
PRIVATE_TYPE varchar2 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 number 0  √  null Unique identifier of the replacement entry whenever the entry is marked to be deleted for 'Duplicate' reason

Analyzed at Thu Jul 20 12:13 PDT 2017

View Definition:
SELECT vw.CAT_HW_MODEL_ID, vw.CREATE_DATE, vw.LAST_MODIFIED_DATE, vw.CAT_MANUFACTURER_ID, vw.CAT_HW_PRODUCT_ID, vw.HAS_FP, vw.MODEL, vw.SUPPORTED_OS, vw.DATE_INTRODUCED, vw.DATE_AVAILABLE, vw.END_OF_LIFE_DATE, vw.END_OF_SALES_DATE, vw.LAST_SHIP_DATE, vw.LAST_SUPPORT_DATE, vw.CPUMAX, vw.CPUURL, prod_tax.CAT_TAXONOMY2012_ID, vw.DESUPFLAG, vw.TO_BE_DELETED, vw.TO_BE_DELETED_ON, vw.DELETE_REASON, vw.PRIVATE_FLAG, vw.IS_PRIVATE, vw.PRIVATE_TYPE, vw.REPLACEMENT_ID FROM ( SELECT f_tcat.CAT_HW_MODEL_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.CAT_MANUFACTURER_ID,f_tcat.CAT_HW_PRODUCT_ID,f_tcat.HAS_FP,f_tcat.MODEL,f_tcat.SUPPORTED_OS,f_tcat.DATE_INTRODUCED,f_tcat.DATE_AVAILABLE,f_tcat.END_OF_LIFE_DATE,f_tcat.END_OF_SALES_DATE,f_tcat.LAST_SHIP_DATE,f_tcat.LAST_SUPPORT_DATE,f_tcat.CPUMAX,f_tcat.CPUURL,f_tcat.CAT_TAXONOMY2012_ID,f_tcat.DESUPFLAG,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 f_tcat where not exists (select 1 from TPC_HW_MODEL tpc_tab where tpc_tab.CAT_HW_MODEL_ID=f_tcat.CAT_HW_MODEL_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_HW_MODEL_ID,tcat.CAT_HW_MODEL_ID) CAT_HW_MODEL_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_MANUFACTURER_ID,tcat.CAT_MANUFACTURER_ID) CAT_MANUFACTURER_ID,COALESCE(tpc.CAT_HW_PRODUCT_ID,tcat.CAT_HW_PRODUCT_ID) CAT_HW_PRODUCT_ID,COALESCE(tpc.HAS_FP,tcat.HAS_FP) HAS_FP,COALESCE(cast(tpc.MODEL as varchar2(255)),cast(tcat.MODEL as varchar2(255))) MODEL,COALESCE(tpc.SUPPORTED_OS,tcat.SUPPORTED_OS) SUPPORTED_OS,COALESCE(tpc.DATE_INTRODUCED,tcat.DATE_INTRODUCED) DATE_INTRODUCED,COALESCE(cast(tpc.DATE_AVAILABLE as varchar2(30)),cast(tcat.DATE_AVAILABLE as varchar2(30))) DATE_AVAILABLE,COALESCE(cast(tpc.END_OF_LIFE_DATE as varchar2(30)),cast(tcat.END_OF_LIFE_DATE as varchar2(30))) END_OF_LIFE_DATE,COALESCE(cast(tpc.END_OF_SALES_DATE as varchar2(30)),cast(tcat.END_OF_SALES_DATE as varchar2(30))) END_OF_SALES_DATE,COALESCE(cast(tpc.LAST_SHIP_DATE as varchar2(30)),cast(tcat.LAST_SHIP_DATE as varchar2(30))) LAST_SHIP_DATE,COALESCE(cast(tpc.LAST_SUPPORT_DATE as varchar2(30)),cast(tcat.LAST_SUPPORT_DATE as varchar2(30))) LAST_SUPPORT_DATE,COALESCE(tpc.CPUMAX,tcat.CPUMAX) CPUMAX,COALESCE(tpc.CPUURL,tcat.CPUURL) CPUURL,COALESCE(tpc.CAT_TAXONOMY2012_ID,tcat.CAT_TAXONOMY2012_ID) CAT_TAXONOMY2012_ID,COALESCE(tpc.DESUPFLAG,tcat.DESUPFLAG) DESUPFLAG,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 tpc LEFT JOIN TCAT_HW_MODEL tcat ON tcat.CAT_HW_MODEL_ID = tpc.CAT_HW_MODEL_ID inner JOIN TPC_UUID uuid ON tpc.CAT_HW_MODEL_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_HW_MODEL_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_HW_MODEL_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.CAT_MANUFACTURER_ID,tpc.CAT_HW_PRODUCT_ID,tpc.HAS_FP,cast(tpc.MODEL as varchar2(255)) MODEL,tpc.SUPPORTED_OS,tpc.DATE_INTRODUCED,cast(tpc.DATE_AVAILABLE as varchar2(30)) DATE_AVAILABLE,cast(tpc.END_OF_LIFE_DATE as varchar2(30)) END_OF_LIFE_DATE,cast(tpc.END_OF_SALES_DATE as varchar2(30)) END_OF_SALES_DATE,cast(tpc.LAST_SHIP_DATE as varchar2(30)) LAST_SHIP_DATE,cast(tpc.LAST_SUPPORT_DATE as varchar2(30)) LAST_SUPPORT_DATE,tpc.CPUMAX,tpc.CPUURL,tpc.CAT_TAXONOMY2012_ID,tpc.DESUPFLAG,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 tpc WHERE SIGN(tpc.CAT_HW_MODEL_ID )= -1 ) vw INNER JOIN (SELECT rn,CAT_TAG_ID,CAT_HW_PRODUCT_ID,CAT_TAXONOMY2012_ID FROM (SELECT ROW_NUMBER() OVER (PARTITION BY hwtax.CAT_HW_PRODUCT_ID ORDER BY CASE WHEN hwtax.TO_BE_DELETED = 1 then -2 WHEN TAG.CAT_TAG_SHORTNAME='IT' then -1 WHEN TAG.CAT_TAG_SHORTNAME='MD' then 0 WHEN TAG.CAT_TAG_SHORTNAME='FX' then 1 WHEN TAG.CAT_TAG_SHORTNAME='IT' then -1 ELSE hwtax.TAXONOMY_VERSION END DESC NULLS LAST,hwtax.TAXONOMY_DEFAULT DESC NULLS LAST) rn ,hwtax.CAT_TAG_ID,hwtax.CAT_HW_PRODUCT_ID,hwtax.CAT_TAXONOMY2012_ID FROM CAT_HW_TAXONOMY2012 hwtax INNER JOIN BDNA_TECHNOPEDIA_TAG tag ON hwtax.CAT_TAG_ID = TAG.CAT_TAG_ID WHERE tag.IS_SUBSCRIBED='Y' ) r WHERE r.rn=1 ) PROD_TAX ON VW.CAT_HW_PRODUCT_ID = PROD_TAX.CAT_HW_PRODUCT_ID
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA