Diese Tabelle bietet einen Querverweis vom SQL-Namen jeder Tabelle im Datenbankschema zu den entsprechenden Tabellen- und Objektnamen:
|
SQL-Name (AKA) |
Tabelle |
Objekt |
|---|---|---|
|
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 |
Anhang |
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 |
|
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 |
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 |
|
chg |
Change_Request |
chg |
|
chg_template |
Chg_Template |
chg_tpl |
|
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 |
|
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 |
dlgsrvr |
|
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 |
|
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 |
Schnittstelle |
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 |
|
Issue |
Issue |
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 |
mgs |
|
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 |
|
Optionen |
Optionen |
Optionen |
|
P_GROUPS |
P_GROUPS |
P_GROUPS |
|
pcat_loc |
Pcat_Loc |
pcat_loc |
|
perscon |
Person_Contacting |
perscnt |
|
pri |
Priorität |
pri |
|
prob_ctg |
Prob_Category |
pcat |
|
Produkt |
Produkt |
prod |
|
prp |
Eigenschaft |
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 |
Antwort |
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 |
Relevanz |
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 |
|
Umfrage |
Survey |
Umfrage |
|
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 |
Zeitspanne |
tspan |
|
tz |
Zeitzone |
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 |
org |
|
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 |
|
Copyright © 2013 CA.
Alle Rechte vorbehalten.
|
|