Diese Tabelle bietet einen Querverweis von jeder Tabelle im Datenbankschema auf die entsprechenden SQL- und Objektnamen:
|
Tabelle |
SQL-Name (AKA) |
Objekt |
|---|---|---|
|
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 |
|
Anhang |
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 |
|
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 |
ca_cmpny |
|
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 |
org |
|
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 |
|
|
ca_site |
ca_site |
Standort |
|
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 |
|
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 |
dlgsrvr |
|
Document_Repository |
doc_rep |
doc_rep |
|
Domäne |
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 |
|
Events |
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 |
|
Schnittstelle |
interface |
intfc |
|
Iss_Template |
iss_template |
iss_tpl |
|
Issue |
Issue |
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 |
mgs |
|
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 |
|
Optionen |
Optionen |
Optionen |
|
P_GROUPS |
P_GROUPS |
P_GROUPS |
|
Pcat_Loc |
pcat_loc |
pcat_loc |
|
Person_Contacting |
perscon |
perscnt |
|
Priorität |
pri |
pri |
|
Prob_Category |
prob_ctg |
pcat |
|
Produkt |
Produkt |
prod |
|
Eigenschaft |
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 |
|
Antwort |
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 |
|
Relevanz |
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 |
|
|
Survey |
Umfrage |
Umfrage |
|
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 |
|
Zeitspanne |
tspan |
tspan |
|
Zeitzone |
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 |
org |
|
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 |
|
Copyright © 2013 CA.
Alle Rechte vorbehalten.
|
|