SoftwareTitleHierarchy Table

SoftwareTitleHierarchy records a hierarchy of applications. This table records relationships between Oracle database and component applications, between suites and their members, and between generic titles and more specific ones that will replace them.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SoftwareTitleHierarchy table

Database Column

Details

ParentSoftwareTitleID

Type: integer. Key

The parent application. Foreign key to the SoftwareTitle table.

ChildSoftwareTitleID

Type: integer. Key

The child application. Foreign key to the SoftwareTitle table.

IsLicensable

Type: boolean. Nullable

This field is used for Oracle option titles. Set this field to True to indicate that the child application needs to be separately licensed. If this field is False, the child application does not need to be separately licensed when the parent application is present and licensed.

IsMandatory

Type: boolean. Nullable

This field is used on component applications of software suites. When the value is True, the child application must be installed for the suite to be recognized as installed. Otherwise, the application may or may not be installed for the suite to be recognized.

RemovalOfChild

Type: boolean. Nullable

This field is used to allow removal of titles when higher quality titles (with more specified evidence) are also found installed. When the value is True, the child application should be removed if evidence is found that both it and its parent title are installed. Otherwise, the child application is left in place.

IsLocal

Type: boolean

If this field is False, the link has come from the ARL. If it is True, then the link has been created by an operator.

IsMandatoryDefault

Type: boolean. Nullable

This field is used on component applications of software suites. This indicates the Default value of the Mandatory field and can be used to determine if this has been overridden by the user, in the case of an application with non-local membership to the suite (that is, the ARL specifies that the app belongs to the suite).

IsShared

Type: boolean