Previous Topic: usp_owned_resource TableNext Topic: usp_pri_cal Table


USP_Preferences Table

Holds information about the CA SDM and Knowledge Management application preferences.

Field

Data Type

Reference

Remarks

ANALYST_ID

UUID

ca_contact ::uuid

 

ARC_DOCS_TO_ DISPLAY

INTEGER

 

 

ASSIGNEE

INTEGER

 

 

AUTHOR

INTEGER

 

 

BU_RESULT

INTEGER

 

 

CLASSIC_ RESULTSET_ CONTEXT

INTEGER

 

Specifies the Classic resultset context menu activation.

CREATED_VIA

INTEGER

 

 

CREATION_DATE

INTEGER

 

Indicates the timestamp indicating when this record was created.

CURRENT_ACTION

INTEGER

 

 

CUSTOM1

INTEGER

 

 

CUSTOM2

INTEGER

 

 

CUSTOM3

INTEGER

 

 

CUSTOM4

INTEGER

 

 

CUSTOM5

INTEGER

 

 

CUSTOM_NUM1

INTEGER

 

 

CUSTOM_NUM2

INTEGER

 

 

DOC_ID

INTEGER

 

 

DOC_TEMPLATE

INTEGER

 

 

DOC_TYPE

INTEGER

 

 

DOC_VERSION

INTEGER

 

 

EXPIRATION_DATE

INTEGER

 

 

GLOBALSD_ ACTIVE_ZONE

INTEGER

 

Specifies the status of the Global Service Desk Active Zone log reader:
0x01—Reduce popups
0x02—Close log reader

HITS

INTEGER

 

 

ID

INTEGER NOT_NULL KEY

 

Specifies the numeric ID that is unique to this table.

INBOX_COUNTER

INTEGER

 

 

INITIATOR

INTEGER

 

 

ITEM

INTEGER

 

 

KT_REPORT_ CARD_PAST_ DAYS

INTEGER

 

Indicates the Knowledge report card past_days status. This is a user-defined preference.

KT_REPORT_ CARD_SCREEN_ DEFAULT

INTEGER

 

Indicates the Knowledge report card screen default. this is a user-defined preference.

LAST_ACCEPTED_DATE

INTEGER

 

 

LAST_MOD_DT

LOCAL_TIME

 

Indicates the timestamp for when this record was last modified.

MODIFY_DATE

INTEGER

 

 

ONE_B_DOC_ VIEW_MODE

INTEGER

 

 

ONE_B_DOCS_TO_DISPLAY

INTEGER

 

 

ONE_B_HIDE_ DETAILS

INTEGER

 

 

ONE_B_MATCH_ TYPE

INTEGER

 

 

ONE_B_SEARCH_FIELDS

INTEGER

 

 

ONE_B_SEARCH_ORDER

STRING 255

 

 

ONE_B_SEARCH_TYPE

INTEGER

 

 

ONE_B_WORD_ PARTS

INTEGER

 

 

OWNER

INTEGER

 

 

PRIMARY_INDEX

INTEGER

 

 

PRIORITY

INTEGER

 

 

PRODUCT

INTEGER

 

 

PUBLISHED_DATE

INTEGER

 

 

REVIEW_DATE

INTEGER

 

 

SD_ACCEPTED_ HITS

INTEGER

 

 

SD_IMPACT

INTEGER

 

 

SD_PRIORITY

INTEGER

 

 

SD_ROOTCAUSE

INTEGER

 

 

SD_SEARCH_ FIELDS_CR

INTEGER

 

Specifies the CA SDM and Knowledge Management search fields for requests.

SD_SEARCH_ FIELDS_ISS

INTEGER

 

Specifies the CA SDM and Knowledge Management search fields for issues.

SD_SEVERITY

INTEGER

 

 

SD_URGENCY

INTEGER

 

 

START_DATE

INTEGER

 

 

STATUS

INTEGER

 

 

SUBJECT_EXPERT

INTEGER

 

 

USER_DEF_ID

INTEGER

 

 

WEB_LAST_LOGIN

LOCAL_TIME

 

Indicates the time of the last web login.

WEB_POPUP1_ HEIGHT

INTEGER

 

Specifies the maximum height for pop-up1.

WEB_POPUP1_ WIDTH

INTEGER

 

Specifies the maximum width for the Web pop-up1.

WEB_POPUP2_ HEIGHT

INTEGER

 

Specifies the medium Web pop-up2 height.

WEB_POPUP2_ WIDTH

INTEGER

 

Specifies the Medium Web pop-up2 width.

WEB_POPUP3_ HEIGHT

INTEGER

 

Specifies the Small Web pop-up3 height.

WEB_POPUP3_ WIDTH

INTEGER

 

Specifies the Small Web pop-up3 width.

WEB_POPUP4_ HEIGHT

INTEGER

 

Specifies the extra Small Web pop-up height.

WEB_POPUP4_ WIDTH

INTEGER

 

Specifies the extra Small Web pop-up4 width.

WEB_ PREFERENCES

INTEGER

 

Indicates Web Preferences Flags.

WEB_SUPPRESS_TOUR

INTEGER

 

Specifies the Web suppressor tour flag:

1—Do not Suppress
2—Suppress tour page

WEB_TOOLBAR_ TAB

INTEGER

 

Indicates the initial toolbar tab.

WF_TEMPLATE

INTEGER