Previous Topic: Change_Request TableNext Topic: Chg_Template Table

Data Element Dictionary › Change_Status Table

Change_Status Table

Lists the states of the change request, which you can add to at will. This table allows you to control whether the change request is active or inactive when it is changed to this status. Possible statuses 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

Active_
Boolean_
Table::enum

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 Change Request status name.