This table contains the list of solutions. It includes the following:

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

TITLE_EN

varchar

1000

Yes

Solution title.

CLASS_ID

varchar

40

No

Foreign key to the KDW_SOLNCLASS_DIM.ID column.

DATE_CREATED

datetime

No

Date and time the solution was created.

DATE_MODIFIED

datetime

Yes

Date and time the solution was last modified.

DATE_DELETED

datetime

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

varchar

40

No

Foreign key to the SDW_LANG_DIM.ID column.

USE_COUNT

integer

Yes

Use count property for solution.

 
loading table of contents...