Data Element Dictionary

Data Element Dictionary

This chapter contains 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 (UNIX) or installation‑directory\site directory (Windows) for the most current list of all database tables for your specific installation.

Important! 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.

This section contains the following topics:

Access_Levels Table

Access_Type_v2 Table

Act_Type_Assoc Table

Active_Boolean_Table Table

Active_Reverse_Boolean_Table Table

admin_tree Table

Am_Asset_Map Table

Archive_Purge_History Table

Archive_Purge_Rule Table

Asset_Assignment Table

Atomic_Condition Table

Attached_Events Table

Attached_SLA Table

Attachment Table

attmnt_folder Table

Attribute_Name Table

Audit_Log Table

Behavior_Template Table

Boolean_Table Table

Bop_Workshift Table

Business_Management_Repository Table

ca_asset_type Table

ca_company Table

ca_company_type Table

ca_contact Table

ca_contact_type Table

ca_country Table

ca_job_function Table

ca_job_title Table

ca_location Table

ca_model_def Table

ca_organization Table

ca_owned_resource Table

ca_resource_class Table

ca_resource_cost_center Table

ca_resource_department Table

ca_resource_family Table

ca_resource_gl_code Table

ca_resource_operating_system Table

ca_resource_status Table

ca_state_province Table

ca_tenant Table

ca_tenant_group Table

ca_tenant_group_member Table

Call_Req_Type Table

Call_Solution Table

Change_Act_Log Table

Change_Category Table

Change_Request Table

Change_Status Table

Chg_Template Table

chg_trans Table

CI_ACTIONS Table

CI_ACTIONS_ALTERNATE Table

CI_BOOKMARKS Table

CI_DOC_LINKS Table

CI_DOC_TEMPLATES Table

CI_DOC_TYPES Table

ci_managed_attribute Table

ci_managed_chgstat Table

ci_planned_change Table

ci_planned_change_status Table

CI_PRIORITIES Table

CI_STATUSES Table

ci_verification_policy Table

ci_verification_policy_act Table

ci_verification_policy_log Table

ci_verification_twa_act Table

CI_WF_TEMPLATES Table

Column_Name Table

Contact_Method Table

Controlled_Table Table

Cr_Call_Timers Table

Cr_Status Table

Cr_Stored_Queries Table

Cr_Template Table

D_PAINTER Table

Delegation_Server Table

Doc_Versions Table

Document_Repository Table

Domain_Constraint Table

Domain_Constraint_Type Table

EBR_ACRONYMS Table

EBR_DICTIONARY Table

EBR_DICTIONARY_ADM Table

EBR_FULLTEXT Table

EBR_FULLTEXT_ADM Table

EBR_FULLTEXT_SD Table

EBR_FULLTEXT_SD_ADM Table

EBR_INDEX Table

EBR_INDEX_ADM Table

EBR_INDEXING_QUEUE Table

EBR_KEYWORDS Table

EBR_METRICS Table

EBR_NOISE_WORDS Table

EBR_PATTERNS Table

EBR_PREFIXES Table

EBR_PROPERTIES Table

EBR_SUBSTITS Table

EBR_SUFFIXES Table

EBR_SYNONYMS Table

EBR_SYNONYMS_ADM Table

ES_CONSTANTS Table

ES_RESPONSES Table

ES_SESSIONS Table

Event_Delay Table

Event_Delay_Type Table

event_log Table

event_type Table

External_Entity_Map Table

Form_Group Table

Global_Change_Extension Table

Global_Change_Queue Table

Global_Contact Table

Global_Issue_Extension Table

Global_Issue_Queue Table

Global_Location Table

Global_Organization Table

Global_Product Table

Global_Queue_Names Table

Global_Request_Extension Table

Global_Request_Queue Table

Global_Servers Table

Usp_Servers Table

Global_Table_Map Table

Global_Table_Rule Table

Group_Member Table

Index_Doc_Links Table

Interface Table

iss_Template Table

iss_trans Table

Issue_Act_Log Table

Issue_Category Table

Issue_Property Table

Issue_Status Table

Issue_Workflow_Task Table

KEIT_TEMPLATES Table

Key_Control Table

Knowledge_Keywords Table

KT_act_content Table

KT_Blc_Type Table

KT_Flg_Status Table

KT_Flg_Type Table

KT_Life_Cycle_Rep Table

KT_REPORT_CARD Table

LONG_TEXTS Table

Managed_Survey Table

Mgs_Act_Log Table

Mgs_Status Table

Note_Board Table

Notification Table

Notification_Urgency Table

Notify_Log_Header Table

Notify_Msg_Tpl Table

Notify_Object_Attr Table

Notify_Rule Table

NR_Comment Table

O_COMMENTS Table

O_INDEXES Table

Person_Contacting Table

Prob_Category Table

Property_Template Table

Property_Validation_Rule Table

Property_Validation_Type Table

Property_Value Table

Query_Policy Table

Query_Policy_Actions Table

Queued_Notify Table

Quick_Template_Types Table

Remote_Ref Table

Reporting_Method Table

Req_Property Table

Req_Property_Template Table

Reverse_Boolean_Table Table

Rootcause Table

sa_agent_availability Table

sa_agent_consult_history Table

sa_agent_present_history Table

sa_agent_status_history Table

sa_alert_config_param Table

sa_art_tool_avail Table

sa_bin_temp Table

sa_branding Table

sa_chat_preset Table

sa_chat_preset_agent_cat Table

sa_chat_preset_cat_loc Table

sa_chat_preset_category Table

sa_chat_preset_localized Table

sa_chat_preset_type Table

sa_comm_temp Table

sa_cr_template Table

sa_custom_category Table

sa_data_routing_server Table

sa_datapool_channel Table

sa_datapool_channel_user Table

sa_default_credential Table

sa_direct_session Table

sa_direct_session_page Table

sa_direct_session_preset Table

sa_disclaimer Table

sa_disclaimer_accept_log Table

sa_disclaimer_history Table

sa_disclaimer_localized Table

sa_display_template_loc Table

sa_division_login_script Table

sa_division_role_join Table

sa_division_tool_join Table

sa_event_history Table

sa_event_history_param Table

sa_event_type Table

sa_event_type_param Table

sa_field_type Table

sa_flow_control_rule Table

sa_function_arg Table

sa_group_current_user Table

sa_group_event_join Table

sa_group_history Table

sa_group_tool_invocation Table

sa_guest_agent_code Table

sa_guest_profile Table

sa_guest_user_field Table

sa_hour_operation_mode Table

sa_iss_template Table

sa_keyword Table

sa_keyword_queue_join Table

sa_large_data_record Table

sa_lib_function Table

sa_localization Table

sa_login_session Table

sa_milepost Table

sa_milepost_history Table

sa_named_user_license Table

sa_patch_history Table

SA_Policy Table

sa_portal_component Table

SA_Prob_Type Table

sa_property Table

sa_queue_hour_setting Table

sa_queue_localized Table

sa_queue_summary_field Table

sa_queue_tool_join Table

sa_queue_transfer_target Table

sa_queued_group Table

sa_queued_user Table

sa_rejoin_code_mapping Table

sa_role_queue_join Table

sa_role_tool_join Table

sa_role_tool_non_art_join Table

sa_rule_conduit_rule Table

sa_script Table

sa_script_acquired_data Table

sa_script_exec_log_join Table

sa_script_exec_status Table

sa_script_execution_log Table

sa_script_function_lib Table

sa_script_group Table

sa_script_role_join Table

sa_script_security_join Table

sa_script_user_field Table

sa_scriptlib Table

sa_scriptlib_language Table

sa_sd_user_map Table

sa_sdconfig Table

sa_sdgroup_map Table

sa_sdsession_ticket_map Table

sa_security_group Table

sa_security_group_dir Table

sa_security_group_function Table

sa_security_group_loc Table

sa_security_grp_role_join Table

sa_security_login_function Table

sa_security_request_order Table

sa_security_text_localized Table

sa_security_tool_function Table

sa_security_tool_localized Table

sa_security_user_directory Table

sa_self_serve_event_join Table

sa_self_serve_keyword Table

sa_self_serve_login_field Table

sa_session_event_join Table

sa_session_login_field Table

sa_session_security_info Table

sa_static_cont_script_join Table

sa_static_content Table

sa_sup_desk_hour_config Table

sa_survey Table

sa_survey_localized Table

sa_survey_result Table

sa_system_message Table

sa_system_property Table

sa_tenant_localization Table

sa_tool_inst_log_evt_join Table

sa_tool_instance Table

sa_tool_instance_log Table

sa_tool_log Table

sa_tool_log_message Table

sa_tool_module Table

sa_tool_name_localized Table

sa_tool_non_art Table

sa_tool_property Table

sa_tool_start_message Table

sa_tool_version Table

sa_triage_script Table

sa_user_alert_config Table

sa_user_route Table

sa_user_route_prop Table

sa_userdrserver_join Table

sa_version Table

sa_virtual_session Table

sa_wait_component Table

sa_wait_component_type Table

Sequence_Control Table

Server_Aliases Table

Server_Zones Table

Service_Contract Table

Service_Desc Table

session_log Table

session_type Table

Skeletons Table

SLA_Contract_Map Table

SLA_Template Table

Spell_Macro Table

Spell_Macro_Type Table

SQL_Script Table

Survey_Answer Table

Survey_Answer_Template Table

Survey_Question Table

Survey_Question_Template Table

Survey_Stats Table

Survey_Template Table

Survey_Tracking Table

Table_Name Table

target_tgttpls_srvtypes Table

target_time Table

target_time_tpl Table

Task_Status Table

Task_Type Table

Transition_Points Table

Transition_Types Table

True_False_Table Table

Type_Of_Contact Table

User_Query Table

usp_acctyp_role Table

usp_attr_control Table

usp_auto_close Table

usp_caextwf_instances Table

usp_caextwf_start_forms Table

usp_ci_window Table

usp_contact Table

usp_contact_handling Table

usp_credentials_Table

usp_email_type Table

usp_export_list_format Table

usp_functional_access Table

usp_functional_access_level Table

usp_functional_access_role Table

usp_functional_access_type Table

usp_ical_alarm Table

usp_ical_event_template Table

usp_kpi_data Table

usp_kpi_ticket_data Table

usp_lrel_asset_chgnr Table

usp_lrel_asset_issnr Table

usp_lrel_att_cntlist_macro_ntf Table

usp_lrel_att_ctplist_macro_ntf Table

usp_lrel_att_ntflist_macro_ntf Table

usp_lrel_attachments_changes Table

usp_lrel_attachments_issues Table

usp_lrel_attachments_requests Table

usp_lrel_aty_events Table

usp_lrel_bm_reps_assets Table

usp_lrel_bm_reps_bmhiers Table

usp_lrel_cenv_cntref Table

usp_lrel_dist_cntlist_mgs_ntf Table

usp_lrel_dist_ctplist_mgs_ntf Table

usp_lrel_dist_ntflist_mgs_ntf Table

usp_lrel_false_action_act_f Table

usp_lrel_false_bhv_false Table

usp_lrel_kwrds_crsolref Table

usp_lrel_notify_list_cntchgntf Table

usp_lrel_notify_list_cntissntf Table

usp_lrel_notify_list_cntntf Table

usp_lrel_ntfr_cntlist_att_ntfrlist Table

usp_lrel_ntfr_ctplist_att_ntfrlist Table

usp_lrel_ntfr_macrolist_att_ntfrlist Table

usp_lrel_ntfr_ntflist_att_ntfrlist Table

usp_lrel_oenv_orgref Table

usp_lrel_status_codes_tsktypes Table

usp_lrel_svc_grps_svc_chgcat Table

usp_lrel_svc_grps_svc_isscat Table

usp_lrel_svc_grps_svc_pcat Table

usp_lrel_svc_grps_svc_wftpl Table

usp_lrel_svc_locs_svc_chgcat Table

usp_lrel_svc_locs_svc_groups Table

usp_lrel_svc_locs_svc_isscat Table

usp_lrel_svc_locs_svc_pcat Table

usp_lrel_svc_schedules_chgcat_svc Table

usp_lrel_svc_schedules_isscat_svc Table

usp_lrel_svc_schedules_pcat_svc Table

usp_lrel_true_action_act_t Table

usp_lrel_true_bhv_true Table

usp_mailbox Table

usp_mailbox_artifact_type Table

usp_mailbox_rule Table

usp_mailbox_violation_log_type Table

usp_mb_rule_action_type Table

usp_mb_rule_filter_type Table

usp_mb_rule_subject_handling Table

usp_menu_bar Table

usp_menu_tree Table

usp_menu_tree_name Table

usp_menu_tree_res Table

usp_notification_phrase Table

usp_organization Table

usp_outage_reason Table

usp_outage_type Table

usp_owned_resource Table

USP_Preferences Table

usp_pri_cal Table

usp_properties Table

usp_resolution_code Table

usp_resolution_method Table

usp_rest_access Table

usp_role_go_form Table

usp_role_tab Table

usp_role_web_form Table

usp_special_handling Table

usp_symptom_code Table

usp_ticket_type Table

usp_web_form Table

usp_window Table

usp_window_type Table

Workflow_Task Table

Workflow_Task_Template Table

Copyright © 2013 CA. All rights reserved.