BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_SW_RELEASE - Software release information 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_RELEASE_ID numeric 20  √  null CAT_SW_RELEASE table's unique identifier
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
CAT_MANUFACTURER_ID numeric 20  √  null Manufacturer's unique identifier
CAT_SW_PRODUCT_ID numeric 20  √  null Software product's unique identifier
RELEASE varchar 2000  √  null Software release's unique identifier
CAT_SW_EDITION_ID numeric 20  √  null Software edition's unique identifier
CAT_SW_VERSION_GROUP_ID numeric 20  √  null Software version group's unique identifier
CAT_SW_VERSION_ID numeric 20  √  null Software version's unique identifier
PATCHLEVEL varchar 2000  √  null The name of patch level for the software release
GA_DATE datetime 16,3  √  null The date when the product is generally available through official vendor distributions, captured the way it was published by the vendor
LICENSABLE varchar 50  √  null A flag to indicate whether the software release is licensable or not
IS_MAJOR varchar 3  √  null Is this row a Major Release?
CAT_SW_MAJOR_RELEASE_ID numeric 20  √  null If not Major release, Release Id of this rows Major Release
UNVERIFIED_VERSION varchar 3  √  null Flag to indicate whether a version can or cannot be verified from reliable sources/references. Yes = version cannot be verified, No or blank = version can be verified
DESUPFLAG varchar 10  √  null A flag that indicates the entry has been de-supported by the vendor. De-support date is in the past (whether the exact date is known or unknown)
DISCONTINUEDFLAG varchar 10  √  null A flag that indicates the entry has been discontinued by the vendor. Discontinued date is in the past (whether the exact date is known or unknown). The entry might or might not be supported 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_RELEASE AS SELECT f_tcat.CAT_SW_RELEASE_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.CAT_MANUFACTURER_ID,f_tcat.CAT_SW_PRODUCT_ID,f_tcat.RELEASE,f_tcat.CAT_SW_EDITION_ID,f_tcat.CAT_SW_VERSION_GROUP_ID,f_tcat.CAT_SW_VERSION_ID,f_tcat.PATCHLEVEL,f_tcat.GA_DATE,f_tcat.LICENSABLE,f_tcat.IS_MAJOR,f_tcat.CAT_SW_MAJOR_RELEASE_ID,f_tcat.UNVERIFIED_VERSION,f_tcat.DESUPFLAG,f_tcat.DISCONTINUEDFLAG,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_RELEASE f_tcat where not exists (select 1 from TPC_SW_RELEASE tpc_tab where tpc_tab.CAT_SW_RELEASE_ID=f_tcat.CAT_SW_RELEASE_ID ) union all SELECT * FROM ( SELECT 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.CAT_MANUFACTURER_ID,tcat.CAT_MANUFACTURER_ID) CAT_MANUFACTURER_ID,COALESCE(tpc.CAT_SW_PRODUCT_ID,tcat.CAT_SW_PRODUCT_ID) CAT_SW_PRODUCT_ID,COALESCE(cast(tpc.RELEASE as varchar(255)) ,cast(tcat.RELEASE as varchar(255)) ) RELEASE,COALESCE(tpc.CAT_SW_EDITION_ID,tcat.CAT_SW_EDITION_ID) CAT_SW_EDITION_ID,COALESCE(tpc.CAT_SW_VERSION_GROUP_ID,tcat.CAT_SW_VERSION_GROUP_ID) CAT_SW_VERSION_GROUP_ID,COALESCE(tpc.CAT_SW_VERSION_ID,tcat.CAT_SW_VERSION_ID) CAT_SW_VERSION_ID,COALESCE(tpc.PATCHLEVEL,tcat.PATCHLEVEL) PATCHLEVEL,COALESCE(tpc.GA_DATE,tcat.GA_DATE) GA_DATE,COALESCE(tpc.LICENSABLE,tcat.LICENSABLE) LICENSABLE,COALESCE(tpc.IS_MAJOR,tcat.IS_MAJOR) IS_MAJOR,COALESCE(tpc.CAT_SW_MAJOR_RELEASE_ID,tcat.CAT_SW_MAJOR_RELEASE_ID) CAT_SW_MAJOR_RELEASE_ID,COALESCE(tpc.UNVERIFIED_VERSION,tcat.UNVERIFIED_VERSION) UNVERIFIED_VERSION,COALESCE(tpc.DESUPFLAG,tcat.DESUPFLAG) DESUPFLAG,COALESCE(tpc.DISCONTINUEDFLAG,tcat.DISCONTINUEDFLAG) DISCONTINUEDFLAG,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_RELEASE tpc LEFT JOIN TCAT_SW_RELEASE tcat ON tcat.CAT_SW_RELEASE_ID = tpc.CAT_SW_RELEASE_ID INNER JOIN TPC_UUID uuid ON tpc.CAT_SW_RELEASE_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_SW_RELEASE_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_SW_RELEASE_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.CAT_MANUFACTURER_ID,tpc.CAT_SW_PRODUCT_ID,cast(tpc.RELEASE as varchar(255)) RELEASE,tpc.CAT_SW_EDITION_ID,tpc.CAT_SW_VERSION_GROUP_ID,tpc.CAT_SW_VERSION_ID,tpc.PATCHLEVEL,tpc.GA_DATE,tpc.LICENSABLE,tpc.IS_MAJOR,tpc.CAT_SW_MAJOR_RELEASE_ID,tpc.UNVERIFIED_VERSION,tpc.DESUPFLAG,tpc.DISCONTINUEDFLAG,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_RELEASE tpc WHERE SIGN(tpc.CAT_SW_RELEASE_ID )= -1
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA