Stores proprietary Spel macros and macro fragments
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| sym | nvarchar(30) | not null | The sym value for this Spell_Macro. |
| description | nvarchar(80) | with null | Textual description |
| ob_type | nvarchar(30) | not null | The ob type value for this Spell_Macro. |
| type | nvarchar(30) | not null | The type value for this Spell_Macro. |
| fragment | nvarchar(4000) | with null | The usr string1 value for this Spell_Macro. |
| usr_string2 | nvarchar(250) | with null | The usr string2 value for this Spell_Macro. |
| usr_string3 | nvarchar(125) | with null | The usr string3 value for this Spell_Macro. |
| usr_string4 | nvarchar(25) | with null | The usr string4 value for this Spell_Macro. |
| usr_integer1 | integer | with null | The usr integer1 value for this Spell_Macro. |
| usr_integer2 | integer | with null | The usr integer2 value for this Spell_Macro. |
| usr_integer3 | integer | with null | The usr integer3 value for this Spell_Macro. |
| msg_html | long nvarchar | with null | To keep html template |
| lock_object | integer | not null | Boolean if the object |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
Product Name: Unicenter Service Desk
Table Type: Table