Les détails de l'objet sont les suivants :
Table associée : Call_Req
Sous-objets : par défaut
REL_ATTR : persistent_id
Nom commun : ref_num
Groupe de fonctions : call_mgr
Opérations REST : CREATE READ UPDATE
|
Attribut |
Champ BdD |
Type de données |
Références SREL |
Indicateurs |
|---|---|---|---|---|
|
description |
description |
STRING |
|
|
|
Activé |
active_flag |
NOMBRE ENTIER |
enum bool_tab |
REQUIRED |
|
active_prev |
LOCAL |
SREL |
bool.enum |
|
|
affected_ resource |
affected_rc |
UUID |
ca_owned_ resource uuid |
|
|
Destinataire |
Destinataire |
UUID |
|
|
|
assignee_prev |
LOCAL |
SREL |
agt.id |
|
|
call_back_date |
call_back_date |
LOCAL_ TIME |
|
|
|
call_back_flag |
call_back_flag |
NOMBRE ENTIER |
|
|
|
catégorie |
catégorie |
STRING |
prob_ctg persid |
|
|
category_prev |
LOCAL |
SREL |
pcat.persistent_id |
|
|
caused_by_chg |
caused_by_chg |
SREL |
chg.id |
|
|
changement |
changement |
NOMBRE ENTIER |
chg id |
|
|
charge_back_id |
charge_back_ id |
STRING |
|
|
|
close_date |
close_date |
LOCAL_ TIME |
|
|
|
cr_tticket |
cr_tticket |
NOMBRE ENTIER |
|
|
|
created_via |
created_via |
NOMBRE ENTIER |
id d'interface |
|
|
customer |
customer |
UUID |
ca_contact uuid |
REQUIRED |
|
event_token |
event_token |
STRING |
|
|
|
external_system_ticket |
|
STRING (4000) |
|
|
|
extern_ref |
extern_ref |
STRING |
|
|
|
groupe |
group_id |
UUID |
|
|
|
group_prev |
LOCAL |
SREL |
grp.id |
|
|
id |
id |
NOMBRE ENTIER |
|
UNIQUE REQUIRED KEY |
|
impact |
impact |
NOMBRE ENTIER |
impact enum |
|
|
impact_prev |
LOCAL |
SREL |
imp.enum |
|
|
incident_priority |
incident_priority |
NOMBRE ENTIER |
|
|
|
incorrectly_assigned |
|
SREL |
actbool |
|
|
last_act_id |
last_act_id |
STRING |
|
|
|
last_mod_dt |
last_mod_dt |
LOCAL_TIME |
|
|
|
log_agent |
log_agent |
UUID |
ca_contact uuid |
REQUIRED |
|
macro_ predicted_ violation |
macro_predict_ viol |
NOMBRE ENTIER |
|
|
|
major_incident |
|
SREL |
actbool |
|
|
open_date |
open_date |
LOCAL_ TIME |
Organisation |
|
|
orig_user_admin_org |
|
SREL |
Organisation |
|
|
orig_user_cost_center |
|
SREL |
cost_cntr |
|
|
orig_user_dept |
|
SREL |
dept |
|
|
orig_user_organization |
|
SREL |
Organisation |
|
|
outage_detail_what |
|
STRING (4000) |
|
|
|
outage_detail_who |
|
STRING (4000) |
|
|
|
outage_detail_why |
|
STRING (4000) |
|
|
|
outage_end_time |
outage_end_time |
LOCAL_TIME |
|
|
|
outage_reason |
|
SREL |
outage_reason |
|
|
outage_start _time |
outage_start _time |
LOCAL_TIME |
|
|
|
outage_type |
|
SREL |
outage_type |
|
|
Parent |
Parent |
STRING |
call_req persid |
|
|
pct_service_restored |
|
NOMBRE ENTIER |
|
|
|
persistent_id |
persid |
STRING |
|
|
|
predicted_sla_violation |
predicted_sla_viol |
NOMBRE ENTIER |
|
|
|
priority |
priority |
NOMBRE ENTIER |
enum pri |
REQUIRED |
|
priority_prev |
LOCAL |
SREL |
pri.enum |
|
|
problème |
problème |
STRING |
|
|
|
ref_num |
ref_num |
STRING |
|
UNIQUE REQUIRED S_KEY |
|
remote_control_used |
|
SREL |
actbool |
|
|
requested_by |
|
SREL |
cnt |
|
|
resolvable_at_lower |
|
SREL |
actbool |
|
|
resolve_date |
resolve_date |
LOCAL_ TIME |
|
|
|
return_to_service |
|
SREL |
actbool |
|
|
rootcause |
rootcause |
NOMBRE ENTIER |
id rootcause |
|
|
extern_token |
sched_token |
STRING |
|
|
|
severity |
severity |
NOMBRE ENTIER |
enum sevrty |
|
|
severity_prev |
LOCAL |
SREL |
sev.enum |
|
|
sla_violation |
sla_violation |
NOMBRE ENTIER |
|
|
|
base_template |
solution |
STRING |
call_req persid |
|
|
status |
status |
STRING |
code cr_stat |
|
|
status_prev |
LOCAL |
SREL |
crs.code |
|
|
Chaîne 1 |
Chaîne 1 |
STRING |
|
|
|
Chaîne 2 |
Chaîne 2 |
STRING |
|
|
|
Chaîne 3 |
Chaîne 3 |
STRING |
|
|
|
Chaîne 4 |
Chaîne 4 |
STRING |
|
|
|
Chaîne 5 |
Chaîne 5 |
STRING |
|
|
|
Chaîne 6 |
Chaîne 6 |
STRING |
|
|
|
children |
|
QREL |
cr |
|
|
sla_events |
|
QREL |
tev |
|
|
attached_slas |
|
BREL |
attached_sla._mapped_cr |
|
|
add_sla_persids |
add_sla_persids |
STRING |
|
|
|
site_sla_attrs |
site_sla_attrs |
STRING |
|
|
|
audit_userid |
audit_userid |
SREL |
cnt.id |
|
|
fldchange_log |
fldchange_log |
STRING |
|
|
|
affected_service |
affected_service |
SREL |
nr |
|
|
init_urg |
|
LOCAL INTEGER |
|
|
|
init_imp |
|
LOCAL INTEGER |
|
|
|
cap_reason |
|
CHAINE LOCAL |
|
|
|
auto_urg |
|
LOCAL INTEGER |
|
|
|
auto_imp |
|
LOCAL INTEGER |
|
|
|
man_urg |
|
LOCAL INTEGER |
|
|
|
man_imp |
|
LOCAL INTEGER |
|
|
|
récapitulatif |
récapitulatif |
STRING |
|
|
|
support_lev |
support_lev |
STRING |
srv_desc code |
|
|
symptom_code |
|
SREL |
symptom_code |
|
|
template_name |
template_name |
STRING |
cr_template template_name |
|
|
time_spent_ sum |
time_spent_ sum |
DUREE |
|
|
|
type |
type |
STRING |
code crt |
|
|
urgency |
urgency |
NOMBRE ENTIER |
urgncy enum |
|
|
urgency_prev |
LOCAL |
SREL |
urg.enum |
|
|
target_times |
target_times |
BREL |
tgt_time_mapped_cr
|
|
|
target_start_last |
target_start_last |
DATE |
|
|
|
target_hold_last |
target_hold_last |
DATE |
|
|
|
target_hold_count |
target_hold_count |
NOMBRE ENTIER |
|
|
|
target_resolved_last |
target_resolved_last |
DATE |
|
|
|
target_resolved_count |
target_resolved_count |
NOMBRE ENTIER |
|
|
|
target_closed_last |
target_closed_last |
DATE |
|
|
|
target_closed_count |
target_closed_count |
NOMBRE ENTIER |
|
|
|
close_date_prev |
close_date_prev |
LOCAL DATE |
|
|
|
resolve_date_prev |
resolve_date_prev |
LOCAL DATE |
|
|
|
target_hold_count_prev |
target_hold_count_prev |
NOMBRE ENTIER |
|
|
|
target_resolved_count_prev |
target_resolved_count |
LOCAL INTEGER |
|
|
|
target_closed_count_prev |
target_closed_count_prev |
LOCAL INTEGER |
tgt_time_mapped_iss |
|
|
Copyright © 2013 CA.
Tous droits réservés.
|
|