BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_HW_LIFECYCLE_CALC - Hardware Lifecycle (Calculated)

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_LIFECYCLE_ID numeric 20  √  null Hardware model's unique identifier
CAT_HW_MODEL_ID numeric 20  √  null Hardware model's unique identifier(This column is being deprecated and will be decomissioned in Aug 15th, 2014. Please use CAT_HW_LIFECYCLE_ID instead)
INTRODUCTION datetime 16,3  √  null The date the hardware was introduced/announced, standardized to follow BDNA's date format
INRODUCTION_EXCEPTION varchar 255  √  null A reason as to why the Introduction date is not available, or a caveat on the date value that is currently being provided. The values: 'Date not published by vendor,' 'Support policy not defined by vendor,' 'Exact date unknown (a date range is provided),' 'Contract-based support only (no specific date),' 'Open-source support only (no specific date),' 'Limited, self-help support only (no specific date), 'Date in the past (exact date unknown),' 'To be determined,' 'Other.'
INTRODUCTION_RANGE_START datetime 16,3  √  null The start date of estimated range of period where the actual Introduction date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
INTRODUCTION_RANGE_END datetime 16,3  √  null The end date of estimated range of period where the actual Introduction date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
GA datetime 16,3  √  null General Availability date of the product
GA_EXCEPTION varchar 255  √  null A reason as to why the GA date is not available, or a caveat on the date value that is currently being provided. The values: 'Date not published by vendor,' 'Support policy not defined by vendor,' 'Exact date unknown (a date range is provided),' 'Contract-based support only (no specific date),' 'Open-source support only (no specific date),' 'Limited, self-help support only (no specific date), 'Date in the past (exact date unknown),' 'To be determined,' 'Other.'
GA_RANGE_START datetime 16,3  √  null The start date of estimated range of period where the actual GA date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
GA_RANGE_END datetime 16,3  √  null The end date of estimated range of period where the actual GA date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
LAST_AVAILABILITY datetime 16,3  √  null The last date the hardware is available for purchase from the vendor, standardized to follow BDNA's date format
LAST_AVAILABILITY_EXCEPTION varchar 255  √  null A reason as to why the Last Availability date is not available, or a caveat on the date value that is currently being provided. The values: 'Date not published by vendor,' 'Support policy not defined by vendor,' 'Exact date unknown (a date range is provided),' 'Contract-based support only (no specific date),' 'Open-source support only (no specific date),' 'Limited, self-help support only (no specific date), 'Date in the past (exact date unknown),' 'To be determined,' 'Other.'
LAST_AVAIL_RANGE_START datetime 16,3  √  null The start date of estimated range of period where the actual Last Availability date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
LAST_AVAIL_RANGE_END datetime 16,3  √  null The end date of estimated range of period where the actual Last Availability date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
OBSOLETE datetime 16,3  √  null The date when any form of support from the vendor ceases to exist, captured the way it was published by the vendor , standardized to follow BDNA's date format
OBSOLETE_EXCEPTION varchar 255  √  null A reason as to why the Obsolete date is not available, or a caveat on the date value that is currently being provided. The values: 'Date not published by vendor,' 'Support policy not defined by vendor,' 'Exact date unknown (a date range is provided),' 'Contract-based support only (no specific date),' 'Open-source support only (no specific date),' 'Limited, self-help support only (no specific date), 'Date in the past (exact date unknown),' 'To be determined,' 'Other.'
OBSOLETE_RANGE_START datetime 16,3  √  null The start date of estimated range of period where the actual Obsolete date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
OBSOLETE_RANGE_END datetime 16,3  √  null The end date of estimated range of period where the actual Obsolete date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
CALC_EOL datetime 16,3  √  null Calculated End of Life date when EOL is not available
CALC_EOL_EXCEPTION varchar 255  √  null Calculated End of Life date Exception
CALC_EOL_RANGE_START datetime 16,3  √  null Calculated start date of estimated range of period where the actual Obsolete date could possibly lie.
CALC_EOL_RANGE_END datetime 16,3  √  null Calculated end date of estimated range of period where the actual Obsolete date could possibly lie.
REASON_IS_SUPPORTED varchar 35  √  null Reason if not Supported
IS_SUPPORTED varchar 7 If Supported/Not suported
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

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW CAT_HW_LIFECYCLE_CALC AS SELECT CAT_HW_LIFECYCLE.CAT_HW_LIFECYCLE_ID, CAT_HW_LIFECYCLE.CAT_HW_MODEL_ID, CAT_HW_LIFECYCLE.INTRODUCTION, CAT_HW_LIFECYCLE.INRODUCTION_EXCEPTION, CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_START, CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_END, COALESCE(CAT_HW_LIFECYCLE.GENERAL_AVAILABILITY,CAT_HW_LIFECYCLE.INTRODUCTION) as GA, COALESCE(CAT_HW_LIFECYCLE.GA_EXCEPTION,CAT_HW_LIFECYCLE.INRODUCTION_EXCEPTION) AS GA_EXCEPTION, COALESCE(CAT_HW_LIFECYCLE.GA_RANGE_START, CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_START ) AS GA_RANGE_START , COALESCE(CAT_HW_LIFECYCLE.GA_RANGE_END,CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_END ) AS GA_RANGE_END, CAT_HW_LIFECYCLE.LAST_AVAILABILITY, CAT_HW_LIFECYCLE.LAST_AVAILABILITY_EXCEPTION, CAT_HW_LIFECYCLE.LAST_AVAIL_RANGE_START, CAT_HW_LIFECYCLE.LAST_AVAIL_RANGE_END, CAT_HW_LIFECYCLE.OBSOLETE , CAT_HW_LIFECYCLE.OBSOLETE_EXCEPTION , CAT_HW_LIFECYCLE.OBSOLETE_RANGE_START , CAT_HW_LIFECYCLE.OBSOLETE_RANGE_END, CAT_HW_LIFECYCLE.OBSOLETE as CALC_EOL, CAT_HW_LIFECYCLE.OBSOLETE_EXCEPTION AS CALC_EOL_EXCEPTION, CAT_HW_LIFECYCLE.OBSOLETE_RANGE_START AS CALC_EOL_RANGE_START , CAT_HW_LIFECYCLE.OBSOLETE_RANGE_END AS CALC_EOL_RANGE_END , CASE WHEN DATEDIFF(day,GETDATE(),CAT_HW_LIFECYCLE.OBSOLETE) > 0 THEN 'Technopedia EOL date not met yet' WHEN DATEDIFF(day,GETDATE(),CAT_HW_LIFECYCLE.OBSOLETE) < 0 THEN 'Technopedia EOL Date' END as REASON_IS_SUPPORTED, CASE WHEN DATEDIFF(day,GETDATE(),CAT_HW_LIFECYCLE.OBSOLETE) > 0 THEN 'yes' ELSE 'no' END as IS_SUPPORTED, CAT_HW_LIFECYCLE.CREATE_DATE, CAT_HW_LIFECYCLE.LAST_MODIFIED_DATE FROM CAT_HW_LIFECYCLE INNER JOIN CAT_HW_MODEL ON CAT_HW_MODEL.CAT_HW_MODEL_ID=CAT_HW_LIFECYCLE.CAT_HW_MODEL_ID INNER JOIN CAT_MANUFACTURER ON CAT_MANUFACTURER.CAT_MANUFACTURER_ID=CAT_HW_MODEL.CAT_MANUFACTURER_ID WHERE CAT_HW_LIFECYCLE.OBSOLETE IS NOT NULL UNION ALL SELECT CAT_HW_LIFECYCLE.CAT_HW_LIFECYCLE_ID, CAT_HW_LIFECYCLE.CAT_HW_MODEL_ID, CAT_HW_LIFECYCLE.INTRODUCTION, CAT_HW_LIFECYCLE.INRODUCTION_EXCEPTION, CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_START, CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_END, COALESCE(CAT_HW_LIFECYCLE.GENERAL_AVAILABILITY,CAT_HW_LIFECYCLE.INTRODUCTION) as GA, COALESCE(CAT_HW_LIFECYCLE.GA_EXCEPTION,CAT_HW_LIFECYCLE.INRODUCTION_EXCEPTION) AS GA_EXCEPTION, COALESCE(CAT_HW_LIFECYCLE.GA_RANGE_START, CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_START ) AS GA_RANGE_START , COALESCE(CAT_HW_LIFECYCLE.GA_RANGE_END,CAT_HW_LIFECYCLE.INTRODUCTION_RANGE_END ) AS GA_RANGE_END, CAT_HW_LIFECYCLE.LAST_AVAILABILITY, CAT_HW_LIFECYCLE.LAST_AVAILABILITY_EXCEPTION, CAT_HW_LIFECYCLE.LAST_AVAIL_RANGE_START, CAT_HW_LIFECYCLE.LAST_AVAIL_RANGE_END, CAT_HW_LIFECYCLE.OBSOLETE , CAT_HW_LIFECYCLE.OBSOLETE_EXCEPTION , CAT_HW_LIFECYCLE.OBSOLETE_RANGE_START , CAT_HW_LIFECYCLE.OBSOLETE_RANGE_START, CASE WHEN 99 =9999 THEN NULL WHEN 99!=9999
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA