SoftwareRecognition Table

Table 1. Database columns for `SoftwareRecognition` table
Database Column	Details
`SoftwareRecognitionID`	Type: text (max 30 characters). Key Factory generated identity.
`UpdateMode`	Type: text (max 20 characters). Nullable Update behavior.
`LastCollectiveUpdated`	Type: datetime. Nullable Last updated datetime by ARL on all software titles and evidence
`LastLinkUpdated`	Type: datetime. Nullable Last updated datetime by ARL on the software title links
`LastRecordUpdated`	Type: datetime. Nullable Last updated datetime by ARL on the software title or evidence records. To know which record this column refers to, see TypeOfID.
`LastCollectiveChecksum`	Type: integer. Nullable Last collective checksum on successful ARL update
`LastLinkChecksum`	Type: integer. Nullable Last link checksum on successful ARL update
`LastRecordChecksum`	Type: integer. Nullable Last record checksum on successful ARL update. To know which record this column refers to, see TypeOfID.
`LastCollectiveUpdate Result`	Type: integer. Nullable Last collective ARL update result
`LastLinkUpdateResult`	Type: integer. Nullable Last ARL link update result
`LastRecordUpdateResult`	Type: integer. Nullable Last ARL record update result
`RecordAdoptedByARL`	Type: boolean When an existing customer record is updated by the ARL, this flag will be set
`SoftwareTitleID`	Type: integer. Key. Nullable The related `SoftwareTitle`
`ChildSoftwareTitleID`	Type: integer. Key. Nullable The related child `SoftwareTitle`
`SoftwareTitleProductID`	Type: integer. Key. Nullable The related `SoftwareTitleProduct`
`SoftwareTitleVersionID`	Type: integer. Key. Nullable The related `SoftwareTitleVersion`
`SoftwareTitleEditionID`	Type: integer. Key. Nullable The related `SoftwareTitleEdition`
`SoftwareTitlePublisherID`	Type: integer. Key. Nullable The related `SoftwareTitlePublisher`
`FileEvidenceID`	Type: integer. Key. Nullable The related `FileEvidence`
`InstallerEvidenceID`	Type: integer. Key. Nullable The related `InstallerEvidence`
`WMIEvidenceID`	Type: integer. Key. Nullable The related `WMIEvidence`
`AccessEvidenceID`	Type: integer. Key. Nullable The related `AccessEvidence`
`RegistryEvidenceID`	Type: integer. Nullable The related registry `WMIEvidence`
`SoftwareLicensePoints DefaultID`	Type: integer. Key. Nullable The related `SoftwareLicensePointsDefault`
`SoftwareLicensePoints RuleSetID`	Type: integer. Key. Nullable The related `SoftwareLicensePointsRuleSet`
`SoftwareLicensePoints RuleID`	Type: integer. Key. Nullable The related `SoftwareLicensePointsRule`
`TypeOfID`	Type: text (max 32 characters). Key The type of the last updated ARL record