Rubrique précédente: Table vers nom SQL et objetRubrique suivante: Objet vers table et nom SQL


Nom SQL vers table et objet

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

Nom SQL (AKA)

Tableau

Object

acc_lvls

Access_Levels

acc_lvls

acctyp_v2

Access_Type_v2

acctyp

act_Log

Act_Log

alg

act_Type

Act_Type

aty

actbool

Active_Boolean_Table

actbool

actrbool

Active_Reverse_Boolean_Table

actrbool

admin_tree

admin_tree

ADMIN_TREE

am_map

Am_Asset_Map

am_asset_map

anima

Animator

ANI

arcpur_hist

Archive_Purge_History

arcpur_hist

arcpur_rule

Archive_Purge_Rule

arcpur_rule

atn

Attribute_Name

 

atomic_cond

Atomic_Condition

atomic_cond

att_evt

Attached_Events

atev

attached_sla

Attached_SLA

attached_sla

attmnt

Attachment

attmnt

attmnt_folder

attmnt_folder

attmnt_folder

atyp_asc

Act_Type_Assoc

act_type_assoc

audit_log

Audit_Log

audlog

bhvtpl

Behavior_Template

bhvtpl

bool_tab

Boolean_Table

Booléen

bpwshft

Bop_Workshift

wrkshft

BU_TRANS

BU_TRANS

BU_TRANS

buscls

Business_Management_Class

bmcls

busmgt

Business_Management

bmhier

busrep

Business_Management_Repository

bmrep

busstat

Business_Management_Status

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

chg

Change_Request

chg

chg_template

Chg_Template

chg_tpl

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

cn

Column_Name

 

cnote

Note_Board

cnote

cr_prp

Req_Property

cr_prp

cr_prptpl

Req_Property_Template

cr_prptpl

cr_stat

Cr_Status

crs

cr_template

Cr_Template

cr_tpl

crctmr

Cr_Call_Timers

ctimer

crsol

Call_Solution

crsol

crsq

Cr_Stored_Queries

crsq

crt

Call_Req_Type

crt

ct_mth

Contact_Method

cmth

ctab

Controlled_Table

ctab

D_PAINTER

D_PAINTER

 

dcon

Domain_Constraint

dcon

dcon_typ

Domain_Constraint_Type

dcon_typ

dlgtsrv

Delegation_Server

objet dlgsrvr

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

evt_dly

Event_Delay

evtdly

evtdlytp

Event_Delay_Type

evtdlytp

ext_appl

ext_appl

 

frmgrp

Form_Group

fmgrp

g_chg_ext

Global_Change_Extension

g_chg_ext

g_chg_queue

Global_Change_Queue

g_chg_queue

g_contact

Global_Contact

g_cnt

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_product

Global_Product

g_prod

g_queue_names

Global_Queue_Names

g_qname

g_req_ext

Global_Request_Extension

g_cr_ext

g_req_queue

Global_Request_Queue

g_cr_queue

g_srvr

Global_Servers

g_srvrs

g_tbl_map

Global_Table_Map

g_tblmap

g_tbl_rule

Global_Table_Rule

g_tblrule

grpmem

Group_Member

grpmem

hier

Asset_Assignment

hier

impact

Impact

imp

INDEX_DOC_LINKS

INDEX_DOC_LINKS

INDEX_DOC_LINKS

interface

Interface

intfc

iss_template

Iss_Template

iss_tpl

issalg

Issue_Act_Log

issalg

isscat

Issue_Category

isscat

issprp

Issue_Property

iss_prp

issstat

Issue_Status

issstat

demande client

Demande client

iss

isswf

Issue_Workflow_Task

iss_wf

kc

Key_Control

 

KD_ATTMNT

KD_ATTMNT

KD_ATTMNT

kdlinks

kdlinks

kdlinks

km_kword

Knowledge_Keywords

kwrd

KT_REPORT_CARD

KT_REPORT_CARD

KT_REPORT_CARD

LONG_TEXTS

LONG_TEXTS

LONG_TEXTS

managed_survey

Managed_Survey

EG

mgsalg

Mgs_Act_Log

mgsalg

mgsstat

Mgs_Status

mgsstat

not_log

Notify_Log_Header

lr

not_que

Queued_Notify

notque

NOTIFICATION

NOTIFICATION

NOTIFICATION

nottrn

Transition_Points

 

noturg

Notification_Urgency

noturg

nr_com

NR_Comment

nr_com

ntfl

Notify_Object_Attr

ntfl

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

perscon

Person_Contacting

perscnt

pri

Priorité

pri

prob_ctg

Prob_Category

pcat

Produit

Produit

prod

prp

Propriété

prp

prptpl

Property_Template

prptpl

quick_tpl_types

Quick_Template_Types

quick_tpl_types

rbooltab

Reverse_Boolean_Table

rev_bool

rem_ref

Remote_Ref

rrf

repmeth

Reporting_Method

rptmeth

response

Réponse

response

rootcause

Rootcause

rc

rptmth

Rpt_Meth

rptm

sapolicy

SA_Policy

sapolicy

saprobtyp

SA_Prob_Type

saprobtyp

sdsc_map

SLA_Contract_Map

sdsc_map

seqctl

Sequence_Control

seq

session_log

session_log

session_log

session_type

session_type

session_type

sevrty

Severity

sev

SHOW_OBJ

SHOW_OBJ

SHOW_OBJ

SKELETONS

SKELETONS

KD

slatpl

SLA_Template

slatpl

splmac

Spell_Macro

macro

splmactp

Spell_Macro_Type

macro_type

sql_tab

SQL_Script

 

srv_desc

Service_Desc

sdsc

srvr_aliases

Server_Aliases

srvr_aliases

srvr_zones

Server_Zones

srvr_zones

enquête

Enquête

enquête

survey_answer

Survey_Answer

svy_ans

survey_atpl

Survey_Answer_Template

svy_atpl

survey_qtpl

Survey_Question_Template

svy_qtpl

survey_question

Survey_Question

svy_ques

survey_statistics

Survey_Stats

svystat

survey_tpl

Survey_Template

svy_tpl

survey_tracking

Survey_Tracking

svytrk

svc_contract

Service_Contract

svc_contract

tn

Table_Name

 

toc

Type_Of_Contact

typecnt

tskstat

Task_Status

tskstat

tskty

Task_Type

tskty

tspan

Timespan

tspan

tz

Timezone

tz

urgncy

Urgency

urg

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_kpi_ticket_data

usp_kpi_ticket_data

ktd

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_ntfrl

usp_lrel_ntfr_cntlist_att_ntfrlist

lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrl

usp_lrel_ntfr_ctplist_att_ntfrlist

lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_macrolist_att_ntfrlist

lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_ntflist_att_ntfrl

usp_lrel_ntfr_ntflist_att_ntfrlist

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_sch_chgcat_svc

usp_lrel_svc_schedules_chgcat_svc

lrel_svc_schedules_chgcat_svc

usp_lrel_svc_sch_isscat_svc

usp_lrel_svc_schedules_isscat_svc

lrel_svc_schedules_isscat_svc

usp_lrel_svc_sch_pcat_svc

usp_lrel_svc_schedules_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_organization

usp_organization

Organisation

usp_pri_cal

usp_pri_cal

 

usp_owned_resource

usp_owned_resource

nr

USP_PREFERENCES

USP_PREFERENCES

USP_PREFERENCES

USP_PROPERTIES

USP_PROPERTIES

USP_PROPERTIES

usq

User_Query

usq

wf

Workflow_Task

wf

wftpl

Workflow_Task_Template

wftpl

wspcol

wspcol

wspcol

wsptbl

wsptbl

wsptbl

xent_map

External_Entity_Map

ext_entity_map