Software Knowledge Base Toolkit to Control Desk mapping tables
These tables describe how the database columns and fields in Control Desk relate to the XML schemas from Software Knowledge Base Toolkit.
TLOAMSWCATALOG mapping
To maintain information
about the import, one instance is created in the TLOAMSWCATALOG table
that contains the following information about Software Knowledge Base Toolkit source
data.
| Control Desk | Software Knowledge Base Toolkit | |
|---|---|---|
| Database Column | Field | XML Schema |
| TloamSwCatalogId | 0 | |
| SchemaVersion | Schema Version | /SoftwareKnowledgeBase.schemaVersion |
| CreatedDate | Created Date | /SoftwareKnowledgeBase.creationDate |
| UniqueId | Unique ID | /SoftwareKnowledgeBase.databaseInstanceId |
| Name | Catalog Name | /SoftwareKnowledgeBase.databaseInstanceName |
| Description | Description | First 99 characters of /SoftwareKnowledgeBase.databaseInstanceName |
| Version | Version | /SoftwareKnowledgeBase.swkbtBuildNumber |
| LastModification | Last Modification | /SoftwareKnowledgeBase.lastModification |
| DataVersion | Data Version | /SoftwareKnowledgeBase.dataVersion |
| ContactName | Contact Name | /SoftwareKnowledgeBase.contact |
TLOAMSOFTWARE mapping
One instance is created in the TLOAMSOFTWARE table in Control Desk for every node in Software Knowledge Base Toolkit with one of the following paths:
- /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/DistributedProduct
- /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/DistributedVersion
- /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/DistributedRelease
Table 2 describes how the database columns and fields in Control Desk relate to the XML schema from Software Knowledge Base Toolkit.
Any of these nodes is referred to as SoftwareItemType below.
| Control Desk | Software Knowledge Base Toolkit | |
|---|---|---|
| Database Column | Field | XML Schema |
| TloamSoftwareId | Unique identifier that is automatically generated. | |
| UniqueID | Unique ID | SoftwareItemType.guid |
| PlatformBase | Platform | "DISTRIBUTED" (translated as needed). |
| Type | Type | If node name = "DistributedProduct",
then "PRODUCT" (translated as needed). If node name = "DistributedVersion", then VERSION" (translated as needed). If node name = "DistributedRelease", then "RELEASE" (translated as needed). |
| SwName | Software Name | If there is an element SoftwareItemType/alias
with attribute preferred='true', then use this value. Otherwise, use SoftwareItemType.name. |
| Func | Function | SoftwareItemType.Function |
| Role | Product Role | If attribute SoftwareItemType.productRole
exists and is equal to "SOFTWARE_PRODUCT", then "SOFTWAREPRODUCT"
(translated as needed). If attribute SoftwareItemType.productRole exists and is not equal to "SOFTWARE_PRODUCT", then its value (translated as needed). If attribute SoftwareItemType.productRole does not exist, then "SOFTWAREPRODUCT" (translated as needed). |
| ProductId | Product Id | SoftwareItemType.productIds |
| ExternalID | External ID | SoftwareItemType.ExternalId |
| Version | Version | If node name = "MainframeProduct",
then (empty). If node name = "MainframeVersion", then SoftwareItemType.version. If node name = "MainframeFeature", the value of /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeVersion.version for the node that has /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeVersion.guid = SoftwareItemType.version. |
| Release | Release | SoftwareItemType.release |
| Description | Description | If SoftwareItemType.description
exists and is not empty, its first 99 characters. Otherwise, the first 99 characters of SoftwareItemType.name. |
| Url | URL | SoftwareItemType.website |
| IsPVU | Uses PVU | If attribute SoftwareItemType.PVU
exists and is equal to "false", then 0. If attribute SoftwareItemType.PVU exists and is empty or not equal to "false", then 1. If attribute SoftwareItemType.PVU does not exist, then 0. |
| IsIPLA | Is IPLA | If attribute SoftwareItemType.IPLA
exists (no matter what is its value), then 1. If attribute SoftwareItemType.IPLA does not exist, then 0. |
| IsSubCap | Subcapacity Eligible | If attribute SoftwareItemType.subCapacityLicensing
exists and is equal to "false", then 0. If attribute SoftwareItemType.subCapacityLicensing exists and is empty or not equal to "false", then 1. If attribute SoftwareItemType.subCapacityLicensing does not exist, then 0. |
| ManufacturerName | Manufacturer | The value of /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer.name
for the node that has /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer.guid
= SoftwareItemType.manufacturer. If Manufacturer.name is empty, then use the parent's manufacturer. |
| SwCatalogId | Catalog Source | 0 |
| ActivationDate | Activation Date | SoftwareItemType.ActivationDate |
| IsDeleted | Deleted | If attribute SoftwareItemType.deleted
exists and is equal to "true", then 1. If attribute SoftwareItemType.deleted does not exist or is not equal to "true", then 0. |
| DeleteDate | Delete Date | If attribute SoftwareItemType.deleted
exists and is equal to "true", then SoftwareItemType.modified. If attribute SoftwareItemType.deleted does not exist or is not equal to "true", then (empty). |
| VulExhibitId | Value Unit Table | SoftwareItemType.VUE - always (empty) |
| SSPID | SSID | SoftwareItemType.SS - always (empty) |
| SSEID | SsEnID | SoftwareItemType.SSEnId - always (empty) |
| TargetSoftwareID | Target Record | If a /SoftwareKnowledgeBase/IdentityLinks/Link
element exists with an attribute primary = SoftwareItemType.guid,
then the tloamSoftwareId of the catalog record with UniqueID equal
to /SoftwareKnowledgeBase/IdentityLinks/Link.descendant. Otherwise, (empty). |
| Parent | Parent Record | If node name = "MainframeProduct",
then (empty). If node name = "MainframeVersion", then the tloamSoftwareId value of the parent product. If node name = "MainframeFeature", then the tloamSoftwareId value of the parent version. |
| CCID | Chargeable Component | the value of ProductId |
TLOAMSWREL mapping
One instance is created
in the TLOAMSWREL table in Control Desk for
every node in Software Knowledge Base Toolkit with
the following path:
- /SoftwareKnowledgeBase/KbIdentity/Relationships/Relationship
Table 3 describes how the database columns and fields in Control Desk relate to the XML schema from Software Knowledge Base Toolkit.
| Control Desk | Software Knowledge Base Toolkit | |
|---|---|---|
| Database Column | Field | XML Schema |
| TloamSwRelId | Unique ID | Unique identifier that is automatically generated. |
| ParentSw | Parent Unique ID | tloamSoftwareId of the catalog record with UniqueID equal to Relationship.source |
| ChildSw | Child Unique ID | tloamSoftwareId of the catalog record with UniqueID equal to Relationship.sink |
| Relationshiptype | Relationship | Relationship.type |
| IsDeleted | Deleted | If attribute Relationship.deleted
exists and is equal to "true", then 1. If attribute Relationship.deleted does not exist or is not equal to "true", then 0. |
| DeletedDate | Delete Date | If attribute Relationship.deleted
exists and is equal to "true", then SoftwareItemType.modified. If attribute Relationship.deleted does not exist or is not equal to "true", then (empty). |
DPAMMANUFACTURER mapping
One instance is
created in the DPAMMANUFACTURER table in Control Desk for
every node in Software Knowledge Base Toolkit with
the following path:
- /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer
However, if a record already exists in DPAMMANUVARIANT with MANUFACTURERVAR = Manufacturer.name, then the node is skipped completely.
Table 4 describes how the database columns and fields in Control Desk relate to the XML schema from Software Knowledge Base Toolkit.
| Control Desk | Software Knowledge Base Toolkit | |
|---|---|---|
| Database Column | Field | XML Schema |
| ManufacturerId | Manufacturer | Unique identifier that is automatically generated. |
| ManufacturerName | Target Manufacturer | Manufacturer.name |
DPAMMANUVARIANT mapping
One instance is
created in the DPAMMANUVARIANT table in Control Desk for
every node in Software Knowledge Base Toolkit with
the following path:
- /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer
However, if a record already exists in DPAMMANUVARIANT with MANUFACTURERVAR = Manufacturer.name, then the node is skipped completely.
Table 5 describes how the database columns and fields in Control Desk relate to the XML schema from Software Knowledge Base Toolkit.
| Control Desk | Software Knowledge Base Toolkit | |
|---|---|---|
| Database Column | Field | XML Schema |
| DpamManuVariantId | Manufacturer Variant Id | Unique identifier that is automatically generated. |
| ManufacturerName | Target Manufacturer | Manufacturer.Name |
| ManufacturerVar | Manufacturer Variant | Manufacturer.Name |
TAMITSWPRTNUM mapping
One instance is created
in the TAMITSWPRTNUM table in Control Desk for
every node in Software Knowledge Base Toolkit that
has a CCID value. The instance is created with the following path:
- /SoftwareKnowledgeBase/KbIdentity/PartNumbers/PartNumber
Table 6 describes how the database columns and fields in Control Desk relate to the XML schema from Software Knowledge Base Toolkit.
| Control Desk | Software Knowledge Base Toolkit | |
|---|---|---|
| Database Column | Field | XML Schema |
| TamitSwPrtNumId | Unique Id | Unique identifier that is automatically generated. |
| PartNumber | Part Number | PartNumber.partNumber |
| Description | Description | PartNumber.name, the first 255 characters |
| CCID | Chargeable Component | PartNumber.ccid |
| ChargeType | Charge Type | PartNumber.chargeUnit |
| ProductIds | Product IDs | PartNumber.productIds |
| IspVu | Uses PVU | If attribute PartNumber.isPVU exists
and is equal to "false", then 0. If attribute PartNumber.isPVU exists and is empty or not equal to "false", then 1. If attribute PartNumber.isPVU does not exist, then 0. |
| IsSubCap | Subcapacity Eligible | If attribute PartNumber.isSubCap
exists and is equal to "false", then 0. If attribute PartNumber.isSubCap exists and is empty or not equal to "false", then 1. If attribute PartNumber.isSubCap does not exist, then 0. |
| Is Deleted | Deleted | If attribute PartNumber.deleted
exists and is equal to "true", then 1. If attribute PartNumber.deleted does not exist or is not equal to "true", then 0. |
| DeleteDate | Delete Date | If attribute PartNumber.deleted
exists and is equal to "true", then PartNumber.modified. If attribute PartNumber.deleted does not exist or is not equal to "true", then (empty). |
| GUID | GUID | PartNumber.guid |
| Quantity | Quantity | PartNumber.quantity |