usp_properties Table

Data Element Dictionary › usp_properties Table

usp_properties Table

Provides a list of property/value pairs for CA SDM and Knowledge Management applications.

SQL Name—usp_properties
Object—usp_properties

The maximum number of characters (HTML or pure text) allowed in the document's resolution field is 32768 bytes by default. The system Administrator can set this limit based on the type of data being stored. The limit can be set from the Administration tab, Knowledge, Documents, Document Settings.

There is also a built-in limit of 32768 bytes for the document's pure text that will be indexed. If the resolution of a document is larger than the set limit, only the first 32768 bytes of the document will be indexed and the rest will be ignored.

Field	Data Type	Remarks
ID	INTEGER NOT_NULL KEY	Unique (to the table) Numeric ID.
auto_policies_last	Date	Displays the last date and time when automated policies were run on the server; stored in seconds, in UNIX time format.
auto_policies_next_ interval	Number	Identifies the number of days between automated calculation batches.
last_mod_dt	LOCAL_TIME	Indicates the timestamp of when this record was last modified.
notify_days_bef_doc_ exp	Number	Defines the number of days before the document expires and a notification is sent.
property_default	STRING 32768	Identifies the property default.
property_description	STRING 255	Identifies the property description.
property_name	STRING 100 S_KEY	Identifies the property name.
property_type	STRING 100	Identifies the property type.
property_value	STRING 32768	Identifies the property value.
suggest_knowledge_ for _issue_cats	INTEGER	Flag that determines whether or not to suggest knowledge to customers. 1—Suggest knowledge by default for all issue categories. 0—Do not suggest knowledge.