ASSIGNEE

UUID

SREL to the Contacts table.

CLOSE_DATE

DATE

Represents the timestamp of when this flag was closed.

CLOSE_DESC

nvarchar(50)

Displays the description when the flag is closed.

COMMENT_TEXT

nvarchar(255)

Displays comment text.

COMMENT_ TIMESTAMP

DATE

Indicates the timestamp of when this record was last created.

DEADLINE_DATE

DATE

Displays the date when the flag should be fixed by the user.

DOC_ID

INTEGER

SKELETONS:: id

Identifies the unique doc ID.

EMAIL_ADDRESS

nvarchar(75)

Identifies the email address.

FLG_CODE

nvarchar(50)

Prevents duplicate flags from being created for the same broken link.

FLG_STATUS

INTEGER

KT_FLG_ STATUS

Identifies the flag status as active or inactive.

FLG_TYPE

INTEGER

SREL to the KT_Flg_Type Table.

ID

INTEGER KEY

Unique (to the table) Numeric ID.

last_mod_by

UUID

ca_contact

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

last_mod_dt

DATE

Indicates the timestamp of when this record was last modified.

tenant

UUID

ca_tenant

Specifies the UUID of the tenant.

USER_ID

UUID

ca_contact:: uuid

Identifies the unique user ID

USER_NAME

STRING 50

Identifies the user name.

VER_COUNT

INTEGER

Identifies the unique version ID and displays the number of versions created (1, 2, 3, 4...)