BDNA Data Platform 5.4 July 2017 (Oracle)
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 number 0  √  null Software release's unique identifier
CAT_SW_RELEASE_ID number 0  √  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 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
GENERAL_AVAILABILITY_STR varchar2 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 date 7  √  null The date when the product is generally available through official vendor distributions, standardized to follow BDNA's date format
GA_EXCEPTION varchar2 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 date 7  √  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 date 7  √  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 varchar2 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 date 7  √  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 varchar2 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 date 7  √  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 date 7  √  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 varchar2 2000  √  null The name of support level that marks the End of Life, captured the way it was published by the vendor
OBSOLETE_STR varchar2 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 date 7  √  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 varchar2 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 date 7  √  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 date 7  √  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 varchar2 2000  √  null The name of support level that marks the Obsolete, captured the way it was published by the vendor
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 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 "CAT_SW_REL_LIFECYCLE_ID","CAT_SW_RELEASE_ID","CREATE_DATE","LAST_MODIFIED_DATE","GENERAL_AVAILABILITY_STR","GENERAL_AVAILABILITY","GA_EXCEPTION","GA_RANGE_START","GA_RANGE_END","END_OF_LIFE_STR","END_OF_LIFE","END_OF_LIFE_EXCEPTION","END_OF_LIFE_RANGE_START","END_OF_LIFE_RANGE_END","END_OF_LIFE_SUPPORT_LEVEL","OBSOLETE_STR","OBSOLETE","OBSOLETE_EXCEPTION","OBSOLETE_RANGE_START","OBSOLETE_RANGE_END","OBSOLETE_SUPPORT_LEVEL","TO_BE_DELETED","TO_BE_DELETED_ON","DELETE_REASON","PRIVATE_FLAG","IS_PRIVATE","PRIVATE_TYPE","REPLACEMENT_ID" 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,GREATEST(NVL(tpc.LAST_MODIFIED_DATE,TO_DATE('31-DEC-1900','DD-MON-YYYY')),tcat.LAST_MODIFIED_DATE) 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.REPLACEMENT_ID FROM TPC_SW_REL_LIFECYCLE tpc WHERE SIGN(tpc.CAT_SW_REL_LIFECYCLE_ID )= -1
 
Confidential and Proprietary to BDNA