Dictionnaire des éléments de données

Dictionnaire des éléments de données

Ce chapitre contient les définitions des tables de la base de données CA SDM. Les tables se trouvent dans les fichiers de schéma (.sch). Consultez le fichier ddict.sch situé dans le répertoire $NX_ROOT/site (UNIX) ou le répertoire‑ d'installation/site (Windows) pour obtenir la liste de toutes les tables de la base de données de votre installation.

Important : Plusieurs tables parmi celles indiquées dans cette section sont obsolètes et sont conservées uniquement pour assurer la rétrocompatibilité ou en vue de leur utilisation ultérieure. Il est toutefois important de ne pas les supprimer (ni aucune autre table) du schéma de base de données. Vous pouvez ajouter de nouvelles tables, ou encore ajouter des champs/colonnes dans des tables existantes, mais vous ne pouvez en aucun cas supprimer les tables. Compte tenu que de nombreuses applications accèdent à la base de données gérée (mdb), la suppression ou la modification de tables ou de champs pourrait perturber le fonctionnement de certaines applications. Veillez à vous conformer aux méthodes recommandées pour les modifications de schéma prises en charge en utilisant l'outil Web Screen Painter.

Ce chapitre traite des sujets suivants :

Table 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

ca_tenant Table

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

Tale 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 de notification

Table Notification_Urgency

Table Notify_Log_Header

Table Notify_Msg_Tpl

Table Notify_Objet_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

Copyright © 2013 CA. Tous droits réservés.