acquire_date

INTEGER

Specifies the date the resource was acquired.

asset_source_uuid

byte(16)

Foreign key to ca_asset_source table, which establishes the identification of an non-software owned resource to a record in the common asset table through the asset source table.

audit_date

INTEGER

Identifies the audit date.

backup_services_ contact_uuid

SREL

cnt

billing_contact_uuid

SREL

cnt

cabinet_location

nvarchar(30)

Identifies the cabinet location.

company_bought_ for_uuid

byte(16)

ca_company::
company_uuid

Foreign key to the company_uuid field of the ca_company table representing the company for which this asset was purchased.

cost_center

INTEGER

ca_resource
_cost_center::id

Identifies the cost center id.
Note: This is a Primary key.

creation_date

INTEGER

Indicates the date when this record was created.

creation_user

nvarchar(64)

Identifies the user or process that created the record.

delete_time

INTEGER

Identifies the date of deletion.

department

INTEGER

ca_resource_
department::id

Foreign key to the id field of the ca_resource_department table representing the department to which this asset belongs.

disaster_recovery_ contact_uuid

SREL

cnt

dns_name

nvarchar(100)

The name by which this device is known in the domain name server.

exclude_ reconciliation

smallint

Flag indicating if the asset is excluded from reconciliation:
0—False
1—True

exclude_
registration

INTEGER

Specifies to exclude registration.

floor_location

nvarchar(30)

Identifies the floor location.

gl_code

INTEGER

Foreign key to the id field of the ca_resource_gl_code table.

host_name

nvarchar(255)

Identifies the machine name (hardware only).

inactive

INTEGER

Active_Boolean_
Table::enum

Sets the Active flag, as follows:
0—False (Active)
1—True (Inactive)

installation_date

INTEGER

Identifies the date the resource was installed in the organization or network.

ip_address

nvarchar(64)

Identifies the IP address (hardware only).

last_update_date

INTEGER

Specifies the date of when the record was last updated.

last_update_user

nvarchar(64)

Specifies the user or process that last updated this record.

license_information

nvarchar(32)

Identifies the license Information.

license_uuid

byte(16)

Foreign key to ca_license table, which establishes the identification of a software owned resource to a record in the common asset table through the license table.

lifecycle_status

INTEGER

ca_asset_ lifecycle_status (CA APM)

Identifies the status of an asset in the lifecycle. For example: request, ordered, receipt, active, available/warehoused, disposed. You may have different terms depending on your processes.

location_uuid

byte(16)

ca_location ::location_uuid

Foreign key to the location_uuid field of the ca_location table representing the location of this asset.

mac_address

nvarchar(64)

Identifies the MAC address (hardware only).

maintenance_org_ uuid

byte(16)

ca_organization :: organization_ uuid

Foreign key to the company_uuid field of the ca_company table representing the vendor responsible for maintenance.

maintenance_ vendor_uuid

byte(16)

ca_company
::company_uuid

Primary key, this is also a unique identifier.

manufacturer_uuid

byte(16)

ca_company:: company_ uuid

Foreign key to the company_uuid field of the ca_company table representing the manufacturer of the asset.

model_uuid

byte(16)

ca_model_def::
model_uuid

Foreign key to the model_uuid field of the ca_model_def table to represent the asset model.

network_contact_ uuid

SREL

cnt

operating_system

INTEGER

Foreign key to the id field of the ca_resource_operating_system table representing the operating system used for this asset.

org_bought_for_uuid

byte(16)

ca_organization:: organization_ uuid

Foreign key to the organization_uuid field of the ca_organization table for the organization that bought this asset.

own_resource_uuid

byte(16)

Primary key. This is the UUID that uniquely identifies the owned resource within tables supporting ownership information.

product_version

nvarchar(16)

Represents the product version.

purchase_order_id

nvarchar(20)

Specifies the purchase order ID on which the resource was purchased.

requisition_id

nvarchar(50)

Identifies the requisition ID on which the resource was requested.

resource_alias

nvarchar(30)

Identifies the resource alias.

resource_capacity

Float

Specifies the resource capacity, for example, the "20" in 20 MB (applies to hardware only).

resource_capacity_unit

INTEGER

Foreign key to the id field of the ca_capacity_unit table. Specifies the resource capacity unit, for example the "MB" in 20 MB (applies to hardware only).

resource_class

INTEGER

ca_resource_ class::id

Primary key that also identifies the class id.

resource_contact_ uuid

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table for the primary contact for this asset.

resource_ description

nvarchar(255)

Indicates the longer name or description of the resource.

resource_family

INTEGER

ca_resource_ family::id

Primary key that is also the resource family id.

resource_name

nvarchar(100)

Identifies the name of the resource.

resource_owner_ uuid

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table for the owner of this asset.

resource_quantity

INTEGER

Specifies the resource quantity.

resource_status

INTEGER

ca_resource_ status::id

Foreign key to the id field of the ca_resource_status table for resource status.

resource_subclass

INTEGER

Foreign key to the id field of the ca_resource_class table for the resource subclass.

resource_tag

nvarchar(64)

Specifies the alternate identifier, for example, the alternate id located on the sticker placed on the machine.

responsible_org_ uuid

byte(16)

ca_organization::organization_ uuid

Foreign key to the organization_uuid field of the ca_organization table for the organization responsible for this asset.

responsible_vendor_uuid

byte(16)

ca_company
::company_uuid

Foreign key to the company_uuid field of the ca_company table representing the vendor

room_location

nvarchar(30)

Specifies the room location.

serial_number

nvarchar(64)

Identifies the serial number.

shelf_location

nvarchar(30)

Identifies the shelf location.

slot_location

nvarchar(30)

Specifies the slot location.

status_date

INTEGER

Provides the status date.

supply_vendor_uuid

byte(16)

ca_company
::company_uuid

Primary key, which is also a unique identifier.

support_contact1_ uuid

SREL

ca_contact

support_contact2_ uuid

SREL

ca_contact

support_contact3_ uuid

SREL

ca_contact

ufam

smallint

Sets the flag that indicates if the asset is managed by UAPM:
0—False
1—True

version_number

INTEGER

Version number for transaction integrity.