BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_SW_REL_LIFECYCLE - Software release lifecylce 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_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)
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
GENERAL_AVAILABILITY_STR varchar 2000  √  null The date when the product is generally available through official vendor distributions, captured the way it was published by the vendor
GENERAL_AVAILABILITY datetime 16,3  √  null The date when the product is generally available through official vendor distributions, standardized to follow BDNA's date format
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'
END_OF_LIFE_STR varchar 2000  √  null The last date when full support for product is provided by the vendor, captured the way it was published by the vendor. Partial support is still available
END_OF_LIFE datetime 16,3  √  null The last date when full support for product is provided by the vendor, standardized to follow BDNA's date format. Partial support is still available
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_STR varchar 2000  √  null The last date when any support is provided by the vendor, captured the way it was published by the vendor. The only support available after this date (if applicable) is self-help online support
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
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_SW_REL_LIFECYCLE AS SELECT f_tcat.CAT_SW_REL_LIFECYCLE_ID,f_tcat.CAT_SW_RELEASE_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.GENERAL_AVAILABILITY_STR,f_tcat.GENERAL_AVAILABILITY,f_tcat.GA_EXCEPTION,f_tcat.GA_RANGE_START,f_tcat.GA_RANGE_END,f_tcat.END_OF_LIFE_STR,f_tcat.END_OF_LIFE,f_tcat.END_OF_LIFE_EXCEPTION,f_tcat.END_OF_LIFE_RANGE_START,f_tcat.END_OF_LIFE_RANGE_END,f_tcat.END_OF_LIFE_SUPPORT_LEVEL,f_tcat.OBSOLETE_STR,f_tcat.OBSOLETE,f_tcat.OBSOLETE_EXCEPTION,f_tcat.OBSOLETE_RANGE_START,f_tcat.OBSOLETE_RANGE_END,f_tcat.OBSOLETE_SUPPORT_LEVEL,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_SW_REL_LIFECYCLE f_tcat where not exists (select 1 from TPC_SW_REL_LIFECYCLE tpc_tab where tpc_tab.CAT_SW_REL_LIFECYCLE_ID=f_tcat.CAT_SW_REL_LIFECYCLE_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_SW_REL_LIFECYCLE_ID,tcat.CAT_SW_REL_LIFECYCLE_ID) CAT_SW_REL_LIFECYCLE_ID,COALESCE(tpc.CAT_SW_RELEASE_ID,tcat.CAT_SW_RELEASE_ID) CAT_SW_RELEASE_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.GENERAL_AVAILABILITY_STR,tcat.GENERAL_AVAILABILITY_STR) GENERAL_AVAILABILITY_STR,COALESCE(tpc.GENERAL_AVAILABILITY,tcat.GENERAL_AVAILABILITY) GENERAL_AVAILABILITY,COALESCE(tpc.GA_EXCEPTION,tcat.GA_EXCEPTION) GA_EXCEPTION,COALESCE(tpc.GA_RANGE_START,tcat.GA_RANGE_START) GA_RANGE_START,COALESCE(tpc.GA_RANGE_END,tcat.GA_RANGE_END) GA_RANGE_END,COALESCE(tpc.END_OF_LIFE_STR,tcat.END_OF_LIFE_STR) END_OF_LIFE_STR,COALESCE(tpc.END_OF_LIFE,tcat.END_OF_LIFE) END_OF_LIFE,COALESCE(tpc.END_OF_LIFE_EXCEPTION,tcat.END_OF_LIFE_EXCEPTION) END_OF_LIFE_EXCEPTION,COALESCE(tpc.END_OF_LIFE_RANGE_START,tcat.END_OF_LIFE_RANGE_START) END_OF_LIFE_RANGE_START,COALESCE(tpc.END_OF_LIFE_RANGE_END,tcat.END_OF_LIFE_RANGE_END) END_OF_LIFE_RANGE_END,COALESCE(tpc.END_OF_LIFE_SUPPORT_LEVEL,tcat.END_OF_LIFE_SUPPORT_LEVEL) END_OF_LIFE_SUPPORT_LEVEL,COALESCE(tpc.OBSOLETE_STR,tcat.OBSOLETE_STR) OBSOLETE_STR,COALESCE(tpc.OBSOLETE,tcat.OBSOLETE) OBSOLETE,COALESCE(tpc.OBSOLETE_EXCEPTION,tcat.OBSOLETE_EXCEPTION) OBSOLETE_EXCEPTION,COALESCE(tpc.OBSOLETE_RANGE_START,tcat.OBSOLETE_RANGE_START) OBSOLETE_RANGE_START,COALESCE(tpc.OBSOLETE_RANGE_END,tcat.OBSOLETE_RANGE_END) OBSOLETE_RANGE_END,COALESCE(tpc.OBSOLETE_SUPPORT_LEVEL,tcat.OBSOLETE_SUPPORT_LEVEL) OBSOLETE_SUPPORT_LEVEL,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_SW_REL_LIFECYCLE tpc LEFT JOIN TCAT_SW_REL_LIFECYCLE tcat ON tcat.CAT_SW_REL_LIFECYCLE_ID = tpc.CAT_SW_REL_LIFECYCLE_ID INNER JOIN TPC_UUID uuid ON tpc.CAT_SW_REL_LIFECYCLE_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_SW_REL_LIFECYCLE_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_SW_REL_LIFECYCLE_ID,tpc.CAT_SW_RELEASE_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.GENERAL_AVAILABILITY_STR,tpc.GENERAL_AVAILABILITY,tpc.GA_EXCEPTION,tpc.GA_RANGE_START,tpc.GA_RANGE_END,tpc.END_OF_LIFE_STR,tpc.END_OF_LIFE,tpc.END_OF_LIFE_EXCEPTION,tpc.END_OF_LIFE_RANGE_START,tpc.END_OF_LIFE_RANGE_END,tpc.END_OF_LIFE_SUPPORT_LEVEL,tpc.OBSOLETE_STR,tpc.OBSOLETE,tpc.OBSOLETE_EXCEPTION,tpc.OBSOLETE_RANGE_START,tpc.OBSOLETE_RANGE_END,tpc.OBSOLETE_SUPPORT_LEVEL,tpc.TO_BE_DELETED,tpc.TO_BE_DELETED_ON,tpc.DELETE_REASON,tpc.PRIVATE_FLAG,tpc.IS_PRIVATE,tpc.PRIVATE_TYPE,tpc.REPLACE
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA