Previous Topic: ca_owned_resource TableNext Topic: ca_resource_cost_center Table


ca_resource_class Table

Definitions of the classifications that may be applied to an asset/resource.

Field

Data Type

Reference

Remarks

creation_date

INTEGER

 

Specifies the date the of when this record was created.

creation_user

nvarchar(64)

 

Identifies the user or process that created the record.

delete_time

INTEGER

 

Indicates the date of deletion.

description

nvarchar(255)

 

Specifies the class description.

exclude_
registration

INTEGER

 

Indicates to exclude registration.

family_id

INTEGER

ca_resource_ family::id

Primary key that is also the resource family id.

id

INTEGER

 

Primary key that is also the class id.

inactive

INTEGER

Active_Boolean_Table::enum

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

last_update_date

INTEGER

 

Indicates the date the record was last updated.

last_update_user

nvarchar(64)

 

Specifies the user or process that last updated the record.

name

nvarchar(100)

 

Identifies the unique class name within family.

parent_id

SREL

 

Foreign key back to the id field of the ca_resource_class table to allow for hierarchical class groupings (for example, subclass).

usp_nsm_class

INTEGER

buscls id

Represents the CA NSM class.
Note: This is the Foreign key to the id field of the buscls table.

version_number

INTEGER

 

Specifies the version number for transaction integrity.