Data Element Dictionary › Asset_Assignment Table

Previous Topic: Archive_Purge_Rule Table

Next Topic: Atomic_Condition Table

Asset_Assignment Table

Describes a relationship between two assets. Each instance of this table is one parent-child arrangement.

Field

Data Type

Reference

Remarks

hier_child

UUID

NOT_NULL S_KEY

ca_owned_ resource:: uuid

Specifies the child.

hier_license_ num

STRING 40

 

Specifies the license serial number.

hier_log_date

LOCAL_TIME NOT_NULL

 

Specifies the time of assignment.

hier_parent

UUID

NOT_NULL S_KEY

ca_owned_ resource:: uuid

Specifies the parent.

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

last_mod_by

UUID

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified.

persid

STRING 30

 

Persistent ID (SystemObjectName:id)