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 |
|
Copyright © 2013 CA.
Alle Rechte vorbehalten.
|
|