ID

varchar

40

No

Identifier; primary key.

TITLE_EN

varchar

2048

Yes

Solution title.

CLASS_ID

varchar

40

No

Foreign key to the KDW_SOLNCLASS_DIM.ID column.

CHECKED_IN

one-digit

1

No

Flag indicating whether or not the solution has been checked in.

DATE_CREATED

timestamp

No

Date and time the solution was created.

DATE_MODIFIED

timestamp

Yes

Date and time the solution was last modified.

DATE_DELETED

timestamp

Yes

Date and time the solution was deleted.

MODIFIED_BY_ID

varchar

40

Yes

User ID of the person who last modified the solution. Foreign key to the ARF_IU_USER.ID column.

LAST_USE_DATE

timestamp

Yes

Date and time the solution was last used.

DELETED

one-digit

1

Yes

Indicates whether or not the solution has been deleted.

1 = Yes

0 = No

STATUS_ID

varchar

40

No

Foreign key to the KDW_SOLNSTATUS_DIM.ID column.

OWNING_GROUP_ID

varchar

40

Yes

Foreign key to the KDW_OWNGROUP_DIM.ID column.

PROFILE_ID

varchar

40

No

Foreign key to the ARF_IU_USER.ID column.

BEST_BET

one-digit

1

No

Indicates whether or not the solution is a Best Bet.

1 = Yes

0 = No

LANGUAGE_ID

smallint

No

Foreign key to the ARF_LANGUAGE.ID column.

USE_COUNT

integer

Yes

The number of times that the solution has been identified as a recommended answer. This can occur when an agent links a ticket to the solution. It can also happen when a self service user provides positive feedback (four or five stars) for the solution.