How are Assets and Legal Documents linked to each other in the MDB?

Document ID : KB000010890
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

I need to produce a report which includes assets and associated legal documents. To do this, I need to know how these items are linked with each other in the MDB.

Environment:
UAPM 14.1
Instructions:

Asset information is held in the ca_owned_resource MDB table. Legal document information is stored in the arg_legaldoc MDB table. These two tables are linked via an intermediate third table, arg_legasset. This table contains the own_resource_uuid column from the ca_owned_resource table and the legaldoc_uuid column from the arg_legaldoc table, so this can be used to map assets to legal documents and vice versa.