active_flag

INTEGER NOT_NULL

Active_Reverse_ Boolean::enum

1—Active

0—Inactive

assignee

UUID

ca_contact::uuid

Assignee of Request

category

STRING 30

Category symbol of Request

close_date

LOCAL_TIME

Close Date of Request

customer

UUID NOT_NULL

ca_contact::uuid

Affected User of Request

global_queue_id

INTEGER

Global_Queue_ Names::id

Pointer to global queue

group_id

UUID

Group assigned to Request

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

impact

INTEGER

Impact::enum

Impact of Request

last_mod_dt

LOCAL_TIME NOT_NULL

Indicates the timestamp of when this record was last modified.

open_date

LOCAL_TIME NOT_NULL

Open Date of Request

priority

INTEGER NOT_NULL

Priority::enum

Priority of Request

ref_num

STRING 30 NOT_NULL

Request ref num

remote_id

INTEGER NOT_NULL S_KEY

Regional request id

status

STRING 30 NOT_NULL

Cr_Status::code

Status symbol of Request

summary

STRING 240

Summary of Request

type

STRING 10

crt code

ITIL record type