Previous Topic: Reverse_Boolean_Table TableNext Topic: Rpt_Meth Table

Data Element Dictionary › Rootcause Table

Rootcause Table

Reference table to denote the rootcause type used when resolving or closing a request, change order, or issue.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_
Table::enum

Specifies the Deleted flag as follows:
0—Active
1—Inactive/marked as deleted

description

nvarchar(240)

 

Provides a textual description of this root cause.

id

INTEGER

 

Primary key of this table.

last_mod_by

byte(16)

ca_contact::uuid

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

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

sym

nvarchar(60)

 

Identifies the symbolic value for this Rootcause.