Previous Topic: Issue_Property TableNext Topic: Issue_Workflow_Task Table

Data Element Dictionary › Issue_Status Table

Issue_Status Table

Lists the states of the Issue, which you can also add. This table allows you to control whether the issue is active or inactive when it is changed to this status. Possible status include: open, approval in process, implementation in progress, verification in progress, cancelled, suspended, and closed.

Field

Data Type

Reference

Remarks

active

INTEGER

 

Flag that indicates the following:
0—Inactive
1—Active

code

nvarchar(12)

 

Primary key of this table.

del

INTEGER

 

Delete flag that indicates the following:
0—Active
1—Inactive/marked as deleted

description

nvarchar
(500)

 

Identifies the textual description of this status.

hold

INTEGER

 

Flag that specifies the following:
0—Start events
1—Stop events

id

INTEGER

 

Unique (to the table) numeric ID.

last_mod_by

byte(16)

ca_contact::uuid

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

last_mod_dt

INTEGER

 

Identifies the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

resolved

INTEGER

 

Flag that indicates the following:
0—Not yet resolved
1—Resolved

sym

nvarchar(30)

 

Identifies the symbolic name of the Issue status.