BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_SW_REL_LIFECYCLE_CALC - Software release lifecylce(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_SW_REL_LIFECYCLE_ID numeric 20  √  null Software release's unique identifier
CAT_SW_RELEASE_ID numeric 20  √  null Software release's unique identifier(This column is being deprecated and will be decomissioned in Aug 15th, 2014. Please use CAT_SW_REL_LIFECYCLE_ID instead)
GA datetime 16,3  √  null
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'
EOL datetime 16,3  √  null
END_OF_LIFE_EXCEPTION varchar 255  √  null A reason as to why the End of Life 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.'
END_OF_LIFE_RANGE_START datetime 16,3  √  null The start date of estimated range of period where the actual End of Life date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
END_OF_LIFE_RANGE_END datetime 16,3  √  null The end date of estimated range of period where the actual End of Life date could possibly lie. This is required when the Exception value is 'Exact date unknown, a date range is provided'
END_OF_LIFE_SUPPORT_LEVEL varchar 2000  √  null The name of support level that marks the End of Life, captured the way it was published by the vendor
OBSOLETE datetime 16,3  √  null The last date when any support is provided by the vendor, standardized to follow BDNA's date format. The only support available after this date (if applicable) is self-help online support
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'
OBSOLETE_SUPPORT_LEVEL varchar 2000  √  null The name of support level that marks the Obsolete, captured the way it was published by the vendor
CALC_EOL datetime 16,3  √  null Calculated EOL date when EOL is not available
DISCONDESUPP varchar 10  √  null If product/release discontinued or de-supported?
VERSION_ORDER numeric 24  √  null Order of the version
MAX_VERSION_ORDER numeric 24  √  null Maximum Version order of the release
CALC_DIFF_ORDER numeric 25  √  null Difference between maximum version order and Version order
REASON_IS_SUPPORTED varchar 53  √  null Reason if not Supported
IS_SUPPORTED varchar 3  √  null 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_SW_REL_LIFECYCLE_CALC AS SELECT CAT_SW_REL_LIFECYCLE.CAT_SW_REL_LIFECYCLE_ID,CAT_SW_REL_LIFECYCLE.CAT_SW_RELEASE_ID, GENERAL_AVAILABILITY as GA,GA_EXCEPTION,GA_RANGE_START,GA_RANGE_END, COALESCE(END_OF_LIFE,OBSOLETE) as EOL,END_OF_LIFE_EXCEPTION,END_OF_LIFE_RANGE_START,END_OF_LIFE_RANGE_END,END_OF_LIFE_SUPPORT_LEVEL, OBSOLETE,OBSOLETE_EXCEPTION,OBSOLETE_RANGE_START,OBSOLETE_RANGE_END,OBSOLETE_SUPPORT_LEVEL, COALESCE(END_OF_LIFE,OBSOLETE) as CALC_EOL, COALESCE(CAT_SW_RELEASE.DISCONTINUEDFLAG,CAT_SW_RELEASE.DESUPFLAG) as DISCONDESUPP, CAT_SW_VERSION.VERSION_ORDER, ORDER1.MAX_VERSION_ORDER, ORDER1.MAX_VERSION_ORDER-CAT_SW_VERSION.VERSION_ORDER as CALC_DIFF_ORDER, CASE WHEN COALESCE(CAT_SW_RELEASE.DISCONTINUEDFLAG,CAT_SW_RELEASE.DESUPFLAG)='yes' THEN 'Technopedia flagged this as discontinued/de-supported' WHEN DATEDIFF(day,GETDATE(),COALESCE(END_OF_LIFE,OBSOLETE)) > 0 THEN 'Technopedia EOL date not met yet' ELSE 'Technopedia EOL Date' END as REASON_IS_SUPPORTED, CASE WHEN COALESCE(CAT_SW_RELEASE.DISCONTINUEDFLAG,CAT_SW_RELEASE.DESUPFLAG)='yes' THEN 'no' WHEN DATEDIFF(day,GETDATE(),COALESCE(END_OF_LIFE,OBSOLETE)) > 0 THEN 'yes' ELSE 'no' END as IS_SUPPORTED, CAT_SW_REL_LIFECYCLE.CREATE_DATE, CAT_SW_REL_LIFECYCLE.LAST_MODIFIED_DATE FROM CAT_SW_REL_LIFECYCLE INNER JOIN CAT_SW_RELEASE ON CAT_SW_RELEASE.CAT_SW_RELEASE_ID=CAT_SW_REL_LIFECYCLE.CAT_SW_RELEASE_ID INNER JOIN CAT_SW_VERSION ON CAT_SW_VERSION.CAT_SW_VERSION_ID=CAT_SW_RELEASE.CAT_SW_VERSION_ID INNER JOIN ( SELECT CAT_SW_PRODUCT_ID, MAX(VERSION_ORDER) as MAX_VERSION_ORDER FROM CAT_SW_VERSION GROUP BY CAT_SW_PRODUCT_ID )ORDER1 ON ORDER1.CAT_SW_PRODUCT_ID=CAT_SW_VERSION.CAT_SW_PRODUCT_ID WHERE (CAT_SW_REL_LIFECYCLE.END_OF_LIFE IS NOT NULL OR CAT_SW_REL_LIFECYCLE.OBSOLETE IS NOT NULL) UNION ALL SELECT CAT_SW_REL_LIFECYCLE.CAT_SW_REL_LIFECYCLE_ID,CAT_SW_REL_LIFECYCLE.CAT_SW_RELEASE_ID,GENERAL_AVAILABILITY AS GA,GA_EXCEPTION,GA_RANGE_START,GA_RANGE_END,COALESCE(END_OF_LIFE,OBSOLETE) AS EOL, END_OF_LIFE_EXCEPTION,END_OF_LIFE_RANGE_START,END_OF_LIFE_RANGE_END,END_OF_LIFE_SUPPORT_LEVEL,OBSOLETE,OBSOLETE_EXCEPTION,OBSOLETE_RANGE_START, OBSOLETE_RANGE_END,OBSOLETE_SUPPORT_LEVEL, CASE WHEN 47 = 9999 THEN NULL WHEN 47 != 9999 THEN DATEADD(month,47,GENERAL_AVAILABILITY) END as CALC_EOL, COALESCE(CAT_SW_RELEASE.DISCONTINUEDFLAG,CAT_SW_RELEASE.DESUPFLAG) as DISCONDESUPP, CAT_SW_VERSION.VERSION_ORDER, ORDER1.MAX_VERSION_ORDER, ORDER1.MAX_VERSION_ORDER-CAT_SW_VERSION.VERSION_ORDER as CALC_DIFF_ORDER, CASE WHEN COALESCE(CAT_SW_RELEASE.DISCONTINUEDFLAG,CAT_SW_RELEASE.DESUPFLAG)='yes' THEN 'Technopedia flagged this as discontinued/de-supported' WHEN ( 47 != 9999 AND DATEDIFF(day,GETDATE(),DATEADD(month,47,GENERAL_AVAILABILITY)) > 0
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA