Previous Topic: CI_DOC_TYPES TableNext Topic: ci_managed_chgstat Table


ci_managed_attribute Table

The following table lists CI attributes that CACF manages for change verification:

Field

Data Type

Reference

Remarks

id

INTEGER

 

Primary key to this table, it is a unique numeric ID.

last_mod_dt

LOCAL_TIME

 

Specifies the timestamp of when this record was last modified.

last_mod_by

UUID

ca_contact

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

tenant

UUID

ca_tenant

Specifies the UUID of the tenant.

del

INTEGER

Active_Boolean_ Table::enum

Indicates the Deleted flag, as follows:
0—Active

1—Inactive/marked as deleted

attribute_name

STRING 128

 

Specifies the name of the CI attribute.

attribute_label

STRING 50

 

Specifies the label for the attribute.

description

STRING 255

 

Specifies a description for the attribute.

initial_status

STRING 32

ci_planned_change_status

Specifies the initial status of the attribute.

case_sensitive

INTEGER

 

Specifies if the managed attribute is case sensitive.

attribute_type

INTEGER

 

Specifies the data type.

attribute_length

INTEGER

 

Specifies the maximum length of the attribute.

srel_factory

STRING 26

 

Specifies the factory associated with a SREL attribute.

srel_rel_attr

STRING 26

 

Specifies the factory attribute used as a foreign key.

srel_common_name_attr

STRING 26

 

Specifies the factory attribute that stores the human-readable value.

srel_show_dropdown

INTEGER

Boolean_Table

Specifies the factory to show in the drop-down list.