BDNA Data Platform 5.4 July 2017 (SQL Server) CAT_HW_LIFECYCLE_CALC - Hardware Lifecycle (Calculated)
|
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: