Rubrique précédente: Références croisées de tables et d’objetsRubrique suivante: Nom SQL vers table et objet


Table vers nom SQL et objet

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

Tableau

Nom SQL (AKA)

Object

Access_Levels

acc_lvls

acc_lvls

Access_Type_v2

acctyp_v2

acctyp

Act_Log

act_Log

alg

Act_Type

act_Type

aty

Act_Type_Assoc

atyp_asc

act_type_assoc

Active_Boolean_Table

actbool

actbool

Active_Reverse_Boolean_Table

actrbool

actrbool

admin_tree

admin_tree

ADMIN_TREE

Am_Asset_Map

am_map

am_asset_map

Animator

anima

ANI

Archive_Purge_History

arcpur_hist

arcpur_hist

Archive_Purge_Rule

arcpur_rule

arcpur_rule

Asset_Assignment

hier

hier

Atomic_Condition

atomic_cond

atomic_cond

Attached_Events

att_evt

atev

Attached_SLA

attached_sla

attached_sla

Attachment

attmnt

attmnt

attmnt_folder

attmnt_folder

attmnt_folder

Attribute_Name

atn

 

Audit_Log

audit_log

audlog

Behavior_Template

bhvtpl

bhvtpl

Boolean_Table

bool_tab

Booléen

Bop_Workshift

bpwshft

wrkshft

BU_TRANS

BU_TRANS

BU_TRANS

Business_Management

busmgt

bmhier

Business_Management_Class

buscls

bmcls

Business_Management_Repository

busrep

bmrep

Business_Management_Status

busstat

bms

ca_asset_type

ca_asset_type

 

ca_company

ca_company

Société CA

ca_company_type

ca_company_type

vpt

ca_contact

ca_contact

cnt

ca_contact_type

ca_contact_type

ctp

ca_country

ca_country

country

ca_job_function

ca_job_function

job_func

ca_job_title

ca_job_title

position

ca_location

ca_location

Loc.

ca_model_def

ca_model_def

mfrmod

ca_organization

ca_organization

Organisation

ca_owned_resource

ca_owned_resource

nr

ca_resource_class

ca_resource_class

grc

ca_resource_cost_center

ca_resource_cost_center

cost_cntr

ca_resource_department

ca_resource_department

dept

ca_resource_family

ca_resource_family

nrf

ca_resource_gl_code

ca_resource_gl_code

gl_code

ca_resource_operating_system

ca_resource_operating_system

opsys

ca_resource_status

ca_resource_status

rss

ca_schema_info

ca_schema_info

 

Table ca_site

Table ca_site

site

ca_state_province

ca_state_province

state

ca_tenant

ca_tenant

tenant

ca_tenant_group

ca_tenant_group

tenant_group

ca_tenant_group_member

ca_tenant_group_member

tenant_group_member

Call_Req

call_req

cr

Call_Req_Type

crt

crt

Call_Solution

crsol

crsol

Table Change_Act_Log

chgalg

chgalg

Change_Category

chgcat

chgcat

Change_Request

chg

chg

Change_Status

chgstat

chgstat

Chg_Template

chg_template

chg_tpl

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

Column_Name

cn

 

Contact_Method

ct_mth

cmth

Controlled_Table

ctab

ctab

Cr_Call_Timers

crctmr

ctimer

Cr_Status

cr_stat

crs

Cr_Stored_Queries

crsq

crsq

Cr_Template

cr_template

cr_tpl

D_PAINTER

D_PAINTER

 

Delegation_Server

dlgtsrv

objet dlgsrvr

Document_Repository

doc_rep

doc_rep

Domain

dmn

dmn

Domain_Constraint

dcon

dcon

Domain_Constraint_Type

dcon_typ

dcon_typ

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_Delay

evt_dly

evtdly

Event_Delay_Type

evtdlytp

evtdlytp

event_log

event_log

event_log

event_type

event_type

event_type

Evénements

evt

evt

ext_appl

ext_appl

 

External_Entity_Map

xent_map

ext_entity_map

Form_Group

frmgrp

fmgrp

Global_Change_Extension

g_chg_ext

g_chg_ext

Global_Change_Queue

g_chg_queue

g_chg_queue

Global_Contact

g_contact

g_cnt

Global_Issue_Extension

g_iss_ext

g_iss_ext

Global_Issue_Queue

g_iss_queue

g_iss_queue

Global_Location

g_loc

g_loc

Global_Organization

g_org

g_org

Global_Product

g_product

g_prod

Global_Queue_Names

g_queue_names

g_qname

Global_Request_Extension

g_req_ext

g_cr_ext

Global_Request_Queue

g_req_queue

g_cr_queue

Global_Servers

g_srvr

g_srvrs

Global_Table_Map

g_tbl_map

g_tblmap

Global_Table_Rule

g_tbl_rule

g_tblrule

Group_Member

grpmem

grpmem

Impact

impact

imp

INDEX_DOC_LINKS

INDEX_DOC_LINKS

INDEX_DOC_LINKS

Interface

interface

intfc

Iss_Template

iss_template

iss_tpl

Demande client

demande client

iss

Issue_Act_Log

issalg

issalg

Issue_Category

isscat

isscat

Issue_Property

issprp

iss_prp

Issue_Status

issstat

issstat

Issue_Workflow_Task

isswf

iss_wf

KD_ATTMNT

KD_ATTMNT

KD_ATTMNT

kdlinks

kdlinks

kdlinks

Key_Control

kc

 

Knowledge_Keywords

km_kword

kwrd

KT_REPORT_CARD

KT_REPORT_CARD

KT_REPORT_CARD

LONG_TEXTS

LONG_TEXTS

LONG_TEXTS

Managed_Survey

managed_survey

EG

Mgs_Act_Log

mgsalg

mgsalg

Mgs_Status

mgsstat

mgsstat

Note_Board

cnote

cnote

NOTIFICATION

NOTIFICATION

NOTIFICATION

Notification_Urgency

noturg

noturg

Notify_Log_Header

not_log

lr

Notify_Object_Attr

ntfl

ntfl

NR_Comment

nr_com

nr_com

O_COMMENTS

O_COMMENTS

O_COMMENTS

O_EVENTS

O_EVENTS

O_EVENTS

O_INDEXES

O_INDEXES

KCAT

Options

options

options

P_GROUPS

P_GROUPS

P_GROUPS

Pcat_Loc

pcat_loc

pcat_loc

Person_Contacting

perscon

perscnt

Priorité

pri

pri

Prob_Category

prob_ctg

pcat

Produit

Produit

prod

Propriété

prp

prp

Property_Template

prptpl

prptpl

Queued_Notify

not_que

notque

Quick_Template_Types

quick_tpl_types

quick_tpl_types

Remote_Ref

rem_ref

rrf

Reporting_Method

repmeth

rptmeth

Req_Property

cr_prp

cr_prp

Req_Property_Template

cr_prptpl

cr_prptpl

Réponse

response

response

Reverse_Boolean_Table

rbooltab

rev_bool

Rootcause

rootcause

rc

Rpt_Meth

rptmth

rptm

SA_Policy

sapolicy

sapolicy

SA_Prob_Type

saprobtyp

saprobtyp

Sequence_Control

seqctl

seq

Server_Aliases

srvr_aliases

srvr_aliases

Server_Zones

srvr_zones

srvr_zones

Service_Contract

svc_contract

svc_contract

Service_Desc

srv_desc

sdsc

session_log

session_log

session_log

session_type

session_type

session_type

Severity

sevrty

sev

SHOW_OBJ

SHOW_OBJ

SHOW_OBJ

SKELETONS

SKELETONS

KD

SLA_Contract_Map

sdsc_map

sdsc_map

SLA_Template

slatpl

slatpl

Spell_Macro

splmac

macro

Spell_Macro_Type

splmactp

macro_type

SQL_Script

sql_tab

 

Enquête

enquête

enquête

Survey_Answer

survey_answer

svy_ans

Survey_Answer_Template

survey_atpl

svy_atpl

Survey_Question

survey_question

svy_ques

Survey_Question_Template

survey_qtpl

svy_qtpl

Survey_Stats

survey_statistics

svystat

Survey_Template

survey_tpl

svy_tpl

Survey_Tracking

survey_tracking

svytrk

Table_Name

tn

 

target_tgttpls_srvtypes

target_tgttpls_srvtypes

tgt_tgttpls_srvtypes

target_time

target_time

tgt_time

target_time_tpl

target_time_tpl

tgt_time_tpl

Task_Status

tskstat

tskstat

Task_Type

tskty

tskty

Timespan

tspan

tspan

Timezone

tz

tz

Transition_Points

nottrn

 

True_False_Table

True_False_Table

true_false

Type_Of_Contact

toc

typecnt

Urgency

urgncy

urg

User_Query

usq

usq

usp_caextwf_instances

usp_caextwf_instances

caextwf_inst

usp_caextwf_start_forms

usp_caextwf_start_forms

caextwf_sfrm

usp_ci_window

usp_ci_window

ci_window

usp_contact

usp_contact

cnt

usp_functional_access

usp_functional_access

func_access

usp_functional_access_level

usp_functional_access_level

func_access_level

usp_functional_access_role

usp_functional_access_role

func_access_role

usp_functional_access_type

usp_functional_access_type

func_access_type

usp_kpi

usp_kpi

kc

usp_kpi_data

usp_kpi_data

kcd

usp_lrel_asset_chgnr

usp_lrel_asset_chgnr

lrel_asset_chgnr

usp_lrel_asset_issnr

usp_lrel_asset_issnr

lrel_asset_issnr

usp_lrel_att_cntlist_macro_ntf

usp_lrel_att_cntlist_macro_ntf

lrel_att_cntlist_macro_ntf

usp_lrel_att_ctplist_macro_ntf

usp_lrel_att_ctplist_macro_ntf

lrel_att_ctplist_macro_ntf

usp_lrel_att_ntflist_macro_ntf

usp_lrel_att_ntflist_macro_ntf

lrel_att_ntflist_macro_ntf

usp_lrel_attachments_changes

usp_lrel_attachments_changes

lrel_attachments_changes

usp_lrel_attachments_issues

usp_lrel_attachments_issues

lrel_attachments_issues

usp_lrel_attachments_requests

usp_lrel_attachments_requests

lrel_attachments_requests

usp_lrel_aty_events

usp_lrel_aty_events

lrel_aty_events

usp_lrel_bm_reps_assets

usp_lrel_bm_reps_assets

lrel_bm_reps_assets

usp_lrel_bm_reps_bmhiers

usp_lrel_bm_reps_bmhiers

lrel_bm_reps_bmhiers

usp_lrel_cenv_cntref

usp_lrel_cenv_cntref

lrel_cenv_cntref

usp_lrel_false_action_act_f

usp_lrel_false_action_act_f

lrel_false_action_act_f

usp_lrel_dist_cntlist_mgs_ntf

usp_lrel_dist_cntlist_mgs_ntf

lrel_dist_cntlist_mgs_ntf

usp_lrel_dist_ctplist_mgs_ntf

usp_lrel_dist_ctplist_mgs_ntf

lrel_dist_ctplist_mgs_ntf

usp_lrel_dist_ntflist_mgs_ntf

usp_lrel_dist_ntflist_mgs_ntf

lrel_dist_ntflist_mgs_ntf

usp_lrel_false_bhv_false

usp_lrel_false_bhv_false

lrel_false_bhv_false

usp_lrel_kwrds_crsolref

usp_lrel_kwrds_crsolref

lrel_kwrds_crsolref

usp_lrel_notify_list_cntchgntf

usp_lrel_notify_list_cntchgntf

lrel_notify_list_cntchgntf

usp_lrel_notify_list_cntissntf

usp_lrel_notify_list_cntissntf

lrel_notify_list_cntissntf

usp_lrel_notify_list_cntntf

usp_lrel_notify_list_cntntf

lrel_notify_list_cntntf

usp_lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_cntl_att_ntfrl

lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrl

lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_macrolist_att_ntfrl

lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_ntflist_att_ntfrlist

usp_lrel_ntfr_ntflist_att_ntfrl

lrel_ntfr_ntflist_att_ntfrlist

usp_lrel_oenv_orgref

usp_lrel_oenv_orgref

lrel_oenv_orgref

usp_lrel_status_codes_tsktypes

usp_lrel_status_codes_tsktypes

lrel_status_codes_tsktypes

usp_lrel_svc_grps_svc_chgcat

usp_lrel_svc_grps_svc_chgcat

lrel_svc_grps_svc_chgcat

usp_lrel_svc_grps_svc_isscat

usp_lrel_svc_grps_svc_isscat

lrel_svc_grps_svc_isscat

usp_lrel_svc_grps_svc_pcat

usp_lrel_svc_grps_svc_pcat

lrel_svc_grps_svc_pcat

usp_lrel_svc_grps_svc_wftpl

usp_lrel_svc_grps_svc_wftpl

lrel_svc_grps_svc_wftpl

usp_lrel_svc_locs_svc_chgcat

usp_lrel_svc_locs_svc_chgcat

lrel_svc_locs_svc_chgcat

usp_lrel_svc_locs_svc_groups

usp_lrel_svc_locs_svc_groups

lrel_svc_locs_svc_groups

usp_lrel_svc_locs_svc_isscat

usp_lrel_svc_locs_svc_isscat

lrel_svc_locs_svc_isscat

usp_lrel_svc_locs_svc_pcat

usp_lrel_svc_locs_svc_pcat

lrel_svc_locs_svc_pcat

usp_lrel_svc_schedules_chgcat_svc

usp_lrel_svc_sch_chgcat_svc

lrel_svc_schedules_chgcat_svc

usp_lrel_svc_schedules_isscat_svc

usp_lrel_svc_sch_isscat_svc

lrel_svc_schedules_isscat_svc

usp_lrel_svc_schedules_pcat_svc

usp_lrel_svc_sch_pcat_svc

lrel_svc_schedules_pcat_svc

usp_lrel_true_action_act_t

usp_lrel_true_action_act_t

lrel_true_action_act_t

usp_lrel_true_bhv_true

usp_lrel_true_bhv_true

lrel_true_bhv_true

usp_kpi_ticket_data

usp_kpi_ticket_data

ktd

usp_organization

usp_organization

Organisation

usp_owned_resource

usp_owned_resource

nr

usp_pri_cal

usp_pri_cal

 

USP_PREFERENCES

USP_PREFERENCES

USP_PREFERENCES

USP_PROPERTIES

USP_PROPERTIES

USP_PROPERTIES

Workflow_Task

wf

wf

Workflow_Task_Template

wftpl

wftpl

wspcol

wspcol

wspcol

wsptbl

wsptbl

wsptbl