BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_SW_LIC_RELEASE - The list of software product/release with all software license attributes attached to them

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_LIC_RELEASE_ID numeric 20  √  null CAT_SW_LIC_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 the Technopedia Version's entry was last modified
CAT_MANUFACTURER_ID numeric 20  √  null CAT_MANUFACTURER table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_MANUFACTURER_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_SW_PRODUCT_ID numeric 20  √  null CAT_SW_PRODUCT table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_SW_PRODUCT_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_SW_EDITION_ID numeric 20  √  null CAT_SW_EDITION table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_SW_EDITION_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_SW_VERSION_GROUP_ID numeric 20  √  null CAT_SW_VERSION_GROUP table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_SW_VERSION_GROUP_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_SW_VERSION_ID numeric 20  √  null CAT_SW_VERSION table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_SW_VERSION_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_SW_RELEASE_ID numeric 20  √  null CAT_SW_RELEASE table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_SW_RELEASE_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_PLATFORMS_ID numeric 20  √  null CAT_PLATFORMS table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_PLATFORMS_ID joining with column CAT_SW_LIC_PRODUCT_ID)
CAT_TAXONOMY2012_ID numeric 20  √  null CAT_TAXONOMY2012 table's unique identifier(This column will be depricated, please use CAT_SW_LIC_PRODUCT.CAT_TAXONOMY2012_ID joining with column CAT_SW_LIC_PRODUCT_ID)
VENDOR_PRODUCT_NAME varchar 4000  √  null The complete name of the product as presented by the vendor in the software license as well as other official documentations and/or website
VENDOR_UNIT_OF_MEASURE varchar 4000  √  null The unit of measure of the product as mentioned in the software license
LICENSE_TYPES varchar 4000  √  null The combined value of one or more values from LICENSE_TYPE column as specified in the software license
LICENSE_TYPES_ID numeric 20  √  null license types id
LICENSE_TYPES_OTHER varchar 500  √  null Other license type(s) that are not captured in LICENSE_TYPE column
LICENSE_METRICS varchar 4000  √  null The combined value of one or more values from LICENSE_METRIC1 + LICENSE_METRIC2 column as specified in the software license
LICENSE_METRICS_ID numeric 20  √  null license metrics id
UNIT_PACK varchar 500  √  null The unit of licenses included in the software license
UNIT_COUNT_MIN numeric 24  √  null The minimum count of licenses included in the software license
UNIT_COUNT_MAX numeric 24  √  null The maximum count of licenses included in the software license
LICENSE_TERM varchar 30  √  null The term of the software license
LICENSE_INFORMATION_OTHER varchar 2000  √  null Other terms/conditions or additional information mentioned in the software license
PERIOD_VALUE numeric 24  √  null The license period of the software as mentioned in the software license
PERIOD_UNIT varchar 30  √  null The unit of PERIOD_VALUE column
MAINT_PEROID_VALUE numeric 24  √  null Maintenance period as specified in the software license(this column is depricated please use MAINT_PERIOD_VALUE column)
MAINT_PERIOD_VALUE numeric 24  √  null Maintenance period as specified in the software license
MAINT_PEROID_UNIT varchar 30  √  null The unit of MAINT_PERIOD_VALUEE column(This column would be depricated please use MAINT_PERIOD_UNIT)
MAINT_PERIOD_UNIT varchar 30  √  null The unit of MAINT_PERIOD_VALUEE column
ENVIRONMENTS varchar 4000  √  null The combined value of one or more values from ENVIRONMENT column as specified in the software license
ENVIRONMENTS_ID numeric 20  √  null Environment Id
ENVIRONMENTS_OTHER varchar 500  √  null Other deployment environment(s) that are not captured in ENVIRONMENTS column
DOWNGRADE_VERSION_AUTH numeric 24  √  null The flag that indicates whether version downgrade is authorized in the software license
DOWNGRADE_VERSION_INCR varchar 100  √  null The incremental value of version downgrade if it's authorized in DOWNGRADE_VERSION_AUTH column
DOWNGRADE_EDITION_AUTH numeric 24  √  null The flag that indicates whether edition downgrade is authorized in the software license
DOWNGRADE_EDITION_INCR varchar 100  √  null The incremental value of edition downgrade if it's authorized in DOWNGRADE_VERSION_AUTH column
DOWNGRADE_DATE_MONTHS_MIN numeric 24  √  null Minimum length of period (in months) where version dwongrade is authorized
DOWNGRADE_DATE_MONTHS_MAX numeric 24  √  null Maximum length of period (in months) where version dwongrade is authorized
UPGRADE_VERSION_AUTH numeric 24  √  null The flag that indicates whether version upgrade is authorized in the software license
UPGRADE_VERSION_INCR varchar 100  √  null The incremental value of version upgrade if it's authorized in UPGRADE_VERSION_AUTH column
UPGRADE_EDITION_AUTH numeric 24  √  null The flag that indicates whether edition upgrade is authorized in the software license
UPGRADE_EDITION_INCR varchar 100  √  null The incremental value of edition upgrade if it's authorized in UPGRADE_VERSION_AUTH column
UPGRADE_DATE_MONTHS_MIN numeric 24  √  null Minimum length of period (in months) where version upgrade is authorized
UPGRADE_DATE_MONTHS_MAX numeric 24  √  null Maximum length of period (in months) where version upgrade is authorized
DUAL_LICENSE_AUTH numeric 24  √  null The flag that indicates whether dual usage is authorized (e.g. desktop and laptop usage for one license) as specified in the software license
VIRTUAL_INSTALL_AUTH numeric 24  √  null The flag that indicates whether virtualized deployment is authorized as specified in the software license
VIRTUAL_INSTALL_MAX numeric 24  √  null The maximum amount of virtualized deployment is authorized as specified in the software license
REASSIGNMENT_AUTH numeric 24  √  null The flag that indicates whether re-assignment of the license is authorized
CROSS_LANGUAGE_AUTH numeric 24  √  null The flag that indicates whether changing language(s) is allowed as specified in the software license
CROSS_PLATFORMS_AUTH numeric 24  √  null The flag that indicates whether changing platform(s) is allowed as specified in the software license
CORE_FACTOR varchar 500  √  null A specific value assigned by the manufacturer to specific multi-core processor(s) that determine the license value
LANGUAGES varchar 4000  √  null The combined value of one or more supported language(s) from LANGUAGE column as specified in the software license
LANGUAGES_ID numeric 20  √  null Languages Id
MAINTENANCE_GRADES varchar 4000  √  null The combined value of one or more values from MAINTENANCE_GRADE column as specified in the software license
MAINTENANCE_GRADES_ID numeric 20  √  null mantenance Id
DISTRIBUTION_MEDIAS varchar 4000  √  null The combined value of one or more values from DISTRIBUTION_MEDIA column as specified in the software license
DISTRIBUTION_MEDIAS_ID numeric 20  √  null Distribution media Id
PROGRAMS varchar 4000  √  null The combined value of one or more values from PROGRAM column as specified in the software license
PROGRAMS_ID numeric 20  √  null programs Id
PRICINGS varchar 1000  √  null The combined value of one or more values from PRICING column as specified in the software license
PRICINGS_ID numeric 20  √  null pricings id
PRICE_LEVELS varchar 500  √  null The combined value of one or more values from PRICE LEVEL column as specified in the software license
PRICE_LEVELS_ID numeric 20  √  null price levels id
CAT_SW_LIC_PRODUCT_ID numeric 20  √  null CAT_SW_LIC_PRODUCT table's unique identifier
REQ_SPECIFIC_VERSION numeric 24  √  null The flag that indicates whether the license is only authorized on a specific version or not((This column will be depricated, please use CAT_SW_LIC_PRODUCT.REQ_SPECIFIC_VERSION joining with column CAT_SW_LIC_PRODUCT_ID)
LIC_PRODUCT_LONG_DESC varchar 4000  √  null Product Long Description
INST_GUIDE_URL varchar 255  √  null Install Guide URL
CUTSHEET_URL varchar 255  √  null Cutsheet URL
PICTURE_URL varchar 255  √  null Picture URL
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_LIC_RELEASE AS SELECT vw.CAT_SW_LIC_RELEASE_ID, vw.CREATE_DATE, vw.LAST_MODIFIED_DATE, vw.CAT_MANUFACTURER_ID, vw.CAT_SW_PRODUCT_ID, vw.CAT_SW_EDITION_ID, vw.CAT_SW_VERSION_GROUP_ID, vw.CAT_SW_VERSION_ID, vw.CAT_SW_RELEASE_ID, vw.CAT_PLATFORMS_ID, prod_tax.CAT_TAXONOMY2012_ID, vw.VENDOR_PRODUCT_NAME, vw.VENDOR_UNIT_OF_MEASURE, vw.LICENSE_TYPES, vw.LICENSE_TYPES_ID, vw.LICENSE_TYPES_OTHER, vw.LICENSE_METRICS, vw.LICENSE_METRICS_ID, vw.UNIT_PACK, vw.UNIT_COUNT_MIN, vw.UNIT_COUNT_MAX, vw.LICENSE_TERM, vw.LICENSE_INFORMATION_OTHER, vw.PERIOD_VALUE, vw.PERIOD_UNIT, vw.MAINT_PEROID_VALUE, vw.MAINT_PERIOD_VALUE, vw.MAINT_PEROID_UNIT, vw.MAINT_PERIOD_UNIT, vw.ENVIRONMENTS, vw.ENVIRONMENTS_ID, vw.ENVIRONMENTS_OTHER, vw.DOWNGRADE_VERSION_AUTH, vw.DOWNGRADE_VERSION_INCR, vw.DOWNGRADE_EDITION_AUTH, vw.DOWNGRADE_EDITION_INCR, vw.DOWNGRADE_DATE_MONTHS_MIN, vw.DOWNGRADE_DATE_MONTHS_MAX, vw.UPGRADE_VERSION_AUTH, vw.UPGRADE_VERSION_INCR, vw.UPGRADE_EDITION_AUTH, vw.UPGRADE_EDITION_INCR, vw.UPGRADE_DATE_MONTHS_MIN, vw.UPGRADE_DATE_MONTHS_MAX, vw.DUAL_LICENSE_AUTH, vw.VIRTUAL_INSTALL_AUTH, vw.VIRTUAL_INSTALL_MAX, vw.REASSIGNMENT_AUTH, vw.CROSS_LANGUAGE_AUTH, vw.CROSS_PLATFORMS_AUTH, vw.CORE_FACTOR, vw.LANGUAGES, vw.LANGUAGES_ID, vw.MAINTENANCE_GRADES, vw.MAINTENANCE_GRADES_ID, vw.DISTRIBUTION_MEDIAS, vw.DISTRIBUTION_MEDIAS_ID, vw.PROGRAMS, vw.PROGRAMS_ID, vw.PRICINGS, vw.PRICINGS_ID, vw.PRICE_LEVELS, vw.PRICE_LEVELS_ID, vw.CAT_SW_LIC_PRODUCT_ID, vw.REQ_SPECIFIC_VERSION, vw.LIC_PRODUCT_LONG_DESC, vw.INST_GUIDE_URL, vw.CUTSHEET_URL, vw.PICTURE_URL, vw.TO_BE_DELETED, vw.TO_BE_DELETED_ON, vw.DELETE_REASON, vw.PRIVATE_FLAG, vw.IS_PRIVATE, vw.PRIVATE_TYPE, vw.REPLACEMENT_ID FROM ( SELECT f_tcat.CAT_SW_LIC_RELEASE_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.CAT_MANUFACTURER_ID,f_tcat.CAT_SW_PRODUCT_ID,f_tcat.CAT_SW_EDITION_ID,f_tcat.CAT_SW_VERSION_GROUP_ID,f_tcat.CAT_SW_VERSION_ID,f_tcat.CAT_SW_RELEASE_ID,f_tcat.CAT_PLATFORMS_ID,f_tcat.CAT_TAXONOMY2012_ID,f_tcat.VENDOR_PRODUCT_NAME,f_tcat.VENDOR_UNIT_OF_MEASURE,f_tcat.LICENSE_TYPES,f_tcat.LICENSE_TYPES_ID,f_tcat.LICENSE_TYPES_OTHER,f_tcat.LICENSE_METRICS,f_tcat.LICENSE_METRICS_ID,f_tcat.UNIT_PACK,f_tcat.UNIT_COUNT_MIN,f_tcat.UNIT_COUNT_MAX,f_tcat.LICENSE_TERM,f_tcat.LICENSE_INFORMATION_OTHER,f_tcat.PERIOD_VALUE,f_tcat.PERIOD_UNIT,f_tcat.MAINT_PEROID_VALUE,f_tcat.MAINT_PERIOD_VALUE,f_tcat.MAINT_PEROID_UNIT,f_tcat.MAINT_PERIOD_UNIT,f_tcat.ENVIRONMENTS,f_tcat.ENVIRONMENTS_ID,f_tcat.ENVIRONMENTS_OTHER,f_tcat.DOWNGRADE_VERSION_AUTH,f_tcat.DOWNGRADE_VERSION_INCR,f_tcat.DOWNGRADE_EDITION_AUTH,f_tcat.DOWNGRADE_EDITION_INCR,f_tcat.DOWNGRADE_DATE_MONTHS_MIN,f_tcat.DOWNGRADE_DATE_MONTHS_MAX,f_tcat.UPGRADE_VERSION_AUTH,f_tcat.UPGRADE_VERSION_INCR,f_tcat.UPGRADE_EDITION_AUTH,f_tcat.UPGRADE_EDITION_INCR,f_tcat.UPGRADE_DATE_MONTHS_MIN,f_tcat.UPGRADE_DATE_MONTHS_MAX,f_tcat.DUAL_LICENSE_AUTH,f_tcat.VIRTUAL_INSTALL_AUTH,f_tcat.VIRTUAL_INSTALL_MAX,f_tcat.REASSIGNMENT_AUTH,f_tcat.CROSS_LANGUAGE_AUTH,f_tcat.CROSS_PLATFORMS_AUTH,f_tcat.CORE_FACTOR,f_tcat.LANGUAGES,f_tcat.LANGUAGES_ID,f_tcat.MAINTENANCE_GRADES,f_tcat.MAINTENANCE_GRADES_ID,f_tcat.DISTRIBUTION_MEDIAS,f_tcat.DISTRIBUTION_MEDIAS_ID,f_tcat.PROGRAMS,f_tcat.PROGRAMS_ID,f_tcat.PRICINGS,f_tcat.PRICINGS_ID,f_tcat.PRICE_LEVELS,f_tcat.PRICE_LEVELS_ID,f_tcat.CAT_SW_LIC_PRODUCT_ID,f_tcat.REQ_SPECIFIC_VERSION,f_tcat.LIC_PRODUCT_LONG_DESC,f_tcat.INST_GUIDE_URL,f_tcat.CUTSHEET_URL,f_tcat.PICTURE_URL,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_LIC_RELEASE f_tcat where not exists (select 1 from TPC_SW_LIC_RELEASE tpc_tab where tpc_tab.CAT_SW_LIC_RELEASE_ID=f_tcat.CAT_SW_LIC_RELEASE_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_SW_LIC_RELEASE_ID,tcat.CAT_SW_LIC_RELEASE_ID) CAT_SW_LIC_RELEASE_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,CASE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') > tcat.LAST_MODIFIED_D
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA