Vorheriges Thema: SQL-Name zu Tabelle und ObjektNächstes Thema: CA SDM-Objektlistentabelle für mehrere Mandanten


Objekt zu Tabelle und SQL-Name

Diese Tabelle bietet einen Querverweis von jedem Objekt zur entsprechenden Tabelle und zum SQL-Namen im Datenbankschema:

Objekt

Tabelle

SQL-Name (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

Anhang

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

Boolean_Table

bool_tab

BU_TRANS

BU_TRANS

BU_TRANS

ca_cmpny

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

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

dlgsrvr

Delegation_Server

dlgtsrv

dmn

Domäne

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

Events

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

Schnittstelle

interface

Iss

Issue

Issue

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

mgs

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

Optionen

Optionen

Optionen

org

ca_organization

ca_organization

org

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ät

pri

prod

Produkt

Produkt

prp

Eigenschaft

prp

prptpl

Property_Template

prptpl

quick_tpl_types

Quick_Template_Types

quick_tpl_types

rc

Rootcause

rootcause

response

Antwort

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

Relevanz

sevrty

SHOW_OBJ

SHOW_OBJ

SHOW_OBJ

Standort

ca_site

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

Umfrage

Survey

Umfrage

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

Zeitspanne

tspan

typecnt

Type_Of_Contact

toc

tz

Zeitzone

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