Data Element Dictionary

This article contains the following topics:
casm173
This article contains the following topics:
Explains the definitions for the tables in the CA SDM database. The tables are found in schema (.sch) files. See the ddict.sch file in the $NX_ROOT/site directory (Non-Windows) or
installation
-
directory\
site directory (Windows) for the most current list of all database tables for your specific installation.
Although several of the tables in this section are obsolete, for backward compatibility, or reserved for future use, it is important that you not delete these -- or any other table -- from the database schema. You can add new tables and add new fields/columns to the existing tables, but never delete any of the tables. Many applications access the mdb database, so deleting or modifying existing fields or tables could cause some applications to not function properly. Ensure that you follow supported schema modification best practices by using the Web Screen Painter.
admin_tree Table
Program control table used by CA SDM applications.
  • SQL Name
    -- admin_tree
  • Object
    -- ADMIN_TREE
Field
Data Type
Reference
Remarks
caption
STRING 50
description
STRING 255
Specifies the textual description of this tree entry.
has_children
INTEGER
id
INTEGER KEY
Unique (to the table) Numeric ID
kt_admin
INTEGER
kt_ks_caption
STRING 50
kt_ks_flag
INTEGER
kt_manager
INTEGER
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
parent_id
SREL
resource
STRING 255
sd_admin
INTEGER
Animator Table
Program control table used by CA SDM applications
  • SQL Name
    -- anima
  • Object
    -- ANI
Field
Data Type
Reference
Remarks
a_act
INTEGER
a_delta
INTEGER
a_lock
STRING 200
a_name
STRING 30 S_KEY
a_org
LOCAL_TIME
a_string
STRING 30
a_time
LOCAL_TIME
id
INTEGER KEY UNIQUE NOT_NULL
Unique (to the table) Numeric ID
t_method
STRING 30 S_KEY
t_persid
STRING 30 S_KEY
t_type
INTEGER
Atomic_Condition Table
These define a single condition.
  • SQL Name
    -- atomic_cond
  • Object
    -- atomic_cond
Field
Data Type
Reference
Remarks
cond_code
STRING 500
connecter
INTEGER NOT_NULL
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
description
STRING 240
Specifies the textual description of this condition.
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
l_paran
INTEGER NOT_NULL
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified
lval
STRING 30 NOT_NULL
Act_Type_Assoc ::code
operator
INTEGER NOT_NULL
owning_macro
STRING 30
Spell_Macro::persid
persid
STRING 30
Persistent ID (SystemObjectName:id)
r_paran
INTEGER NOT_NULL
rval
STRING 50
rval_assoc
STRING 30
Act_Type_Assoc ::code
sequence
INTEGER NOT_NULL
Ordering
Attribute_Name Table
Provides corresponding user name for an object attribute. Default population for the table should set at_name and at_dflt to the same thing. The user sees and is able to modify only the at_name. at_dflt is used to restore the default name. at_desc could be user changeable or not. It is of use for identifying the attribute for an as yet unplanned user maintenance application. at_sys should never be seen by the user, nor should at_obj.
  • SQL Name
    -- atn
Field
Data Type
Reference
Remarks
at_desc
STRING 240
Specifies the description of the attribute.
at_dflt
STRING 30
Specifies the default external name.
at_name
STRING 30
Specifies the user name for attribute.
at_obj
STRING 30 S_KEY
Specifies the system object name.
at_sys
STRING 30 S_KEY
Specifies the system name.
del
INTEGER NOT_NULL
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
Audit_Log Table
Contains all audit log entries.
  • SQL Name
    -- audit_log
  • Object
    -- audlog
Field
Data Type
Reference
Remarks
analyst
Byte 16
ca_contact::uuid
Specifies the user whose update generated this audit record.
Note:
This is a foreign key.
attr_after_val
nvarchar(160)
Specifies the new value of the object's attribute that has changed.
attr_before_val
nvarchar(160)
Indicates the previous value of the object's attribute that has changed.
attr_name
nvarchar(80)
This is the object's attribute that has changed.
aud_opr
INTEGER
Indicates the type of operation that generated this entry, such as, update, insert, and delete.
audobj_name
nvarchar(10)
Used for tracking the object that has changed.
audobj_persid
nvarchar(30)
Used for tracking the object that has changed.
audobj_trkid
nvarchar(40)
Used for tracking the object that has changed.
audobj_uniqueid
nvarchar(30)
Used for tracking the object that has changed.
change_date
INTEGER
The change date value for this Audit_Log.
id
INTEGER
Specifies the unique (to the table) numeric ID.
Note:
This is a primary key.
int1_rsrved
INTEGER
Reserved
int2_rsrved
INTEGER
Reserved
persid
nvarchar(30)
This is the Persistent ID (SystemObjectName:id).
str1_rsrved
nvarchar(25)
Reserved for future use by CA.
Behavior_Template Table
Each object includes a list of things to execute based on the state of the object. If no behavior is associated with the state transition then it simply controls whether the object can be transitioned to the state.
  • SQL Name
    -- bhvtpl
  • Object
    -- bhvtpl
Field
Data Type
Reference
Remarks
context_attrname
STRING 30
Specifies the attribute name, such as "state".
context_attrval
INTEGER
Specifies the attribute value.
context_type
STRING 30 NOT_NULL
Specifies information which determines whether the transition is valid for the consumercontext object.
Note:
For general use, the context_attrnamecontext_attrval pair was added. However, can't get the list of valid values very easily from the GUI so we've added an SREL to the object that context_attrnamecontext_attrval really represents. short name of object (eg. wf)
del
INTEGER NOT_NULL
Active_ Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
description
STRING 500
Specifies the textual description of this behavior template
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
last_mod_by
UUID
ca_contact:: uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
macro_condition
STRING 30
Spell_Macro ::persid
Specifies whether the macro executes.
object_id
INTEGER NOT_NULL
Specifies the id of creator object.
object_type
STRING 30 NOT_NULL
Specifies the short name of creator object.
persid
STRING 30
Persistent ID (SystemObjectName:id)
transition_errmsg
STRING 240
Specifies the text to display on failure.
transition_test
STRING 30
Spell_Macro ::persid
Specifies the condition.
Bop_Workshift Table
Workshift definition.
  • SQL Name
    -- bpwshft
  • Object
    -- wrkshft
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
This is the Deleted flag:
0
-- Active
1
-- Inactive/marked as deleted
description
nvarchar(80)
Specifies the textual description of this workshift.
id
INTEGER
Unique (to the table) Numeric ID.
last_mod_by
Byte(16)
ca_contact:: uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
Persistent ID (SystemObjectName:id).
Note:
This is a primary key.
sched
nvarchar(1000)
Describes the schedule of this workshift.
sym
nvarchar(30)
Represents the symbolic value for this workshift.
BU_TRANS Table
Program control table used by Knowledge Management.
  • SQL Name
    -- BU_TRANS
  • Object
    -- BU_TRANS
Field
Data Type
Reference
Remarks
BU_DATE
LOCAL_TIME
BU_PROCESSED
INTEGER
BU_RATING
REAL
DOC_ID
INTEGER
SKELETONS::id
HIT_NO_VOTE
INTEGER
HIT_ORIGIN
INTEGER
ID
INTEGER NOT_NULL KEY
Unique (to the table) Numeric ID
INDEX_ID
INTEGER
O_INDEXES::id
User_slv
INTEGER
Ticket_slv
INTEGER
LAST_MOD_DT
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
USER_ID
UUID
ca_contact::uuid
Specifies the UUID of the user id.
kd_duration
INTEGER
Specifies the duration of a specific event, such as how long a knowledge document was open.
Business_Management_Repository Table
Table that keeps track of CA NSM repositories used by Service Analyzer.
  • SQL Name
    -- busrep
  • Object
    -- bmrep
Field
Data Type
Reference
Remarks
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
hostname
STRING 64 UNIQUE NOT_NULL
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
nx_desc
STRING 40
password
STRING 200
persid
STRING 30
Persistent ID (SystemObjectName:id)
sym
STRING 60 UNIQUE NOT_NULL S_KEY
userid
STRING 40
Column_Name Table
Column Name list used by Web Screen Painter.
  • SQL Name
    -- cn
Field
Data Type
Reference
Remarks
cn_desc
STRING 240
description of column
cn_dflt
STRING 30
default external name
cn_name
STRING 30
user name for column
cn_sys
STRING 30
S_KEY
system name
cn_table
STRING 30
S_KEY
system table name
del
INTEGER
NOT_NULL
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
UNIQUE
NOT_NULL KEY
Unique (to the table) Numeric ID
Contact_Method Table
Defines contact method types. The cm_template field is a command string that gets executed as a script (with environment variables set) by the notify subsystem.
  • SQL Name
    -- ct_mth
  • Object
    -- cmth
Field
Data Type
Reference
Remarks
cm_template
nvarchar(240)
Specifies the method template.
del
INTEGER
Active_Boolean_Table::enum
Identifies the Delete flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted)
id
INTEGER
Specifies the primary key of this table, this is also a unique, numeric ID.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Identifies the timestamp of when this record was last modified.
nx_desc
nvarchar(40)
Specifies the Contact method description.
persid
nvarchar(30)
Specifies the Persistent ID (SystemObjectName:id).
supports_smtp
INTEGER
Determines if the method supports SMTP email addresses.
sym
nvarchar(60)
Identifies the Contact method symbolic name.
write_file
INTEGER
Flag that indicates the following:
1
-- write output to the file
D_PAINTER Table
Tables to be used for Form Server and Screen Painter For the new GUI.
  • SQL Name
    -- D_PAINTER
Field
Data Type
Reference
Remarks
CNTLID
INTEGER
id of the control
CNTLTYPE
INTEGER
type of control
DDID
INTEGER
data dictionary id
ENTITYID
INTEGER
entity type
EXTRA_L1
INTEGER
user-definable
EXTRA_L2
INTEGER
user-definable
EXTRA_L3
INTEGER
user-definable
EXTRA_S1
STRING 50
user-definable
EXTRA_S2
STRING 50
user-definable
EXTRA_S3
STRING 50
user-definable
FORMGROUP
STRING 50
group in which the form is contained
FORMID
INTEGER
id number of the form
FORMNAME
STRING 50
name of the form
FORMTYPE
INTEGER
type of form
ID
INTEGER UNIQUE NOT_NULL KEY
key ID
MAPBACK
STRING 30
data dictionary owner
PARENTID
INTEGER
control id of parent control
PREDEFINED
INTEGER
0
-- Normal screen
2
-- Default screen
PROPLIST
STRING 1000
properties for the control
SECLEVEL
INTEGER
security level
TSTAMP
REAL
time stamp
Delegation_Server Table
List of servers that can be delegated from this one along with xport methods.
  • SQL Name
    -- dlgsrvr
  • Object
    -- dlgsrvr
Field
Data Type
Reference
Remarks
anon_userid
STRING 8
Specifies the anonymous userid.
appl_addr
STRING 48
Specifies the name or address of application.
default_assignee
UUID
ca_contact::uuid
Specifies the assignee for incoming tickets.
default_userid
STRING 8
Specifies the default userid.
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
UNIQUE
NOT_NULL KEY
Unique (to the table) Numeric ID
metafile
STRING 256
Specifies the path to conversion metafile def.
nx_desc
STRING 40
Specifies the description.
password
STRING 16
Specifies the server password.
server
STRING 128
Specifies the server name or ip address.
sym
STRING 64 UNIQUE NOT_NULL S_KEY
Specifies the system name.
transport
INTEGER
Controlled_Table Table
Program control table used by CA SDM applications.
  • SQL Name
    -- ctab
  • Object
    -- ctab
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_ Table::enum
Indicates the Deleted flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
Primary key to this table, it is a unique numeric ID.
nx_desc
nvarchar(40)
Specifies the Table description.
obj_name
nvarchar(30)
Specifies the Majic object name that corresponds to this table.
persid
nvarchar(30)
Persistent ID (SystemObjectName:id).
sym
nvarchar(30)
Represents the symbolic name of this controlled table.
EBR_SUFFIXES Table
Program control table used by Knowledge Management.
  • SQL Name
    -- EBR_SUFFIXES
  • Object
    -- EBR_SUFFIXES
Field
Data Type
Reference
Remarks
ID
INTEGER NOT_NULL KEY
Unique (to the table) Numeric ID
SUFFIX
STRING 50
Priority Table
List of Priority entries. The priority reflects the time-frame in which a ticket must be resolved. For the ticket, it represents the highest priority of any problem attached to the ticket. Problem priorities are derived from the scope (impact) and severity of the problem.
  • SQL Name
    -- pri
  • Object
    -- pri
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Deleted flag that indicates the following:
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER
Primary key of this table.
id
INTEGER
Specifies the unique (to the table) numeric ID.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Indicates the timestamp of when this record was last modified.
nx_desc
nvarchar(40)
Describes the priority.
service_type
nvarchar(30)
Service_Desc:: code
Classic Service Type. Foreign key to the code field of the srv_desc table.
sym
nvarchar(12)
Indicates the symbolic name for this priority.
Queued_Notify Table
Notifications that are queued due to workshifts are saved here.
  • SQL Name
    -- not_que
  • Object
    -- notque
Field
Data Type
Reference
Remarks
cmth_override
INTEGER
method over ride
context_instance
INTEGER 30
Contains the persistent ID of the associated Activity Log for the notifications
context_persid
STRING 30
Contains the persistent ID of object for notification
del
INTEGER NOT_NULL
Active_Boolean_Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
internal
INTEGER
internal notification
msg_ack
STRING 40
message acknowledgment
msg_body
STRING 1000
message text
msg_body_html
STRING 32768
message text
msg_title
STRING 40
Msg header text
notify_level
INTEGER
notification level
persid
STRING 30
Persistent ID (SystemObjectName:id)
transition_pt
INTEGER
transition point
Quick_Template_Types Table
Quick_Template_Types - Reference table for quick template types.
  • SQL Name
    -- quick_tpl_types
  • Object
    -- quick_tpl_types
Field
Data Type
Reference
Remarks
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER UNIQUE NOT_NULL
Enumerated value for this entry - specifies ordering in lists and relative values
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
nx_desc
STRING 40
Descriptive Info
persid
STRING 30
Persistent ID (SystemObjectName:id)
sym
STRING 30
Symbolic name of level
Remote_Ref Table
Remote References. Used for smart hooks. Determines what command to execute. Different command for UNIX and pc's using the same smart hook. Can apply security to smart hook.
  • SQL Name
    -- rem_ref
  • Object
    -- rrf
Field
Data Type
Reference
Remarks
description
STRING 500
Specifies the description of the command.
arch_type
STRING 12
Specifies the architecture to exec this on UNIX or PC. If empty, then all.
code
STRING 12 UNIQUE NOT_NULL S_KEY
Specifies the noneditable key for command.
del
INTEGER NOT_NULL
Active_Boolean_Table::enum
Deleted flag
0
-- Active
1 --
Inactive/marked as deleted
exec_str
STRING 500
Specifies the string to execute on UNIX.
function_group
STRING 30
Specifies the function group for security.
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
pcexec_str
STRING 500
Specifies the string to execute on pc.
sym
STRING 30 NOT_NULL
Specifies the name of command.
Response Table
Personalized response text used to simplify data entry when using the CA SDM applications.
  • SQL Name
    -- response
  • Object
    -- response
Field
Data Type
Reference
Remarks
chg_flag
INTEGER S_KEY
cr_flag
INTEGER S_KEY
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
in_flag
INTEGER S_KEY
iss_flag
INTEGER S_KEY
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
persid
STRING 30
Persistent ID (SystemObjectName:id)
pr_flag
INTEGER S_KEY
response
STRING 1000
response text
response_owner
UUID S_KEY
ca_contact::uuid
response owner
sym
STRING 50 NOT_NULL S_KEY
symbol
Rootcause Table
Reference table to denote the rootcause type used when resolving or closing a request, change order, or issue.
  • SQL Name
    -- rootcause
  • Object
    -- rc
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag as follows:
0
-- Active
1
-- Inactive/marked as deleted
description
nvarchar(240)
Provides a textual description of this root cause.
id
INTEGER
Primary key of this table.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
Persistent ID (SystemObjectName:id).
sym
nvarchar(60)
Identifies the symbolic value for this Rootcause.
Rpt_Meth Table
Reporting methods used to display information within the CA SDM applications.
  • SQL Name
    -- rptmth
  • Object
    -- rptm
Field
Data Type
Reference
Remarks
description
STRING 80
Specifies the textual description of this reporting method.
def_pg_len
STRING 80
Specifies the page length default.
default_out
STRING 80
Specifies the output default.
del
INTEGER NOT_NULL
Active_Boolean_Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
is_default
INTEGER
If set, this specifies the default reporting method.
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
script
STRING 1000
sym
STRING 30 NOT_NULL
Reporting_Method Table
Reference table to denote how the contact with the customer occurred. Example: email, phone.
  • SQL Name
    -- repmeth
  • Object
    -- rptmeth
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag as follows:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
Primary key of this table.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
Persistent ID (SystemObjectName:id).
sym
nvarchar(60)
Identifies the symbolic value for this Reporting Method.
Note_Board Table
Message board (announcements) on the main menu.
  • SQL Name
    -- cnote
  • Object
    -- cnote
Field
Data Type
Reference
Remarks
active_flag
INTEGER NOT_NULL
Boolean_Table:: enum
0
-- Inactive
1
-- Active
close_date
LOCAL_TIME
Indicates when closed
cnote_type
INTEGER
Indicates the announcement type
control_group
UUID
Specifies the group to display to
del
INTEGER
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
internal
INTEGER
Internal Flag
loc_id
UUID
ca_location:: location_uuid
Indicates a pointer to location
organization
UUID
ca_organization ::organization_ uuid
Indicates a pointer to Organization
persid
STRING 30
Persistent ID (SystemObjectName:id)
posted_by
UUID
ca_contact::uuid
Specifies who posted the announcement
posted_date
LOCAL_TIME
Indicates the last modify time
text
STRING 4000
Indicates the message text
Prob_Category Table
Call Request call areas. Category of the issue that the customer is calling about. Can be hierarchical.
  • SQL Name
    -- prob_ctg
  • Object
    -- pcat
Field
Data Type
Reference
Remarks
id
INTEGER
UNIQUE NOT_NULL KEY
Unique (to the table) numeric ID.
persid
STRING (30)
Persistent ID (SystemObjectName:id)
del
INTEGER
NOT_NULL
Delete flag that indicates the following:
0
-- Active
1
-- Inactive/marked as deleted
sym
STRING (1000)
NOT_NULL S_KEY
Specifies the symbolic name of the request area.
last_mod_dt
LOCAL_TIME
Identifies the timestamp of when this record was last modified.
last_mod_by
UUID
ca_contact
Specifies the UUID of the contact who last modified this record.
description
STRING (500)
Identifies the textual description of the call area.
organization
UUID
ca_organization
Foreign key to the id field of the ca_organization table, this is the Organization.
assignee
UUID
ca_contact
Foreign key to the contact_uuid field of the ca_contact table, this is the Assignee.
group_id
UUID
ca_contact
Foreign key to the contact_uuid field of the ca_contact table, this is the Group.
tcode
INTEGER
Deprecated
service_type
STRING (30)
Service_Desc
Foreign key to the code field of the srv_desc table, this is the Classic Service Type.
survey
INTEGER
Survey_Template
Foreign key of the id field of the survey_tpl table, this is the Survey.
schedule
INTEGER
Bop_Workshift
Deprecated
auto_assign
INTEGER
Represents the flag that enables auto assignment.
owning_contract
INTEGER
Service_Contract
Foreign key to the id field of the svc_contract table.This is the Service Contract.
cr_flag
INTEGER
Represents the cr_flag status. When set to 1, this status is valid for requests.
in_flag
INTEGER
Specifies the Incident flag. When set to 1, the status is valid for Incidents.
pr_flag
INTEGER
Specifies the Problem flag. When set to 1, the status is valid for Problems.
suggest_knowledge
INTEGER
Specifies whether or not to suggest knowledge to users.
1
-- Suggest knowledge.
2
-- Do not suggest knowledge.
assignable_ci_attr
STRING (60)
Identifies the name of the attribute on a CI object that contains the grp contact that should be used to perform Category/CI auto group assignment.
flow_flag
INTEGER
Specifies the type of workflow:
0
-- Classic Workflow or none (default)
2
-- CA IT PAM
caextwf_start_id
INTEGER
caextwf_start_forms
Identifies the CA IT PAM process definition information to use when the user selects this category on a change order, issue, request.
tenant
UUID
ca_contact
ss_include
INTEGER
Required.
On new default: 0
ss_sym
STRING (128)
category_urgency
INTEGER
Urgency
sap_prop
INTEGER
Product Table
Reference table to denote the product that the complaint relates to.
  • SQL Name
    -- product
  • Object
    -- prod
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_ Table::enum
Delete flag that indicates the following:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
Primary key of this table.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
Persistent ID (SystemObjectName:id).
sym
nvarchar(60)
Specifies the symbolic value for this Product.
sa_agent_availability Table
Program control table used by Support Automation.
  • SQL Name
    -- sa_agent_availability
  • Object
    -- sa_agent_availability
Field
Data Type
Reference
Remarks
id
INTEGER
KEY
agentID
UUID
ca_contact
NOT_NULL
queueID
INTEGER
sa_queue
NOT_NULL
status
INTEGER
availEpoch
LOCAL_TIME
clientSessionID
INTEGER
sa_login_session
matchEpoch
LOCAL_TIME
groupID
INTEGER
sa_group
incidentCount
INTEGER
last_mod_by
UUID
cnt
Specifies the UUID of the contact who last modified this record.
last_mod_dt
DATE
Specifies the timestamp of when this record was last modified.
tenant
UUID
ca_tenant
Specifies the UUID of the tenant.
Table_Name Table
Table name list used by CA SDM applications.
  • SQL Name
    -- tn
Field
Data Type
Reference
Remarks
del
INTEGER NOT_NULL
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
Unique (to the table) Numeric ID
tn_desc
STRING 240
description or table
tn_dflt
STRING 30
default external name
tn_name
STRING 30
user name for table
tn_sys
STRING 30 S_KEY
system name
usp_special_handling Table
The usp_special_handling table defines the characteristics of each special handling classification.
Attribute
Data Type
SREL References
Flags
alert_icon_url
STRING 1000
alert_text
STRING 60
autodisplay_notes
INTEGER
del
INTEGER
NOT_NULL
description
STRING 4000
escalate_urgency
INTEGER
id
INTEGER
UNIQUE NOT_NULL KEY
last_mod_by
UUID
ca_contact
last_mod_dt
LOCAL_TIME
sym
STRING 60
NOT_NULL
tenant
UUID
ca_tenant
usp_symptom_code Table
The usp_symptom_code table associates codes with a special handling classification.
Attribute
Data Type
SREL References
Flags
del
INTEGER
NOT_NULL
description
STRING 4000
id
INTEGER
UNIQUE NOT_NULL KEY
last_mod_by
UUID
ca_contact
last_mod_dt
LOCAL_TIME
sym
STRING 60
NOT NULL
tenant
UUID
ca_tenant
usp_tab Table
Information on Tabs used in the Role Based UI.
  • SQL Name
    -- usp_tab
  • Object
    -- tab
Field
Data Type
Reference
Remarks
id
INTEGER
Specifies the unique (to the table) numeric ID.
name
STRING (80)
Tab Name
display_name
STRING (80)
Text displayed on tab
code
STRING 30
Code
del
INTEGER
Active_
Boolean_
Table::enum
description
STRING (255)
Description
menu_bar_obj
INTEGER
usp_menu_bar::id
Foreign key to the menu bar id field of the usp_menu_bar table.
web_form_obj
INTEGER
web_form::id
Foreign key to the web form id field of the usp_web_form table.
usp_ticket_type Table
The usp_ticket_type table lists the ticket types referenced by Action Object drop-down list (action_object) in the usp_mailbox_rule table.
Field
Data Type
Description
id
INTEGER UNIQUE KEY
Specifies the primary key of this table.
allow_mailbox
INTEGER
code
STRING 30 UNIQUE S_KEY
Specifies the REL_ATTR value of the table, and the distinct keyword for each ticket type that is recognized by some components
del
INTEGER
sym
STRING 60
Specifies the symbolic value for the ticket type.
ticket_object
STRING 30
Specifies the Majic object for the ticket (cr, chg, or iss).
ticket_object_type
STRING 1
Specifies the Call_Request_Type field (R, I or P) for the cr object.
The following values are the defaults for the usp_ticket_type table:
id
code
sym
ticket_obj
ticket_obj_type
100
REQUEST
Request
cr
R
200
INCIDENT
Incident
cr
I
300
PROBLEM
Problem
cr
P
400
CHANGE
Change
chg
500
ISSUE
Issue
iss
usp_web_form Table
Information on Web Forms used in the Role Based UI.
  • SQL Name
    -- usp_web_form
  • Object
    -- web_form
Field
Data Type
Reference
Remarks
id
INTEGER
Specifies the unique (to the table) numeric ID.
name
STRING (80)
Tab Name
code
STRING 30
Code
del
INTEGER
Active_Boolean_
Table::enum
description
STRING (255)
Description
wf_resource
STRING (1024)
The URL to display the HTMPL form, Report, Go button resource or third party form.
wf_type
INTEGER
The type of the web form:
0
-- HTMPL
1
-- Report
2
-- Go Resource
3
-- Other
dflt_for_obj
STRING 30
For Go Resource type web forms only. Indicates that this Go Resource will override the role's default when displaying objects of this type (such as "Request", "Issue", "Change Order"). Only one Go Resource can be assigned a dflt_for_obj for each type.
usp_attr_control Table
A dependent_control object specifies the attribute name and locked or required value that activates dependent control.
  • SQL Name
    -- usp_attr_control
  • Object
    -- att_control
Attribute
DB Field
Data Type
SREL References
Flags
id
id
INTEGER
UNIQUE REQUIRED KEY
control
control
INTEGER REF
usp_dependent_control
attrname
attrname
STRING 64
Identifies attribute name.
locked
locked
INTEGER
Identifies locked attribute.
required
required
INTEGER
Identifies required attribute.
last_mod_dt
last_mod_dt
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
last_mod_by
last_mod_by
UUID REF
ca_contact
Specifies the UUID of the contact who last modified this record.
del
INTEGER
nn
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
tenant
UUID REF
ca_tenant
usp_auto_close Table
The auto close object controls the automatic closure of a ticket (request, incident, problem, change order, issue). The usp_auto_close table lists the automatic closure settings. For each ticket type, you can define the number of business hours before the closure takes place. By definition, zero hours means that automatic closure is not implemented for the ticket type.
In an untenanted system only one active row is allowed in this table.
In a tenanted system, each tenant can have its own row and only one row is permitted. In addition, one active Public row is permitted for tenants that do not have a tenanted row. If a tenant does not have its own row of auto-close settings, and there is not an active Public row, the automatic closure feature is disabled for that tenant.
  • SQL Name
    -- usp_auto_close
  • Object
    -- auto_close
Label
Field
Description
id
INTEGER
Unique key
sym
STRING 80
cr_ach
INTEGER
in_ach
INTEGER
pr_ach
INTEGER
chg_ach
INTEGER
iss_ach
INTEGER
description
STRING 255
last_mod_dt
LOCAL_TIME
last_mod_by
UUID REF
ca_tenant
del
INTEGER
nn
tenant
UUID REF
ca_tenant
usp_ci_window Table
The usp_ci_window table stores the associations between windows and configuration items.
  • SQL Name
    -- usp_ci_window
  • Object
    -- ci_window
Attribute
Data Type
SREL References
id
nr_uuid
UUID
nr (object)
Window_id
ID
window (object)
producer_id
STRING
persistent_id
STRING
last_mod_by
SREL
cnt.id
last_mod_dt
DATE
usp_email_type Table
The usp_email_type table lists the email types that are available for the Email Type drop-down list (email_type) in the usp_mailbox table.
Field
Data Type
Description
id
INTEGER UNIQUE KEY
Specifies the primary key of this table.
code
STRING 30 UNIQUE S_KEY
Specifies the code value for the email type.
del
INTEGER
incoming
INTEGER
Specifies whether the email type is incoming or outgoing.
sym
STRING 60
Specifies the symbolic value for the email type.
The following values are the defaults for the usp_email_type table:
id
code
incoming
sym
100
NONE
1
NONE
200
IMAP
1
IMAP
300
POP3
1
POP3
400
SMTP
0
SMTP
usp_export_list_format Table
The usp_export_list_format table lists the file format that is used to export list results outside of CA Service Desk Manager.
  • SQL Name
    -- usp_export_list_format
  • Object
    -- usp_exlist_format
Label
Field
Description
id
INTEGER
Unique (to the table) Numeric ID.
file_extention
STRING
Specifies the active file format to export search list results. Excel (.xls) is currently supported.
mime_type
STRING
Specifies the internet media type.
xslt_name
STRING
Specifies the XSL file name on the server.
sym
STRING
Specifies the export file format.
delete_flag
INTEGER
Delete indicator.
usp_ical_alarm Table
  • SQL Name
    -- usp_ical_alarm
  • Object
    -- ical_alarm
Field
Data Type
Reference
Remarks
id
INTEGER
Unique key
del
INTEGER
alarm_value
STRING 120
sym
STRING 60
last_mod_dt
LOCAL_TIME
last_mod_by
UUID REF
ca_contact
usp_ical_event_template Table
  • SQL Name
    -- usp_ical_event_template
  • Object
    -- ical_event_template
Field
Data Type
Reference
id
INTEGER
Unique key
del
INTEGER
NOT_NULL
obj_type
STRING 30
NOT_NULL
code
STRING 60
NOT_NULL
sym
STRING 60
NOT_NULL
start_date
STRING 30
NOT_NULL
end_date
STRING 30
alarm
INTEGER
usp_ical_alarm
categories
STRING 128
summary
STRING 240
description
STRING 4000
url
STRING 4000
extra_entries
STRING 4000
last_mod_dt
LOCAL_TIME
last_mod_by
UUID
ca_contact
usp_owned_resource Table
Holds information about the owned resource.
  • SQL Name
    -- usp_owned_resource
  • Object
    -- usp_owned_resource
Attribute
DB Field
Data Type
SREL References
Flags
argis_id
nr_argis_id
STRING
assoc_projex
assoc_projex
BREL
projex.id
audit_userid
audit_userid
LOCAL SREL
cnt
assoc_in
assoc_in
QREL
cr
assoc_pr
assoc_pr
QREL
cr
bm_rep
nr_bm_rep
INTEGER
busrep id
bm_label
nr_bmlabel
STRING
bm_macro_smag
bm_macro_smag
LOCAL STRING 0
bm_status
nr_bms
INTEGER
busstat status_no
expiration_date
nr_exp_dt
LOCAL_TIME
financial_num
nr_financial_id
STRING
nsm_id
nsm_id
STRING 40
contact_1
nr_nx_ref_1
UUID
ca_contact uuid
contact_2
nr_nx_ref_2
UUID
ca_contact uuid
contact_3
nr_nx_ref_3
UUID
ca_contact uuid
linked_id_usp_ owned_resource
linked_id_usp_ owned_resource
UUID
smag_1
nr_nx_string1
STRING
smag_2
nr_nx_string2
STRING
smag_3
nr_nx_string3
STRING
smag_4
nr_nx_string4
STRING
smag_5
nr_nx_string5
STRING
smag_6
nr_nx_string6
STRING
priority
nr_pr_id
INTEGER
pri enum
name_type
nr_prim_skt_id
INTEGER
service_type
nr_service_type
STRING
srv_desc code
sla
nr_sla_id
INTEGER
warranty_end
nr_wrty_end_dt
LOCAL_TIME
warranty_start
nr_wrty_st_dt
LOCAL_TIME
id
owned_resource_uuid
UUID
USP_Preferences Table
Holds information about the CA SDM and Knowledge Management application preferences.
  • SQL Name
    -- usp_preferences
  • Object
    -- usp_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
usp_pri_cal Table
Stores priority calculation data.
  • SQL Name
    -- usp_pri_cal
  • Object
    -- pri_cal
Field
Data Type
Reference
Remarks
id
INTEGER
UNIQUE NOT_NULL KEY
name
STRING 80
NOT_NULL UNIQUE NOT_NULL S_KEY
description
STRING 1024
del
INTEGER
NOT_NULL
in_flag
INTEGER
Boolean_Table
pr_flag
INTEGER
Boolean_Table
imp_def
INTEGER
Impact
urg_def
INTEGER
Urgency
ci_imp
INTEGER
Boolean_Table
cat_urg
INTEGER
Boolean_Table
bk_window
INTEGER
cnt_vip
INTEGER
pri_5_4
INTEGER
Priority
pri_5_3
INTEGER
Priority
pri_5_2
INTEGER
Priority
pri_5_1
INTEGER
Priority
pri_5_0
INTEGER
Priority
pri_4_4
INTEGER
Priority
pri_4_3
INTEGER
Priority
pri_4_2
INTEGER
Priority
pri_4_1
INTEGER
Priority
pri_4_0
INTEGER
Priority
pri_3_4
INTEGER
Priority
pri_3_3
INTEGER
Priority
pri_3_2
INTEGER
Priority
pri_3_1
INTEGER
Priority
pri_3_0
INTEGER
Priority
pri_2_4
INTEGER
Priority
pri_2_3
INTEGER
Priority
pri_2_2
INTEGER
Priority
pri_2_1
INTEGER
Priority
pri_2_0
INTEGER
Priority
pri_1_4
INTEGER
Priority
pri_1_3
INTEGER
Priority
pri_1_2
INTEGER
Priority
pri_1_1
INTEGER
Priority
pri_1_0
INTEGER
Priority
pri_0_4
INTEGER
Priority
pri_0_3
INTEGER
Priority
pri_0_2
INTEGER
Priority
pri_0_1
INTEGER
Priority
pri_0_0
INTEGER
Priority
cap_reason
INTEGER
Boolean_Table
last_mod_dt
LOCAL_TIME
last_mod_by
UUID
ca_contact
tenant
UUID
ca_tenant
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
Reference
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.
usp_notification_phrase Table
The usp_notification_phrase table lists common phrases that notification message templates can use.
  • S QL Name
    -- usp_notification_phrase
  • Object
    -- notification_phrase
Field
Data Type
References
Description
id
INTEGER UNIQUE KEY
Specifies the primary key of this table.
del
INTEGER REF
last_mod_dt
LOCAL_TIME
Specifies the time stamp of when this record was last modified.
last_mod_by
UUID REF
ca_contact
Specifies the UUID of the contact who last modified this record.
code
STRING UNIQUE S_KEY
Specifies the code name for the notification phrase that identifies the specific phrase when referenced in other text.
sym
STRING
Specifies the display name for the notification phrase.
description
STRING
Describes the notification phrase.
phrase
STRING
Specifies the phrase text to use for notification.
usp_organization Table
This table provides extensions to the ca_organization table that are used only by CA SDM products.
  • SQL Name
    -- usp_organization
  • Object
    -- org
Field
Data Type
Reference
Remarks
iorg_assigned_svr
INTEGER
Deprecated.
iorg_service_type
nvarchar(30)
Service_Desc::code
Foreign key to the code field of the srv_desc table, this is the Classic Service Type.
last_mod
INTEGER
Indicates the timestamp of when this record was last modified.
organization_uuid
byte(16)
Primary key. Unique identifier.
owning_contract
INTEGER
Service_Contract::id
Identifies the unique (to the table) numeric ID.
Form_Group Table
Listing of defined form groups.
  • SQL Name
    -- fmgrp
  • Object
    -- fmgrp
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted
description
nvarchar(100)
Specifies the textual description of this form group.
id
INTEGER
Primary key of this table, it is a unique, numeric ID.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
Indicates the timestamp of when this record was last modified.
sym
nvarchar(30)
Specifies the symbolic value for this Form_Group.
True_False_Table Table
Contains localized True or False strings that display on the UI.
  • SQL Name
    -- True_False_Table
  • Object
    -- true_false
Field
Data Type
Reference
Remarks
id
INTEGER
UNIQUE NOT_NULL KEY Unique to the table Numeric ID.
del
INTEGER
NOT_NULL Deleted flag:
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER
NOT_NULL Enumerated value for this entry
0
-- False
1
-- True
sym
STRING 60
UNIQUE NOT_NULL S_KEY Identifies the symbolic value for this target
desc
STRING 40
Describes the enum