Rubrique précédente: Nom SQL vers table et objetRubrique suivante: Table de la liste d'objet CA SDM pour l'hébergement multiclient


Objet vers table et nom SQL

Ce tableau fournit une référence croisée de chaque objet vers ses noms de table et SQL correspondants dans le schéma de base de données :

Object

Tableau

Nom SQL (AKA)

acc_lvls

Access_Levels

acc_lvls

acctyp

Access_Type_v2

acctyp_v2

act_type_assoc

Act_Type_Assoc

atyp_asc

actbool

Active_Boolean_Table

actbool

actrbool

Active_Reverse_Boolean_Table

actrbool

ADMIN_TREE

admin_tree

admin_tree

alg

Act_Log

act_Log

am_asset_map

Am_Asset_Map

am_map

ANI

Animator

anima

arcpur_hist

Archive_Purge_History

arcpur_hist

arcpur_rule

Archive_Purge_Rule

arcpur_rule

atev

Attached_Events

att_evt

atomic_cond

Atomic_Condition

atomic_cond

attached_sla

Attached_SLA

attached_sla

attmnt

Attachment

attmnt

attmnt_folder

attmnt_folder

attmnt_folder

aty

Act_Type

act_Type

audlog

Audit_Log

audit_log

bhvtpl

Behavior_Template

bhvtpl

bmcls

Business_Management_Class

buscls

bmhier

Business_Management

busmgt

bmrep

Business_Management_Repository

busrep

bms

Business_Management_Status

busstat

Booléen

Boolean_Table

bool_tab

BU_TRANS

BU_TRANS

BU_TRANS

Société CA

ca_company

ca_company

caextwf_inst

usp_caextwf_instances

usp_caextwf_instances

caextwf_sfrm

usp_caextwf_start_forms

usp_caextwf_start_forms

chg

Change_Request

chg

chg_tpl

Chg_Template

chg_template

chgalg

Table Change_Act_Log

chgalg

chgcat

Change_Category

chgcat

chgstat

Change_Status

chgstat

CI_ACTIONS

CI_ACTIONS

CI_ACTIONS

CI_ACTIONS_ALTERNATE

CI_ACTIONS_ALTERNATE

CI_ACTIONS_ALTERNATE

CI_BOOKMARKS

CI_BOOKMARKS

CI_BOOKMARKS

CI_DOC_LINKS

CI_DOC_LINKS

CI_DOC_LINKS

CI_DOC_TEMPLATES

CI_DOC_TEMPLATES

CI_DOC_TEMPLATES

CI_DOC_TYPES

CI_DOC_TYPES

CI_DOC_TYPES

CI_PRIORITIES

CI_PRIORITIES

CI_PRIORITIES

CI_STATUSES

CI_STATUSES

CI_STATUSES

CI_WF_TEMPLATES

CI_WF_TEMPLATES

CI_WF_TEMPLATES

ci_window

usp_ci_window

usp_ci_window

cmth

Contact_Method

ct_mth

cnote

Note_Board

cnote

cnt

ca_contact

ca_contact

cnt

usp_contact

usp_contact

cost_cntr

ca_resource_cost_center

ca_resource_cost_center

country

ca_country

ca_country

cr

Call_Req

call_req

cr_prp

Req_Property

cr_prp

cr_prptpl

Req_Property_Template

cr_prptpl

cr_tpl

Cr_Template

cr_template

crs

Cr_Status

cr_stat

crsol

Call_Solution

crsol

crsq

Cr_Stored_Queries

crsq

crt

Call_Req_Type

crt

ctab

Controlled_Table

ctab

ctimer

Cr_Call_Timers

crctmr

ctp

ca_contact_type

ca_contact_type

dblocks

 

 

dcon

Domain_Constraint

dcon

dcon_typ

Domain_Constraint_Type

dcon_typ

dept

ca_resource_department

ca_resource_department

objet dlgsrvr

Delegation_Server

dlgtsrv

dmn

Domain

dmn

doc_rep

Document_Repository

doc_rep

EBR_ACRONYMS

EBR_ACRONYMS

EBR_ACRONYMS

EBR_FULLTEXT

EBR_FULLTEXT

EBR_FULLTEXT

EBR_FULLTEXT_ADM

EBR_FULLTEXT_ADM

EBR_FULLTEXT_ADM

EBR_FULLTEXT_SD

EBR_FULLTEXT_SD

EBR_FULLTEXT_SD

EBR_FULLTEXT_SD_ADM

EBR_FULLTEXT_SD_ADM

EBR_FULLTEXT_SD_ADM

EBR_INDEXING_QUEUE

EBR_INDEXING_QUEUE

EBR_INDEXING_QUEUE

EBR_KEYWORDS

EBR_KEYWORDS

EBR_KEYWORDS

EBR_LOG

EBR_LOG

EBR_LOG

EBR_METRICS

EBR_METRICS

EBR_METRICS

EBR_NOISE_WORDS

EBR_NOISE_WORDS

EBR_NOISE_WORDS

EBR_PATTERNS

EBR_PATTERNS

EBR_PATTERNS

EBR_PREFIXES

EBR_PREFIXES

EBR_PREFIXES

EBR_PROPERTIES

EBR_PROPERTIES

EBR_PROPERTIES

EBR_SUBSTITS

EBR_SUBSTITS

EBR_SUBSTITS

EBR_SUFFIXES

EBR_SUFFIXES

EBR_SUFFIXES

EBR_SYNONYMS

EBR_SYNONYMS

EBR_SYNONYMS

EBR_SYNONYMS_ADM

EBR_SYNONYMS_ADM

EBR_SYNONYMS_ADM

ES_CONSTANTS

ES_CONSTANTS

ES_CONSTANTS

ES_NODES

ES_NODES

ES_NODES

ES_RESPONSES

ES_RESPONSES

ES_RESPONSES

ES_SESSIONS

ES_SESSIONS

ES_SESSIONS

event_log

event_log

event_log

event_type

event_type

event_type

evt

Evénements

evt

evtdly

Event_Delay

evt_dly

evtdlytp

Event_Delay_Type

evtdlytp

ext_entity_map

External_Entity_Map

xent_map

fmgrp

Form_Group

frmgrp

func_access

usp_functional_access

usp_functional_access

func_access_level

usp_functional_access_level

usp_functional_access_level

func_access_role

usp_functional_access_role

usp_functional_access_role

func_access_type

usp_functional_access_type

usp_functional_access_type

g_chg_ext

Global_Change_Extension

g_chg_ext

g_chg_queue

Global_Change_Queue

g_chg_queue

g_cnt

Global_Contact

g_contact

g_cr_ext

Global_Request_Extension

g_req_ext

g_cr_queue

Global_Request_Queue

g_req_queue

g_iss_ext

Global_Issue_Extension

g_iss_ext

g_iss_queue

Global_Issue_Queue

g_iss_queue

g_loc

Global_Location

g_loc

g_org

Global_Organization

g_org

g_prod

Global_Product

g_product

g_qname

Global_Queue_Names

g_queue_names

g_srvrs

Global_Servers

g_srvr

g_tblmap

Global_Table_Map

g_tbl_map

g_tblrule

Global_Table_Rule

g_tbl_rule

gl_code

ca_resource_gl_code

ca_resource_gl_code

grc

ca_resource_class

ca_resource_class

grpmem

Group_Member

grpmem

hier

Asset_Assignment

hier

imp

Impact

impact

INDEX_DOC_LINKS

INDEX_DOC_LINKS

INDEX_DOC_LINKS

intfc

Interface

interface

iss

Demande client

demande client

iss_prp

Issue_Property

issprp

iss_tpl

Iss_Template

iss_template

iss_wf

Issue_Workflow_Task

isswf

issalg

Issue_Act_Log

issalg

isscat

Issue_Category

isscat

issstat

Issue_Status

issstat

job_func

ca_job_function

ca_job_function

kc

usp_kpi

usp_kpi

KCAT

O_INDEXES

O_INDEXES

kcd

usp_kpi_data

usp_kpi_data

KD

SKELETONS

SKELETONS

KD_ATTMNT

KD_ATTMNT

KD_ATTMNT

kdlinks

kdlinks

kdlinks

KT_REPORT_CARD

KT_REPORT_CARD

KT_REPORT_CARD

ktd

usp_kpi_ticket_data

usp_kpi_ticket_data

kwrd

Knowledge_Keywords

km_kword

Loc.

ca_location

ca_location

LONG_TEXTS

LONG_TEXTS

LONG_TEXTS

lr

Notify_Log_Header

not_log

lrel_asset_chgnr

usp_lrel_asset_chgnr

usp_lrel_asset_chgnr

lrel_asset_issnr

usp_lrel_asset_issnr

usp_lrel_asset_issnr

lrel_att_cntlist_macro_ntf

usp_lrel_att_cntlist_macro_ntf

usp_lrel_att_cntlist_macro_ntf

lrel_att_ctplist_macro_ntf

usp_lrel_att_ctplist_macro_ntf

usp_lrel_att_ctplist_macro_ntf

lrel_att_ntflist_macro_ntf

usp_lrel_att_ntflist_macro_ntf

usp_lrel_att_ntflist_macro_ntf

lrel_attachments_changes

usp_lrel_attachments_changes

usp_lrel_attachments_changes

lrel_attachments_issues

usp_lrel_attachments_issues

usp_lrel_attachments_issues

lrel_attachments_requests

usp_lrel_attachments_requests

usp_lrel_attachments_requests

lrel_aty_events

usp_lrel_aty_events

usp_lrel_aty_events

lrel_bm_reps_assets

usp_lrel_bm_reps_assets

usp_lrel_bm_reps_assets

lrel_bm_reps_bmhiers

usp_lrel_bm_reps_bmhiers

usp_lrel_bm_reps_bmhiers

lrel_cenv_cntref

usp_lrel_cenv_cntref

usp_lrel_cenv_cntref

lrel_dist_cntlist_mgs_ntf

usp_lrel_dist_cntlist_mgs_ntf

usp_lrel_dist_cntlist_mgs_ntf

lrel_dist_ctplist_mgs_ntf

usp_lrel_dist_ctplist_mgs_ntf

usp_lrel_dist_ctplist_mgs_ntf

lrel_dist_ntflist_mgs_ntf

usp_lrel_dist_ntflist_mgs_ntf

usp_lrel_dist_ntflist_mgs_ntf

lrel_false_action_act_f

usp_lrel_false_action_act_f

usp_lrel_false_action_act_f

lrel_false_bhv_false

usp_lrel_false_bhv_false

usp_lrel_false_bhv_false

lrel_kwrds_crsolref

usp_lrel_kwrds_crsolref

usp_lrel_kwrds_crsolref

lrel_notify_list_cntchgntf

usp_lrel_notify_list_cntchgntf

usp_lrel_notify_list_cntchgntf

lrel_notify_list_cntissntf

usp_lrel_notify_list_cntissntf

usp_lrel_notify_list_cntissntf

lrel_notify_list_cntntf

usp_lrel_notify_list_cntntf

usp_lrel_notify_list_cntntf

lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_cntlist_att_ntfrl

lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrl

lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_macrolist_att_ntfrl

lrel_ntfr_ntflist_att_ntfrlist

usp_lrel_ntfr_ntflist_att_ntfrlist

usp_lrel_ntfr_ntflist_att_ntfrl

lrel_oenv_orgref

usp_lrel_oenv_orgref

usp_lrel_oenv_orgref

lrel_status_codes_tsktypes

usp_lrel_status_codes_tsktypes

usp_lrel_status_codes_tsktypes

lrel_svc_grps_svc_chgcat

usp_lrel_svc_grps_svc_chgcat

usp_lrel_svc_grps_svc_chgcat

lrel_svc_grps_svc_isscat

usp_lrel_svc_grps_svc_isscat

usp_lrel_svc_grps_svc_isscat

lrel_svc_grps_svc_pcat

usp_lrel_svc_grps_svc_pcat

usp_lrel_svc_grps_svc_pcat

lrel_svc_grps_svc_wftpl

usp_lrel_svc_grps_svc_wftpl

usp_lrel_svc_grps_svc_wftpl

lrel_svc_locs_svc_chgcat

usp_lrel_svc_locs_svc_chgcat

usp_lrel_svc_locs_svc_chgcat

lrel_svc_locs_svc_groups

usp_lrel_svc_locs_svc_groups

usp_lrel_svc_locs_svc_groups

lrel_svc_locs_svc_isscat

usp_lrel_svc_locs_svc_isscat

usp_lrel_svc_locs_svc_isscat

lrel_svc_locs_svc_pcat

usp_lrel_svc_locs_svc_pcat

usp_lrel_svc_locs_svc_pcat

lrel_svc_schedules_chgcat_svc

usp_lrel_svc_schedules_chgcat_svc

usp_lrel_svc_sch_chgcat_svc

lrel_svc_schedules_isscat_svc

usp_lrel_svc_schedules_isscat_svc

usp_lrel_svc_sch_isscat_svc

lrel_svc_schedules_pcat_svc

usp_lrel_svc_schedules_pcat_svc

usp_lrel_svc_sch_pcat_svc

lrel_true_action_act_t

usp_lrel_true_action_act_t

usp_lrel_true_action_act_t

lrel_true_bhv_true

usp_lrel_true_bhv_true

usp_lrel_true_bhv_true

macro

Spell_Macro

splmac

macro_type

Spell_Macro_Type

splmactp

mfrmod

ca_model_def

ca_model_def

EG

Managed_Survey

managed_survey

mgsalg

Mgs_Act_Log

mgsalg

mgsstat

Mgs_Status

mgsstat

NOTIFICATION

NOTIFICATION

NOTIFICATION

notque

Queued_Notify

not_que

noturg

Notification_Urgency

noturg

nr

ca_owned_resource

ca_owned_resource

nr

usp_owned_resource

usp_owned_resource

nr_com

NR_Comment

nr_com

nrf

ca_resource_family

ca_resource_family

ntfl

Notify_Object_Attr

ntfl

O_COMMENTS

O_COMMENTS

O_COMMENTS

O_EVENTS

O_EVENTS

O_EVENTS

opsys

ca_resource_operating_system

ca_resource_operating_system

options

Options

options

Organisation

ca_organization

ca_organization

Organisation

usp_organization

usp_organization

P_GROUPS

P_GROUPS

P_GROUPS

pcat

Prob_Category

prob_ctg

pcat_loc

Pcat_Loc

pcat_loc

perscnt

Person_Contacting

perscon

position

ca_job_title

ca_job_title

pri

Priorité

pri

prod

Produit

Produit

prp

Propriété

prp

prptpl

Property_Template

prptpl

quick_tpl_types

Quick_Template_Types

quick_tpl_types

rc

Rootcause

rootcause

response

Réponse

response

rev_bool

Reverse_Boolean_Table

rbooltab

rptm

Rpt_Meth

rptmth

rptmeth

Reporting_Method

repmeth

rrf

Remote_Ref

rem_ref

rss

ca_resource_status

ca_resource_status

sapolicy

SA_Policy

sapolicy

saprobtyp

SA_Prob_Type

saprobtyp

sdsc

Service_Desc

srv_desc

sdsc_map

SLA_Contract_Map

sdsc_map

seq

Sequence_Control

seqctl

session_log

session_log

session_log

session_type

session_type

session_type

sev

Severity

sevrty

SHOW_OBJ

SHOW_OBJ

SHOW_OBJ

site

Table ca_site

Table ca_site

slatpl

SLA_Template

slatpl

srvr_aliases

Server_Aliases

srvr_aliases

srvr_zones

Server_Zones

srvr_zones

state

ca_state_province

ca_state_province

enquête

Enquête

enquête

svc_contract

Service_Contract

svc_contract

svy_ans

Survey_Answer

survey_answer

svy_atpl

Survey_Answer_Template

survey_atpl

svy_qtpl

Survey_Question_Template

survey_qtpl

svy_ques

Survey_Question

survey_question

svy_tpl

Survey_Template

survey_tpl

svystat

Survey_Stats

survey_statistics

svytrk

Survey_Tracking

survey_tracking

target_tgttpls_srvtypes

target_tgttpls_srvtypes

tgt_tgttpls_srvtypes

target_time

target_time

tgt_time

target_time_tpl

target_time_tpl

tgt_time_tpl

tenant

ca_tenant

ca_tenant

tenant_group

ca_tenant_group

ca_tenant_group

tenant_group_member

ca_tenant_group_member

ca_tenant_group_member

True_False_Table

True_False_Table

true_false

tskstat

Task_Status

tskstat

tskty

Task_Type

tskty

tspan

Timespan

tspan

typecnt

Type_Of_Contact

toc

tz

Timezone

tz

urg

Urgency

urgncy

USP_PREFERENCES

USP_PREFERENCES

USP_PREFERENCES

USP_PROPERTIES

USP_PROPERTIES

USP_PROPERTIES

usq

User_Query

usq

vpt

ca_company_type

ca_company_type

wf

Workflow_Task

wf

wftpl

Workflow_Task_Template

wftpl

wrkshft

Bop_Workshift

bpwshft

wspcol

wspcol

wspcol

wsptbl

wsptbl

wsptbl

 

Attribute_Name

atn

 

ca_asset_type

ca_asset_type

 

ca_schema_info

ca_schema_info

 

Column_Name

cn

 

 

 

 

D_PAINTER

D_PAINTER

 

ext_appl

ext_appl

 

Key_Control

kc

 

Transition_Points

nottrn

 

SQL_Script

sql_tab

 

Table_Name

tn